The work breakdown structure

A work breakdown structure (WBS) is a hierarchy that consists of a top‐level project and top‐level, mid‐level, and lowest‐level tasks. A lowest‐level task is a task that does not have any child tasks.

You can create work breakdown structures in Oracle Project Accounting. Creating the work breakdown structure includes the following activities:
  • Defining a project and related tasks
  • Assigning budget information to the project
  • Assigning labor, material, and tools to the tasks
The following diagram shows the typical work breakdown structure:
Figure 1. Work breakdown structure
Diagram depicting the typical work breakdown structure

For more information about creating work breakdown structures, see the Oracle Project Accounting User Guide.

Maximo Asset Management System cost management application

The Maximo® Asset Management Cost Management application stores work breakdown structures and summarized project and task costs at the site level. The integration framework process assigns a unique financial control ID to each project and task that it adds to Maximo Asset Management.

Transfer project and task data to Maximo Asset Management

To transfer project and task data from Oracle Project Accounting to the Maximo Asset Management Cost Management application, you must first run three processes to distribute costs and generate rolled‐up costs for each entry within the work breakdown structure. You then run the financial extract concurrent process (PRC: Financial Update from Oracle) to extract and transfer updated work breakdown structure and summarized cost data to Maximo Asset Management.

The latter process does not create actuals against the Maximo Asset Management work orders. Expenditures entered as actuals against a task within the Oracle Project Accounting are part of the rolled‐up costs.

Depending on how you configure project types and task types in Oracle Projects, the integration framework passes burdened costs or raw costs to Maximo Asset Management.

Perform the project and task integration as often as necessary, after updating work breakdown structures or costs in Oracle Project Accounting.

Process Description
PRC: Distribute Labor Costs Distributes labor costs to general ledger accounts
PRC: Distribute Usage and Miscellaneous Costs Distributes non‐labor costs to general ledger accounts

You can run the first two processes in any order.
PRC: Update Project Summary Amounts Generates rolled‐up inception‐to‐date budget, burdened, and committed costs for each entry in a project work breakdown structure
PRC: Maximo Asset Management Financial Update from Oracle Transfers updated work breakdown structure and summarized cost data to Maximo Asset Management.
You can enter the following optional parameters to filter projects:
  • Operating Unit ID
  • Project Number
  • Budget Type
  • Start Date

The current operating unit is the default operating unit ID.

If you enter a budget type, the process passes all budget amounts for that budget type to Maximo Asset Management.

If you do not enter a budget type and the project has one budget type, the process passes the budget amount for that type to Maximo Asset Management. If the project has multiple budget types, the process sets the budget amount in Maximo Asset Management to null.

The process extracts records updated on or after the start date. If you do not enter a start date, the screen displays the date in the Oracle FCEXTRACTDATE control. If you erase that value, the process extracts all projects that meet the project number and operating unit ID criteria.

Project and task information updates

Add and modify projects and tasks in Oracle Project Accounting, not in Maximo Asset Management. If you delete a task in Oracle Project Accounting, manually delete it in Maximo Asset Management, as the integration framework does not delete project information.

Project and task integration controls

The project and task integration uses the following Projects integration‐specific Maximo Asset Management and Oracle integration controls.

Table 1. Project and task integration controls
Control Description System
FCEXTRACTDATE Date financial extract program (PRC: Maximo Asset Management Financial Update from Oracle) last run Oracle E-Business Suite
FCSTATUSXREF Cross‐reference Oracle project status and Maximo Asset Management financial control status Maximo Asset Management