1 Introduction

Introduction

The Data Reference Manual (DRM) describes the data model entities of the Published Model of Oracle Product Lifecycle Analytics Multi-Dimensional Schema (MDS). The schema reference tables are documented across DRM Volume 1 and DRM Volume 2 in release 3.3.1.1.

Intended users of this document are advanced database developers who extend and customize the MDS data model to build custom solutions based on the prepackaged dashboards and reports within the Oracle Product Lifecycle Analytics application.

Note: The schema reference provided with the product may change in future releases. Any customized solution provided on the basis of this reference manual is not supported and you may need to make appropriate changes in future releases.

Acronyms

Table 1-1 Acronyms used in this manual

Acronym	Expansion
BI	Business Intelligence
CAPA	Corrective and Preventive Action
DB	Data Base
DEV	Deviations
ECO	Engineering Change Order
ECR	Engineering Change Request
ETL	Extract-Transform-Load
FK	Foreign Key
MCO	Manufacturing Change Order
MDS	Multi-Dimensional Schema
NCR	Non-Conformance Report
OBIEE	Oracle Business Intelligence Enterprise Edition
ODI	Oracle Data Integrator
PC	Product Collaboration
PLM	Product Lifecycle Management
PPM	Product Portfolio Management
PQM	Product Quality Management
PR	Problem Report
PSR	Problem Service Request
SS	Stop Ship

What's New in Oracle Product Lifecycle Analytics 3.3.1.0.0

New tables (PC_ECO_CUM_%) have been added to aggregate fact tables in ECO area at fiscal week, month, quarter, and year levels.

New dimension tables (W_WEEK_D, W_MONTH_D, W_QTR_D,W_YEAR_D) have been added to store calendar data for report calculations.

The following columns have been added into existing tables:

Table 1-2 New tables in OPLA 3.3.1.0.0

Table Name	New Column
PC_ECO_F	NEW_FLG NUMBER(1)
ETL_PARAMETER	ECO_WKLY_AGGR_SINCE DATE