My Oracle Support Banner

EXGC9.2 Rows With Wrong END_EFFDT On VAT_DEFAULT_HDR after applying Bug ID : 25696337 (Doc ID 2430196.1)

Last updated on FEBRUARY 04, 2019

Applies to:

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


When adding VAT Defaults for a vendor, if there are 3 VAT defaults added with 01-IAN-2000, current Date and CurrentDate-1 then the CurrentDate-1 row will have END_EFFDT as CurrentDate-2.


1. Enable VAT for a vendor
2. Click on VAT Service Treatment Setup link and add a new Vat row effective dated 02/21/2000 with Seller Location Country = FRA. Hit Save.
3. While still on the Service Vat Treatment  page, add 2 new rows effective dated current date and current date – 1 and SAVE.
4. Check the database –  notice that the end_effdt of the latest effective dated rows is the correct one now but the currentDate-1 row will have END_EFFDT as CurrentDate-2.

SELECT to_char(a.effdt, 'DD-MON-YYYY'),to_char(a.end_effdt, 'DD-MON-YYYY'),a.*
WHERE a.vat_driver_key1='SHARE' and a.vat_driver_key2='0000000047' and a.vat_driver='VENDOR' ;

"01-IAN-2000" "18-IUN-2018" "VENDOR" "SHARE" "0000000047" " " " " " " "FRA" " " 01-01-2000 "A" " " 18-06-2018
"19-IUN-2018" "18-IUN-2018" "VENDOR" "SHARE" "0000000047" " " " " " " "FRA" " " 19-06-2018 "A" " " 18-06-2018
"20-IUN-2018" "31-DEC-2100""VENDOR" "SHARE" "0000000047" " " " " " " "FRA" " " 20-06-2018 "A" " " 31-12-2100




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.