nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

VOs missing in BICC & OTBI - Projects views mapping not available

User_0NZKD

Organization Name

Archrock Services LP

Description

Looks like the Projects views do not have the related VOs mapping in OTBI. It will really help for creating Project reports with VOs.

PJF_TASKS_V
pjf_proj_all_members_v

Use Case and Business Need

We are working on a project of converting our EBS reports and data warehouse reports to cloud with ADW & BICC. In order to create reports on Projects, we are unable to find the Projects VOs in 20 C or 20 D.

HCM https://cloudcustomerconnect.oracle.com/posts/925646a5f0

FSCM https://cloudcustomerconnect.oracle.com/posts/c6614f9d47
CX https://cloudcustomerconnect.oracle.com/posts/3f1cae5e32

Original Idea Number: 6a3600492e

Find more posts tagged with

Submitted

Status: Submitted

Comments

Christine Mink-189236

Data elements need to be added to PVO in BICC to enable access via ADW reporting

User_0NZKD

Oracle provided an update that all these tables are part of the VO's in 21B.
PJC_COMMITMENT_TXNS
PJC_EXP_ITEMS_ALL
PJF_PROJ_ELEMENTS_TL
PJF_PROJ_ELEMENTS_B
PJF_TXN_SOURCES_B
PJF_TXN_SOURCES_TL

Oracle also highlighted that last 3 tables are the ones that customers should be using which are also available in 21B.

PJF_PROJ_ALL_MEMBERS_V -> "PJF_PROJECT_PARTIES"
PJF_TASKS_V -> "PJF_PROJ_ELEMENTS_B, PJF_PROJ_ELEMENTS_TL"
PA_TRANSACTION_SOURCES -> "PJF_TXN_SOURCES_B, PJF_TXN_SOURCES_TL"

We will close this once 21 B is released.

Brendan J. Doyle-Oracle

Hi there,

Thank you for your idea. I am relocating it to our Transactional Reporting (OTBI) Idea Lab for proper review: https://cloudcustomerconnect.oracle.com/resources/b2df648d2a/summary

Best,

Brendan J. Doyle

Arpan Chowdhury

there is requirement for BICC extract for one of the EBS table "pa_resource_list_uses_v" , i'm unable to figure out the corresponding fusion table to be used for BICC extract. Can anyone please help?