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 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

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

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