Results for “hxc_approval_styles”

50+ results




Overview
Explore in AI Chat

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

Overview

HXC_APPROVAL_STYLES is a configuration table in the HXC schema (Time and Labor Engine) that defines approval styles used to control how timecards, time building blocks, and related time and labor records are routed through the approval process in Oracle E-Business Suite. Each row represents a named approval style, which determines the composition of the approval chain, the roles involved, and how exceptions or errors are handled during the approval cycle. Approval styles are attached to time building blocks and to data approval rule usages, and are consumed by the approval component mechanism defined in HXC_APPROVAL_COMPS, making this table a central reference point for Time and Labor approval configuration.

From a Data Vault modeling perspective, the foreign-key structure mined from the ETRM metadata suggests a hub-leaning classification. The table holds a surrogate primary key (APPROVAL_STYLE_ID) that is referenced by multiple downstream tables, which is characteristic of a hub entity that anchors business keys and is linked to dependent satellite or link structures. This classification is heuristic and intended as a modeling suggestion rather than a documented Oracle designation.

Key Information Stored

The table is documented with 15 columns, of which the following are the most significant. The surrogate primary key, APPROVAL_STYLE_ID, uniquely identifies each approval style and is enforced by HXC_APPROVAL_STYLES_PK. A second unique index, HXC_APPROVAL_STYLES_UK1, spans NAME, BUSINESS_GROUP_ID, and ZD_EDITION_NAME, indicating that the business-key candidate is the style name scoped to a business group and edition.

  • APPROVAL_STYLE_ID — surrogate primary key; the technical identifier propagated to child tables.
  • NAME and DESCRIPTION — the user-facing style name and descriptive text; NAME participates in the unique business key.
  • BUSINESS_GROUP_ID — scopes the style to a specific business group, enabling multi-organization separation.
  • LEGISLATION_CODE — ties the style to a legislative context, relevant for statutory approval rules.
  • RUN_RECIPIENT_EXTENSIONS — controls whether recipient extension logic executes during the approval run.
  • ADMIN_ROLE and ERROR_ADMIN_ROLE — designate the administrative roles responsible for normal approval administration and for error handling.
  • ZD_EDITION_NAME — editioning attribute supporting online patching in EBS 12.2.x.
  • OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit and optimistic-locking columns.

Common Use Cases and Queries

Typical reporting scenarios include listing all approval styles available in a business group, identifying the administrative roles assigned to each style, and tracing which time building blocks or approval components depend on a given style.

  • Enumerating styles by business group: SELECT approval_style_id, name, description, admin_role FROM hxc.hxc_approval_styles WHERE business_group_id = :bg_id;
  • Looking up a style by its business key: filter on NAME, BUSINESS_GROUP_ID, and ZD_EDITION_NAME to honor the unique index.
  • Auditing configuration changes: order by LAST_UPDATE_DATE to identify recently modified approval styles.
  • Impact analysis: join to HXC_APPROVAL_COMPS and HXC_TIME_BUILDING_BLOCKS on APPROVAL_STYLE_ID to see which components and building blocks reference each style.

Related Objects

  • HXC_APPROVAL_COMPS — references HXC_APPROVAL_STYLES via APPROVAL_STYLE_ID; defines the approval chain components.
  • HXC_DATA_APP_RULE_USAGES — references HXC_APPROVAL_STYLES via APPROVAL_STYLE_ID; associates styles with data approval rules.
  • HXC_TIME_BUILDING_BLOCKS — references HXC_APPROVAL_STYLES via APPROVAL_STYLE_ID; ties building blocks to an approval style.
  • HXC_TIME_BUILDING_BLOCKS_AR — archive counterpart referencing APPROVAL_STYLE_ID.
  • HXC_AR_TC_IDS_TEMP — temporary structure referencing APPROVAL_STYLE_ID.

These relationships confirm that HXC_APPROVAL_STYLES functions as an anchor table whose key is widely consumed across the Time and Labor approval architecture.