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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Need Syntax for DAVE_TIME_SCAN_SET function

edited Feb 4, 2019 4:42AM in Workforce Management 2 comments

Content

We are trying to use the DAVE functions mentioned in Doc ID 1990057.1 in our Time Calculation rules rules and tried below syntax;

Syntax 1: l_dave = DAVE_TIME_SCAN_SET(ctxPersonId,ctxPeriodStartTime,ctxPeriodEndTime,'REPORTED','REPORTED',' ' ,' ' ,' ',l_sstatus default 'zz',l_slog default 'zz', l_row_count default 0,l_row_count_dtl default 0, l_rpt_start_date default '01-01-1951'(date),l_rpt_end_date default '31-12-4712'(date),l_rpt_rs_key default 'zz')

Initialized the output variables prior to the use in the below function
Syntax 2: l_dave = DAVE_TIME_SCAN_SET(ctxPersonId,ctxPeriodStartTime,ctxPeriodEndTime,'REPORTED','REPORTED','NULL','NULL','NULL',l_sstatus,l_slog, l_row_count,l_row_count_dtl,l_rpt_start_date,l_rpt_end_date,l_rpt_rs_key)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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