Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Data Extraction Approach for Oracle tables that doesn't have PVO's

edited Sep 19, 2024 5:32AM in Reporting and Analytics for ERP 2 comments

Problem

We need to understand what is the best Data Extraction Approach for Oracle tables that doesn't have PVO's

Came across below approaches:

Approach 1:

Steps:

1. Create a New Data Store
2. Data Store Key: You have to manually enter the full path of OTBI EFF VO: FscmTopModelAM.EgpItemsPublicModelAM.ItemEFFBIFlattenedVO
3. Provide Query Filter as necessary and save
4. You can now select Columns and add the required EFF segments to the data store.

Approach 2:

1. Create BIP report and invoke it to extract incremental data from Oracle SCM but this approach is not recommended as per https://www.ateam-oracle.com/post/using-synchronous-bip-for-extracting-data-dont


Could you please suggest us the best alternative approach?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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