Search Results ego_action_groups_s

Overview

EGO_EXT_FWK_PUB is the public PL/SQL package body that implements the Extensibility Framework for Oracle E-Business Suite. This framework underpins the Oracle Product Information Management (PIM) and Product Data Hub (PDH) module, providing the runtime engine by which customers define, store, and manage user-defined attributes (descriptive flexfields and extension attributes) attached to standard EBS entities such as items, and by which they organize those attributes into logical attribute groups. In Oracle EBS 12.1.1 and 12.2.2 the package is owned by the APPS schema and is classified as a public API (PUB), meaning it is intended to be called by both Oracle's own application code and by customer extensions. The package serves as the primary interface for creating and maintaining attribute groups, resolving metadata about columns and tables in which extensible data is persisted, and determining the database-level characteristics of attributes such as whether a backing column is indexed.

Key Procedures and Functions

The ETRM metadata documents 118 procedures and functions in this package. Representative members include:

• CREATE_ATTRIBUTE_GROUP and COPY_ATTRIBUTE_GROUP — create a new attribute group definition and clone an existing one, respectively, driving inserts against the EGO attribute group and action group entities.
• GET_ATTR_GROUP_ID_FROM_PKS, GET_OBJECT_ID_FROM_NAME, GET_OBJECT_ID_FOR_AG_TYPE — resolve internal identifiers from business keys and object names.
• GET_TABLE_NAME, GET_TL_TABLE_NAME, GET_ATTR_CHANGES_TABLE, GET_ATTR_CHANGES_B_TABLE, GET_ATTR_CHANGES_TL_TABLE — return the physical table names used to persist attribute definitions and translations.
• IS_COLUMN_INDEXED, GET_PK_COLUMNS, GET_AVAILABLE_ATTRDBCOL, GET_AVAILABLE_ATTRDBCOLS — introspect database columns to determine eligibility and indexing status for attribute storage.
• GET_PRIVILEGE_FOR_ATTR_GROUP, CHECK_SUPPORTED_ATTR_USAGES, GET_CLASS_MEANING — enforce authorization and validate that requested attribute usages are supported.
• DOES_ATTR_HAVE_DATA — check whether an attribute currently holds data, a prerequisite for safe deletion or restructuring.
• GET_APPLICATION_OWNER, GET_ORACLE_USERNAME — utility accessors returning application and schema context.

Tables Accessed

The package operates across the EGO extensibility entity model. It reads and writes EGO_ACTION_GROUPS_B, EGO_ACTION_GROUPS_S, and EGO_ACTION_GROUPS_TL — the base, sequence, and translation tables for action groups, the entity most closely associated with the search term "ego_action_groups_s". It similarly manipulates EGO_ACTIONS_B, EGO_ACTIONS_S, EGO_ACTIONS_TL, EGO_ACTIONS_DL, and EGO_ACTION_DISPLAYS_B to define the actions presented within groups.

Attribute and object metadata are managed through EGO_ATTRS_S, EGO_ATTR_GROUPS_S, EGO_ATTR_GROUP_DL, EGO_ASSOCS_S, EGO_ACTN_GRP_ENTRIES_B, EGO_OBJ_AG_ASSOCS_B, and EGO_OBJECT_EXT_TABLES_B. Flexfield and value-set context is supplied by the FND family of tables, including FND_FLEX_VALUE_SETS, FND_FLEX_VALUES, FND_DESCRIPTIVE_FLEXS, FND_DESCR_FLEX_COLUMN_USAGES, FND_DESCR_FLEX_CONTEXTS, and FND_COLUMNS. EGO_VS_VALUES_DISP_ORDER supports value-set display ordering.

Usage Notes

EGO_EXT_FWK_PUB is invoked primarily by the Extensibility Framework's own UI — the attribute group and action group setup pages in PIM/PDH — and by concurrent programs that build and refresh the extensibility metadata cache. Because it is a public API, customers may call it from custom PL/SQL to programmatically create attribute groups, resolve object IDs, or inspect column metadata during integrations. The metadata indicates the package is referenced by 26 other packages, confirming its role as a foundational dependency rather than a leaf utility. Callers should invoke it within a properly initialized FND_GLOBAL session context so that GET_APPLICATION_OWNER and GET_ORACLE_USERNAME return accurate values, and should observe standard EBS API error-handling conventions via FND_API and ERROR_HANDLER.