Fiscal Classifications FAQs

How do I get the Fiscal Code of Operations and Services (CFOP) of a fiscal document line?

The CFOP codes are entered in the Transaction Business Category (TRX_BUSINESS_CATEGORY) field of each fiscal document line. The fiscal document extract file provides the complete fiscal classification path of the transaction business category. To get only the CFOP code, the partner must extract the last four digits of the transaction business category value.

How can I identify the different fiscal classifications associated with the item?

The group ADDITIONAL_PRODUCT_CLASSIFICATIONS contains all the item catalogs and item categories associated with the item in fiscal document line. CATEGORY_SET_NAME field contains the item catalog name and CATEGORY_CODE field contains the item category for that item catalog.

How can I define the company fiscal classification codes according to the National Classification of Economic Activities (CNAE)?

Create an item catalog for the National Classification of Economic Activities and enter the necessary CNAE fiscal classification codes for your business as item categories under this catalog. Associate each inventory item with a corresponding CNAE fiscal classification code as an item category. From the Fiscal Document extract file, get the CNAE code from the CATEGORY_CODE field for which the CATEGORY_SET_NAME is equal to the item catalog name.

How can I define the service fiscal classifications of a transaction?

When services are configured as inventory items, the service fiscal classifications can be identified as product fiscal classifications. In this case, an item catalog should be created and the item categories should be associated with each service item, indicating the corresponding service fiscal classification. During transaction entry, if the transaction line has an inventory item, the service fiscal classification is captured as a product fiscal classification and the value is defaulted from the item catalog.

If services are not configured as inventory items, the service fiscal classification can be captured as a product category. In this case, each service fiscal classification code should be defined as a product category fiscal classification code. During transaction entry, the service fiscal classification code can be selected as a product category in the transaction line.

When there is a local service fiscal classification for the city, both national and local service fiscal classification codes can be defined as product fiscal classifications or product category fiscal classifications. They can be configured as different levels of the product fiscal classifications or product category structure.

How can I identify the different fiscal classifications?

IPI legal framework codes PIS CST codes
COFINS CST codes ICMS CST codes IPI CST codes
ICMS taxable basis determination codes

ICMS-ST taxable basis determination codes ICMS exemption condition codes
ISS applicability codes

These different fiscal classifications can be defined as tax reporting types. Tax reporting types and tax reporting codes can be configured and associated with the tax configuration to represent the different tax situations.

From the Fiscal Document extract file, obtain the tax reporting code for which the REPORTING_TYPE_CODE is equal to the tax reporting type code defined for each fiscal classification.

For more information on tax reporting types, see the Advanced Tax Configuration chapter in the Oracle Financials Cloud Implementing Tax guide at http://docs.oracle.com.

How can I associate the NCM and EX-TIPI fiscal classification codes with each item?

NCM and EX-TIPI can be configured as product fiscal classifications:

Create an item catalog for the NCM and EX-TIPI.
Create a Product Fiscal Classification Type Group and associate the item catalog.
In the Country Default Controls, choose the same item catalog as the primary inventory category set.
Enter the NCM codes as item categories under the same item catalog. Enter the necessary product fiscal classification for your business, including the EX-TIPI codes as part of the NCM codes.
Associate each inventory item with a corresponding NCM and EX-TIPI fiscal classification code as an item category.
From the Fiscal Document extract file, get the NCM and EX-TIPI code from the product fiscal classification of each fiscal document line (PRODUCT_FISC_CLASSIFICATION).

How can I associate the Tributary Substitution Specifier Code (CEST) with each product?

Create an item catalog for the Tributary Substitution Specifier Code and enter the necessary CEST fiscal classification codes for your business as item categories under this catalog. Associate each inventory item with corresponding CEST fiscal classification code as an item category. From the Fiscal Document extract file, get the CEST code from the CATEGORY_CODE field for which the CATEGORY_SET_NAME is equal to the item catalog name.

How can I define the vehicle classification as passenger, cargo, mixed, racing, traction, or special vehicle for the vehicle industry?

Use the Intended Use attribute in the transaction line to capture the vehicle classification for the vehicle industry. The intended use identifies the purpose for which the product is used.