Search Results g_error_count

Overview

OE_BULK_VALIDATE is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is classified under the Order Management (OE) module and provides the validation engine used during bulk order import through the Order Import concurrent program. When order data is staged in the interface tables (OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL), this package performs pre-processing, attribute derivation, bill-of-material validation, and error marking before the records are promoted to the production order tables. Its role is to ensure data integrity and to surface descriptive errors to the user through the Order Management messaging framework rather than allowing malformed orders to reach OE_ORDER_HEADERS and OE_ORDER_LINES_ALL.

Key Procedures and Functions

The ETRM documentation records four procedures/functions within this package body:

• PRE_PROCESS — Performs the initial validation pass over staged interface records prior to detailed processing. It is the entry point that seeds working structures and orchestrates downstream validation logic, including defaulting of values sourced from profile options and lookups.
• ATTRIBUTES — Validates and resolves order and line attribute values, cross-referencing flexfield, lookup, and descriptive flexfield metadata. This routine helps ensure attribute combinations accepted during import conform to the configured value sets for the operating unit.
• VALIDATE_BOM — Validates bill-of-materials relationships for configured or ATO (Assemble-to-Order)/PTO (Pick-to-Order) items. It reads BOM_EXPLOSIONS and MTL_SYSTEM_ITEMS to confirm that the parent/component structure implied by the imported order lines is viable.
• MARK_INTERFACE_ERROR — Writes error information back to the interface records so that failed rows can be identified and corrected by the user. This routine collaborates with OE_BULK_MSG_PUB and OE_PROCESSING_MSGS to produce the descriptive error text returned by Order Import.

Tables Accessed

The package accesses a broad set of APPS synonyms. Interface staging tables OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL hold the inbound records being validated. OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL are read and updated; OE_ORDER_HEADERS is referenced for existing-order context. OE_PRICE_ADJS_INTERFACE is accessed in relation to price adjustment lines applied to imported orders, which is the object surface relevant to users searching for "oe_price_adjs_interface." Supporting validation data comes from QP_LIST_HEADERS, QP_LIST_HEADERS_VL, and QP_LIST_LINES (price lists), BOM_EXPLOSIONS and MTL_SYSTEM_ITEMS (item/BOM structure), MTL_GRADES_B (grade codes), JTF_RS_RESOURCE_EXTNS, JTF_RS_SALESREPS, and RA_SALESREPS_ALL (salesrep validation), plus FND_LOOKUP_TYPES, FND_LOOKUP_VALUES, and OE_LOOKUPS for lookup code verification. OE_CONFIG_DETAILS_TMP, OE_MSG_ID_S, and OE_PROCESSING_MSGS support message handling, while OE_CODE_CONTROL, OE_AR_LOOKUPS_V, OE_FND_CURRENCIES_V, OE_GL_DAILY_CONVERSION_TYPES_V, OE_RA_RULES_V, OE_RA_TERMS_V, OE_SHIP_METHODS_V, OE_SOLD_TO_ORGS_V, and PJM_UNIT_NUMBERS_LOV_V provide validation views for codes, currencies, receivables rules, payment terms, shipping methods, sold-to organizations, and unit numbers.

Usage Notes

OE_BULK_VALIDATE is not referenced by any database object and is therefore an internal implementation package rather than a public API. It is invoked by the Order Import flow through OE_BULK_ORDER_IMPORT_PVT and OE_BULK_ORDER_PVT, and it in turn relies on OE_ORDER_UTIL, FND_API, FND_MESSAGE, FND_PROFILE, FND_GLOBAL, MO_GLOBAL, and OE_DEBUG_PUB. Customizations should avoid direct calls into this package; instead, extensions should be implemented on the interface staging tables or through supported Order Import hooks. Because the package is documented as OTHER rather than as a public API, Oracle does not guarantee backward compatibility of its internal signatures across patch levels, and any debugging should be performed with OE_DEBUG_PUB tracing enabled. Three other packages reference OE_BULK_VALIDATE, confirming its role as a shared validation utility within the Order Import stack.