R12 Wrong Project Intercompany Invoice In AP Invoice Workbench Line (AP_INVOICE_LINES_V)
(Doc ID 2198767.1)
Last updated on DECEMBER 04, 2020
Applies to:Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
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.
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
View definition has incorrect join to ap_invoices_all to get Intercompany Invoice Number.
Due to this Intercompany Invoice Number fetched is incorrect.
Modified Query as below:
,AIII.TRX_NUMBER INTERCOMPANY_INVOICE_NUM /*Bug 24383287
,RA_CUSTOMER_TRX_ALL AIII /*For Intrecompany Invoice
Number Bug 24383287*/
AND AIL.pa_cc_ar_invoice_id = AIII.customer_trx_id(+)
/*Bug 24383287 */
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