My Oracle Support Banner

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:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


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?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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