My Oracle Support Banner

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 JULY 22, 2021

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




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.