BI publisher parameter not working In Fusion

Hi All,

Please can anyone tell me why this basic script is not pulling up data from BI publisher.

The paramteer has the required LOV but does not pull data from this script. The two LOV script is just basic like select ledger name from GL_ledgers order by Ledger_Name and the second LOV is select Period_Name from GL JE Headers order by Period)name. But Testing same script in sql developer, it works

SELECT DISTINCT GLR.NAME  "LEDGER NAME"

, GJH.NAME

,       GJH.CURRENCY_CODE "CurrencyCode"

, SUM(NVL(GJL.Entered_DR,0))  "Entered DR"

, SUM(NVL(GJL.Entered_CR,0))  "Entered CR"