Oracle Fusion BI Publisher - Pivot table - Dynamically derive header

Summary:

Hi All, We have a requirement where we have to calculate opening balance of a fund(GL_CODE_COMBINATIONS.SEGMENT6) from GL balances and pivot it to the fund name(Description of parent value of segment6) where the fund name has to be dynamically derived using a subquery for the BIP report. Our requirement met when we hardcoded these fund names in the pivot section (as mentioned in below example).

Eg. select * from master_data_table pivot( max(opening_balance) for fund_name in ('parent_fund_1','parent_fund_2')

However we are facing challenges in deriving these fund names dynamically using a sub query inside pivot section. So we can dynamically derive the parent_fund_names and can match with fund_name from master_data for pivoting.(as mentioned in below example)