R12: Unable to Create Invoices For New Suppliers Due To Error ORA-1403 FRM-40735 WHEN-VALIDATE-ITEM and APP-SQLAP-10108
Last updated on MAY 18, 2017
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
Patch 8889211, Patch 9739904 or Patch 9322013.
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 hundreds of Community platforms