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

Last updated on MAY 29, 2008

Applies to:

Oracle Payables - Version: 12.0.0
This problem can occur on any platform.
REPORT:APXIIMPT.RDF - Payables Open Interface Import

Symptoms

Find the 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.

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