Results for “release_version”

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

Overview

ASG_ITEM_INDEX is a table in the ASG schema belonging to the CRM Gateway for Mobile Devices product within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores index definitions associated with a publication item, describing the indexing structure that the mobile gateway applies when publishing CRM data to handheld and mobile devices. Each row ties an index definition to a specific item registered in the ASG publication framework through the ITEM_ID foreign key. The table is a satellite-type object in Data Vault modeling terms: it is dependent on a parent entity, contributes descriptive and structural attributes, and carries its own surrogate and business keys rather than acting as an independent hub or an associative link.

Key Information Stored

The table contains eleven documented columns, of which the most significant are described below.

• ITEM_ID — Foreign key to ASG_PUBLICATION_ITEMS, identifying the publication item to which the index definition belongs. It is part of the composite primary key ASG_ITEM_INDEX_PK.
• INDEX_ID — The index identifier. It is the second component of the composite primary key ASG_ITEM_INDEX_PK and simultaneously the sole column of the unique key ASG_ITEM_INDEX_UK1, making it the primary business-key candidate and a natural surrogate identifier for downstream references.
• INDEX_NAME — The user-facing name of the index as exposed through the mobile publication configuration.
• PMODE — The processing mode associated with the index, governing how the index is applied or refreshed during publication.
• COLUMNS — The column specification for the index, defining which fields of the publication item are indexed and in what order.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-org and data-security partitioning consistent with standard EBS row-level security.
• RELEASE_VERSION — The release version marker used to track the schema or content generation of the record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard EBS audit columns recording who created and last modified the row and when.

Note that INDEX_ID is a pure surrogate identifier while the combination of ITEM_ID and INDEX_ID forms the true primary key; the unique constraint on INDEX_ID alone confirms that each index definition is globally unique across items.

Common Use Cases and Queries

Typical uses center on auditing and troubleshooting mobile publication indexing. A common pattern joins the index definitions back to their parent items:

• Listing all indexes for a given publication item: SELECT index_id, index_name, pmode, columns FROM asg.asg_item_index WHERE item_id = :item_id;
• Retrieving a single index definition by its unique identifier: SELECT * FROM asg.asg_item_index WHERE index_id = :index_id;
• Security-scoped reporting that respects data partitioning: SELECT i.index_name FROM asg.asg_item_index i, fnd_security_groups s WHERE i.security_group_id = s.security_group_id;
• Change auditing based on the standard audit columns, filtering by last_update_date to identify recently redefined indexes.

Reporting scenarios include verifying that every active publication item has the expected index coverage before a synchronization cycle, and generating configuration extracts for mobile device provisioning.

Related Objects

• ASG_PUBLICATION_ITEMS — Parent table; joined on ASG_ITEM_INDEX.ITEM_ID = ASG_PUBLICATION_ITEMS.ITEM_ID.
• FND_SECURITY_GROUPS — Referenced by ASG_ITEM_INDEX.SECURITY_GROUP_ID for row-level security.
• ASG_ITEM_INDEX_PK and ASG_ITEM_INDEX_UK1 — The primary and unique constraints that enforce key integrity on (ITEM_ID, INDEX_ID) and INDEX_ID respectively.
• Other ASG publication configuration tables that share the ITEM_ID foreign key will typically be joined alongside this table when producing complete publication definitions.
• Standard EBS audit and security views over FND_SECURITY_GROUPS are commonly used in conjunction with this object for reporting.