Getting Error in FAST FORMULA due to null Value of Location_ID. — 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

Getting Error in FAST FORMULA due to null Value of Location_ID.

edited May 17, 2019 12:43PM in Human Capital Management 1 comment

Summary

I created the Fast Formula to fetch Location Attribute by passing LOCATION_ID as Parameter. But Some Location_ID's are null so EXTRACT ending up with an Error.

Content

I created the Fast Formula to fetch Location Attribute by passing LOCATION_ID as Parameter. But Some Location_ID's are null so EXTRACT ending up with an Error. 

ERROR: "ORA-20001: Formula ****_ADP_LOCATION_CODE, line 13, array data value missing. Details: There is no data for array DATA_ELEMENTS,index LOCATION_ID."

[line 13 : l_Location_id = DATA_ELEMENTS['LOCATION_ID'] ]

 

Below is the Fast Formula which i used for Location_Attribute.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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