Search Results process_sync




Overview
Explore in AI Chat

Overview

XNP_WF_SYNC is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports workflow-driven synchronization for the XNP messaging and order-line infrastructure. The package coordinates the exchange and reconciliation of synchronization events between the Oracle Workflow notification framework and the XNP registration and messaging tables. Consulted through the ETRM repository for releases 12.1.1 and 12.2.2, the package is documented as VALID and is classified as an OTHER API, indicating that it is not part of a published, externally supported integration interface but instead serves as internal infrastructure consumed by other Application modules.

Its principal business purpose is to register synchronization participants, raise and process synchronization errors, manage sync timers, and notify downstream components — such as the XDP engine — when an order-line or message-related change must be propagated. In this respect XNP_WF_SYNC acts as the glue between Oracle Workflow notification attributes and the synchronization registration data used by the wider XNP messaging stack.

Key Procedures and Functions

The package exposes ten documented procedures and functions, each tied to a specific phase of synchronization control:

  • PROCESS_SYNC — Drives the primary synchronization processing logic for a given sync event.
  • SYNC_REGISTER — Registers a synchronization participant or event so that it is tracked by the sync framework.
  • RAISE_SYNC_ERROR — Raises a structured synchronization error for downstream handling or logging.
  • PROCESS_SYNC_ERR — Processes recorded synchronization errors, typically invoked by the XNP_SYNC_ERR_U notification or error handler.
  • PROCESS_SYNC_TIMER — Executes timer-based synchronization processing, invoked from the XNP_SYNC_TIMER_U path.
  • RESET_SYNC_REGISTER — Clears or resets synchronization registration state, allowing a fresh sync cycle.
  • SYNCHRONIZE — Performs the core synchronization action against the affected records.
  • IS_LAST_SYNC — Returns a boolean-style indicator of whether the current invocation represents the final synchronization in a sequence.
  • SET_RESULT_CODE — Assigns a result code to the synchronization outcome for status tracking.
  • SYNCNOTIF — Sends or constructs the synchronization notification, leveraging Workflow notification attributes.

Parameter lists are not reproduced here; callers should reference the package specification in the EBS database for exact signatures.

Tables Accessed

The package references several tables through APPS synonyms. XNP_SYNC_REGISTRATION and its sequence-driven companion XNP_SYNC_REGISTRATION_S hold the registered synchronization entities and identifiers. XDP_ORDER_LINE_ITEMS supplies order-line data subject to synchronization. WF_NOTIFICATION_ATTRIBUTES is read or written to bridge Oracle Workflow notifications with sync events, supporting SYNCNOTIF and related error notification paths. DUAL is used for trivial single-row evaluations. XNP_MESSAGE, listed among the dependencies, supports the messaging side of the synchronization exchange.

Usage Notes

XNP_WF_SYNC is not intended for direct end-user invocation. It is referenced by XDP_ENGINE and by the XNP_SYNC_ERR_U and XNP_SYNC_TIMER_U objects, which invoke PROCESS_SYNC_ERR and PROCESS_SYNC_TIMER respectively. Typical invocation occurs from Oracle Workflow notification activities (correlated to WF_NOTIFICATION_ATTRIBUTES) and from concurrent or scheduled timer programs that drive periodic synchronization. Custom code should treat the package as an internal API: callers should not assume stable signatures across patches, and any extension should be validated against Oracle Support guidance. When troubleshooting, confirm that XNP_SYNC_REGISTRATION and XDP_ORDER_LINE_ITEMS reflect the expected state and that Workflow notification attributes are populated correctly.