How to pass comma separated values as input parameter in BIP – Oracle Fusion Applications

Sample Code

SELECT
hp.party_id, hp.party_Number, hp.party_name 
FROM hz_parties hp 
where 1=1
and hp.party_number IN
 (  select regexp_substr (
           :P_PARTY_NUM_CSV,
           '[^,]+',
           1,
           level
         ) value
  from   dual 
  connect by level <= 
    length ( :P_PARTY_NUM_CSV ) - length ( replace ( :P_PARTY_NUM_CSV, ',' ) ) + 1 )