Oracle R12 FSG column set showing Months from January, February, March, .....November, December
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.