Project Commitments Star Schema

The Oracle E-Business Suite Data Intelligence includes a dedicated Project Commitments star schema to support this subject area.

At the center of the schema is the Project Commitment Fact table (W_PROJ_COMMITMENT_F), which stores the latest commitment information extracted from the Oracle E-Business Suite transactional table PA_COMMITMENT_TXNS.

The fact table contains measures for:

• Total commitment amount

• Commitment quantity

• Raw commitment amount

• Burdened commitment amount

These measures are available for requisitions, purchase orders, and supplier invoices.