No Tax Calculation in Payables
Oracle Version: Oracle R12
“ORA-01422: exact fetch returns more than requested number of rows.”
Cause of Issue:
Clash of Configuration Owner Options – when there are two different set ups active for Payables the system will not know where to look to get the tax information and therefore won’t calculate tax.
You will need to end date the old ‘Configuration Owner Options’ and disable it. To do this navigate to the configuration owner options, Tax Managers > Defaults and Controls > Configuration Owner Options. Search for the operating unit, find the options linked to Payables, against it click on ‘Update’. End date and disable it then click ‘Apply’.
You will now be able to calculate tax.
When available, we provide additional resources to a particular support item, such as User Guides, blog posts, support videos and links to recommended Oracle solutions.
GCC VAT Oracle Learning Series
Want to know how to set tax up for Oman, Kuwait, Bahrain, Qatar, United Arab Emirates and Saudi Arabia then sign up to our free webinar series.