EAP: Effective Dated rows not deleted from PS_VAT_DEFAULT_HDR after deleting from VAT Defaults and Service VAT Treatment Defaults pages

(Doc ID 1103573.1)

Last updated on JULY 14, 2017

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9 to 9.1 [Release 9]
PeopleSoft Enterprise SCM Billing - Version 9 to 9.1 [Release 9]
PeopleSoft Enterprise SCM Purchasing - Version 9 to 9.1 [Release 9]
PeopleSoft Enterprise SCM Order Management - Version 9 to 9.1 [Release 9]
PeopleSoft Enterprise FIN Payables - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

When having multiple effective dated VAT Defaults, deleting one of the rows from the VAT Defaults and Service VAT Treatment Defaults pages deletes the data from the PS_VAT_DEFAULTS successfully, but rows still exist in PS_VAT_DEFAULT_HDR.

The existence of the extra VAT_DEFAULT_HDR rows causes VAT defaulting errors when creating Vouchers. Missing VAT setup errors appear.

STEPS
1.  Navigate to Set Up Financials/Supply Chain > Common Definitions > VAT and Intrastat > Value Added Tax > Vat Defaults
2.  Verify that for VAT Driver = AP Options, two effective dated rows exist for VAT Defaults
3.  Navigate to Setup Financials/Supply Chain > Common Definitions > VAT and Intrastat > Value Added Tax > Service VAT Treatment Defaults
4.  Verify that for VAT Driver = AP Options, two effective dated rows exist for Service VAT Treatments Defaults
5.  Query PS_VAT_DEFAULT_HDR: Both rows exist
6.  Query PS_VAT_DEFAULTS: Rows exist for both dates
7.  Navigate to Set Up Financials/Supply Chain > Common Definitions > VAT and Intrastat > Value Added Tax > Vat Defaults
8.  For VAT Driver = AP Options, delete VAT Defaults for one row
9.  Query PS_VAT_DEFAULT_HDR: Both rows still exist
10.  Query PS_VAT_DEFAULTS: Some rows were deleted
11.  Navigate to Set Up Financials/Supply Chain > Common Definitions > VAT and Intrastat > Value Added Tax > Service VAT Treatment Defaults
12.  For VAT Driver = AP Options, delete Service VAT Treatment Defaults for one row
13.  Query PS_VAT_DEFAULT_HDR: Both rows still exist
14.  Query PS_VAT_DEFAULTS: No rows exist for the deleted date
15.  Navigate to Accounts Payable > Vouchers > Add/Update > Regular Entry
16.  Create a Voucher
17.  Several error messages appears due to missing VAT setup. some of the errors are as follows:

Calculation Type is required (9060,746)
VAT Use Type is required (9060,746)

The errors occur both on-line and during Voucher Build. Below is an example of errors received when running Voucher Build:

ORA-01427: single-row subquery returns more than one row

Fatal SQL error occurred. (2,125) LC_VATDRIVER.DRIVER.GBL.default.1900-01-01.Step01.OnExecute Name:RunSQL2 PCPC:4903 Statement:71
Called from:LC_VATDRIVER.DRIVER.GBL.default.1900-01-01.Step01.OnExecute Statement:201

Process 11162 ABENDED at Step LC_VATDRIVER.DRIVER.Step01 (PeopleCode) -- RC = 8 (108,524)

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms