My Oracle Support Banner

R12.2 PRC: Interface Supplier Costs Ends in Error ORA-20003: import1_prog:ORA-01403: no data foundIn stage 2 (Doc ID 2446312.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

In Oracle Projects, PRC: Interface Supplier Costs errors with the following in the log file:

ERROR
-------
01:29:54: get_parent_txn_status: log_message: X_transaction_source :AP NRTAX
01:29:54: get_parent_txn_status: log_message: G_cash_based_accounting :N
01:29:54: get_parent_txn_status: log_message: l_DocumentDistTypeTab :SELF_ASSESSED_TAX
01:29:54: get_parent_txn_status: log_message: l_SysRef5Tab(p_indx) :24520707
01:29:54: get_parent_txn_status: log_message: l_SysRef4Tab(p_indx) :SELF_ASSESSED_TAX
01:29:54: get_parent_txn_status: log_message: l_parent_dist_id :24350877
01:29:54: get_parent_txn_status: log_message: l_rejected_txn_id :61748263
01:29:54: get_parent_txn_status: log_message: l_status :PA_EXP_TASK_EFF
01:29:54: get_parent_txn_status: log_message: Status Override for child (Date Failure) l_status :PA_REJECTED_PARENT_RECORD
01:29:54: ValidateItem: log_message: Calling PA_GMS_API api
01:29:54: ValidateItem: log_message: After PA_GMS_API api
01:29:54: Import1: log_message: Updating txn interface table for txn rejected by validateitem
01:29:54: Import1: log_message: Updated to reject count 1

The issue can be reproduced at will with the following steps:

1. Using Projects responsibility

2. Run PRC: Interface Supplier Costs and get error


Product: Oracle Projects
Release: 12.1.3 RUP 7

Changes

 Upgraded to 12.1.3 RUP7

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.