R11i:AP:Cannot Create Online Accounting for Voided Payment/Cancelled Invoice Due to Error APP-SQLAP-10710 (Doc ID 2158436.1)

Last updated on JULY 26, 2016

Applies to:

Oracle Payables - Version 11.5.10.1 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.1 version, Accounting Issues in AP

Can not create online accounting for cancelled invoice/voided payment due to error APP-SQLAP-10710.
 

ERROR
-----------------------
APP-SQLAP-10710:Online accounting could not be created and submit the Payables accounting Process instead to

create accounting entries for this transaction


Submit the Payables Accounting Process request,and found below error from concurrent log.

 

ERROR
-----------------------
The INVOICE CANCELLATION event for invoiceXXXXXX cannot be accounted because some payment event or prepayment application or unapplication event for this invoice has not been accounted.
Cannot Account for void of XXXXXX bank account's check number XXXXXX because some Invoice that it pays, is NOT accounted.

 

Check the AP_ACCOUNTING_EVENTS_ALL table for the INVOICE CANCELLATION event and the PAYMENT CANCELLATION event.

The PAYMENT CANCELLATION event has a higher ACCOUNTING_EVENT_ID.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create accounting for Voided Payment/Cancelled Invoice

Cause

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