My Oracle Support Banner

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 later
Oracle 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


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