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.

Period Close Exception - Oracle Payables: "Accounting Entries not Transferred to the General Ledger"

Issue: Period Close Exception: Accounting Entries not Transferred to the General Ledger

For Example : The following data displayed in report as

Accounting Entries not Transferred to the General Ledger
Accounting Date	Accounting Event Type	Supplier Name	Document Number
18-Nov-16	MANUAL	xxxxxxxxxxxxxxx	34/2016-17
30-Nov-16	MANUAL	xxxxxxxxxxxxxxx	0016IBC00008117

R12: Generic DataFix (GDF) Patch 17983453 - Delete Orphan Invoice Distribution Lines for Missing Invoice Lines (Doc ID 1060644.1)

Solution

Patch: 17983453

• Detect and Show the Distributions both Posted/Unposted exist in AP which do not have corresponding Invoice lines.
• Remove these Orphan Distributions from the system after appropriately taking care of any accounting impacts and proper sync up with Etax repository. 

 1. Apply the fix from document R12: Generic DataFix (GDF) Patch 17983453 - Delete Orphan Invoice Distribution Lines for Missing Invoice Lines ( Doc ID 1060644.1 )

2. Run Create Accounting

3. Run the Transfer Journal Entries to GL

4. Attempt to close the period.