Receivables - EBS (MOSC)

MOSC Banner

orphan event_id, cant close period cause no transaction found.

edited Feb 11, 2020 4:00AM in Receivables - EBS (MOSC) 2 commentsAnswered

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?

Tagged:

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