Human Capital Management - EBS (MOSC)

MOSC Banner

Need help on UDT Fast Formula in EBS

edited Aug 22, 2019 9:27AM in Human Capital Management - EBS (MOSC) 7 commentsAnswered ✓

Hi Experts,

we have requirement like based on the location we need to deduct some amount.So I have created the User defined table(UDT) for location and enter the location with value and also created the fast formula as below but it's returning the null value.please help me on this where i am missing.

Default for ASG_LOCATION is  ' '

l_location=ASG_LOCATION

l_amount=to_num(GET_TABLE_VALUE('LOC_UDT','Location',l_location))

return l_amount

LOC_UDT----Table Name

Location---Column Name

Thanks,

Nagaraju.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center