R12.2.3 PRC: Interface Supplier Cost - Transaction Import Failed With Sqlcode = -20003

(Doc ID 2044903.1)

Last updated on AUGUST 01, 2016

Applies to:

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

Symptoms

On : 12.2.3 version, Purchase to Pay Flow

When attempting to run the PAAPIMP_SI module: PRC: Interface Supplier Costs process to include AP Discounts, the following error occurs.

ERROR
-----------------------
07:40:19: ......Transaction Import Phase For AP DISCOUNTS
07:40:19: ->PAAPIMP_PKG.mark_RCV_PAflag->PAAPIMP_PKG.trans_import
07:40:19: log messages from transaction import ----------------------
07:40:32: transaction import failed with sqlcode =
07:40:32: -20003
07:40:32: ORA-20003: import1_prog:ORA-01403: no data found2. After l_SysRef5Tab(j) : 24157000
07:40:32: Within main logic of 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