Oracle applications - Surendranath Subramani

Thursday, August 28, 2025

Select multiple parameter values in BIP Oracle Fusion

Purpose:

To show how to select one or more values from the parameter.

example: Item number parameter can be run for All 

example: Item number parameter can be run for selected item(s).

Prerequisite:

  • The report parameter is setup
  • LOV is attached to the parameter


Data Model Query:

select * from egp_system_items_b  ESI
where (ESI.inventory_item_id     IN (:p_item_id) OR 'All' IN (:p_item_id || 'All'))