My Oracle Support Banner

Missing PJF Tables In BICC PVO Data Lineage Repository (Doc ID 2604212.1)

Last updated on JUNE 16, 2021

Applies to:

Oracle Fusion Project Foundation Cloud Service - Version 11.13.19.07.0 and later
Information in this document applies to any platform.
BICCC

Goal

Missing PJF Application Period Tables in BICC PVO Data Lineage Repository

The following tables are not in the BICC Public View Objects PVOs:
PJF_PROJECT_PARTIES
PJT_PROJECT_ROLES_B
PJR_ASSIGNMENT
PJF_PERIODS_ALL
PJF_PROJ_ROLE_TYPES_TL
PJF_TP_SCHEDULE_LINES
PJF_OBJ_STATUS_CHANGES
PJF_RATE_SCHEDULES_B
PJF_RATE_SCHEDULE_LINES

 

These views are required for retrieving data for the following BI publisher reports:

BI Publisher Report
----------------------------
Project_Periods_Extract
Project_Roles_Resources_Extract
Project_Schedule_Lines_Extract
Project_Status Hist_Extract
Resource_Cost_Rate
Datasecurity - User Responsibility
Datasecurity- User Project
Project Workplan Fact



 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.