Home » Applications » Oracle Fusion Apps & E-Business Suite » Errorr running pay_element_entry_api.create_element_entry (Human Resources,11.5.12, AIX )
| Errorr running pay_element_entry_api.create_element_entry [message #577679] |
Tue, 19 February 2013 11:08 |
rbertrand
Messages: 45
Registered: November 2005
|
Member |
|
|
I have a procedure in place that gathers the info I'll need to run create_element_entry. I'm getting the following errors when running with p_validate set to 'TRUE':
Failed to validate element entry. ORA-20001: System Error: Procedure hr_entry.get_eligibility_period at Step 4
Cause: The procedure hr_entry.get_eligibility_period has created an error at Step 4.
Action: Contact your
I've attached the data being used when error occurs.
Code for api follows:
Pay_Element_Entry_Api.create_element_entry
(
p_validate => TRUE
,p_effective_date => LTRIM(lg_effective_date)
--changed below to = 81 to fix problem with 'ora-20001: element link does not exist for the duration of the entry' on 30-aug-10.
,p_business_group_id => 81 --null
,p_original_entry_id => NULL
,p_assignment_id => LTRIM(rec_valid_ele.assign_id)
,p_element_link_id => LTRIM(rec_valid_ele.element_link_id)
,p_entry_type => 'E' ---- default as per cv040
,p_creator_type => 'F' ---- default as per cv040
,p_cost_allocation_keyflex_id => NULL --ltrim(rec_valid_ele.cost_keyflex_id)
,p_updating_action_id => NULL
,p_updating_action_type => NULL
,p_comment_id => NULL
,p_reason => NULL
,p_target_entry_id => NULL
,p_subpriority => NULL
,p_date_earned => NULL
,p_personal_payment_method_id => NULL
,p_attribute_category => NULL
,p_attribute1 => NULL
,p_attribute2 => NULL
,p_attribute3 => NULL
,p_attribute4 => NULL
,p_attribute5 => NULL
,p_attribute6 => NULL
,p_attribute7 => NULL
,p_attribute8 => NULL
,p_attribute9 => NULL
,p_attribute10 => NULL
,p_attribute11 => NULL
,p_attribute12 => NULL
,p_attribute13 => NULL
,p_attribute14 => NULL
,p_attribute15 => NULL
,p_attribute16 => NULL
,p_attribute17 => NULL
,p_attribute18 => NULL
,p_attribute19 => NULL
,p_attribute20 => NULL
,p_input_value_id1 => LTRIM(rec_valid_ele.input_value_id1)
,p_input_value_id2 => NULL --ltrim(rec_valid_ele.input_value_id2)
,p_input_value_id3 => NULL --ltrim(rec_valid_ele.input_value_id3)
,p_input_value_id4 => NULL --ltrim(rec_valid_ele.input_value_id4)
,p_input_value_id5 => NULL --ltrim(rec_valid_ele.input_value_id5)
,p_entry_value1 => LTRIM(rec_valid_ele.entry_value1)
,p_entry_value2 => NULL --ltrim(rec_valid_ele.entry_value2)
,p_entry_value3 => NULL --ltrim(rec_valid_ele.entry_value3)
,p_entry_value4 => NULL --ltrim(rec_valid_ele.entry_value4)
,p_entry_value5 => NULL --ltrim(rec_valid_ele.entry_value5)
,p_entry_information_category => NULL
,p_entry_information1 => NULL
,p_entry_information2 => NULL
,p_entry_information3 => NULL
,p_entry_information4 => NULL
,p_entry_information5 => NULL
,p_entry_information6 => NULL
,p_entry_information7 => NULL
,p_entry_information8 => NULL
,p_entry_information9 => NULL
,p_entry_information10 => NULL
,p_entry_information11 => NULL
,p_entry_information12 => NULL
,p_entry_information13 => NULL
,p_entry_information14 => NULL
,p_entry_information15 => NULL
,p_entry_information16 => NULL
,p_entry_information17 => NULL
,p_entry_information18 => NULL
,p_entry_information19 => NULL
,p_entry_information20 => NULL
,p_entry_information21 => NULL
,p_entry_information22 => NULL
,p_entry_information23 => NULL
,p_entry_information24 => NULL
,p_entry_information25 => NULL
,p_entry_information26 => NULL
,p_entry_information27 => NULL
,p_entry_information28 => NULL
,p_entry_information29 => NULL
,p_entry_information30 => NULL
,p_override_user_ent_chk => 'N'
,p_effective_start_date => ld_effective_start_date --out
,p_effective_end_date => ld_effective_end_date --out
,p_element_entry_id => ln_element_entry_id --out
,p_object_version_number => ln_object_version_number --out
,p_create_warning => lb_create_warning --out
);
thanks very much!
|
|
|
|
Goto Forum:
Current Time: Mon Dec 23 01:20:01 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
