Search Results get_rejected_lines

Overview

OE_REJECTED_LINES_ACK is an Oracle Order Management acknowledgement utility package owned by APPS. Its business purpose is to retrieve and acknowledge order lines that the Order Management processing engine could not accept during import or validation, exposing those rejected records back to the calling application or interface so that they can be reported, corrected, and resubmitted. In Oracle EBS 12.1.1 and 12.2.2 this package functions as the return channel of the inbound order flow: rather than silently discarding failing records, it packages them into strongly typed PL/SQL collections that mirror the structures used by OE_Order_Pub. This gives external order sources, typically middleware or a legacy order capture system, a programmatic way to identify exactly which lines failed, along with the associated validation messages and lot/serial information.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than as definer-rights APPS code. Callers must therefore hold the necessary object and table privileges directly.

Key Procedures and Functions

• GET_REJECTED_LINES — The single documented procedure in the package. It accepts a request identifier, the source order system identifier, the original source document reference, a change sequence, and a header identifier, with optional sold-to organization name and identifier parameters. It returns rejected order line records, their associated value/flexfield attribute records, and rejected lot and serial records through IN OUT NOCOPY and OUT NOCOPY collection parameters, along with a standard return status indicator. The NOCOPY hint confirms that the collections are passed by reference for performance, which matters because rejected result sets can be large. No other procedures or functions are documented.

Tables Accessed

• OE_LINES_INTERFACE — The order lines open interface table. The procedure reads rejected line payloads staged here to construct the returned line collections.
• OE_LOTSERIALS_INTERFACE — The lot and serial number open interface table, used to compile the rejected lot/serial collection returned to the caller.
• PLITBLM — An Oracle Applications internal table used in the processing of open interface data, referenced during the retrieval logic.

Access to these objects occurs through APPS synonyms, consistent with standard EBS interface design.

Usage Notes

GET_REJECTED_LINES is typically invoked in the context of inbound order import processing, where an external source submits orders and then calls back to obtain the acknowledgement of any lines the import rejected. It is referenced by one other documented package, indicating it is a supporting component layered beneath a higher-level acknowledgement or import orchestration routine rather than being called directly from a form.

Practical invocations include custom PL/SQL wrappers, concurrent program bodies that extract rejected lines for reporting, and integration adapters that must return error detail to the originating system. Because the procedure uses IN OUT NOCOPY collections typed against OE_Order_Pub, callers should declare their collection variables using those same public types, initialize them before the call, and inspect the returned status value rather than relying on exceptions for normal rejection flow. The source header notes a packaging version of 115.8 dated 2003, so the object has remained stable across the 12.1.1 and 12.2.2 releases, with no structural change to the documented interface.