Who's Online Now
0 registered members (), 3 guests, and 16 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Sarathy R, pjchiverton, Jampat, sankumar, MAS - HRMS
1255 Registered Users
Recent Posts
Monthly Data Collection
by delboy. 20/09/17 02:31 PM
Costing Proration
by delboy. 20/09/17 12:21 PM
Future dated records and API
by CT. 14/09/17 10:26 AM
Location Extra info API error
by ALERO. 13/09/17 02:52 PM
Fusion OSP/OMP Setup Guidance Request
by delboy. 11/09/17 05:39 AM
Faster Payments
by pat. 07/09/17 10:29 AM
11i or R12.1.x to R12.2.x Upgrade
by CT. 06/09/17 06:44 AM
Incrementing parameter in scheduled request
by ClanGowland. 04/09/17 10:22 AM
Top Posters(30 Days)
CT 11
ALERO 10
delboy 6
PeterP 3
pat 1
Rashmi 1
Popular Topics(Views)
412,206 PAYE RTI
49,345 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
Page 2 of 2 1 2
#12036 - 11/09/17 07:50 AM Re: Location Extra info API error [Re: ALERO]  
Joined: Mar 2005
Posts: 2,085
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,085
Additionally, and having just looked at the definition of the valueset PQP_GB_EDU_ESTB_TYPE, you will need to set up a session row with your required effective date in fnd_sessions prior to the API call.


CT
#12038 - 13/09/17 02:52 PM Re: Location Extra info API error [Re: CT]  
Joined: Sep 2009
Posts: 31
ALERO Offline
enthusiast
ALERO  Offline
enthusiast

Joined: Sep 2009
Posts: 31


A line in the sessions table resolved the issue, also one of the parameters is referenced wrongly .

Thanks for your assistance.


BEGIN
HR_LOCATION_EXTRA_INFO_API.create_location_extra_info (
p_validate => FALSE
, p_location_id => 706609
, p_information_type => 'PQP_GB_EDU_ESTB_INFO'
, p_lei_attribute_category => 'PQP_GB_EDU_ESTB_INFO' - This line should be p_lei_information_category => 'PQP_GB_EDU_ESTB_INFO'
, p_lei_information1 => 'Y'
, p_lei_information2 => '3111'
, p_lei_information4 => 'LEA_ESTB'
, p_lei_information6 => '123'
, p_location_extra_info_id => l_extra_info_id
, p_object_version_number => l_object_vn);

Page 2 of 2 1 2

Moderated by  bcooper, CT 

Forum Statistics
Forums48
Topics2,190
Posts11,857
Members1,255
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,085
bcooper 1,285
delboy 1,249
paulgos 431
SBi 423
Gus 252
pat 248
vkumar 223
September
S M T W T F S
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.019s Queries: 16 (0.005s) Memory: 2.7355 MB (Peak: 2.8749 MB) Zlib disabled. Server Time: 2017-09-24 15:57:30 UTC