Payables and Cash Management - EBS (MOSC)

MOSC Banner

Updating TAX_RATE_CODE in ZX_RATES_B

edited Aug 20, 2020 9:31AM in Payables and Cash Management - EBS (MOSC) Question

Hi

We have a requirement to change the VAT_CODE in AP_SUPPLIER_SITES_ALL table.

We do not have Patch 18342689 installed (Note 1604569.1) hence AP_VENDOR_PUB_PKG.UPDATE_VENDOR_SITE is not working as it does not update VAT_CODE unless the patch is installed.

Is there a way to update the TAX_RATE_CODE value in ZX_RATES_B table?

Background - For Ireland the VAT Rate is being reduced from 23pc to 21pc effective 1/Sep, our TAX_RATE_CODE has the number 23 in it. We have to remove the number 23 as it will cause confusion. We are able to create a new VAT Code but since the API is unable to update the VAT Code in the Supplier Sites table this approach is not going to work. So I was wondering if there is a way to update the Tax Rate Code in ZX_RATES_B table such that Supplier Site will automatically be updated. (This would also mean updating relevant

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center