General Ledger - EBS (MOSC)

MOSC Banner

Option to schedule a GL Custom program where period parameter needs to be dynamically change on firs

edited Aug 10, 2018 10:23AM in General Ledger - EBS (MOSC) 2 commentsAnswered

Hi All,

We are building a custom report which extracts the GL Balances of all Balance Sheet accounts along with some other columns and the output will be automatically emailed to concerned stake holders.

This report has Period Parameter which is a Mandatory parameter

We want to schedule this report once, but we want the period parameter to change dynamically on first of every month.

Ex:- If we schedule this report say today (i..e. on 08-Aug-2018) with Period parameter as "AUG-18". We want the report parameter to be dynamically changed to "Sep-18" on 01-Sep-2018 and again this needs to be changed to "Oct-18" on 01-Oct-2018 and so on...

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