AR Manual Invoice -Distribution Table -For Receivable class — oracle-mosc

Receivables - EBS (MOSC)

MOSC Banner

AR Manual Invoice -Distribution Table -For Receivable class

edited Aug 6, 2017 3:41AM in Receivables - EBS (MOSC) 2 commentsAnswered ✓

Application Version : R12.1.3 

Navigation : AR -> Transaction -> Transaction ->

  • Source : Manual -Others ,
  • Class: Invoice
  • Type : Invoice

Recently when we do reconciliation - Trial balance account with customer statement, we identified the  for many 'Manual Invoice' user  entered   wrong distribution on RECEIVABLE 

We are developing script to identify  for all such wrong distribution entries. Below are the table

  1. RA_CUSTOMER_TRX_ALL A,
  2. RA_CUSTOMER_TRX_LINES_ALL B,
  3. RA_CUST_TRX_LINE_GL_DIST_ALL C

Here the table  C - contains distribution only for 'REVENUE' CLASS   but we need to get the distribution for 'RECEIVABLE'  CLASS as well.

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