Who's Online Now
0 registered members (), 2 guests, and 16 spiders.
Key: Admin, Global Mod, Mod
Newest Members
MANISH KUMAR, Pallavi Negi, SalomeClara, Steph W, Aflexgis
1263 Registered Users
Recent Posts
RUP10 New Functionality
by delboy. 16/01/18 10:56 AM
EDI Replacement
by delboy. 16/01/18 06:33 AM
Happy New Year 2018
by CT. 02/01/18 08:30 AM
Recover an Advanced Grossup Payment
by Steph W. 21/12/17 11:34 AM
Top Posters(30 Days)
delboy 7
pat 1
CT 1
Popular Topics(Views)
433,897 PAYE RTI
51,502 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,088
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,088
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,200
Posts11,895
Members1,262
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,088
bcooper 1,285
delboy 1,262
paulgos 431
SBi 425
Gus 252
pat 250
vkumar 223
January
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 31
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.029s Queries: 16 (0.013s) Memory: 2.7368 MB (Peak: 2.8758 MB) Zlib disabled. Server Time: 2018-01-18 12:05:37 UTC