You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!