Receivables - EBS (MOSC)

MOSC Banner

Link between ra_cust_trx_line_ table to xla_ae_lines table

edited Jan 5, 2023 12:32PM in Receivables - EBS (MOSC) 2 commentsAnswered ✓

Hi ,

I'm not able to figure direct mapping between ra_customer_trx_all/ra_customer_trx_lines/ra_cust_trx_line_gl_dist_all to xla_ae_lines,

which is resulting in causing cartesian join (multiplied value), can anybody advice please,

Many Thanks,

Code:

SELECT DISTINCT

   xah.ae_header_id              AS "AE_HEADER_ID",

   xah.application_id            AS "APPLICATION_ID",

   xah.ledger_id                 AS "LEDGER_ID",

   xah.entity_id                 AS "ENTITY_ID",

   xah.event_id                  AS "EVENT_ID",

   xah.event_type_code           AS "EVENT_TYPE_CODE",

   xah.accounting_date           AS "ACCOUNTING_DATE",

   xah.gl_transfer_status_code   AS "GL_TRANSFER_STATUS_CODE",

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