R12: AP: Navigating to Invoice Lines Tab Errors with FRM-40735: PRE-RECORD Trigger Raised Unhandled Exception ORA-01403, FRM-40202 and APP-SQLAP-10378

(Doc ID 1074119.1)

Last updated on MARCH 22, 2017

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
APXINWKB - Invoice Workbench


After matching an invoice to a PO and then navigating to the lines tab results in the following error:

This has also been observed when changing invoice distribution line type from item to variance and trying to save.
1.Payables > Invoices > Entry > Invoices
2.Query existing batch, click Invoices button
3.Click lines tab
4.In Invoice header, click on new line and navigate to existing invoice and close the form
5.The invoice batch form is displayed. Click on any invoice batch.


1.Payables > Invoices >Entry > Invoices
2.Create invoice, create a line and then create distribution
3.Change distribution line type from item to variance
4.Save the record




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