app-ar-294571 the period cannot be closed due to some unprocessed accounting events or untransferred journal entries
When I try to close AR periods I was facing following errors.
 |
| app-ar-294571 the period cannot be closed due to some unprocessed accounting events or untransferred journal entries |
Solution can be find from the Oracle Note: 1479975.1
I am pasting Note detail below but it is highly recomended to check this note from support.oracle.com for updated version (if any).
Create Accounting APP-AR-294571 : The Period Cannot Be Closed Due to Some Unprocessed Accounting Events or Untransferred Journal Entries [ID 1479975.1]
In this Document
Information in this document applies to any platform.
APP-AR-294571 : The PERIOD cannot be closed due to some unprocessed accounting events or un-transferred journal entries.
Adjustments are not Approved or Rejected. Two adjustments were in Pending status and need to be processed by users.
In Release 12, Pending adjustments have to be processed.
ev.event_id, ev.entity_id, ev.event_type_code,
ev.event_status_code, ev.event_date,
et.SECURITY_ID_INT_1, et.ledger_id, et.transaction_number
from XLA.XLA_TRANSACTION_ENTITIES et,
XLA.XLA_EVENTS ev
where ev.event_date between to_date('&startdate', 'dd-mon-yyyy') AND
to_date('&enddate', 'dd-mon-yyyy')
and ev.event_status_code not in ('P','N')
and ev.application_id = 222
and et.entity_id = ev.entity_id;
Check the following Things for the Adjustment in question
1. Status is in W (Pending) or R (Rejected)
2. Event Status Code for Pendng (W) or N for (Rejected). These statuses then need to be resolved.
Pending Adjustments (W) need to be processed by Users.
Responsibility: Receivables Manager
Navigation: Control > Adjustments > Approve Adjustments
Process the adjustments and run Create Accounting with the period open in AR and GL in question
| Symptoms |
| Cause |
| Solution |
Applies to:
Oracle Receivables - Version 12.0.0 to 12.2 [Release 12.0 to 12.2]Information in this document applies to any platform.
Symptoms
Attempting to run Create Accounting and receive the following error:APP-AR-294571 : The PERIOD cannot be closed due to some unprocessed accounting events or un-transferred journal entries.
Cause
Found that Un-Approved Adjustments were present.Adjustments are not Approved or Rejected. Two adjustments were in Pending status and need to be processed by users.
In Release 12, Pending adjustments have to be processed.
Solution
Run the following to find the offending Entries.ev.event_id, ev.entity_id, ev.event_type_code,
ev.event_status_code, ev.event_date,
et.SECURITY_ID_INT_1, et.ledger_id, et.transaction_number
from XLA.XLA_TRANSACTION_ENTITIES et,
XLA.XLA_EVENTS ev
where ev.event_date between to_date('&startdate', 'dd-mon-yyyy') AND
to_date('&enddate', 'dd-mon-yyyy')
and ev.event_status_code not in ('P','N')
and ev.application_id = 222
and et.entity_id = ev.entity_id;
1. Status is in W (Pending) or R (Rejected)
2. Event Status Code for Pendng (W) or N for (Rejected). These statuses then need to be resolved.
Pending Adjustments (W) need to be processed by Users.
Responsibility: Receivables Manager
Navigation: Control > Adjustments > Approve Adjustments
Process the adjustments and run Create Accounting with the period open in AR and GL in question
APP-AR-294571
Your feedback/comment is quite important for improving this blog so feel free to leave your comments & suggestions
o run the Subledger Period Close Exceptions Report, and see if any activity appears. If so, run the Transfer Journal Entries to GL request for the period. Then run Submit Accounting with the parameters “Y” to Transfer to, and Post, to General Ledger
ReplyDeleteo Once complete, re-run the Subledger Period Close Exceptions Report to see if any activity. If still open activity, contact IT. If the report shows no exceptions, retry to close the period
nice post. thanks for this post. Very helpful and informative. Looking for the accounting and accounting courses like ACCA, Mba in international finance and accounting,and many other CPA courses to manage the accounts, You can visit this website
ReplyDelete