HCM Extract – Using Multiple values in Parameter
There is a frequent requirement of using a parameter in HCM Extracts which can accept multiple comma separated values. For example, in Worker Extract, we need to have a Parameter called PER_NUMBER which should accept multiple comma separated values. To split the input values, we can use REGEXP_SUBSTR function.
