E-Business Tax (MOSC)

MOSC Banner

Updating AP_SUPPLIER_SITES.VAT_CODE using a SQL SCRIPT.

edited Nov 18, 2013 11:31PM in E-Business Tax (MOSC) 1 commentAnswered
 Hello
We need to update en masse the vat_code for the supplier sites. Our current code includes the vat rate as part of the code and as our rate will change on 1/1/2014 having a rate as part of the code is confusing. In short we need to change 8000  supplier site records from the VAT_CODE = 'FFR_196ABS' to the VAT_CODE='FFR_NORM.ABS'. 

 Oracle do not support a mass change using SQL to do this. 

We cannot find an API written by Oracle which updates the AP_SUPPLIER_SITES_ALL table. 

We need to know if this update is possible using SQL? Is the VAT_CODE duplicated somewhere in eTax? If so , where?

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