R12 Wrong Project Intercompany Invoice In AP Invoice Workbench Line (AP_INVOICE_LINES_V)
Last updated on JANUARY 16, 2018
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 */
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