Results for “exp_report_header_id”
7 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FII_AP_INV_STG is a staging table owned by the FII (Financial Intelligence) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as the intermediate landing area for Accounts Payable summary information, capturing invoice distribution-level detail before it is consumed by downstream Financial Intelligence extraction, transformation, and reporting processes. In a typical EBS implementation, data is populated into FII_AP_INV_STG from Payables transactional tables and subsequently moved into the FII data warehouse star schemas, where it feeds AP aging, spend analysis, supplier performance, and subledger reconciliation reporting.
Based on the foreign key structure mined from the ETRM metadata, this object can be modeled heuristically as a link table in a Data Vault sense. It records associative relationships among invoices, distributions, purchase orders, projects, employees, companies, and accounting flexfield combinations rather than acting as a standalone hub or a descriptive satellite. The 52 documented columns reflect this bridging role, carrying keys and measures that tie AP activity to multiple dimensions.
Key Information Stored
FII_AP_INV_STG spans 52 columns. The most significant include:
- INVOICE_ID and INVOICE_DISTRIBUTION_ID — identifiers for the invoice header and its distribution lines, the core transactional grain.
- INVOICE_NUM, INVOICE_DATE, ACCOUNT_DATE, INVOICE_TYPE — business-key attributes describing the invoice itself.
- SUPPLIER_ID and SUPPLIER_SITE_ID — supplier dimension references.
- SET_OF_BOOKS_ID and LEDGER_ID — ledger context for multi-org and multi-ledger deployments.
- AMOUNT_T and AMOUNT_B — transactional and base currency amounts used for aggregation.
- DIST_CCID and CHART_OF_ACCOUNTS_ID — accounting flexfield combination references.
- PO_HEADER_ID, PO_RELEASE_ID, PO_DISTRIBUTION_ID, PO_NUM, PO_MATCHED_FLAG — purchasing linkage and match status.
- PROJECT_ID and TASK_ID — project accounting context.
- ORG_ID and COST_CENTER_ORG_ID — operating unit and cost center organization identifiers.
- POSTED_FLAG and APPROVED_FLAG — workflow and accounting status indicators.
No surrogate primary key or unique index is documented in the supplied metadata; the table functions primarily as a key-and-measure container whose uniqueness is defined by the combination of invoice distribution, ledger, and org identifiers. Business-key candidates include INVOICE_ID plus INVOICE_DISTRIBUTION_ID and DISTRIBUTION_LINE_NUMBER.
Common Use Cases and Queries
Typical scenarios include AP spend reporting by supplier, cost center, or project; reconciliation between Payables and the General Ledger; and validating PO-matched versus non-PO invoices. A representative query pattern joins the staging table to supplier and accounting dimensions:
- Aggregating
SUM(AMOUNT_B)grouped bySUPPLIER_ID,ORG_ID, andACCOUNT_DATEfor period spend analysis. - Filtering on
PO_MATCHED_FLAGto separate matched and unmatched invoices. - Joining
DIST_CCIDto the accounting flexfield to report by natural account or cost center. - Using
POSTED_FLAGto isolate unposted distributions awaiting accounting. - Project cost queries filtering on
PROJECT_IDandTASK_ID.
Related Objects
The documented foreign keys identify the principal dependencies of FII_AP_INV_STG:
- AP_EXPENSE_REPORT_HEADERS_ALL — joined via EXP_REPORT_HEADER_ID for expense report invoices.
- PO_RELEASES_ALL — joined via PO_RELEASE_ID for release-level purchasing detail.
- GL_MGT_SEG_UPGRADE_H — joined via CHART_OF_ACCOUNTS_ID.
- PSB_EMPLOYEES — joined via EMPLOYEE_ID.
- PN_COMPANIES_ALL — joined via COMPANY_ID.
These relationships confirm the table's role as a consolidation point linking Payables, Purchasing, Projects, and Financials dimensions within the FII reporting architecture.
-
This table is the staging table for AP Summary Information.
-
This table holds AP Summary Information. It is used to support AP and POA portlets.
-
TABLE: FII.FII_AP_INV_STG 12.1.1
-
TABLE: FII.FII_AP_INV_B 12.1.1
-
eTRM - FII Tables and Views 12.1.1
This table stores the mapping of leaf nodes from pruned dimension to nodes in the child value sets