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:

Symptoms

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