Search Results admin_timeout

Overview

HXC_APPROVAL_STYLES_V is an APPS-owned database view within the HXC — Time and Labor Engine product of Oracle E-Business Suite. It exposes the configuration of approval styles, which govern how timecards, time entry submissions, and related transactions are routed through approval workflows. An approval style defines the approval hierarchy behavior, notification recipients, timeout handling, and the administrative roles responsible for resolving exceptions during the approval process.

The view presents the same logical data as its underlying base table HXC_APPROVAL_STYLES, but enriches it with computed attributes derived from the HXC_NOTIFICATION_HELPER package. Rather than duplicating notification and timeout configuration across columns in the base table, the view resolves these values on the fly through PL/SQL helper functions. This design allows Oracle Applications to centralize notification logic while still surfacing the resolved settings in a queryable form for reports, concurrent programs, and integration points. The view is marked VALID and is documented in the ETRM 12.2.2 repository against base objects HXC_APPROVAL_STYLES (a synonym) and the HXC_NOTIFICATION_HELPER package.

Underlying Base Objects

The view is defined over two documented references:

• HXC_APPROVAL_STYLES — the base table (referenced through its synonym) holding the persistent approval-style definitions, including business group, legislation, name, description, and administrative role assignments.
• HXC_NOTIFICATION_HELPER — a PL/SQL package supplying the timeout, retry, and notification flag functions invoked directly in the view's SELECT list.

All table columns are sourced from HXC_APPROVAL_STYLES aliased as APS. The computed columns (TIMEOUTS_ENABLED, NUMBER_RETRIES, APPROVER_TIMEOUT, PREPARER_TIMEOUT, ADMIN_TIMEOUT, and the NOTIFY_* flags) are each produced by a corresponding function call in HXC_NOTIFICATION_HELPER, keyed on APS.APPROVAL_STYLE_ID. This means the view returns one row per approval style, joined implicitly to the helper package logic at query time.

Key Columns

• BUSINESS_GROUP_ID — the business group owning the approval style; critical for multi-organization filtering.
• APPROVAL_STYLE_ID — the primary identifier of the approval style and the key passed to all helper functions.
• LEGISLATION_CODE — the legislation under which the style operates.
• NAME / DESCRIPTION — the user-facing label and descriptive text of the approval style.
• ADMIN_ROLE — the role responsible for administering the style; this is the column most directly relevant to the user's search for "admin_role".
• ERROR_ADMIN_ROLE — the administrative role to which error conditions are routed when the standard approval path fails.
• OBJECT_VERSION_NUMBER — used for optimistic locking during concurrent updates.
• TIMEOUTS_ENABLED, NUMBER_RETRIES, APPROVER_TIMEOUT, PREPARER_TIMEOUT, ADMIN_TIMEOUT — resolved timeout and retry configuration.
• NOTIFY_SUPERVISOR, NOTIFY_WORKER_ON_SUBMIT, NOTIFY_WORKER_ON_AA, NOTIFY_PREPARER_APPROVED, NOTIFY_PREPARER_REJECTED, NOTIFY_PREPARER_TRANSFER — notification behavior flags.
• Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

Typical uses include auditing which administrative roles are configured, troubleshooting approval routing, and reporting on timeout and notification settings. Because the view resolves values through package functions, queries execute the helper logic per row.

To locate styles by administrative role, the query typically filters on ADMIN_ROLE or ERROR_ADMIN_ROLE:

• SELECT approval_style_id, name, admin_role, error_admin_role FROM apps.hxc_approval_styles_v WHERE admin_role = :role;
• SELECT name, timeouts_enabled, number_retries, approver_timeout, preparer_timeout, admin_timeout FROM apps.hxc_approval_styles_v WHERE business_group_id = :bg_id;
• SELECT name, notify_supervisor, notify_worker_on_submit, notify_preparer_approved FROM apps.hxc_approval_styles_v ORDER BY name;
• SELECT approval_style_id, name, admin_role FROM apps.hxc_approval_styles_v WHERE legislation_code = :leg_code AND error_admin_role IS NOT NULL;

Because helper functions are invoked in the SELECT list, performance-sensitive reports should restrict result sets with WHERE predicates on indexed base columns such as BUSINESS_GROUP_ID or APPROVAL_STYLE_ID to avoid evaluating the package functions across the full table.