For more information, please refer to this announcement explaining best practices for getting answers to questions.
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)