ETL 9.1 Time And Labor Archive Queries Does Not Use Consistent Criteris For Archiving. (Doc ID 1458990.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms


ETL9.1: Time & Labor Archive queries does not use consistent criteria for archiving


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Reporting Tools> Query> Query Manager and Click on Advance Search. Enter Query name TL% and change query type to Archive
2. Select Query TL_PAYABLE_TIME_ARCHIVE1 and click on Viw SQL Tab
3. Select Query TL_PAYABLE_TIME_ARCHIVE2 and click on Viw SQL Tab Inconisstent Query Archive Criteria
4. TL_EXCEPTION query: All queries except for TL_PAYABLE_TIME_ARCHIVE1 use A.DUR>= and A.DUR and A.DUR < used by other queries

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users can archive one extra day of payable time as compared to Exception table or XREF tables

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