PAAPIMP_SI Completes In Error: ORA-20003: Import1_prog:ORA-01403 (Doc ID 1498343.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked for relevance 28-Jan-2015 ***

Symptoms


When attempting to run process PRC: Interface Supplier Costs,
the following error occurs.

ERROR
-----------------------

09:41:46: ......Transaction Import Phase For AP DISCOUNTS
09:41:46: ->PAAPIMP_PKG.mark_RCV_PAflag->PAAPIMP_PKG.trans_import
09:41:46: log messages from transaction import ----------------------
09:41:48: transaction import failed with sqlcode =
09:41:48: -20003
09:41:48: ORA-20003: import1_prog:ORA-01403: no data foundIn stage 2 Updated count to T = 0
09:41:48: Within main logic of tieback
09:41:48: Clearing PLSQL tables in payment tieback


09:42:09: Calling trans import for discounts
09:42:09: ......Transaction Import Phase For AP DISCOUNTS
09:42:09: ->PAAPIMP_PKG.mark_RCV_PAflag->PAAPIMP_PKG.trans_import
09:42:09: log messages from transaction import ----------------------
09:42:12: transaction import failed with sqlcode =
09:42:12: -20003
09:42:12: ORA-20003: import1_prog:ORA-01403: no data found2. After l_SysRef5Tab(j) : 13603955
09:42:12: Within main logic of tieback
09:42:12: Clearing PLSQL tables in payment tieback



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