Search Results all_constraints




Overview
Explore in AI Chat

Overview

APPS.OTA_UGT_SHD is a PL/SQL package in the Oracle E-Business Suite, owned by the APPS schema and validated in both 12.1.1 and 12.2.2. The suffix _SHD identifies it as a shadow (or stub-replacement) package used by the Oracle Applications Technology layer during patching and language-installation operations. The package supports the OTA (Oracle Training Administration) user-group schema objects, principally OTA_USER_GROUPS_B and OTA_USER_GROUPS_TL, the base and translation tables that define training user groups. Its purpose is to allow the Applications DBA and the AD (Applications DBA) utilities to create, validate, and convert user-group data without invoking the full transactional API package during restricted or non-interactive operations.

In its documented classification the package is listed as OTHER, meaning it is not an exposed business API but an internal helper. It is referenced by no other package and references only one package of its own kind, so its dependency chain is deliberately shallow to keep it safe to run during patching.

Key Procedures and Functions

The ETRM metadata documents five procedures:

  • CONSTRAINT_ERROR — Raises or handles the error condition associated with constraint violations detected while validating user-group rows against constraints in the data dictionary.
  • API_UPDATING — Flags or records that an API-driven update is in progress, allowing downstream logic to distinguish direct table maintenance from API-mediated changes.
  • LCK — Acquires the locking mechanism used to serialize concurrent access to the user-group records, preventing conflicting updates during conversion routines.
  • ADD_LANGUAGE — Inserts the translated rows required when a new language is installed or activated for the OTA user-group data, working against the _TL translation table.
  • CONVERT_ARGS — Normalizes and converts the arguments passed into the package, typically to reconcile date, language, or identifier formats between the calling environment and the stored data.

No parameter lists are documented; the procedures should be treated as internal and invoked only by Oracle-supplied routines.

Tables Accessed

Because the user searched on "all_constraints," the most significant dictionary reference is ALL_CONSTRAINTS, which the package queries to discover and validate the constraints defined on the OTA user-group tables before performing conversion or language-addition work. The remaining documented dependencies are:

  • FND_LANGUAGES — the Applications language registry, consulted to determine installed and enabled languages during ADD_LANGUAGE processing.
  • OTA_USER_GROUPS_B — the base table holding user-group definitions; the package inserts, updates, or validates rows here.
  • OTA_USER_GROUPS_TL — the translation table holding language-specific user-group names and descriptions.

Access to these tables is via APPS synonyms. The ALL_CONSTRAINTS lookup means the package performs metadata-driven validation rather than hard-coding rule logic, which allows it to remain valid across customization of the underlying constraints.

Usage Notes

OTA_UGT_SHD is not intended for direct invocation from forms, concurrent programs, or custom code. It is exercised by the AD patching and language-installation machinery, and by Oracle's upgrade scripts, when OTA user-group data must be seeded or translated in a controlled manner. Because it carries the _SHD designation, Oracle may replace its body during patching, so any customer extension referencing it would be unsupported and subject to breakage. Developers needing to maintain training user groups should use the supported OTA user-group API rather than this shadow package.