EPM Data Writeback to Two different DB Tables consecutively
Summary:
Hi Team,
We have a requirement where EPM PBCS Data needs to be loaded to two different EBS Staging Tables.
Table One: Week Period, Year, Account, Scenario, Product, Version
05/08/2023,0000,Actual,PR01,Working
05/08/2023,0001,Actual,PR02,Working
05/08/2023,0003,Actual,PR03,Working
05/08/2023,0004,Actual,PR04,Working
05/08/2023,0005,Actual,PR05,Working
Table Two: Week Period
05/08/2023
05/08/2023
05/08/2023
05/08/2023
05/08/2023
Our requirement is to validate Table Two Week Period Rows and create a EBS Program to capture same Rows from Table One and to load to a different table for additional processing.
I tried using Data Integration Query and Table name parallel but Query taking precedence. I can think of a Target application and to reload Second Table Data using Query method but is there any other way where at Single click, we can perform above requirements?