General Ledger - EBS (MOSC)

MOSC Banner

Dynamically change report parameter (Period Name) value on a scheduled FSG report in Report Manager

We have a request to dynamically reset the value of a scheduled FSG report (Income Statement) parameter: Period. We want to change it to prior month based on the report running date/time and repeat every month. e.g. we want to use JUN-18 for Period parameter when we schedule to run it on July 1, we want to automatically change it to JUL-18 on next month scheduled run on August 1 etc.. A screen shot of the report parameters and  scheduling options is shown below.

I know we can do a "wrapper" concurrent program to reset the parameter value of a report with a standard request submission and schedule it,  but how to do similar with a FSG report in Report Manager ?

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