BICC Extract PVO's for PJO_PLAN_VERSIONS_B and PJO_PLAN_LINE_DETAILS — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Submitted
272
Views
1
Comments
User_K8D6V
User_K8D6V Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

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
Up
1 votes

Submitted · Last Updated

Comments

  • Arpan Chowdhury
    Arpan Chowdhury Rank 1 - Community Starter

    Any idea what can be the fusion table used for the EBS table pa_resource_list_uses_v. i need it for BICC extract.