Search Results ota_trb_bus




Overview
Explore in AI Chat

Overview

The APPS.OTA_TRB_SHD package is a shadow (audit-trail) package within the Oracle E-Business Suite OTA (Oracle Training Administration / Learning Management) module. In Oracle EBS, "_SHD" packages are auto-generated, shadow copies that record the pre- and post-image of DML operations performed against the corresponding transactional table. OTA_TRB_SHD shadows operations against the OTA_TRB_BUS business logic layer, which manages Training Resource Bookings data.

Its principal role is to capture audit information whenever the booking table is inserted, updated, or deleted through the associated OTA_TRB_INS, OTA_TRB_UPD, and OTA_TRB_DEL packages. This supports the Oracle EBS AuditTrail: Enabled feature, providing a tamper-resistant history of changes for compliance and troubleshooting. The package is documented with an API classification of OTHER and is marked VALID in the ETRM 12.2.2 metadata. Within Oracle EBS 12.1.1 and 12.2.2, it resides in the APPS schema and functions as a system-generated dependency rather than a user-callable API.

Key Procedures and Functions

The ETRM documentation records five procedures/functions for this package. While full signatures are not exposed in the metadata, their documented names indicate the following purposes:

  • RETURN_API_DML_STATUS — Returns the DML status flag reflecting the outcome of the most recent shadow API operation, allowing callers to interrogate whether a change was successfully recorded.
  • CONSTRAINT_ERROR — Handles or signals constraint violations encountered while writing shadow audit rows, typically mapping Oracle errors to application-level exceptions.
  • API_UPDATING — Indicates whether the shadow package is currently in an update state, used to guard against recursive or redundant audit writes.
  • LCK — Acquires the required row-level or package-level lock to serialize concurrent shadow updates and preserve audit integrity.
  • CONVERT_ARGS — Converts passed arguments into the internal format required for insertion into the shadow table, normalizing datatypes between the caller and the audit table.

These routines are internal to the shadow framework and are not intended to be called directly by application developers.

Tables Accessed

The documented tables referenced (via APPS synonyms) are:

  • ALL_CONSTRAINTS — Read to inspect constraint definitions, enabling the shadow package to validate and preserve referential integrity information during audit capture.
  • OTA_RESOURCE_BOOKINGS — The primary transactional table for resource bookings; the shadow package records insert, update, and delete images of rows here.

Access to OTA_RESOURCE_BOOKINGS forms the core of the audit function, while ALL_CONSTRAINTS supports metadata validation. The metadata notes no direct write to business tables by this package; it operates on shadow tables derived from these sources.

Usage Notes

OTA_TRB_SHD is referenced by four other packages — OTA_TRB_BUS, OTA_TRB_DEL, OTA_TRB_INS, and OTA_TRB_UPD — and is not typically invoked directly by forms or concurrent programs. Instead, it is triggered implicitly whenever those API packages perform DML. This indirect invocation is consistent with EBS shadow-package architecture, where the shadow layer is coupled to the business API rather than exposed to end users.

Customizations should never modify or call shadow packages directly, as they are regenerated by Oracle and their signatures may change across releases. When troubleshooting audit discrepancies or DML errors in the Training Resource Booking area, DBAs and developers may query the shadow tables to reconstruct change history. Activation of auditing requires the AuditTrail: Enabled profile option to be set appropriately; otherwise the shadow package may remain dormant. Because dependencies include the SYS-owned STANDARD package and ALL_CONSTRAINTS, recompilation of this package requires valid APPS and SYS grants.