About Project Invoice Fact

The Invoice Line Fact table (W_PROJ_INVOICE_LINE_F) stores line-level invoice information extracted from the Invoice Line table (PA_DRAFT_INVOICE_ITEMS) in the Oracle E-Business Suite Billing module.

This fact table includes invoice lines for invoices at every stage of the invoice lifecycle, including creation, approval, release, transfer, and other processing stages. As a result, it provides a comprehensive view of invoice activity throughout the billing process.

In addition to line-level details, selected header-level attributes from the Invoice Header table (PA_DRAFT_INVOICES_ALL) are denormalized into the Invoice Line Fact. These include:

• GL Date

• PA Date

• Write-Off Flag

• Concession Flag

• Cancelled Flag

• Retention Invoice Flag

For Oracle E-Business Suite source systems, the Invoice Currency in the Invoice Line Fact corresponds to the Document Currency of the invoice.