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

Symptoms

Cause

Solution

References

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.