Search Results pa_invoice_format_details




Overview
Explore in AI Chat

Overview

The PA_INVOICE_FORMAT_DETAILS table is a core implementation table within the Oracle Projects (PA) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It stores the detailed configuration rules that define how project invoices are formatted and structured. This table operates as a child to the PA_INVOICE_FORMATS table, holding the specific line items or criteria that constitute a complete invoice format. Its primary role is to provide the system with the necessary metadata to generate invoices that meet specific organizational requirements for grouping, sequencing, and presenting transaction lines, such as costs and revenue.

Key Information Stored

The table's structure centers on linking an invoice format to specific grouping columns and defining their order. The primary key, INVOICE_FORMAT_DETAIL_ID, uniquely identifies each configuration line. The critical foreign key column, INVOICE_FORMAT_ID, ties each detail record to a parent format defined in PA_INVOICE_FORMATS. Another essential foreign key, INVOICE_GROUP_COLUMN_ID, references the PA_INVOICE_GROUP_COLUMNS table to specify which project attribute (e.g., Task, Expenditure Type, Resource) is used for grouping invoice lines. Additional columns typically include SEQUENCE_NUMBER to dictate the order of grouping levels within the invoice hierarchy and CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY for audit purposes.

Common Use Cases and Queries

This table is central to troubleshooting invoice generation issues and analyzing invoice format setups. A common use case involves identifying all grouping rules for a specific invoice format to verify its configuration. For reporting, administrators often join this table to related objects to produce a comprehensive map of invoice formats. A typical diagnostic query would be:

  • SELECT fmt.name format_name,
          col.column_name,
          det.sequence_num
    FROM pa_invoice_format_details det,
         pa_invoice_formats fmt,
         pa_invoice_group_columns col
    WHERE det.invoice_format_id = fmt.invoice_format_id
    AND det.invoice_group_column_id = col.invoice_group_column_id
    ORDER BY fmt.name, det.sequence_num;

This query reveals the hierarchy and components of each invoice format, which is essential for validating setups before running the invoice generation process.

Related Objects

The PA_INVOICE_FORMAT_DETAILS table has defined foreign key relationships with two key parent tables, forming the backbone of the invoice formatting setup.

  • PA_INVOICE_FORMATS: This is the parent table. The relationship is maintained via the column PA_INVOICE_FORMAT_DETAILS.INVOICE_FORMAT_ID, which references PA_INVOICE_FORMATS.INVOICE_FORMAT_ID. Each detail record must belong to a single, pre-defined invoice format.
  • PA_INVOICE_GROUP_COLUMNS: This table defines the available attributes for grouping invoice lines. The relationship is maintained via the column PA_INVOICE_FORMAT_DETAILS.INVOICE_GROUP_COLUMN_ID, which references PA_INVOICE_GROUP_COLUMNS.INVOICE_GROUP_COLUMN_ID. This link specifies which attribute is applied at a given grouping level in the format.