can not close a preriod in AR
when trying to close a period in AR appear an error:
APP-AR-294571 : The PERIOD cannot be closed due to some unprocessed accounting events or un-transferred journal entries
then i run this SQL statement and return with no result:
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')
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')
0