Error Page When Cancellation of Unsubmitted Invoice In ISupplier ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in with parameters (Terms id = Sequence num = 1) (Doc ID 2149399.1)

Last updated on JULY 28, 2024

Applies to:

Symptoms

On  R12

When attempting to cancel and unsubmitted invoice,
the following error occurs.

ERROR
-----------------------
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in

with parameters (Terms id = Sequence num = 1)
while performing the following operation:
&DEBUG_INFO
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.AP_ISP_UTILITIES_PKG", line 638
ORA-06512: at line 1

..
..
## Detail 0 ##
java.sql.SQLException: ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in

with parameters (Terms id = Sequence num = 1)
while performing the following operation:
&DEBUG_INFO
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.AP_ISP_UTILITIES_PKG", line 638
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Query an unsubmited invoice in Isupplier portal
2. Click cancel
3. Receive the error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot cancel unsubmitted invoices.

Cause

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