R12: Unable to Create Invoices For New Suppliers Due To Error ORA-1403 FRM-40735 WHEN-VALIDATE-ITEM and APP-SQLAP-10108
(Doc ID 1123713.1)
Last updated on APRIL 27, 2023
Applies to:
Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]Information in this document applies to any platform.
APXINWKB - Invoice Workbench
Symptoms
Join our growing Oracle Payables Community and learn from your peers and Oracle on how to address your unique issues in AP.
Unable to create invoice for new supplier due to the following error after tabbing out of supplier site field:
ORA-01403: no data found
FRM-40735 WHEN-VALIDATE-ITEM trigger raised unhandled ORA-1403
and possibly also
APP-SQLAP-10108: An error has occurred while trying to commit.
-- Steps to Reproduce
Payables > Invoices > Entry > Invoices
Enter Invoice Header data, choose site
Tab out of Supplier Site
-- Business Impact
Unable to create invoices for new suppliers
Changes
The error while entering Invoices appears for only those Suppliers/Sites that are created after applying any of the following patches:
Patch 8889211, Patch 9739904 or Patch 9322013.
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! |