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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Get table value date in fast formula

Summary:

Unable to get date which has been defined in table values.

Content (required):

We have created table values based on column Date, and defined value as date. but when we call it fast formula it's not being called an getting an error.

DEFAULT FOR Policy_Date IS '1901/01/01' (date)

Policy_Date = GET_TABLE_VALUE('XX_INCREMETN_POLICY', 'PERIROD_INFOMRATION,'STARTING_DATE')


DEFAULT FOR Policy_Dat IS 'X'

TO_CHAR(GET_TABLE_VALUE('XX_INCREMETN_POLICY', 'PERIROD_INFOMRATION,'STARTING_DATE'),'DD-MON-YYYY')

I have tried to get date as date and Character as well but in both way getting an error.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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