Receivables - EBS (MOSC)

MOSC Banner

AR to GL Data flow

edited Dec 8, 2016 8:27AM in Receivables - EBS (MOSC) 3 commentsAnswered

I am trying to track the data from AR (Invoices) to GL, however, not able to find the table linking AR to SLA. I have the following tables but interestingly I don't see any data in

XLA_TRANSACTION_ENTITIES for application ID 222

select *
from RA_CUSTOMER_TRX_ALL
where to_char(creation_date,'yyyy') = '2016'
and customer_trx_id = '771630'
and bill_to_customer_id = '7669'

select *
from RA_CUST_TRX_LINE_GL_DIST_ALL
where customer_trx_id = '771630'
and event_id = '4323335'

select *
from xla_events
where application_id = '222'
and to_char(event_date,'yyyy') = '2016'

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