Search Results create_direct_rti_rec

Overview

GML_RCV_DIR_RCPT_APIS is an Oracle EBS PL/SQL package owned by the APPS schema that supports direct receipt processing within the Process Manufacturing (OPM/GML) receiving model. "GML" denotes the Process Manufacturing product family, while "DIR_RCPT" reflects the package's role in handling direct receipts — receipts where inventory is received and transacted without the intermediate staging typical of standard Oracle Purchasing receiving. The package is classified as an OTHER API, indicating it operates as a programmatic interface layer rather than a public, formally supported open interface.

The package enables creation of receipt transactions that touch both the receiving and inventory/order-management sides of the application. It bridges purchasing documents (purchase orders, distributions, line locations) with inventory transactions and, in the OSP variant, outside processing scenarios where a supplier performs a service against a purchase order. In Oracle EBS 12.1.1 and 12.2.2 this object remains VALID, and it depends only on the standard SYS.STANDARD package, meaning it is essentially self-contained with no reliance on other APPS-level dependency packages.

Key Procedures and Functions

• CREATE_DIRECT_RTI_REC — Creates a direct receive-transaction receipt. "RTI" refers to receipt-to-inventory processing: the procedure records a receipt against a purchasing document and drives the corresponding inventory transaction so that material is received directly into inventory in a single flow.
• CREATE_OSP_DIRECT_RTI_REC — The outside-processing (OSP) variant of the same operation. It handles direct receipts tied to outside processing, where a supplier performs value-added work against a purchase order and the receipt must also drive the associated OSP inventory and cost activity.

No parameter lists, return types, or overload signatures are documented in the ETRM metadata; only the two procedure names and their roles are available. Customizations should inspect the package specification for exact signatures before invocation.

Tables Accessed

The package operates against a broad set of transactional and reference tables, referenced via APPS synonyms:

• Purchasing: PO_HEADERS, PO_LINES, PO_LINES_ALL, PO_LINE_LOCATIONS, PO_DISTRIBUTIONS — source documents for the receipt, including distribution accounting.
• Inventory transactions: MTL_MATERIAL_TRANSACTIONS_S (sequence), MTL_MATERIAL_TRANSACTIONS_TEMP — staging for the inventory transaction records generated by the receipt.
• Lot and serial control: MTL_LOT_NUMBERS, MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_TEMP — lot/serial capture for the received material.
• Item and UOM master: MTL_SYSTEM_ITEMS, MTL_UNITS_OF_MEASURE — validation of items and units of measure.
• Costing: CST_COST_GROUP_ACCOUNTS — cost group account derivation.
• Order management: OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL — support for drop-ship or order-linked receipt flows.

Usage Notes

Typical invocation is from Process Manufacturing receiving forms, receipt-related concurrent programs, or custom PL/SQL that needs to post direct receipts programmatically. Because the package is classified as OTHER, it is not part of Oracle's supported public API set; Oracle does not guarantee backward compatibility of its signatures across releases. Custom code should call it only after validating that the current package specification matches compiled assumptions, and should wrap calls in appropriate error handling since direct receipt creation touches purchasing, inventory, lot/serial, and costing data in a single transaction. It is referenced by no other APPS package and references no other APPS package, so its usage surface is limited to external callers such as forms, concurrent managers, or bespoke extensions.