Search Results ahl_user_statuses_b_u1

Overview

AHL.AHL_USER_STATUSES_B is a seed data table within the Oracle E-Business Suite AHL (Complex Maintenance, Repair and Overhaul, formerly Enterprise Asset Management for aerospace and defense) schema. It stores user-defined status definitions that may be applied to any ASO (Asset Servicing and Operations) object, providing the master list from which status codes are assigned to maintenance work orders, tasks, visit types, and related entities. Because the table resides in the APPS_TS_SEED tablespace, it is intended to hold relatively static configuration data that is shipped or seeded with the application, and it is the base (non-translated) table of a two-table translation pair.

In Data Vault modeling terms, the heuristic classification for this table is hub-leaning. AHL_USER_STATUSES_B functions as a business hub: its surrogate key USER_STATUS_ID uniquely identifies each status entity, while descriptive attributes such as ACTIVE_FLAG, DEFAULT_FLAG, and the active-date range behave as satellite or reference attributes. Translating the user status to a language-specific display name would typically be handled by a dependent satellite (AHL_USER_STATUSES_TL).

Key Information Stored

The following columns represent the most functionally significant data held in this table:

• USER_STATUS_ID — The surrogate primary key (AHL_USER_STATUSES_B_PK) and the unique business-key candidate exposed through index AHL_USER_STATUSES_B_U1. It is the value referenced by all downstream entities.
• SYSTEM_STATUS_TYPE and SYSTEM_STATUS_CODE — System-generated status type and code that anchor user-defined statuses to the underlying system status framework.
• ACTIVE_FLAG — Indicates whether the user status is currently enabled for use.
• DEFAULT_FLAG — Identifies the status that is applied by default when a new ASO object is created.
• START_DATE_ACTIVE and END_DATE_ACTIVE — Effective-dating controls bounding the period in which the status is valid.
• SEEDED_FLAG — Distinguishes Oracle-seeded records from customer-defined records.
• OBJECT_VERSION_NUMBER — Locking sequence number used for optimistic concurrency control during updates.
• SECURITY_GROUP_ID — Used in application hosting environments and mapped to FND_SECURITY_GROUPS.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield segments allowing customer-specific extension without schema change.

Common Use Cases and Queries

Typical usage centers on validating and resolving status codes prior to assignment on ASO objects, and on reporting status configuration across environments. A common query retrieves the currently active, non-seeded status definitions:

• Listing active statuses by system status type:

  SELECT USER_STATUS_ID, SYSTEM_STATUS_CODE, ACTIVE_FLAG, DEFAULT_FLAG FROM AHL.AHL_USER_STATUSES_B WHERE ACTIVE_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND END_DATE_ACTIVE ORDER BY SYSTEM_STATUS_TYPE;

• Identifying customer-defined versus seeded statuses using SEEDED_FLAG = 'N'.
• Joining to the translation table to obtain the display name in the session language: SELECT B.USER_STATUS_ID, T.DESCRIPTION FROM AHL.AHL_USER_STATUSES_B B, AHL.AHL_USER_STATUSES_TL T WHERE B.USER_STATUS_ID = T.USER_STATUS_ID AND T.LANGUAGE = USERENV('LANG');

Related Objects

The table participates in a limited but well-defined dependency network:

• AHL.AHL_USER_STATUSES_TL — The translation table, joined on USER_STATUS_ID; it receives the foreign key reference from this base table and holds language-specific names and descriptions.
• FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID for hosted multi-tenant deployments.
• ASO maintenance object tables (such as work order and task entities) — These reference USER_STATUS_ID to record the currently assigned user status, forming the primary operational consumption of this seed data.
• AHL_USER_STATUSES_B_PK and AHL_USER_STATUSES_B_U1 — The primary key constraint and unique index that enforce identity on USER_STATUS_ID.