Oracle Fusion · Data dictionary
PJO_PROJECT_PROGRESS
ProjectsUsed in 57 subject areas38 reporting columns
Projects Planning (PJO).
Primary key: not yet catalogued for PJO_PROJECT_PROGRESS, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTUALS_THRU_PERIOD | ● | Actuals thru period. | |
| ACTUAL_COST_THRU_PERIOD_FC | ● | Actual cost thru period fc. | |
| ACTUAL_COST_THRU_PERIOD_PC | ● | Actual cost thru period pc. | |
| ACTUAL_EFFORT_THRU_PERIOD | ● | Actual effort thru period. | |
| ACTUAL_FINISH_DATE | ● | Actual finish date. | |
| ACTUAL_RAW_COST_THRU_PRD_FC | ● | Actual raw cost thru prd fc. | |
| ACTUAL_RAW_COST_THRU_PRD_PC | ● | Actual raw cost thru prd pc. | |
| ACTUAL_START_DATE | ● | Actual start date. | |
| AS_OF_DATE | ● | As of date. | |
| BASELINE_PLAN_COST_FC | ● | Baseline plan cost fc. | |
| BASELINE_PLAN_COST_PC | ● | Baseline plan cost pc. | |
| BASELINE_PLAN_EFFORT | ● | Baseline plan effort. | |
| BASELINE_PLAN_RAW_COST_FC | ● | Baseline plan raw cost fc. | |
| BASELINE_PLAN_RAW_COST_PC | ● | Baseline plan raw cost pc. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| EARNED_VALUE_COST_FC | ● | Earned value cost fc. | |
| EARNED_VALUE_COST_PC | ● | Earned value cost pc. | |
| EARNED_VALUE_EFFORT | ● | Earned value effort. | |
| ESTIMATED_FINISH_DATE | ● | Estimated finish date. | |
| ESTIMATED_START_DATE | ● | Estimated start date. | |
| ETC_CALC_METHOD | ● | Etc calc method. | |
| ETC_COST_FC | ● | Etc cost fc. | |
| ETC_COST_PC | ● | Etc cost pc. | |
| ETC_EFFORT | ● | Etc effort. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| ORIGINAL_PERCENT_COMPLETE | ● | Original percent complete. | |
| PERCENT_COMPLETE | ● | Percent complete. | |
| PERCENT_COMP_CALC_METHOD | ● | Percent comp calc method. | |
| PROGRESS_PERIOD | ● | Progress period. | |
| PUBLISHED_FLAG | ● | Indicator (Y/N) for the published. | |
| SUMMARIZATION_DATE | ● | Summarization date. | |
| TOTAL_PLAN_COST_FC | ● | Total plan cost fc. | |
| TOTAL_PLAN_COST_PC | ● | Total plan cost pc. | |
| TOTAL_PLAN_EFFORT | ● | Total plan effort. | |
| TOTAL_PLAN_RAW_COST_FC | ● | Total plan raw cost fc. | |
| TOTAL_PLAN_RAW_COST_PC | ● | Total plan raw cost pc. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Costing - Cost Accounting Real Time
- Costing - Period Inventory Valuation Real Time
- Costing - Receipt Accounting Real Time
- Costing - Work Order Costs Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Innovation Management - Product Proposals Real Time
- Installed Base - Customer Asset Real Time
- Inventory - Inventory Balance Real Time
- Inventory - Inventory Cycle Count Real Time
- Inventory - Inventory Supply Real Time
- Inventory - Inventory Transactions Real Time
- Inventory - Inventory Transfer Order Real Time
- Maintenance Management - Asset Real Time
- Maintenance Management - Material Usage Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Maintenance Management - Resource Usage Real Time
- Maintenance Management - Work Order Performance Real Time
- Manufacturing - Actual Production Real Time
- Manufacturing - Material Usage Real Time
- Manufacturing - Purchased Item Usage Real Time
Need the extract + dbt staging for PJO_PROJECT_PROGRESS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table