General Ledger - EBS (MOSC)

MOSC Banner

R12 GL: XLA_DISTRIBUTIONS_LINKS 's columns : source_distribution_id_num_1 AND source_distributio

edited Apr 15, 2013 12:53AM in General Ledger - EBS (MOSC) 1 commentAnswered

Hi there,

As per metalink note 813968.1.

WHENEVER

         XLA_DISTRIBUTIONS_LINKS.source_distribution_type   = 'AP_INV_DIST'

THEN

          XLA_DISTRIBUTIONS_LINKS.source_distribution_id_num_1 = <ap_invoice_distributions_all.INVOICE_DISTRIBUTION_ID>

But for one of our GL Batches for Paybles/Purchase Invoices, we are finding that out of  10 lines in XLA_DISTRIBUTIONS_LINKS,

1.four of them have accouting_line_code = 'AP_SELF_ASSESSED_REC_TAX_INV'

2.these four lines have  source_distribution_id_num_1 as non-NULL

3.All four have  XLA_DISTRIBUTIONS_LINKS.source_distribution_type   = 'AP_INV_DIST'

But we are not able to find these as INVOICE_DISTRIBUTION_IDs(

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