Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
HWM Array Formula Pull Work Pattern Shift using DBIs
Summary:
For any 'Array' Time Calculation Rule formula in OTL, we cannot pull the values for the below DBIs. We are successful in retrieving these DBI values in the 'normal formula' but not in suffixed _AP formula:
HWM_PUB_SCHD_START_TIME
HWM_PUB_SCHD_STOP_TIME
HWM_DTL_SCHD_ALL_SCHEDULED_DURATION
Content (required):
The behaviour in the Array formula with these DBIs is that it seems to ignore the defaults:
Error msg - Database item HWM_PUB_SCHD_START_TIME must have a DEFAULT statement.
Default attempted to set as below:
DEFAULT FOR HWM_PUB_SCHD_START_TIME is EMPTY_DATE_NUMBER
Tagged:
0