My Oracle Support Banner

Loading latest element record through HDL as update, Erred: ORA-20001: The Procedure Pay_entry_pkg.load_asg_info Failed At Step 2 [EBS - FUSION Coexistence] (Doc ID 2451322.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Initially On : 11.12.1.0.0 version / Upgraded to 11.13.18.05.0 version, Global Payroll
Co-existence mode between Oracle HCM (EBS) on premises and Oracle HCM Cloud


When attempting to load latest record through HDL as update, it is failing with below error:

ERROR
-----------------------
Critical: Error occured while carrying out post-execution steps of the PL/SQL Step: Data Loader Support Diagnostics
oracle.apps.fnd.appltest.diagfwk.common.DiagfwkException: Error occured while carrying out post-execution steps of the PL/SQL Step: Data Loader Support Diagnostics at oracle.apps.fnd.appltest.diagfwk.engine.impl.StepExecutorPLSQL.executeStep(StepExecutorPLSQL.java:198) at oracle.apps.fnd.appltest.diagfwk.engine.impl.StepExecutorBase.execute(StepExecutorBase.java:75) at oracle.apps.fnd.appltest.diagfwk.engine.impl.TestDefImpl.executeTest(TestDefImpl.java:982) at oracle.apps.fnd.appltest.diagfwk.engine.impl.TestDefImpl.execute(TestDefImpl.java:937) at oracle.apps.fnd.appltest.diagfwk.engine.impl.TestDefImpl.run(TestDefImpl.java:761) at oracle.apps.fnd.appltest.diagfwk.engine.impl.TestRunner.run(TestRunner.java:441) at oracle.apps.fnd.appltest.diagfwk.engine.impl.TestRunner.run(TestRunner.java:241) at oracle.apps.fnd.appltest.diagfwk.engine.impl.TestRunner.doRun(TestRunner.java:152) at oracle.apps.fnd.appltest.diagfwk.engine.DiagRunnable.run(DiagRunnable.java:68) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:745) Caused by: oracle.apps.fnd.appltest.diagfwk.common.DiagfwkException: Execution of the SQL query failed. SQL query was: 'select fl.SEQ_NUM "Sequence Number" ,fl.LINE_ID "LINE_ID" ,RO.LINE_OPERATION "Record Type" ,bo.bus_obj_file_discriminator "Object Discriminator" ,RO.P_EFFECTIVE_START_DATE "Effective Start Date" ,RO.P_EFFECTIVE_END_DATE "Effective End Date" ,RO.P_EFFECTIVE_SEQUENCE "Effective Sequence" ,RO.P_EFFECTIVE_LATEST_CHANGE "Effective Latest Change" ,hrc_dl_diag_utils.get_distinct_messages(RO.LINE_ID) "Line Message Text" ,RO.ROW_ID "ROW_ID" ,RO.TRANSFER_STATUS "Row Transfer Status" ,RO.IMPORT_STATUS "Row Import Status" ,hrc_dl_diag_utils.get_distinct_messages(RO.ROW_ID) "Row Message Text" ,RO.KEY_SOURCE_OWNER "Source System Owner" ,RO.KEY_SOURCE_ID "Source System ID" ,RO.KEY_SURROGATE_ID "Surrogate ID" ,RO.KEY_GUID "GUID" ,FH.PARENT_RESOLUTION_TYPE "Parent Resolution Type" ,RO.KEY_PARENT_SOURCE_OWNER "Parent Source System Owner" ,RO.KEY_PARENT_SOURCE_ID "Parent Source System ID" ,RO.KEY_PARENT_SURROGATE_ID "Parent Surrogate ID" ,RO.KEY_PARENT_GUID "Parent GUID" ,uk.UKVAL001 "User Key Value 01......................................................
.............................................................................

Full error message referenced in the bellow report:
Diagnostic Report: HCM Data Loader Data Set Status Diagnostic

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
A. HDL behavior:
1. loading latest record through HDL as update;
2. it is failing with error.

B. UI behavior:
1. go to Manage Element Entries;
2. trying to update element 'A05 Corporate X Plan' ;
2. it is also failing, this time with below error:
" The message is ORA-20001: An application error occurred. Details: The procedure pay_entry_pkg.load_asg_info failed at step 2. ORA-06512: at "FUSION.PAY_ELEMENT_ENTRY_API", line 1189 ORA-06512: at line 32. "

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
User/s need to start employee payroll letter from system, so they need all elements data to be up to date in FUSION.
Getting a resolution as soon as possible is preferred, otherwise it may create a big concern.

Business impact Details
a. Please describe the business impact (what does this actually prevent you from doing): - provided above -
b. Do you have a Complete Loss of Service? No
c. Is this a Test or Production Environment? Production
d. Is there a workaround? Yes
e. Deadline name: Employees payroll letter
f. Deadline date: Currently we have manual fix for this issue which we are following. But we need its resolution ASAP because it is impacting our Co-Existence module.
g. Number of affected employees: Daily in co-existence we are facing this issue with 2 to 5 employees. But some times count is 0 as well. But yes this issue is repeating in co-existence runs.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.