Transaction Import PAXTRTRX - Gives Errors on Package HXC_GENERIC_RETRIEVAL_PKG For Oracle Time And Labor Transactions (Doc ID 2189356.1)

Last updated on JUNE 16, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

DB Version: 11.2.0.2.0
Release: 12.1.3
Patch Set: R12.PA.B.3
Latest Patchset/RUP: 9147711 (R12.PJ_PF.B.DELTA.3)

The transaction import process (PAXTRTRX) - will not complete for Oracle Time and Labor after patch 14688253 was applied.

  - Works fine for other transaction types
  - No Invalid objects
  - No custom triggers
  - OTL: Transfer Batch Size = 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"

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms