Hyperion Financial Close Management (FCM) (MOSC)

MOSC Banner

ARM Report Manager parameter query not passing parameters

edited Nov 11, 2015 9:54AM in Hyperion Financial Close Management (FCM) (MOSC) 4 commentsAnswered ✓

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)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center