Symptom:
An error message pops up while closing AP period through "Accounting>Control Payables periods"
Reason:
AP_ACCOUNTING_EVENTS_ALL.EVENT_STATUS_CODE gets updated with status INCOMPLETE when the invoice is updated after being validated. And when the invoice is validated again, the status becomes CREATED.
But due to Oracle bug, sometimes the status remains in INCOMPLETE status even after validating the invoice. Due to which the transaction could not get accounted and hence error pops up while closing AP period.
Fix:
Ask the user to update the invoice again with something and save it again and then validate the invoice. See if that fixes the issue.
If not then following datafix can be used to update the EVENT_STATUS_CODE to CREATED. Then run the Payables Accounting Process to make the transaction accounted.
UPDATE ap_accounting_events_all
SET event_status_code = 'CREATED'
WHERE accounting_event_id = r1.data1
AND event_status_code IN ('INCOMPLETE')
AND org_id = &invoice_or_payment_org_id
AND source_id = &invoice_or_check_id
Hello
ReplyDeleteKindly may you assist me:
I want to write an sql code that will show me all the incorrect GL accounts code per item
thank you
The presence of the 'INCOMPLETE' status in the AP_ACCOUNTING_EVENTS_ALL table signifies that certain accounting events have not undergone the complete processing cycle. how-to-delete-ps4-game/how to delete ps4 gameThis status acts as a useful marker, highlighting transactions that require further steps for finalization. It's a reminder to stakeholders that there are pending actions needed to ensure accurate financial reporting. By addressing and resolving these 'INCOMPLETE' events, organizations can maintain data integrity and uphold the accuracy of their financial records within the Oracle application.
ReplyDelete