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
Unable to fetch the value using Element Input Validation
Summary:
I'm using the below formula in one of Element to process, upon saving the element entry.
But I'm getting following error "ORA-20001: The data type TEXT of parameter AMOUNT doesn't match the data type NUMBER used in the formula. ORA-06512: at "FUSION.HR_UTILITY", line 798 ORA-06512: at "FUSION.FF_EXEC_WRAPPER_PKG", line 81 ORA-06512: at line 2"
Need solution to resolve this error.
Content (required):
Version (include the version you are using, if applicable):
21D
Code Snippet (add any code snippets that support your topic, if applicable):
DEFAULT FOR L_AMOUNT IS 0
INPUTS ARE AMOUNT (NUMBER)
L_Person_ID = GET_CONTEXT(PERSON_ID,0)
0