R12:AP:AP_INVOICE_LINES_INTERFACE.TAX_CODE Field is Ignored by Payables Open Interface Import (APXIIMPT) (Doc ID 472649.1)

Last updated on APRIL 28, 2023

Applies to:

Symptoms

Payables Open Interface Import (APXIIMPT.rdf) is ignoring the value in AP_INVOICE_LINES_INTERFACE.TAX_CODE

According to the Oracle Payables Reference Guide Release 12 (Part No. B25455-02)

 TAX_CODE

 Enter the tax code or tax group you want to assign to the invoice distribution created     from this record.

  Validation: AP_TAX_CODES_ALL.NAME
  Destination: AP_INVOICE_DISTRIBUTIONS_ALL.VAT_CODE

EXPECTED BEHAVIOR
Expect the TAX_CODE field to be populated in table AP_INVOICE_DISTRIBUTIONS_ALL.VAT_CODE when
importing the invoice.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Create records in

AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE

Make sure the field AP_INVOICE_LINES_INTERFACE.TAX_CODE is populated with a valid tax code.

2. Run the Payables Open Interface Import (APXIIMPT.rdf)
3. Validate the invoices imported, notice the VAT_CODE field in AP_INVOICE_DISTRIBUTIONS is empty.

The system is calculating the default invoices setup in eBTax.

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot specific taxes on the invoices other than the ones setup to be
calculated automatically via eBTax.

Changes

Cause

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