Go to primary content

Oracle® Product Lifecycle Analytics Multi-Dimensional Schema Data Reference Manual Release 3.6 E84200-01 |
| Contents

Previous | Next |

# 3 Entity-Relationship Diagrams

This chapter consists of the Entity Relationships in the Oracle Product Lifecycle Analytics MDS.

ER Diagrams for Agile A9 PLM Source

The ER's under the following sections are specific to only Agile A9 PLM source:

- Problem Reports

- Non Conformance Reports

- Corrective and Preventive Actions

- Audit

- Deviations

- Engineering Change Order

- Engineering Change Request

- Item

- Manufacturer Change Order

- Stop Ship

Note: The tables showing P4P are applicable only when the source is Agile PLM for process.

ER Diagrams for Agile PLM for Process Source

The ER's under the following sections are specific to only Agile PLM for Process source:

- Project Metrics

- Phase gate Signoff

- Project Detail Workflow

- Project Detail Signoff

- Specifications

- Specifications Workflow

## Problem Reports

### Problem Reports Fact

Figure 3-1 Problem Reports Fact

### Problem Reports Item Fact

Figure 3-2 Problem Reports Item Fact

### Problem Reports - Workflow Detail

Figure 3-3 Problem Reports - Workflow Detail

## Non Conformance Reports

### NCR Fact

Figure 3-4 NCR Fact

### NCR Workflow Detail

Figure 3-5 NCR Workflow Detail

## Corrective and Preventative Actions

### CAPA Fact

Figure 3-6 CAPA Fact

### CAPA Item

Figure 3-7 CAPA Item

### CAPA Workflow Detail

Figure 3-8 CAPA Workflow Detail

## Audit

### Audit Fact

Figure 3-9 Audit Fact

### Audit Item

Figure 3-10 Audit Item

### Audit Workflow Detail

Figure 3-11 Audit Workflow Detail

## Deviations

### DEV Fact

Figure 3-12 Dev Fact, part 1 of 2

Figure 3-13 DEV Fact, part 2 of 2

### DEV Item Fact

Figure 3-14 DEV Item Fact, part 1 of 2

Figure 3-15 DEV Item Fact, part 2 of 2

### DEV Sign-off Fact

Figure 3-16 DEV Sign-off Fact

### DEV Workflow Detail

Figure 3-17 DEV Workflow Detail

## Engineering Change Order

### ECO Fact

Figure 3-18 ECO Fact, part 1 of 2

Figure 3-19 ECO Fact, part 2 of 2

### ECO Item Fact

Figure 3-20 ECO Item Fact, part 1 of 2

Figure 3-21 ECO Item Fact, part 2 of 2

### ECO Sign-off Fact

Figure 3-22 ECO Sign-off Fact

### ECO Workflow Detail

Figure 3-23 ECO Workflow Detail

## Engineering Change Request

### ECR Fact

Figure 3-24 ECR Fact, part 1 of 2

Figure 3-25 ECR Fact, part 2 of 2

### ECR Item Fact

Figure 3-26 ECR Item Fact, part 1 of 2

Figure 3-27 ECR Item Fact, part 2 of 2

### ECR Workflow Detail Fact

Figure 3-28 ECR Workflow Detail Fact

### ECR Sign-off Fact

Figure 3-29 ECR Sign-off Fact

## Item

### Item Fact

Figure 3-30 Item Fact, part 1 of 3

Figure 3-31 Item Fact, part 2 of 3

Figure 3-32 Item Fact, part 3 of 3

### Manufacturer Part Fact

Figure 3-33 Manufacturer Part Fact, part 1 of 2

Figure 3-34 Manufacturer Part Fact, part 2 of 2

### Item Manufacturer Part Fact

Figure 3-35 Item Manufacturer Part Fact, part 1 of 2

Figure 3-36 Item Manufacturer Part Fact, part 2 of 2

## Manufacturer Change Order

### MCO Fact

Figure 3-37 MCO Fact, part 1 of 2

Figure 3-38 MCO Fact, part 2 of 2

### MCO Item Fact

Figure 3-39 MCO Item Fact, part 1 of 2

Figure 3-40 MCO Item Fact, part 2 of 2

### MCO Signoff Fact

Figure 3-41 MCO Signoff Fact

### MCO Workflow Detail Fact

Figure 3-42 MCO Workflow Detail Fact

## Stop Ship

### Stop Ship Fact

Figure 3-43 Stop Ship Fact, part 1 of 2

Figure 3-44 Stop Ship Fact, part 2 of 2

### Stop Ship Item Fact

StopShipItemFact

Figure 3-45 Stop Ship Item Fact, part 1 of 2

Figure 3-46 Stop Ship Item Fact, part 2 of 2

### Stop Ship Signoff Fact

Figure 3-47 Stop Ship Signoff Fact

### Stop Ship Workflow Detail Fact

Figure 3-48 Stop Ship Workflow Detail Fact

## PPM

### PPM - Activity

Figure 3-49 PPM - Activity, diagram 1 of 2

Figure 3-50 PPM - Activity, diagram 2 of 2

### PPM - Baseline

Figure 3-51 PPM - Baseline

### PPM - Phase Gate

Figure 3-52 PPM - Phase Gate

### Phase Gate Singoff

Figure 3-53 Phase Gate Signoff

### PPM - Portfolio

Figure 3-54 PPM - Portfolio, part 1 of 2

Figure 3-55 PPM - Portfolio, part 2 of 2

### PPM - Project Cost

Figure 3-56 PPM - Project Cost, part 1 of 2

Figure 3-57 PPM - Project Cost, part 2 of 2

### PPM Project Details

#### PPM Project Details, Signoff

Figure 3-58 PPM Project Details, Signoff

#### PPM Project Details, Workflow

Figure 3-59 Project Details, Workflow

### PPM - Project Summary

Figure 3-60 PPM - Project Summary

### PPM - Project Forecast Revenue

Figure 3-61 PPM - Project Forecast Revenue, part 1 of 2

Figure 3-62 PPM - Project Forecast Revenue, part 2 of 2

### PPM - Program

Figure 3-63 PPM - Program, part 1 of 2

Figure 3-64 PPM - Program, part 2 of 2

### PPM - Snapshot

Figure 3-65 PPM - Snapshot

The ER diagrams for the cumulative ECO fact tables are same as the ECO fact tables exceptf or the time dimension.

PC_ECO_CUM_COMP_FSCL_YEAR_F, PC_ECO_CUM_COMPLETED_YEAR_F,PC_ECO_CUM_NEW_FSCL_YEAR_F, PC_ECO_NEW_YEAR_F,

PC_ECO_CUM_REL_FSCL_YEAR_F, PC_ECO_CUM_RELEASED _YEAR_F tables are qualified with time dimension at year level.

PC_ECO_CUM_COMP_FSCL_QTR_F, PC_ECO_CUM_COMPLETED_ QTR_F,PC_ECO_CUM_NEW_ QTR_YEAR_F, PC_ECO_NEW_ QTR_F, PC_ECO_CUM_REL_FSCL_

QTR_F, PC_ECO_CUM_RELEASED _ QTR_F are qualified at the quarter level.

PC_ECO_CUM_COMP_FSCL_MONTH_F, PC_ECO_CUM_COMPLETED_ MONTH_F, PC_ECO_CUM_NEW_ QTR_ MONTH_F,PC_ECO_NEW_ MONTH_F,

PC_ECO_CUM_REL_FSCL_ MONTH_F,PC_ECO_CUM_RELEASED _ MONTH_Fare qualified at month level.

PC_ECO_CUM_COMP_FSCL_WEEK_F, PC_ECO_CUM_COMPLETED_ WEEK_F, PC_ECO_CUM_NEW_ QTR_ WEEK_F, PC_ECO_NEW_ WEEK_F, PC_ECO_CUM_REL_FSCL_

WEEK_F, PC_ECO_CUM_RELEASED _ WEEK_F are qualified at week level.