ARM Report Manager parameter query not passing parameters
I intended to use a list of ARM Profiles as a parameter to another query. I created the SQL below, which generates the desired output in SQL Developer, but when saved as a parameter query, nothing comes up. Even when I edit report, the parameter value list is still empty. The parameter type is defined as a query.
SELECT ProfileEO.RECONCILIATION_ACCOUNT_ID
FROM ARM_RECONCILIATIONS ProfileEO
WHERE (ProfileEO.PERIOD_ID IS NULL)