UDT is not fetching data in compensation calculation Fast formula? — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

UDT is not fetching data in compensation calculation Fast formula?

Summary:

Compensation calculation fast formula is not getting data from the UDT.

Content (required):

Below is the code, The Fast formula function get_table_value is only returning Default values.

Version (include the version you are using, if applicable):

Oracle Fusion Cloud Applications

23B (11.13.23.04.0)

Code Snippet (add any code snippets that support your topic, if applicable):

DEFAULT FOR CMP_ASSIGNMENT_SALARY_ANNUAL_AMOUNT IS 0

DEFAULT_DATA_VALUE for ELEMENT_ENTRY_BASE_ELEMENT_NAME IS 'N'

DEFAULT_DATA_VALUE for ELEMENT_ENTRY_VALUE is '0'


l_eff_date    = GET_CONTEXT(EFFECTIVE_DATE,to_date('1951/01/01 0:00:00'))

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!