Data Fix: Third Party Taxes Attached To Invoice Distribution Of Main Vendor's Invoice (Doc ID 2404339.1)

Last updated on AUGUST 27, 2019

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Receipt has third party taxes attached but those taxes have got attached to the ERS invoice distribution and third party supplier details has got replaced with PO vendor details.

Following is the identification query of the impacted transactions:-

SELECT
 trx_number "invoice number"
FROM
 jai_tax_lines jtl1,
 ap_invoices_all aia,
 ap_invoice_lines_all aila
WHERE
 jtl1.entity_code = 'AP_INVOICES'
 AND   jtl1.trx_id = aia.invoice_id
 AND   aia.invoice_id = aila.invoice_id
 AND   aia.source = 'ERS'
 AND   jtl1.party_id=aia.VENDOR_ID
 AND   jtl1.reporting_only_flag = 'N'
 AND   EXISTS (
     SELECT
         1
     FROM
         jai_tax_lines jtl2
     WHERE
         jtl2.trx_loc_line_id = aila.rcv_transaction_id
         and jtl2.trx_id=jtl1.APPLIED_TO_TRX_ID
         and jtl2.Trx_Line_Id=jtl1.APPLIED_TO_TRX_LINE_ID
         AND   jtl2.trx_type = 'RECEIVE'
         AND   jtl2.party_id<>jtl1.party_ID
 )
 and exists (
 select 1 from ap_invoice_lines_all aila2
 where aila.invoice_id=aila2.invoice_id
 and aila2.description=jtl1.TAX_RATE_CODE
 and aila2.Line_Type_Lookup_Code='MISCELLANEOUS'
 );

EXPECTED BEHAVIOR
-----------------------
Third Party Taxes should not be attached to the ERS invoice.

STEPS
-----------------------
The issue is not reproducible at will for fresh transactions.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot maintain statutory compliance.

Cause

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