My Oracle Support Banner

FAQs - Procurement Fusion Tax Best Practices and General Questions (Doc ID 2377199.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

Oracle Fusion Purchasing - Version 11.1.9.2.0 and later
Oracle Fusion Purchasing Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Purpose

This document is a consolidation of some frequently asked questions and step-by-step practices related to implementation of tax and use of it in Procurement module. The practice guide includes a document that shows the steps on how to do a tax setup based on some specific requirements.

This document is related country based tax: like european countries, the countries from Gulf Cooperation Council (GCC).

This document is for help the analysts to learn about how to do a tax setup based on some requirements, find answers to some questions that encountered in Service Requests (SRs) for Procurement tax in order to get more knowledge about how to troubleshoot and solve issues related to this subject.

This document also help the customers in their setup for tax in Procurement module.

Note: Please perform setup from this note on Test instance before to do it in Production instance.

Please note the following guidelines:

-Analysts should use these practices when working related Service Requests.

-Customers can use these practices when they setup the tax and use it in Procurement module.

-If you have suggestions from improvement this note please add comments. Suggestions are welcome!

Questions and Answers

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
Purpose
Questions and Answers
  1. Why tax is not calculated on Purchase Order?
 2. How to create a default tax setup?
 3. Is it possible to override the defaulted tax code?
 4. How to override tax using Tax Classification?
 5. How to override Tax using User-Defined Fiscal Classification?
 6. How make tax not be calculated on Purchase Order?
 7. How to use Tax Classification that no tax applied?
 8. How to use User-defined Fiscal Classification to make sure no tax is applied?
 9. How to have a different tax on specific item categories?
 10. How make tax not be calculated on specific item categories?
 11. How to default tax from Supplier or from Supplier Site?
 12. How to default tax from Items?
 13. How to make tax not be calculated for one supplier?
 14. How to create more than one Supplier/ Customer with the same Tax Registration Number?
 15. Which are the main Fusion tax tables that will contain the setup information that will help support in troubleshooting Fusion tax information?
 16. Which are the main Fusion tax tables that will contain the transaction information that will have the tax details after tax is calculated?
 17. What Are The Primary Purchasing and Tax Tables Populated for Requisitions and Purchase Orders?
 18. Which table is stored the tax classification of Suppliers?
 19. Can we have INCLUSIVE TAX on Purchase Order?
 20. How to stop calculations for all taxes on Purchase Order?
 21. How to stop a tax from applying in Procurement but still in other modules?
 22. When using the register supplier function, the system require us to enter a value for at least one of these fields: D-U-N-S Number, Taxpayer ID, or Tax Registration Number.
      Is that any way to disable this restriction?
 23. On Supplier Self Service Registration Page: Company Details - There should be Tax Registration number validation for UAE. There should be a field 'Are you UAE tax registered'    Yes/  No , if yes, the TRN field should be mandatory.
      How to do this?
 24. The user made the tax registration number in supplier to mandatory. But the system is validating the mandatory check only if user go to the particular tab Transaction Tax>Tax Registrations>Registration Number.
      If don't enter the registration number also it allows user to save the records, unless user go to the above navigation.
      Why this is happen?
 25. Why tax is not getting calculated while Uploading Purchase Orders (POs) through FBDI template?
  26. How to Allow Suppliers With Duplicate Taxpayer ID?
 27. How to create a supplier from an existing party (customer)?
 28. It is possible to have a different tax classification code (TCC) for a supplier and a customer that have the same name and the same register_id?
 29. How to update by spreadsheet tax classification code (TCC) for a supplier?
 30) How it is validation of Tax Registration Number (TRN)?
 31) How it is the correct way to insert Tax Registration Number (TRN) on supplier?
 32) Which is the functionality of field Registration Number from Supplier UI ?
 33) How to import Tax Profile fields for Suppliers and Customers via FBDI?
 Analyzing PO Tax related issues:
 34) How to solve this error?
 35) How Inclusive/Exclusive Tax is Calculated on Purchase Order?
 36) Tax is not calculating on Requisition but is correctly calculating on Purchase Order created from Requisition. Why this is happening?
 37) How to solve error when try to update supplier sites using supplierServiceV2 Web Service?
 38) What setup is needed that tax to be calculated on base amount not on the amount after discount (Ordered)?
 39) How tax is coming on Purchase Order based on Purchasing category?
 40) Tax registration number validation problem for Switzerland
 41) Validate Tax Registration Number (TRN) Format in Supplier Registration
 42) Withholding tax classification code not visible in Supplier LOV.
Why this is happen?
 43) Why Tax Classification Code is not coming in LOV when user is trying to insert manually this field in Purchase Order, at supplier profile level, at supplier address level, at customer level, at customer site level, at item level for Purchasing, in Payables?
 44) Is it possible for the Intended Use Field on Purchase Orders/Requisitions to Default Based on Item/Inventory?
 45) Upload supplier tax data through tax implementation workbook is not working consistently.
 46) Unable to fetch Taxpayer ID from BI Publisher
 47) Tax payer ID is not displayed in the supplier approval notification
 48) Tax exception/Tax exemption
 49) Solution for error: Error with Tax on Requisitions: "The tax amounts cannot be calculated. Contact the Procurement application administrator POR-2010408"
 50) Test Case: scenario: Customer want tax on AP but no tax on PO.
 51) Test Case: tax based on Product Type
 52) Test Case: Withholding Tax Classification Code Not Showing Up In Income Tax tab however codes have been created and active.
References

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