My Oracle Support Banner

R12: iSupplier: Unable to create Invoices due to Unexpected Error: ORA-20001 APP-SQLAP-10000 ORA-01403 ORA-06512 error messages displayed (Doc ID 1662149.1)

Last updated on MARCH 29, 2017

Applies to:

Oracle Payables - Version 12.0.1 and later
Information in this document applies to any platform.

Symptoms

While supplier creates and submits Invoice through iSupplier portal, at the click of final Submit button, user is logged out automatically and the following error occurs.

ERROR

Error page:

"You have encountered an unexpected error. Please contact the System Administrator for assistance"
Error Page
Exception Details.
    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 1859
ORA-06512: at line 1

FNDDebug Logs:

AP.PLSQL.AP_CREATE_PAY_SCHEDS_PKG.Calc_Due_Date 1 There is no calendar associated with the term line
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log 4 "APP-SQLAP-10000: ORA-01403: no data found occurred in
with parameters (Terms id  = Sequence num = 1)
while performing the following operation:
&DEBUG_INFO"


This error occurs for one supplier where, for one PO it is working and for other it is not.


STEPS

1. iSupplier portal -> Finance Tab->Create Invoices
2. In the final page when user clicks Submit button, the system administrator error occurs.



Changes

 

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
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


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