R12: Transaction Import PAXTRTRX - Gives Errors on Package HXC_GENERIC_RETRIEVAL_PKG For Oracle Time And Labor Transactions
(Doc ID 2189356.1)
Last updated on JULY 08, 2020
Applies to:
Oracle Time and Labor - Version 12.1.3 and laterOracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
On 12.1.3:
The transaction import process (PAXTRTRX) - will not complete for Oracle Time and Labor
- Works fine for other transaction types
- No Invalid objects
- No custom triggers
- Profile Option "OTL: Transfer Batch Size" is set to 100
Error:
MSG-20002: ORA-20002: pre_import:ORA-04063: package body "APPS.HXC_GENERIC_RETRIEVAL_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.HXC_GENERIC_RETRIEVAL_PKG"
ORA-06512: at "APPS.HXC_GENERIC_RETRIEVAL_UTILS", line 1576
ORA-06512: at "APPS.HXC_INTEGRATION_LAYER_V1_GRP", line 902
ORA-06512: at "APPS.PA_OTC_API", line 1502
ORA-04063: package body "APPS.HXC_GENERIC_RETRIEVAL_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.HXC_GENERIC_RETRIEVAL_PKG"
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 |