General Ledger - EBS (MOSC)

MOSC Banner

What is link between ra_customer_Trx_all with gl_je_lines

edited Feb 17, 2014 12:00PM in General Ledger - EBS (MOSC) 3 commentsAnswered

Hi,

I want to make reconciliation report between GL and AR Sales.  I fill  description field with trx_number on gl_je_lines so I Use it as A link  between ra_customer_trx_all  and gl_lines_all. but some of data on description field is Journal Import created so I can't link it with ra_customer_trx table.  I checked to Reference 5,6,7 from gl_lines_all since those 3 field filled with number, I link it to xla_distribution_links get source_distribution_id_numI to link it to  RA_CUST_TRX_LINE_GL_DIST_ALL table then to ra_customer_trx_all, but it not return anything, even if they return a row, it's not the right data.

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