Line level invoice information is extracted from the Invoice Line table (PA_DRAFT_INVOICE_ITEMS) in the Billing Module of E-Business Suite and loaded into Invoice Line Fact (W_PROJ_INVOICE_LINE_F).
All invoices at any stage of the invoice generation process, such as creation, approval, release, transfer, and so forth, are loaded into this table so that customers can see a full view of the invoices. Some of the information available in the Invoice Header Table (PA_DRAFT_INVOICES_ALL) such as GL Date and PA Date; and flags such as Write-Off Flag, Concession Flag, Cancelled Flag, and Retention Invoice Flag in E-Business Suite, have also been denormalized into Invoice Line Fact.
For E-Business Suite, Invoice Currency is the Document Currency for this fact.
Note:
The E-Business Suite concurrent programs, such as PRC: Generate Draft Invoices for a Single Project or PRC: Generate Draft Invoices for a Range of Projects, for generating draft invoices, or PRC: Interface streamline Process, for transferring invoice to Receivables, should be run before the ETL is run to load Oracle Business Analytics Warehouse.