General Ledger - EBS (MOSC)

MOSC Banner

Oracle R12 FSG column set showing Months from January, February, March, .....November, December

edited Dec 20, 2010 4:57PM in General Ledger - EBS (MOSC) 7 commentsAnswered
 We have a requirement for some reports that requires us to create a row set with current_Year, Previous_Year, and 2 Years Ago. On the column set we need to built 12 columns for the 12 months from January to December plus a column for YTD Comparative and Annual. We tried using the existing YTD-Actual, Monthly, and PTD but realize that it doesn't work.

Rows:

YYYY

YYYY-1

YYYY-2

These years rows share the same account ranges for account assignment.

Columns:

January

February

March

April

May

June

July

August

September

October

November

December

The problem is how to pull the years dynamically in FSG without hard-coding since these reports will be run for a long time. Also with the months in the columns they cannot be periods (eg Oct-09) but should be a month independent of year since the years are on the rows.

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