R12: PA: Interface Intercompany Invoices To Receivables Not Populate RA_INTERFACE_DISTRIBUTIONS_ALL (Doc ID 2549555.1)

Last updated on JANUARY 03, 2024

Applies to:

Symptoms

PATTARIC: PRC: Interface Intercompany Invoices to Receivables is not populating RA_INTERFACE_DISTRIBUTIONS_ALL and it's taking account from AR auto accounting details.

PRC: Interface Intercompany Invoices to Receivables does not populate the RA_INTERFACE_DISTRIBUTIONS_ALL table. It is taking into account the AR Auto
Accounting and not with PA Auto Accounting.

The instance is an upgrade to 12.2.7 from 12.2.4.  It is working as expected in 12.2.4.

1) The cursor get_invoice_info in procedure PA_INVOICE_XFR.Convert_Amt is updated for <bug 26262803>.
2) The below conditions added are causing the data not to be returned and hence the RA_INTERFACE_DISTRIBUTIONS_ALL table is not populated.

AND Nvl(INT_LINE.INTERFACE_LINE_ATTRIBUTE9,'X') = P_Project_Num /*
Bug 26262803*/
AND Nvl(INT_LINE.INTERFACE_LINE_ATTRIBUTE10,'X') =
ltrim(rtrim(to_char(ORG_DI.Draft_invoice_num))) /* Bug 26262803*/

3) When comparing the PA_INVOICE_XFR package between 12.2.4 and 12.2.7, this is the major difference found and seems to be the cause of the issue.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.