APP-DT-52554 Error When You View DateTrack History For An Assignment Time Information Record With No Rotation Plan Value (Doc ID 1953616.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Time and Labor - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Archive/Restore Issues

When attempting to view DateTrack History for Assignment Time Information record without a Rotation Plan entered, the following error occurs.

ERROR
---------------
APP-DT-52554: Contact your system administrator:" The database view called HXT_ADD_ASSIG_INFO_D did not retrieve any history details for this record

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into OTL Application Developer responsibility
2. N: Assignment Time Information
3. Query back an employee with no Rotation Plan value.  Click on DateTrack History... icon, get error:

APP-DT-52554: Contact your system administrator:" The database view called HXT_ADD_ASSIG_INFO_D did not retrieve any history details for this record

 Click OK button and History Form is empty:

- Click the 'Full History' button and the following message appears:

APP-PAY-06153: System Error: Procedure SET_UP_FOLDER_BLOCK at step 1


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, History is not available on the Assignment Time Information form so user cannot see how the record has changed over time.

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