You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Active Shift lookup code (ORA_HTS_SHIFT_TYPE) for Duration Shifts?

Question
40
Views
0
Comments
edited Dec 14, 2019 12:20PM in Workforce Management

Summary

How to Active Shift lookup code (ORA_HTS_SHIFT_TYPE) for Duration Shifts?

Content

Hi all,

My business scenario is to upload non-working. I have tried to upload non-working using the following HDL.

METADATA|ScheduleRequest|ScheduleRequestNumber|RequestSource|RequestTime

MERGE|ScheduleRequest|TEST001|CRP|

 

METADATA|ScheduleEvent|ScheduleRequestNumber|ScheduleEventNumber|ImportMode|PersonNumber|PeriodStartDate|PeriodEndDate|AllowEdits|Publish|WorkerNotification

MERGE|ScheduleEvent|TEST001|SE001|UPDATE|EMPLOYEE_011|2019/12/30|2019/12/30|N|Y|Y

 

METADATA|ScheduleShiftEvent|ScheduleRequestNumber|ScheduleEventNumber|ScheduleShiftEventNumber|ShiftNumber|ShiftAction|ReferenceDay|ShiftStartTime|ShiftEndTime|ShiftTimeNotWorked|ShiftCode|ShiftCategory|ShiftType|AllowEdits

MERGE|ScheduleShiftEvent|TEST001|SE001|SSE101|SN001|UPDATE|2019/12/30||||ROD||Duration|N

 

This HDL error saying Shift type lookup value for the Duration shift is not available. Therefore, I have tried to create Duration Lookup under ORA_HTS_SHIFT_TYPE. It seems it does not allow creating a new lookup code. Therefore Currently ELAPSED and TIME appear in the Shift type lookup area. I want to know the way to active lookup for the Duration shift type. Please be kind to share your valuable knowledge.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!