Configuration – Check table based value from backend

There are many scenarios where a table validated value set is created which is then called in fast formulas. using GET_VALUE_SET function using a parameter.

For developers, it is a headache to test the value coming from value set as they have to write log statements in fast formula to debug that.

One easy way of doing that is to use pay_ff_functions.gvs function from BIP.

Sample code:

SELECT pay_ff_functions.gvs ('EMP_NATIONALITY','|=P_PERSON_ID='''||'1123121') VALUE FROM DUAL