Incorrect Tax calculated on Purchase Order, due to oracle not considering Date Effectivity.
Summary:
In India we have frequent changes in Tax Rate so we have added multiple Tax Category on Item Level. But Oracle doesn't check Date effectivity on Tax Category (Start Date and End Date). It fetches first record returned by Query.
Hence, due to which Incorrect Tax is calculated on Purchase Order
Content (please ensure you mask any confidential information):
We enabled setup Allow Multiple Item Category.
Hence, we are end dating old tax rate and adding new tax rate
Version (include the version you are using, if applicable):
Oracle Fusion Cloud Applications25C (11.13.25.07.0)
Code Snippet (add any code snippets that support your topic, if applicable):