Results for “fle_lookup_type3”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_DRAFT_INVOICE_ITEMS is a core table in the Oracle Projects (PA) module of Oracle E-Business Suite 12.1.1 / 12.2.2. It stores the individual line-level records that make up draft invoices generated by the Project Billing process. When Oracle Projects generates a draft invoice for a project or contract, the header-level information is written to PA_DRAFT_INVOICES_ALL, while the corresponding detail lines — one row per billable line item, retention line, credit, or tax line — are stored in PA_DRAFT_INVOICE_ITEMS. These lines are subsequently reviewed, adjusted, released, and eventually transferred to Oracle Receivables as transactions.

Because the table holds transactional attributes that describe individual invoice lines and inherit their identity from the parent draft invoice, the heuristic Data Vault classification supplied in the metadata is satellite-leaning. In a dimensional or Data Vault model, PA_DRAFT_INVOICE_ITEMS is best treated as a satellite attached to the PA_DRAFT_INVOICES_ALL hub/link, carrying descriptive and quantitative line attributes rather than acting as a standalone hub. The parent-child dependency is enforced through the composite primary key and foreign keys to the invoice header.

Key Information Stored

The table contains 98 documented columns. The most operationally significant are listed below; the primary key is composite and business-meaningful rather than a meaningless surrogate:

• PROJECT_ID, DRAFT_INVOICE_NUM, LINE_NUM — the composite primary key (PA_DRAFT_INVOICE_ITEMS_PK) and the unique business key (PA_DRAFT_INVOICE_ITEMS_U1). Together they identify each line of a given draft invoice for a given project.
• INVOICE_LINE_TYPE — classifies the line (for example, regular, retention, credit, or tax lines), driving downstream processing logic.
• AMOUNT, INV_AMOUNT, ACCT_AMOUNT — the draft line amount, invoice currency amount, and accounting amount, respectively.
• TASK_ID, EVENT_TASK_ID, EVENT_NUM — link the line to the project task and the event that generated it.
• SHIP_TO_ADDRESS_ID, OUTPUT_VAT_TAX_ID, OUTPUT_TAX_EXEMPT_FLAG — tax and shipping detail used when transferring the line to Receivables.
• CC_REV_CODE_COMBINATION_ID, CC_PROJECT_ID, CC_TAX_TASK_ID — the credit code combination and credit project/task identifiers used for revenue and credit processing.
• RETN_DRAFT_INVOICE_NUM, RETN_DRAFT_INVOICE_LINE_NUM, RETN_BILLING_CYCLE_ID, RETAINED_AMOUNT — retention-related columns connecting retention lines back to the line and billing cycle that generated them.
• CREDIT_AMOUNT, CREDIT_PROCESS_FLAG — indicators used when the line represents or participates in credit processing.

Common Use Cases and Queries

Typical reporting and troubleshooting activities involve reconciling generated draft invoice lines, verifying retention and credit handling, and confirming amounts before transfer to Receivables. A representative query joining the line to its header follows:

• Listing all lines for a draft invoice: SELECT line_num, invoice_line_type, amount, task_id FROM pa_draft_invoice_items WHERE project_id = :p_id AND draft_invoice_num = :num ORDER BY line_num;
• Summarizing draft invoice amounts by line type for a project to verify revenue and retention balances.
• Identifying retention lines by querying RETN_DRAFT_INVOICE_NUM and RETENTION_RULE_ID, then tracing them to the originating line.
• Auditing credit processing by filtering on CREDIT_PROCESS_FLAG and CREDIT_AMOUNT.
• Extracting tax-related lines using OUTPUT_VAT_TAX_ID and OUTPUT_TAX_CLASSIFICATION_CODE prior to Receivables transfer.

Because the table is written during the draft invoice generation concurrent program, ROW records can be traced using REQUEST_ID and PROGRAM_ID for a specific run.

Related Objects

The table is tightly coupled to several parent and child objects in the PA schema:

• PA_DRAFT_INVOICES_ALL — parent invoice header; joined on PROJECT_ID and DRAFT_INVOICE_NUM.
• PA_DRAFT_INVOICE_DETAILS_ALL — child detail records referencing the line.
• PA_CUST_REV_DIST_LINES_ALL and PA_CUST_EVENT_RDL_ALL — revenue distribution lines that reference the draft invoice item.
• PA_RETN_INVOICE_DETAILS and PA_MC_RETN_INV_DETAILS — retention invoice detail tables linked via PROJECT_ID.
• PA_TASKS and PA_PROJECTS_ALL — provide the task and project context (TASK_ID, CC_PROJECT_ID).
• GL_CODE_COMBINATIONS — supplies the credit revenue account via CC_REV_CODE_COMBINATION_ID.
• AR_VAT_TAX_ALL_B — tax definition for OUTPUT_VAT_TAX_ID.
• HZ_CUST_ACCT_SITES_ALL and RA_ADDRESSES_ALL — ship-to address resolution.