orphan event_id, cant close period cause no transaction found.
hi we have a problem trying to close AR period we use this query to get unposted events
SELECT TRANSACTION_NUMBER,xlt.source_id_int_1 id,
xlt.security_id_int_1 org_id,
xe.*
FROM apps.xla_events xe,
xla.xla_transaction_entities xlt
WHERE xe.entity_id = xlt.entity_id
AND xe.application_id =xlt.application_id
AND xlt.source_application_id = 222
AND xe.event_date between to_date('01-DEC-2019','DD-MON-YYYY')
and to_date('31-DEC-2019','DD-MON-YYYY')
AND xe.process_status_code <> 'P'
AND xe.event_status_code <> 'P'
order by xe.event_date;
but there´s no trx_number related to the events that the query found, could you please give us a solution to this problem?