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 Manage Cost Management application

The Maximo® Manage 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 Manage.

Transfer project and task data to Maximo Manage

You need to transfer project and task data from Oracle Project Accounting to the Maximo Manage Cost Management application. To transfer project and task data, 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 Manage.

The latter process does not create actuals against the Maximo Manage 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 Manage.

Do the project and task integration as often as necessary after you update 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 Manage Financial Update from Oracle Transfers updated work breakdown structure and summarized cost data to Maximo Manage.
You can enter the following nonmandatory 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 Manage.

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 Manage. If the project has multiple budget types, the process sets the budget amount in Maximo Manage to null.

The process extracts records that are 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 Manage. If you delete a task in Oracle Project Accounting, manually delete it in Maximo Manage, 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 Manage and Oracle integration controls.

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