R12 Wrong Project Intercompany Invoice In AP Invoice Workbench Line (AP_INVOICE_LINES_V) (Doc ID 2198767.1)

Last updated on MARCH 16, 2017

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Invoice Issues & MassAdd

In AP_INVOICE_LINES_V,  PA_CC_AR_INVOICE_ID is mapped with AP Invoice where it should be mapped with AR Invoice.

STEPS

The issue can be reproduced at will with the following steps:

1. Go To Payables Responsibility.
2. Search the Invoice with Invoice number. check Intercompany Invoice number .
3. It Refers to AP Invoice instead of AR Invoice

Changes

View definition has incorrect join to ap_invoices_all to get Intercompany Invoice Number.
Due to this Intercompany Invoice Number fetched is incorrect.

Resolution :

Modified Query as below:
SELECT
..
,AIII.TRX_NUMBER INTERCOMPANY_INVOICE_NUM /*Bug 24383287
*/
..
..
FROM
..
,RA_CUSTOMER_TRX_ALL AIII /*For Intrecompany Invoice
Number Bug 24383287*/
..
WHERE
..
AND AIL.pa_cc_ar_invoice_id = AIII.customer_trx_id(+)
/*Bug 24383287 */

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms