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 AUGUST 01, 2018

Applies to:

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

Symptoms

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.

 STEPS

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.*
FROM PS_VAT_DEFAULT_HDR a
WHERE a.vat_driver_key1='SHARE' and a.vat_driver_key2='0000000047' and a.vat_driver='VENDOR' ;

"TO_CHAR(A.EFFDT,'DD-MON-YYYY')" "TO_CHAR(A.END_EFFDT,'DD-MON-YYYY')" "VAT_DRIVER" "VAT_DRIVER_KEY1" "VAT_DRIVER_KEY2" "VAT_DRIVER_KEY3" "VAT_DRIVER_KEY4" "VAT_DRIVER_KEY5" "COUNTRY" "STATE" "EFFDT" "EFF_STATUS" "VAT_SETID" "END_EFFDT"
"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

Cause

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
Symptoms
Cause
Solution
References


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