DATA INTEGRATION BETWEEN PROJECT SYSTEMS

• US 20110016084A1
• Filed: 07/15/2009
• Published: 01/20/2011
• Est. Priority Date: 07/15/2009
• Status: Active Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: SUN, Mary, WANG, Tianyi, SUNDARESAN, Sivakumar, MUNDY, Kiran, BALL, Simon
• Application Number:
  US12/503,472
• Publication Number:
  US 20110016084A1
• Time in Patent Office: Days
• US Class Current: 707/613
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

A project systems integrator integrates a financial planning system and an operational planning system for a project. The integrator loads a work breakdown structure (“WBS”) from the financial planning system and another WBS from the operational planning system. The integrator then records links between corresponding nodes of the financial WBS and operational WBS. When data is entered, updated, or otherwise changed, the data is propagated between the nodes in accordance with the links.

Claims

1. A computer-readable medium having instructions stored thereon that, when executed by a processor, cause the processor to integrate a financial planning system and an operational planning system for a project by:

loading a first work breakdown structure (WBS) from the financial planning system;

loading a second WBS from the operational planning system;

recording at least one link between a first node in the first WBS and a second node in the second WBS; and

propagating data between the first node and the second node via the link.

2. The computer-readable medium of claim 1, wherein data entered into the financial planning system at the first node is propagated to the second node.

3. The computer-readable medium of claim 1, wherein data entered into the operational planning system at the second node is propagated to the first node.

4. The computer-readable medium of claim 1, further comprising recording a plurality of links linking a plurality of nodes in the first WBS and a plurality of nodes in the second WBS.

5. The computer-readable medium of claim 4, wherein the plurality of links are many-to-one.

6. The computer-readable medium of claim 4, wherein the plurality of links are one-to-one.

7. The computer-readable medium of claim 1, wherein the data flows in a one-way direction from the first node to the second node, and the data comprises at least one of:

resource definition data, resource availability data, and budget data.

8. The computer-readable medium of claim 1, wherein the data flows in a one-way direction from the second node to the first node, and the data comprises at least one of:

resource assignment data, resource demand data, estimated hours at completion data, estimated cost at completion data, cost of work done data, and percent completed data.

9. The computer-readable medium of claim 1, wherein the data flows in a two-way direction between the first node and the second node.

10. The computer-readable medium of claim 1, wherein the at least one link is changed to link the first node to a third node in the second WBS.

19. The computer-readable medium of claim 1, wherein the first node and second node are tasks.

20. The computer-readable medium of claim 1, wherein the data comprises changed data from the first WBS or the second WBS.

11. A computer-implemented method for integrating a financial planning system and an operational planning system for a project, comprising:

loading a first work breakdown structure (WBS) from the financial planning system;

loading a second WBS from the operational planning system;

recording at least one link between a first node in the first WBS and a second node in the second WBS; and

propagating data between the first node and the second node in accordance with the link.

12. The method of claim 11, wherein data entered into the financial planning system at the first node is propagated to the second node.

13. The method of claim 11, wherein data entered into the operational planning system at the second node is propagated to the first node.

14. The method of claim 11, wherein the data flows in a one-way direction from the first node to the second node, and the data comprises at least one of:

resource definition data, resource availability data, and budget data.

15. The method of claim 11, wherein the data flows in a one-way direction from the second node to the first node, and the data comprises at least one of:

resource assignment data, resource demand data, estimated hours at completion data, estimated cost at completion data, cost of work done data, and percent completed data.

16. A system for integrating a financial planning system and an operational planning system for a project, comprising:

a financial planning system having a first work breakdown structure (WBS);

an operational planning system having a second WBS; and

a project systems integrator that records at least one link between a first node in the first WBS and a second node in the second WBS and propagates data between the first node and the second node in accordance with the link.

17. The system of claim 16, wherein the link comprises a web service.

18. The system of claim 16, wherein the link comprises extract, load and transport integration.