AR Sub Ledger Period Close Exception Status shows “Unprocessed” and unable to close the AR Period

AR Sub Ledger Period Close Exception Status shows “Unprocessed” and unable to close the AR Period

Symptoms

AR Credit Memo “Status” Completed and Create Accounting completed and posted to GL. But “Sub Ledger Period Close Exception’ Report shows some records in “Unprocessed” status.

Journal Category	Credit Memos		Event Class	Credit Memo
Event Date	Event Type	Transaction Number	Status	Customer Name	Customer Number	Credit Memo Number
07-Oct-16	Credit Memo Updated	1317801453	Unprocessed	xxxxxxxxxxxxxxxxx	1044	1317801453
15-Oct-16	Credit Memo Updated	1317801488	Unprocessed	xxxxxxxxxxxxxxxxx	1042	1317801488
15-Oct-16	Credit Memo Updated	1317801489	Unprocessed	xxxxxxxxxxxxxxxxx	1042	1317801489

Solution

Undo accounting lines and Insert the new accounting lines against the customer_trx_id

Run below script which will undo account the events of the CM:
Script 1: undo_account_transaction_ra_event.sql

Undo Parameters:
org_id (Required)
customer_trx_id (Required) : Pass one transaction_id listed in query output
Bug_Number := 38981
gl_date := Enter GL_DATE of an open period>

The script will undo account the CM and will sweep the CM to the new gl_date which lies in open period.
2. Once successfully executed, issue: commit.
3. Now, run below script to create the missing distributions:
Script 2: insert_missing_cm_ra_dist_120.sql

Insert Parameters:
org_id (Required)
gl_start_date (Required)
gl_end_date (Required)
read_only_mode (Required) : Y to List the corruption and N to fix the corruption.
customer_trx_id (Required) : pass trx_id for which you did undo accounting above
Bug_Number := 38981

It will list the receivable_application_id for which the distributions are missing. Please validate it.
4. Once successfully executed, issue: commit.
5. Run Create Accounting to Post the data to GL.