R12: AP: EBTAX: Payables Invoices Imported Using Payables Open Interface Import are Created Without Tax Jurisdiction For Tax Lines (Doc ID 3018208.1)

Last updated on MAY 24, 2024

Applies to:

Symptoms

Payables invoices which are imported using Payables Open Interface Import program created without Tax Jurisdiction for tax lines.

Users are importing these invoices from ap_invoices_interface/ap_invoice_lines_interface through Payable Open Interface program and seeing that tax Jurisdiction is NULL after import in ap_invoice_lines_all/zx_lines tables.

The tax_classification_Code is passed for tax line in ap_invoice_lines_interface. Expect system to derive the default tax jurisdiction for the tax line.


STEPS TO REPLICATE
-------------------------
1. Insert invoices in ap_invoices_interface/ap_invoice_lines_interface tables using SQL Loader
2. Payabes Responsibility > Other > Requests > Run Payables Open Interface Import
3. Payabes Responsibility > Invoices> Entry > Invoices > Query the Invoice created
4. Go to Invoice lines, and check tax line. Tax Jurisdiction field is Blank.

Cause

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