R12: PA: PRC: Transaction Import Process Errors Out: MSG-20003: ORA-20003: import1_prog:ORA-06502 (Doc ID 1488626.1)

Last updated on JANUARY 13, 2016

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.
PRC: Transaction Import process

Symptoms

When attempting to run PRC: Transaction Import process, the following error occurs.


Error only occurs when storing a NON-NUMERIC value in one of the CDL_SYSTEM_REFERENCE columns in PA_TRANSACTION_INTERFACE_ALL table:

CDL_SYSTEM_REFERENCE1

CDL_SYSTEM_REFERENCE2

CDL_SYSTEM_REFERENCE3


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Uploading data into PA_TRANSACTION_INTERFACE_ALL table.
2. Run PRC: Transaction Import process.
3. Review the log file and see the error.

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