My Oracle Support Banner

R12: AP: Match Status Flag Incorrect On Canceled Invoice Distribution; Error 'APP-SQLAP-10237, APP-SQLAP-10108' (Doc ID 1952205.1)

Last updated on FEBRUARY 26, 2019

Applies to:

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

Symptoms

Match_Status_Flag is 'N' on all invoice distributions even though invoice has been canceled.


ERROR
-----------------------
APP-SQLAP-10237:The total of all schedule payment must equal the invoice amount.
Adjust the gross amount for one or more scheduled payments.
APP-SQLAP-10108:An Error has occurred while trying to commit.


STEPS
-----------------------
1. Entry invoice header with Invoice Amount: 0.
2. Entry invoice line and calculate tax.
3. Switch to Scheduled Payments tab, and change the Due Date.
4. Change the invoice header with the correct Invoice Amount.
Try to switch to Lines tab, then get "APP-SQLAP-10237, APP-SQLAP-10108" error.
5. Click Action button, get "APP-SQLAP-10237", ignore the error and cancel the invoice.
6. Match_Status_Flag is 'N' on all invoice distributions even though invoice has been canceled.
7. Create another invoice and Save it.

Event_status_code is 'I' and process_status_code is 'U' in XLA_EVENTS table.

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!


In this Document
Symptoms
Cause
Solution
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.