Hi all,I am working on an integration from a custom Oracle APEX application into Oracle EBS R12 Payables. The requirement involves importing an invoice with a combination of dynamic and fixed manual tax lines.
Specifically, I have a scenario with an invoice total of 2,200 SAR broken down as follows:
-
Line 1 (ITEM): 1,000 SAR – Has a fixed/ad-hoc tax amount of exactly 75 SAR passed directly from APEX.
-
Line 3 (ITEM): 2000 SAR – Has a fixed/ad-hoc tax amount of exactly 50 SAR passed directly from APEX.
The Problem
-
The invoice header and lines are successfully imported (Tax get as summary 125 SAR) from the interface table (AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE). However, when running the Invoice Validation Process, it fails to generate distribution lines for the custom tax line. The invoice sits in an Unvalidated state with missing distributions.
What I Have Tried So Far
- Grouping: Each TAX with it's Item using
LINE_GROUP_NUMBER
- Tax Headers: Set
CALC_TAX_DURING_IMPORT_FLAG = 'N' on the header to allow manual tax insertions.
- EBS Config: Verified that the "Allow Ad Hoc Amount" checkbox is checked on the Tax Rate configuration screen for our tax rate code (
VAT_15_NON_REC).
Thanks