My Oracle Support Banner

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

Last updated on DECEMBER 26, 2020

Applies to:

Oracle Project Billing - Version 12.2.7 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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