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 JULY 23, 2020
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
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
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!