Search Results check_closed_delivery_detail

Overview

OE_ERROR_WF is an Oracle Workflow integration package in the Oracle Order Management (OE) module of Oracle E-Business Suite. Its classification within ETRM is OTHER, indicating that it is an internal infrastructure package rather than a public, customer-facing API. The package supports the Order Management error-handling workflow by managing the lifecycle of workflow error items raised against sales orders, order lines, deliveries, and related entities. When Order Management processing encounters a failure — for example, during order import, order booking, or delivery processing — a workflow process can be suspended in an errored state. OE_ERROR_WF provides the programmatic hooks used to purge, initialize, reset, and inspect those error conditions, and to drive notifications and process messages associated with them.

The package is owned by the APPS schema and is valid in both Oracle EBS 12.1.1 and 12.2.2. It depends on SYS.STANDARD and, internally, on the APPS.OE_ERROR_WF package specification and body. No other documented packages reference it, confirming its role as a supporting utility rather than a shared service.

Key Procedures and Functions

ETRM documents eight procedures and functions within OE_ERROR_WF. Their names indicate the following purposes:

• PURGE_ERROR_FLOW — Removes or cleans up workflow error data associated with a failed Order Management process, preventing obsolete error records from accumulating.
• INITIALIZE_ERRORS — Establishes the initial error-handling state for a workflow item, preparing it for error tracking and notification.
• UPDATE_PROCESS_MESSAGES — Maintains the processing messages linked to an errored workflow activity, updating OE_PROCESSING_MSGS content.
• SET_ENTITY_DESCRIPTOR — Defines the entity descriptor (such as order header, line, or delivery) that the error flow is associated with.
• CHECK_ERROR_ACTIVE — Determines whether an error condition is currently active for a given workflow item or entity.
• RESET_ERROR — Clears the error state so that a workflow process can be retried or resumed.
• EM_BATCH_RETRY_CONC_PGM — Supports batch retry of errored processes through a concurrent program interface, typically invoked for mass reprocessing.
• CHECK_CLOSED_DELIVERY_DETAIL — Validates whether a delivery detail is in a closed state, a relevant precondition when deciding whether an error can be reset or retried.

Parameter lists are not documented in the ETRM excerpt and are therefore not reproduced here.

Tables Accessed

The package reads and writes Order Management and Oracle Workflow tables through APPS synonyms. Order entities are represented by OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, and OE_BLANKET_HEADERS_ALL, which identify the documents in error. Message content is stored in OE_PROCESSING_MSGS and its translation table OE_PROCESSING_MSGS_TL, while OE_TRANSACTION_TYPES_TL supplies transaction type descriptions. Workflow state is managed through WF_ITEMS, WF_ACTIVITIES, WF_ITEM_ACTIVITY_STATUSES, WF_ITEM_ATTRIBUTE_VALUES, and WF_PROCESS_ACTIVITIES. Delivery context is drawn from WSH_DELIVERY_DETAILS. Utility access includes DBMS_UTILITY, PLITBLM, and V$TIMER, used for diagnostics and elapsed-time measurement.

Usage Notes

OE_ERROR_WF is an internal package and is not intended as a supported public API. It is invoked indirectly by Order Management error-handling workflows, by the standard error notification and retry mechanisms, and by the batch retry concurrent program that calls EM_BATCH_RETRY_CONC_PGM. Customizations that need to inspect or reset workflow errors should prefer documented public APIs; direct calls to this package risk incompatibility across patches and releases. Because the package depends on Workflow and Order Management dictionary objects, its availability is limited to environments where those products are installed and the APPS schema is fully compiled.