Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BICC Extract PVO's for PJO_PLAN_VERSIONS_B and PJO_PLAN_LINE_DETAILS
User_K8D6V
Rank 1 - Community Starter
Description
We are looking to pull all the data from ERP-SaaS associated with two Project tables:
1. PJO_PLAN_VERSIONS_B
2. PJO_PLAN_LINE_DETAILS
Currently, the VO's associated with the BICC extractions for these are such that joins/filters cannot be modified, and we are seeing unexpected results. There are not VO's available based on these particular tables. We are opening this ER to request that Oracle add VO's to accommodate these tables.
Use Case and Business Need
We were attempting to use data replication to bring the data that is in ERP-SaaS, into ATP for use in OAC reporting. The use case is such that we would want to bring all the data that exists in SaaS, into ATP. But we cannot do that through this means, because of the VO limitation.
Original Idea Number: 456a8c9997
1