My Oracle Support Banner

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



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


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!

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