My Oracle Support Banner

FDC - The Taxable Amount Of ICMS And IPI Taxes Is Not Deriving From XML (Doc ID 2910792.1)

Last updated on AUGUST 23, 2023

Applies to:

Oracle Fusion Inventory Management Cloud Service - Version and later
Oracle Fusion Cost Management Cloud Service - Version and later
Oracle Fusion Purchasing Cloud Service - Version and later
Information in this document applies to any platform.


The customer use FDC (fiscal document capture) to enter import invoices into the system. All taxes related to this process have specific calculations that is not covered today by Cloud ERP (mainly the way the taxable amount is defined). Importation fiscal document tax amount and taxable amount is defined outside Cloud ERP.


the taxable amount of ICMS and IPI is not deriving from XML, causing the ICMS calculation in the system to be different from the one calculated in XML (this tax is recoverable in this case).
In example XML, the ICMS value is 1,380.59 and in the system, due to the incorrect calculation base, it is calculating 257.12
The system should bring the Taxable amount equal in the XML, all taxes is with the taxable amount correct, except ICMS and IPI.

Once the XML of the invoice is interfaced there is a JG tax table that receives the taxable base amount in a column named TAXABLE_AMT.

At any tax setup that customer setup in order to have the tax recovered there is an update of this column according the information that is calculated at Cloud ERP, however, as this information is required, Customer need the original information (taxable amount) contained in the XML for correct bookkeeping with the government oversight agency (SPED) for this interface that will happen after FD is captured.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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