AR Invoice showing completed in front end application, however sub ledger period close exception report showing status as invalid

Issue: AR Invoice showing completed in front end application, however sub ledger period close exception report showing status as invalid

Cause: Mostly this issue happens when you copy recurring invoices

Solution:

------------------

1. Pull Invoice diagnostics and take event id

2. If the invoice is invalid the EVENT_STATUS_CODE= 'I'

3. Run the below query to check the same.

select * from xla.XLA_EVENTS where EVENT_ID=1234567;

It will show the EVENT_STATUS_CODE= 'I'

4. Run the below update script to change the flag to 'U'

UPDATE XLA.XLA_EVENTS SET EVENT_STATUS_CODE = 'U' WHERE EVENT_ID = 1234567 AND APPLICATION_ID = 222 AND EVENT_STATUS_CODE= 'I' AND PROCESS_STATUS_CODE='U';

COMMIT;

5. Run the create accounting and transfer to General ledger 'Yes’.

6. Now the status will change to  EVENT_STATUS_CODE = 'P'

Run the subledger period close exception report ,it won’t show this Invoice .