R12: AP: Error when Searching PO In Isupplier Invoice Page ORA-20001: APP-SQLAP-10000: ORA-01403: no data found (Doc ID 2731735.1)

Last updated on MAY 17, 2023

Applies to:

Symptoms

When attempting to search for Purchase Order from Create Invoice Page of Isupplier portal
the following error occurs.

ERROR
-----------------------
## Detail 0 ##
java.sql.SQLException: ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_Matching_Utils_Pkg. Get_qty_amt <-
with parameters ( p_rcv_transaction_id = XXXX)
while performing the following operation:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.AP_MATCHING_UTILS_PKG", line 2785


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Isupplier portal.
2. Create invoices for PO.
3. Search for PO, issue is populated.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.