Who's Online Now
0 registered members (), 3 guests, and 12 spiders.
Key: Admin, Global Mod, Mod
Newest Members
lmartin, Kevin, Andi, nicwoody, appetite11
1272 Registered Users
Recent Posts
Migration into Existing Payroll and RTI
by hpatel15. 18/07/18 11:08 AM
Retropay Enhanced Performance Issues
by delboy. 17/07/18 06:06 AM
HR Intelligence in R12.2
by elmilsse. 09/07/18 10:53 AM
PAYE RTI
by sheebs. 04/07/18 10:46 AM
Top Posters(30 Days)
delboy 4
sheebs 3
JNA 1
Popular Topics(Views)
458,896 PAYE RTI
54,164 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,092
CT Online sleepy
CT  Online Sleepy

****

Joined: Mar 2005
Posts: 2,092
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
Forums60
Topics2,210
Posts11,948
Members1,273
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,092
bcooper 1,289
delboy 1,286
paulgos 434
SBi 426
pat 254
Gus 252
vkumar 223
July
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.017s Queries: 16 (0.004s) Memory: 2.7451 MB (Peak: 2.8853 MB) Zlib disabled. Server Time: 2018-07-20 17:56:56 UTC