My Oracle Support Banner

R12: APXINWKB: APP-SQLAP-10108 If Leave Invoice Amount Null and Click on Lines Tab (Doc ID 1259441.1)

Last updated on JANUARY 03, 2023

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.


-- Problem Description
Clicking into Invoice Lines after entering all required invoice header data except Invoice Amount results in the following error:

APP-SQLAP-10108: An error has occurred while trying to commit.

Normally, we would expect to get either a message in the lower left hand corner as follows:

FRM-40202: Field must be entered
or
Forms window with the same message

If you enter the Header without Amount and hit Save, you get the Error: FRM-40202: Field must be Entered

If you enter the Header without Amount and Click on Lines you get the Error: APP-SQLAP-10108: An error has occurred while trying to commit.

When you Hit OK and acknowledge the APP-SQLAP-10108 Error, the Cursor goes to the Amount field and at the bottom of the screen you can see the Error: FRM-40202: Field must be Entered

When you click on any of the Tabs: Holds, View Payments, Scheduled Payments or View Prepayment Applications the same error FRM-40202 occurs.
The only exception is the Lines Tab in which case you get the different Error: APP-SQLAP-10108

-- Steps to Reproduce
Payables > Invoices > Entry > Invoices
Enter Invoice Header info except amount
Click Lines tab

-- Business Impact
Inconsistent error messages

Cause

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.