INCOMPLETE status in AP_ACCOUNTING_EVENTS_ALL table

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