My Oracle Support Banner

Sales Returns - Incorrect Credit Memo PIS/COFINS Tax Calculation (Based on Amount Instead of Quantity) When Inclusive Tax is Present (Doc ID 2927116.1)

Last updated on MAY 15, 2023

Applies to:

Oracle Financials for the Americas - Version 12.2 and later
Information in this document applies to any platform.
PIS (Program of Social Integration) - federal tax
COFINS (Contribution for the Financing of Social Security) - federal tax


While creating Sales Returns, after the receipt in Inventory module, the Credit Memo is calculating PIS/COFINS (taxes) based on the 'amount' (quantity x unit price) instead of 'quantity' as defined in Latin Tax codes setup. This happens when Inclusive Tax setup is used.
The taxable_amount is incorrect in both ra_customer_trx_lines_all and zx_lines tables. When the Credit Memo reaches the Oracle Receivables (AR) interface (ra_interface_lines_all), the tax group is the same as for the original sales order while the tax codes are setup for Taxable Basis = Quantity.
If the goods are returned, the tax calculation must be the same as in original invoice: PIS and COFINS must be based on quantity for such cases.


  1. Order Management responsibility > Orders Workbench > Orders, Returns > Create Return Material Authorization (RMA)
  2. Oracle Receivables responsibility > Transactions > Create a return invoice
  3. Integrated Receiving > Create invoice receipt
  4. Inventory responsibility > Transactions > Receiving > Create physical receipt
  5. The Credit Memo is created in ar_interface_lines_all > Observe that the tax group is the same as for the original sales order
  6. Oracle Receivables responsibility > Import this data from the interface > Verify ra_customer_trx_lines_all and zx_lines tables, the taxable_amount is incorrect
  7. Observe PIS/COFINS (taxes) are incorrectly calculated based on the 'amount' (quantity x unit price) instead of 'quantity' (expected per setups)



The PIS/COFINS taxes differences can be manually calculated in Oracle Receivables and General Ledger modules.




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.