Results for “fa_location_id”

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

Overview

CSI_I_ASSETS is the Oracle E-Business Suite Install Base table that stores the association between an installed instance and a fixed asset. Owned by the CSI schema and valid in Oracle EBS 12.1.1 and 12.2.2, it acts as the bridge between Oracle Install Base (CSI_ITEM_INSTANCES) and Oracle Assets (FA_ADDITIONS_B and related FA tables). The table records which fixed asset, asset book, and asset location a given instance is linked to, enabling asset-to-instance tracking across the enterprise asset lifecycle.

From a dimensional modeling perspective, the mined foreign key structure suggests a satellite-leaning classification, since the table holds descriptive and association attributes tied to a parent instance rather than acting as a pure hub or link. It carries its own surrogate primary key, CSI_I_ASSETS_PK on INSTANCE_ASSET_ID, but also references multiple operational tables, giving it both link and satellite characteristics.

Key Information Stored

The documented physical schema contains 19 columns. The most significant include:

• INSTANCE_ASSET_ID — Surrogate primary key (CSI_I_ASSETS_PK) and the business-key candidate exposed by unique index CSI_I_ASSETS_U01.
• INSTANCE_ID — Foreign key to CSI_ITEM_INSTANCES, identifying the installed base instance being associated.
• FA_ASSET_ID — Foreign key to FA_ADDITIONS_B, identifying the fixed asset record in Oracle Assets.
• FA_BOOK_TYPE_CODE — Foreign key to FA_BOOK_CONTROLS, identifying the asset book context.
• FA_LOCATION_ID — Foreign key to FA_LOCATIONS, capturing the asset location.
• ASSET_QUANTITY — Quantity of the asset associated with the instance.
• ACTIVE_START_DATE / ACTIVE_END_DATE — Effective dating for the association.
• UPDATE_STATUS — Status flag used during interface or synchronization processing.
• FA_SYNC_FLAG / FA_MASS_ADDITION_ID — Controls and identifies fixed asset mass additions synchronization.
• CREATION_COMPLETE_FLAG — Indicates whether creation processing completed.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS supporting multi-org data security.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the ORM framework.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns.

Common Use Cases and Queries

Typical scenarios include reporting which fixed asset is linked to a customer's installed instance, reconciling Install Base records against Oracle Assets, and auditing mass addition synchronization.

• Instance-to-asset lookup:

  SELECT a.INSTANCE_ASSET_ID, a.INSTANCE_ID, a.FA_ASSET_ID, a.FA_BOOK_TYPE_CODE
  FROM CSI.CSI_I_ASSETS a
  WHERE a.INSTANCE_ID = :instance_id;

• Asset-to-instance reconciliation joining FA_ADDITIONS_B on FA_ASSET_ID.
• Mass addition auditing filtered on FA_MASS_ADDITION_ID and FA_SYNC_FLAG.
• Effective-dated reporting using ACTIVE_START_DATE and ACTIVE_END_DATE.

Related Objects

• CSI_ITEM_INSTANCES — joined on INSTANCE_ID; the parent installed instance.
• FA_ADDITIONS_B — joined on FA_ASSET_ID; the fixed asset definition.
• FA_BOOK_CONTROLS — joined on FA_BOOK_TYPE_CODE; the asset book.
• FA_LOCATIONS — joined on FA_LOCATION_ID; the asset location.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID; data security.
• CSI_I_ASSETS_H — history table referencing INSTANCE_ASSET_ID.
• CSI_I_ASSET_INTERFACE — interface table referencing INSTANCE_ASSET_ID for inbound processing.