In this Document
APPLIES TO:
Oracle Receivables - Version 12.0.0 and later
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.
select et.source_id_int_1, et.entity_code, et.entity_id,
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. Review the event_status_code of the Adjustment in question from Script Above.2. Event_status_code = U indicated Adjustment has not processed.
Gather the latest Create Accounting Output file and review the results for any error Conditions.
Gather the information on the Adjustment in question using the source_id_int_1 as the adjustment id
Run the EBS Oracle Receivables Adjustment Analyzer provided in Note.2069916.1.
Create a new Service Request and upload the Results of the Create Accounting Output file and the Adjustment Analyzer information.
3. Event_status_code = I indicates Incomplete
Query the Adjustment Number in question to determine if the Adjustment is in Pending or Rejected status.
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
If Status is in W (Pending) status then Users will either have to Approve and process or Reject.
Still Have Questions?
To discuss this information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the
My Oracle Support Receivables Community.
To provide feedback on this note, click on the
Rate this document link.
转到底部
