Search Results oe_delayed_requests_util
Overview
OE_DELAYED_REQUESTS_UTIL is a utility package in the APPS schema of Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Order Management (OM) module and is classified under the ETRM (E-Business Suite Technical Reference Manual) as a UTIL-type API. In that taxonomy, utility packages provide low-level helper logic that supports higher-level public APIs, rather than exposing a user-facing or fully validated business interface of their own.
The package supports delayed request processing within Order Management, including service credit (SCREDIT) handling, hold management, and order line credit validation. Its procedures and functions centralize reusable processing that other OM components — particularly OE_DELAYED_REQUESTS_PVT and the order/lines utilities — rely on when an order or order line has been captured but whose dependent processing is deferred.
Key Procedures and Functions
According to the documented ETRM metadata, the package contains 46 procedures and functions. Representative entries include:
- FIRST_PERIOD_BILL_AMT — derives the bill amount for the first billing period, used in service credit and billing-related calculations.
- VALIDATE_LSC_QUOTA_TOTAL and VALIDATE_HSC_QUOTA_TOTAL — validate line-level and header-level service credit quota totals respectively.
- CASCADE_SERVICE_SCREDIT — propagates service credit values down affected order structures.
- DFLT_HSCREDIT_PRIMARY_SREP — defaults the primary sales representative for header-level service credit.
- UPDATE_LINK_TO_LINE_ID — maintains the linkage between related order records.
- CHECK_DUPLICATE, CHECK_FIXED_PRICE, CHECK_PERCENTAGE — validation checks for duplicates, fixed-price pricing, and percentage-based values.
- CREATE_CONFIG_ITEM, INS_INCLUDED_ITEMS — build configuration items and their included components.
- VERIFY_PAYMENT — confirms payment conditions before credit processing proceeds.
- INSERT_RMA_SCREDIT_ADJUSTMENT, INSERT_RMA_OPTIONS_INCLUDED, INSERT_RMA_LOT_SERIAL — insert RMA-related service credit adjustments, included options, and lot/serial detail.
- TAX_LINE — supports tax line creation linked to order processing.
- SPLIT_HOLD, EVAL_HOLD_SOURCE, APPLY_HOLD, RELEASE_HOLD — the package's hold-management set: evaluating hold sources, applying, splitting, and releasing order holds.
Parameter lists are not published in the ETRM excerpt, so signatures should always be confirmed against the live package specification before direct invocation.
Tables Accessed
The package reads and writes through APPS synonyms of the following base tables:
- OE_ORDER_HEADERS / OE_ORDER_HEADERS_ALL and OE_ORDER_LINES / OE_ORDER_LINES_ALL — the core order header and line records the utility updates or queries.
- OE_HOLD_SOURCES_ALL — hold source definitions consumed by EVAL_HOLD_SOURCE, APPLY_HOLD, and RELEASE_HOLD.
- OE_DISCOUNTS and OE_DISCOUNT_LINES — pricing and discount data relevant to credit and pricing checks.
- OE_HEADER_ACKS, OE_LINE_ACKS, OE_LINE_SETS — acknowledgement and line set records produced or maintained during deferred processing.
- MTL_SYSTEM_ITEMS, MTL_LOT_NUMBERS, MTL_MATERIAL_TRANSACTIONS, MTL_TRANSACTION_LOT_NUMBERS — item and lot/serial information used in RMA and inventory-facing inserts.
- FND_USER — user context for responsibility and attribution.
Usage Notes
OE_DELAYED_REQUESTS_UTIL is an internal helper, not a standalone public API. It depends on FND_API, OE_DELAYED_REQUESTS_PVT, OE_HOLD_SOURCES_ALL, and OE_ORDER_PUB, and is itself referenced by OE_DELAYED_REQUESTS_PVT, OE_HEADER_UTIL, OE_LINE_UTIL, OE_VALIDATE_LINE_SCREDIT, and OM_TAX_UTIL — eight referring packages in total. Invocation therefore typically flows indirectly: delayed request processing, order entry forms, hold application flows, and service credit validation routines reach these procedures through the public Order Management APIs (notably OE_ORDER_PUB). Customizations should prefer those supported entry points; direct calls should be limited to extension logic that mirrors an existing internal call path and must be re-tested against both 12.1.1 and 12.2.2, since utility packages are not covered by Oracle's compatibility guarantees.
-
PACKAGE: APPS.OE_DELAYED_REQUESTS_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_DELAYED_REQUESTS_UTIL, status:VALID,
-
PACKAGE: APPS.OE_DELAYED_REQUESTS_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_DELAYED_REQUESTS_UTIL, status:VALID,
-
SYNONYM: APPS.OE_HOLD_SOURCES_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:OE_HOLD_SOURCES_ALL, status:VALID,
-
SYNONYM: APPS.OE_HOLD_SOURCES_ALL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:OE_HOLD_SOURCES_ALL, status:VALID,
-
SYNONYM: APPS.OE_DISCOUNT_LINES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:OE_DISCOUNT_LINES, status:VALID,
-
SYNONYM: APPS.OE_DISCOUNT_LINES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:OE_DISCOUNT_LINES, status:VALID,
-
PACKAGE BODY: APPS.OE_DELAYED_REQUESTS_UTIL
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_DELAYED_REQUESTS_UTIL, status:VALID,
-
PACKAGE: APPS.OE_DELAYED_REQUESTS_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_DELAYED_REQUESTS_PVT, status:VALID,
-
PACKAGE: APPS.OE_FTE_INTEGRATION_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_FTE_INTEGRATION_PVT, status:VALID,
-
PACKAGE: APPS.OE_DELAYED_REQUESTS_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_DELAYED_REQUESTS_PVT, status:VALID,
-
PACKAGE: APPS.OM_TAX_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OM_TAX_UTIL, status:VALID,
-
SYNONYM: APPS.OE_SETS_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:OE_SETS_S, status:VALID,
-
PACKAGE: APPS.OE_PROCESS_REQUISITION_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_PROCESS_REQUISITION_PVT, status:VALID,
-
SYNONYM: APPS.OE_DISCOUNTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:OE_DISCOUNTS, status:VALID,
-
PACKAGE: APPS.OE_PROCESS_REQUISITION_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_PROCESS_REQUISITION_PVT, status:VALID,
-
PACKAGE BODY: APPS.OE_DELAYED_REQUESTS_UTIL
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_DELAYED_REQUESTS_UTIL, status:VALID,
-
PACKAGE: APPS.OE_ORDER_IMPORT_WF
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_ORDER_IMPORT_WF, status:VALID,
-
PACKAGE: APPS.OE_FTE_INTEGRATION_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_FTE_INTEGRATION_PVT, status:VALID,
-
SYNONYM: APPS.OE_DISCOUNTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:OE_DISCOUNTS, status:VALID,
-
PACKAGE: APPS.PO_CREATE_REQUISITION_SV
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_CREATE_REQUISITION_SV, status:VALID,
-
PACKAGE: APPS.OM_TAX_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OM_TAX_UTIL, status:VALID,
-
PACKAGE: APPS.PO_CREATE_REQUISITION_SV
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_CREATE_REQUISITION_SV, status:VALID,
-
PACKAGE: APPS.OE_ORDER_IMPORT_WF
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_ORDER_IMPORT_WF, status:VALID,
-
PACKAGE: APPS.OE_COPY_UTIL_EXT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_COPY_UTIL_EXT, status:VALID,
-
SYNONYM: APPS.OE_SETS_S
12.2.2
owner:APPS, object_type:SYNONYM, object_name:OE_SETS_S, status:VALID,
-
PACKAGE: APPS.OE_COPY_UTIL_EXT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_COPY_UTIL_EXT, status:VALID,
-
SYNONYM: APPS.OE_XML_MESSAGE_SEQ_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:OE_XML_MESSAGE_SEQ_S, status:VALID,
-
PACKAGE: APPS.OE_ATCHMT_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_ATCHMT_UTIL, status:VALID,
-
PACKAGE: APPS.OE_VALIDATE_HEADER_SCREDIT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_VALIDATE_HEADER_SCREDIT, status:VALID,
-
PACKAGE: APPS.OE_VALIDATE_HEADER_SCREDIT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_VALIDATE_HEADER_SCREDIT, status:VALID,
-
SYNONYM: APPS.OE_HEADER_ACKS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:OE_HEADER_ACKS, status:VALID,
-
SYNONYM: APPS.OE_HEADER_ACKS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:OE_HEADER_ACKS, status:VALID,
-
SYNONYM: APPS.OE_LINE_SETS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:OE_LINE_SETS, status:VALID,
-
SYNONYM: APPS.OE_LINE_SETS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:OE_LINE_SETS, status:VALID,
-
PACKAGE: APPS.OE_ORDER_COPY_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_ORDER_COPY_UTIL, status:VALID,
-
PACKAGE: APPS.OE_ORDER_BOOK_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_ORDER_BOOK_UTIL, status:VALID,
-
PACKAGE: APPS.OE_ORDER_BOOK_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_ORDER_BOOK_UTIL, status:VALID,
-
SYNONYM: APPS.OE_LINE_ACKS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:OE_LINE_ACKS, status:VALID,
-
PACKAGE: APPS.OE_ATCHMT_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_ATCHMT_UTIL, status:VALID,
-
PACKAGE: APPS.OE_SHIPPING_INTEGRATION_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_SHIPPING_INTEGRATION_PVT, status:VALID,
-
PACKAGE: APPS.OE_SHIPPING_INTEGRATION_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_SHIPPING_INTEGRATION_PVT, status:VALID,
-
SYNONYM: APPS.OE_LINE_ACKS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:OE_LINE_ACKS, status:VALID,
-
SYNONYM: APPS.OE_XML_MESSAGE_SEQ_S
12.2.2
owner:APPS, object_type:SYNONYM, object_name:OE_XML_MESSAGE_SEQ_S, status:VALID,
-
PACKAGE: APPS.OE_GRP_SCH_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_GRP_SCH_UTIL, status:VALID,
-
PACKAGE: APPS.OE_ORDER_COPY_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_ORDER_COPY_UTIL, status:VALID,
-
PACKAGE: APPS.OE_GRP_SCH_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_GRP_SCH_UTIL, status:VALID,
-
PACKAGE BODY: APPS.OE_VALIDATE_LINE_SCREDIT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_VALIDATE_LINE_SCREDIT, status:VALID,
-
PACKAGE: APPS.OE_LOT_SERIAL_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_LOT_SERIAL_UTIL, status:VALID,
-
PACKAGE BODY: APPS.OE_VALIDATE_LINE_SCREDIT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_VALIDATE_LINE_SCREDIT, status:VALID,
-
PACKAGE: APPS.OE_LOT_SERIAL_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_LOT_SERIAL_UTIL, status:VALID,