Get string value from value set() not working as expected in Autocomplete Rules
Summary:
We are using this Get string value from value set() function in our autocomplete rule and it stopped working as expected.
We have implemented an ACR last year and it was working fine until we noticed today. Upon investigation, we found that the UDT Name parameter seems to be accepting the BASE_USER_TABLE_NAME instead of USER_TABLE_NAME .
Example:
BEFORE it was working like this:
Get string value from value set(ORA_HRC_ACR_GET_VALUE_FROM_UDT,<****>,<****-XX-XX>,Name_of_list,XXXX,****)
NOW it is only working if udt code i used:
Get string value from value set(ORA_HRC_ACR_GET_VALUE_FROM_UDT,<****>,<****-XX-XX>,NAME_OF_LIST,XXXX,****)