Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood 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
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)
Tagged:
0