Search Results cost_center_vs




Overview
Explore in AI Chat

Overview

FII_LOB_ASSIGNMENTS_V is a database view documented within the FII (Financial Intelligence) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The ETRM metadata classifies FII as obsolete and describes this object only as an "internal view," indicating it was created for use by Financial Intelligence internal processing logic rather than as a supported public interface. The view presents the association between a Line of Business (LOB) and a company cost center organization, resolving the numeric organization identifier into its descriptive company and cost center segments. This joining of the assignment table to the company cost center definition allows consumers of the view to avoid a second lookup when they need both the LOB identifier and the human-readable company/cost center attributes.

The object is relevant to the search term "company_cost_center_org_id" because that column is the central integration key in the view. It is the foreign key that links an LOB assignment to the HR_COMPANY_COST_CENTERS definition, and it is the column most likely to be referenced in custom queries that filter or group financial intelligence data by organization. Because FII is obsolete, the view should be regarded as a legacy reference rather than a target for new development, and any dependency on it should be reviewed for upgrade impact, particularly when moving between 12.1.1 and 12.2.2.

Underlying Base Objects

The view text reveals that FII_LOB_ASSIGNMENTS_V is defined over exactly two base objects joined on a single equality predicate. The driving table, FII_LOB_ASSIGNMENTS (aliased LOB), stores the line-of-business assignments and their audit columns. The reference table, HR_COMPANY_COST_CENTERS (aliased HRCC), supplies the descriptive company and cost center attributes. The join condition is LOB.COMPANY_COST_CENTER_ORG_ID = HRCC.ORGANIZATION_ID, an inner join that returns only those assignments whose organization identifier exists in HR_COMPANY_COST_CENTERS. The ETRM metadata records no referenced base objects, but the embedded view text is authoritative on this point. The ROW_ID column is populated from LOB.ROWID, confirming the driving table and giving each returned row a stable row locator for that assignment record.

Key Columns

  • ROW_ID — the ROWID of the FII_LOB_ASSIGNMENTS row, useful as a unique handle for the assignment.
  • LINE_OF_BUSINESS — the line-of-business identifier associated with the assignment.
  • COMPANY_COST_CENTER_ORG_ID — the organization identifier linking the assignment to HR_COMPANY_COST_CENTERS.ORGANIZATION_ID; the primary key for joining and for filtering by organization.
  • COMPANY_CC_ORG_NAME — the descriptive name of the company cost center organization, sourced from HRCC.NAME.
  • COMPANY_CODE and COMPANY_VS — the company code and its value set designation from the cost center definition.
  • COST_CENTER_CODE and COST_CENTER_VS — the cost center code and its value set designation.
  • DESCRIPTION — the concatenated company and cost center segments (HRCC.CONC_COMPANY_CC_SEGMENTS), providing a single readable label.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns carried from FII_LOB_ASSIGNMENTS.

Common Use Cases and Queries

The principal use case is reporting an LOB assignment alongside the company and cost center it belongs to, particularly when filtering by organization. A typical query selects the LOB and descriptive attributes for a specific organization:

SELECT line_of_business, company_cost_center_org_id, company_cc_org_name, company_code, cost_center_code, description FROM fii_lob_assignments_v WHERE company_cost_center_org_id = :p_org_id;

Because the view already joins HR_COMPANY_COST_CENTERS, it is convenient for listing all LOB assignments grouped by company or cost center, or for validating that every assignment resolves to a defined organization. When auditing legacy FII data before an upgrade from 12.1.1 to 12.2.2, the view can be queried to inventory assignments and their organizational context. Since FII is obsolete and the view is internal, new code should not depend on it; where equivalent current functionality exists, the underlying FII_LOB_ASSIGNMENTS and HR_COMPANY_COST_CENTERS tables should be joined directly to avoid reliance on an undocumented, unsupported interface.