Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Payroll fast formula,throws an error " Database item must have a default statement" when compiled.
Summary:
Hi everyone,
I'm compiling a payroll fast formula and encountering an error:
"Database item SHIFT_ALLOWANCE_SHIFT_CODE_ENTRY_VALUE must have a DEFAULT statement."
The database item, SHIFT_ALLOWANCE_SHIFT_CODE_ENTRY_VALUE, is a Text Value and Number Index array. When I add a default statement (DEFAULT_DATA_VALUE for SHIFT_ALLOWANCE_SHIFT_CODE_ENTRY_VALUE is 'X'), it throws an "the assignment uses inconsistent data types.
" error.
Since the formula is lengthy, I've attached only the code section causing the error. This database item appears just twice in the entire 1000-line formula.
Any help to resolve this would be greatly appreciated. Thanks!
0