Receivables - EBS (MOSC)

MOSC Banner

Error APP-AR-294571 : The Dec-17 cannot Be Closed Due to Some Unprocessed Accounting Events or Untra

edited Jul 9, 2019 4:22PM in Receivables - EBS (MOSC) 5 commentsAnswered

Following the Note:

1. Create Accounting APP-AR-294571 : The Period Cannot Be Closed Due to Some Unprocessed Accounting Events or Untransferred Journal Entries (Doc ID 1479975.1)

Run:

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center