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