Search Results online_flag

Overview

OTA_CATEGORY_USAGES is a Learning Management (OTA) table in the Oracle E-Business Suite 12.1.1 / 12.2.2 schema. It defines the category usages that indicate the role in which an activity category is used. In practice, the table acts as a reference or lookup mechanism that determines how a given activity category participates in the OTA training model, such as distinguishing categories used for classes, offerings, or other learning constructs. Each row captures a distinct category-usage definition scoped to a business group.

From a data modeling perspective, the heuristic Data Vault classification mined from the foreign-key structure is standalone. This suggests the table can be modeled as an independent hub-like reference entity, since it holds a stable business definition of category usage rather than acting as a transactional link or a dependency satellite. Its 39 documented columns include the standard EBS audit, multi-org, and descriptive-flexfield (DDF) attribute set.

Key Information Stored

The most significant columns documented for OTA_CATEGORY_USAGES are:

CATEGORY_USAGE_ID — the surrogate primary key, defined by the OTA_CATEGORY_USAGES_PK unique index and single-column primary key constraint.
CATEGORY — the activity category to which the usage applies; together with TYPE and BUSINESS_GROUP_ID it forms the OTA_CATEGORY_USAGES_UK2 business-key candidate.
TYPE — the usage type, distinguishing the nature of the role the category plays; a component of the UK2 business key.
BUSINESS_GROUP_ID — the operating unit / business group that scopes the row within the OTA multi-org model; also part of UK2.
PARENT_CAT_USAGE_ID — self-referencing parent pointer supporting hierarchical category-usage relationships.
SYNCHRONOUS_FLAG and ONLINE_FLAG — behavior flags controlling whether the usage is synchronous and available online.
START_DATE_ACTIVE and END_DATE_ACTIVE — effective-dating columns controlling the active window of the usage.
USER_GROUP_ID — the user group associated with the usage.
DATA_SOURCE and COMMENTS — provenance and free-text annotation.
OBJECT_VERSION_NUMBER — optimistic locking version.
LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard EBS audit columns.
ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — the descriptive flexfield (DDF) context and segment columns.

Common Use Cases and Queries

The table is queried whenever OTA activity definitions, event associations, or activity-category inclusions must resolve the role of a category. Typical reporting includes listing active category usages by business group, validating configuration before publishing learning activities, and driving the LOV values available in OTA setup forms.

A representative query retrieving active usages for a business group:

SELECT category_usage_id, category, type, start_date_active, end_date_active FROM ota_category_usages WHERE business_group_id = :bg AND TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, TRUNC(SYSDATE));

Joining to dependent activities to report configuration coverage:

SELECT cu.category_usage_id, cu.category, cu.type, ad.activity_definition_id FROM ota_category_usages cu, ota_activity_definitions ad WHERE ad.category_usage_id = cu.category_usage_id;

Related Objects

The following depend on OTA_CATEGORY_USAGES via documented foreign keys, joining on CATEGORY_USAGE_ID:

OTA_ACTIVITY_DEFINITIONS — OTA_ACTIVITY_DEFINITIONS.CATEGORY_USAGE_ID → OTA_CATEGORY_USAGES.
OTA_ACT_CAT_INCLUSIONS — OTA_ACT_CAT_INCLUSIONS.CATEGORY_USAGE_ID → OTA_CATEGORY_USAGES.
OTA_EVENT_ASSOCIATIONS — OTA_EVENT_ASSOCIATIONS.CATEGORY_USAGE_ID → OTA_CATEGORY_USAGES.

These relationships confirm that category usage definitions are referenced as a validation value set across activity, event association, and category inclusion entities in the OTA Learning Management module.

Table: OTA_CATEGORY_USAGES 12.1.1
owner:OTA, object_type:TABLE, fnd_design_data:OTA.OTA_CATEGORY_USAGES, object_name:OTA_CATEGORY_USAGES, status:VALID, product: OTA - Learning Management , description: Category usages indicate the role in which an activity category is used. , implementation_dba_data: OTA.OTA_CATEGORY_USAGES ,
Table: OTA_CATEGORY_USAGES 12.2.2
owner:OTA, object_type:TABLE, fnd_design_data:OTA.OTA_CATEGORY_USAGES, object_name:OTA_CATEGORY_USAGES, status:VALID, product: OTA - Learning Management , description: Category usages indicate the role in which an activity category is used. , implementation_dba_data: OTA.OTA_CATEGORY_USAGES ,
View: OTA_CATEGORY_USAGES_V1 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:OTA.OTA_CATEGORY_USAGES_V1, object_name:OTA_CATEGORY_USAGES_V1, status:VALID, product: OTA - Learning Management , description: List all the uses of a Category , implementation_dba_data: APPS.OTA_CATEGORY_USAGES_V1 ,
View: OTA_CATEGORY_USAGES_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:OTA.OTA_CATEGORY_USAGES_VL, object_name:OTA_CATEGORY_USAGES_VL, status:VALID, product: OTA - Learning Management , implementation_dba_data: APPS.OTA_CATEGORY_USAGES_VL ,
View: OTA_CATEGORY_USAGES_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OTA.OTA_CATEGORY_USAGES_VL, object_name:OTA_CATEGORY_USAGES_VL, status:VALID, product: OTA - Learning Management , implementation_dba_data: APPS.OTA_CATEGORY_USAGES_VL ,
View: OTA_CATEGORY_USAGES_V1 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OTA.OTA_CATEGORY_USAGES_V1, object_name:OTA_CATEGORY_USAGES_V1, status:VALID, product: OTA - Learning Management , description: List all the uses of a Category , implementation_dba_data: APPS.OTA_CATEGORY_USAGES_V1 ,