Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)

MOSC Banner

Multiperiod export from epmcs to oracle table

Hello,

We are trying to export forecast data for 12 months in column format (period in column) and load to oracle table. Data integration has the option to pivot period to column and export a file but not for direct load to on prem database. so we created the first integration to export a file with periods in column and then second integration to load that file into oracle table but unable to load all 12 months in column format. error says, invalid data. In the insert query, we mapped JAN_AMOUNT, FEB_AMOUNT etc from table to Jan, Feb etc in the

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