Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Unable to fetch the value using Element Input Validation — Cloud Customer Connect
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

Unable to fetch the value using Element Input Validation

Received Response
11
Views
2
Comments

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!