Error APP-AR-294571 : The Dec-17 cannot Be Closed Due to Some Unprocessed Accounting Events or Untra
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