My Oracle Support Banner

PAXTRTRX PRC: Transaction Import Errors with 'ORA-20003: import1_prog:ORA-06508: PL/SQL: could not find program unit being calledOverride Assignment Id' for Labor Distribution Items. (Doc ID 2768519.1)

Last updated on JULY 29, 2022

Applies to:

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

Symptoms

The PRC:  Transaction Import errors with the following when run as part of the PSP: Summarize and Transfer Payroll Distributions and PSP: Summarize And Transfer Adjustments processes (Labor Distributions) or some third party source data:

MSG-20003: ORA-20003: import1_prog:ORA-06508: PL/SQL: could not find program unit being calledOverride Assignment Id
ORA-06512: at "APPS.PA_TRX_IMPORT", line 10717


or

MSG-20003: ORA-20003: import1_prog:ORA-06508: PL/SQL: could not find program unit being calledIn OTHERS exception of import1
ORA-06512: at "APPS.PA_TRX_IMPORT", line 10717

Steps to Reproduce:

1.  Grants Super User or Project Costing Super User responsibility

2.  Navigate:  Other | Request | Run and run the PRC:  Transaction Import process with the correct parameters.

Changes

 Migrated files to the new 12.2 instance

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.