Results for “fin_category_id”

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

Overview

FII_AP_INV_B_V1 is a view owned by the APPS schema within the FII (Financial Intelligence) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes a curated projection of accounts payable invoice data drawn from the underlying FII base object FII_AP_INV_B, presenting a reduced column set oriented toward financial intelligence reporting and downstream analytical consumption. The view is documented with a VALID status in the ETRM, indicating that it compiles successfully and is available for query at runtime.

Its role is to serve as a stable reporting interface over AP invoice balances and amounts. By selecting a discrete list of columns — account date, prim amount G, cost center org id, invoice id, supplier id, chart of accounts id, financial category id, posted flag, company id, and cost center id — the view isolates the attributes most frequently required by financial analysis, budgeting, and cross-module reporting. The presence of COST_CENTER_ORG_ID directly addresses the search term under which this object was retrieved: it supports queries that segment invoice activity by the operating unit or organization associated with a cost center.

Underlying Base Objects

The documented view text defines FII_AP_INV_B_V1 exclusively over the base object FII_AP_INV_B in the same APPS schema. The ETRM metadata for the referenced base objects lists none explicitly, so the materialized dependency is captured in the view text itself rather than in a separate base-object register. The view is a simple SELECT projection with no joins, filters, or aggregation expressed in the documented definition, meaning row cardinality and grain are inherited directly from FII_AP_INV_B.

Consequently, any change to the columns or availability of FII_AP_INV_B propagates to this view. Because the definition is a straight projection, the view benefits from the indexing and partitioning of the base object, and it introduces negligible additional execution cost.

Key Columns

• ACCOUNT_DATE — The accounting date associated with the invoice distribution or transaction, used for period-based reporting and aging.
• PRIM_AMOUNT_G — The primary monetary amount, typically carried in the functional or global currency for consolidated reporting. Note that this column is the source of the ACTUAL_G attribute referenced in the view's column listing.
• COST_CENTER_ORG_ID — The organization identifier tied to the cost center, enabling segmentation by operating unit or legal entity context.
• INVOICE_ID — The unique identifier of the AP invoice, forming the primary join key to invoice headers.
• SUPPLIER_ID — The identifier of the supplier or vendor associated with the invoice.
• CHART_OF_ACCOUNTS_ID — Identifies the chart of accounts context for the accounting flexfield.
• FIN_CATEGORY_ID — The financial category classification used to group transactions for reporting.
• POSTED_FLAG — Indicates whether the invoice or distribution has been posted to the general ledger.
• COMPANY_ID — The company segment identifier from the accounting flexfield.
• COST_CENTER_ID — The cost center segment identifier from the accounting flexfield.

Common Use Cases and Queries

Typical use cases include cost center level spend analysis, posted versus unposted invoice reconciliation, and supplier expenditure aggregation by financial category. A common query filters on the cost center organization to isolate activity for a specific operating entity:

SELECT invoice_id, supplier_id, cost_center_id, account_date, prim_amount_g
FROM apps.fii_ap_inv_b_v1
WHERE cost_center_org_id = :p_org_id
AND posted_flag = 'Y'
AND account_date BETWEEN :p_start AND :p_end;

Additional scenarios aggregate amounts by company and cost center, or join on INVOICE_ID to AP invoice header tables to enrich the view with descriptive supplier and invoice details. Because the view is a direct projection, these queries perform well and remain stable across 12.1.1 and 12.2.2.