My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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
References


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