R12: AP: APXINWKB: APP-SQLAP-10108: An Error Has Occured While Trying To Commit FRM-40350 or FRM-40735: When-validate-ITEM trigger raised unhandled exception ORA-01403 (Doc ID 1598952.1)

Last updated on OCTOBER 05, 2016

Applies to:

Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to click on Invoice Lines tab in the Invoice Workbench, the following error occurs:

APP-SQLAP-10108 - FRM-40350 An error has occurred while trying to commit

The issue can be reproduced at will with the following steps:

1. Using Payables Manager responsibility
2. Navigate to Invoices : Inquiry > Invoices
3. Query the invoice to be updated
4. Click on the lines tab
5. Displayed the error: APP-SQLAP-10108 An error has occurred while trying to commit.

or

Unable to save distributions on Invoice Workbench due to error

FRM-40735: When-validate-ITEM trigger raised unhandled exception ORA-01403

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