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