Payables Accounting Process does not create accounting entries for cancelled invoice
UPDATE AP_ACCOUNTING_EVENTS AAE
SET request_id = P_request_id
WHERE AAE.source_table = 'AP_INVOICES'
AND AAE.event_status_code = 'CREATED'
AND (AAE.accounting_date >= G_start_date OR G_start_date IS NULL)
AND (AAE.accounting_date <= G_end_date OR G_end_date IS NULL);
It means if we created invoice 30-MAY-2013 and then cancelled it on 31-MAY-2013. Then ran Payables Accounting Process to create accounting for cancelled invoice with end date parameter 31-MAY-2013. Program will not pick this invoice for accounting. But if run with end date next day of day when cancelled that is 1-JUN-2013, it will get picked.
This document says it is bug in the system(BUG 7629187 - 11I APACCENG DOES NOT ACCOUNT FOR INVOICE CANCELLATION ).
In solution section of this document states to apply patch# 7670236 to fix this issue
Workaround Solution given in this document is same one I have found:
You can check with oracle for appropriate patch to fix this issue.
We have face this problem in our Oracle apps 11i env, not sure this issue is there or not in R12 env.