EAP: Is There a Way to Mass Update the VAT Code Account Distribution Setting? (Doc ID 2849777.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Goal

Requirement changed the way  VAT is booked  to a specific account. With that user need to more than 100 VAT Codes to point the Input Non Recoverable VAT (VAT_DST_ACCT_TYPE = 'VIN' in PS_VAT_DST_TBL) to a new account. However doing an update on this table to the account value only doesn't do the trick. It seems that the details are also stored in PS_VAT_ACCT_TBL.
Are there any additional records/fields that impacted if an SQL update is done, or preferably if there is a delivered way of doing a mass update to the VAT account distribution setup?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.