Search Results hz_subscription_delete

Overview

APPS.FND_OID_SUBSCRIPTIONS is an internal Oracle E-Business Suite PL/SQL package that integrates EBS with Oracle Internet Directory (OID), the LDAP-based directory service that underpins Oracle Application Server and single sign-on deployments. Its core responsibility is to keep user identity data synchronized between the EBS application schema and the OID directory. The package operates as a subscriber to Oracle Workflow business events: when a user account is created, modified, or deleted inside EBS, the subscription handlers in this package queue the corresponding change so that it can be propagated to OID. Conversely, the HZ_ prefixed handlers and the SYNCH_OID_TO_TCA procedure support inbound synchronization, moving directory-side changes back into the Trading Community Architecture (TCA) person and party model.

The package also manages the deferred execution of events. Future-dated changes detected on the source record are held and re-queued as real events at the appropriate time, ensuring that time-dependent user updates reach the directory in the correct sequence. The entity_changes reference in the source header identifies this queueing behaviour as the defining purpose of the subscription logic.

Key Procedures and Functions

• IDENTITY_ADD, IDENTITY_MODIFY, IDENTITY_DELETE — Workflow subscription functions that queue user identity additions, modifications, and deletions for transmission to OID. Each accepts a subscription GUID and a workflow event, and returns a status string.
• SUBSCRIPTION_ADD, SUBSCRIPTION_DELETE — Handle creation and removal of subscription records, maintaining the registry of directory subscriptions that the package processes.
• ON_DEMAND_USER_CREATE — Supports on-demand creation of a user, bridging a request raised in EBS to the identity creation flow in OID.
• EVENT_ERROR, EVENT_RESEND — Error-handling routines that record failed synchronization attempts and allow the originating event to be resubmitted.
• HZ_IDENTITY_ADD, HZ_IDENTITY_MODIFY, HZ_IDENTITY_DELETE — Counterpart handlers for identity changes originating on the TCA/HZ side, ensuring the party model and the directory remain consistent.
• HZ_SUBSCRIPTION_ADD, HZ_SUBSCRIPTION_DELETE — Manage subscriptions associated with HZ entities.
• SYNCH_OID_TO_TCA — Performs an inbound synchronization pass, reconciling OID directory entries with TCA records.
• ASSIGN_DEFAULT_RESP, ASSIGN_DEF_RESP, GET_RESP_APP_ID — Assign default responsibilities to newly created or synchronized users, resolving the owning application identifier for each responsibility.

Tables Accessed

• FND_USER — The EBS user repository; the source of identity records that drive outbound synchronization.
• FND_RESPONSIBILITY — Queried to determine default responsibility assignments and their owning applications.
• WF_EVENT_T — The Oracle Workflow event object passed in and out of each subscription handler.
• WF_EVENT_T and WF_ATTRIBUTE_CACHE — Support event attribute resolution and caching during subscription processing.
• WF_ENTITY_CHANGES — Records deferred or future-dated entity changes, enabling the package to queue real events when they become due.

Usage Notes

This package is invoked indirectly during normal EBS operation rather than called directly by end users. It is registered as a Workflow event subscription for the relevant user and identity business events, so the handlers fire automatically when FND_USER records change or when TCA party data is updated. The HZ_ and SYNCH_OID_TO_TCA routines are typically driven by concurrent programs or administrative synchronization runs. Customizations should avoid direct calls to these internal functions; integrators needing directory synchronization should instead raise the standard business events to which the package subscribes. The package is also referenced by one other EBS package, confirming its role as a shared integration component. Direct invocation is appropriate only for controlled resubmission of failed events through EVENT_RESEND or for scheduled reconciliation using SYNCH_OID_TO_TCA.