No Tax Calculation in Payables

Module: Payables

Oracle Version: Oracle R12

Error Message:

“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.


Submit a Comment

Your email address will not be published. Required fields are marked *

Additional Support

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.


User Guide


News Article/Post

Video Support


Oracle Recommendations

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.

Share This