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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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