Search Results ieu_work_source_pvt




Overview
Explore in AI Chat

Overview

IEU_WORK_SOURCE_PVT is a private PL/SQL package in the APPS schema that supports Oracle E-Business Suite's Interaction Center / Universal Work Queue infrastructure, part of the iSupport and TeleService (IEU) product family. Its internal classification as a "PVT" (private) package indicates it is not intended as a public, callable API; rather it functions as a supporting module invoked by the owning work source framework to load and validate work source definitions and their associated properties.

In Oracle EBS 12.1.1 and 12.2.2, the Universal Work Queue (UWQ) aggregates assignable work items—service requests, tasks, and other CRM activities—into a single agent-facing queue. Work sources describe the origin and attributes of those items. IEU_WORK_SOURCE_PVT encapsulates the internal logic for populating work source metadata records and confirming that a referenced object is valid before the record is used by the queue engine. The package carries a VALID status in the data dictionary and depends only on the SYS.STANDARD package, confirming it is a self-contained unit with no external application-package dependencies.

Key Procedures and Functions

The ETRM metadata documents two callable units within this package:

  • LOADWORKSOURCE — Loads work source definition data into the underlying UWQ work source tables. This routine is the primary write path used when a work source is registered or refreshed, seeding the base and translation records that describe the source to the queue engine.
  • VALIDATEOBJ — Validates a referenced object associated with a work source. This routine performs the integrity checks that confirm a work source maps to a legitimate, usable object before it is activated for agent consumption, preventing invalid or orphaned work source entries from entering the queue.

No parameter signatures are published in the available metadata, and the package is not exposed for direct external invocation; consumers should treat these routines as internal contracts subject to change between patch levels.

Tables Accessed

The package reads and writes the following tables by way of APPS synonyms:

  • IEU_UWQM_WORK_SOURCES_B_S1 — the base (non-translated) definition table for UWQ work sources; the primary target of LOADWORKSOURCE.
  • IEU_UWQM_WORK_SOURCES_TL — the translation table holding language-specific work source text; populated alongside the base row during a load.
  • IEU_UWQM_WS_ASSCT_PROPS_S1 — the work source associated properties table, which stores the property mappings that govern how a work source behaves in the queue.
  • DUAL — used for single-row evaluations, typically within validation or default-value logic.

Usage Notes

Because IEU_WORK_SOURCE_PVT is a private package, it is normally invoked indirectly by the UWQ configuration and setup flows rather than called from custom code. Administrators trigger its logic through the standard interaction-center setup forms and the work source administration screens in the TeleService/iSupport responsibility; the form layer calls the private routines to load and validate records as the setup is saved.

The ETRM metadata records zero packages referencing IEU_WORK_SOURCE_PVT, indicating it sits at the base of the dependency tree and is entered through UI or concurrent setup paths. Customizations that create work sources directly should insert through the supported public UWQ APIs rather than calling LOADWORKSOURCE or VALIDATEOBJ, since these private signatures are undocumented and may change during 12.1.1 to 12.2.2 upgrades or patching.