Search Results update_rti

Overview

The APPS.RCV_UPDATE_RTI_LC package is a supporting PL/SQL specification within the Oracle E-Business Suite Receiving (RCV) module. Its specific role is to manage the landed cost dimension of Receiving Transaction Interface (RTI) processing. In Oracle EBS, Inventory and Purchasing maintain two parallel costs for received goods: the transaction cost and the landed cost. The landed cost reflects additional charges that are legitimately allocated to the material — freight, duty, insurance, and similar charges. The RTI is the staging mechanism by which transaction data is validated, then processed into the receiving transaction tables.

This package exposes a procedure, UPDATE_RTI, whose purpose is to write unit landed cost values back to the Receiving Transaction Interface. It accepts an incoming collection of records (defined internally via the rcv_cost_type record type, comprising interface_id, lcm_shipment_line_id, and unit_landed_cost) and returns a table of numeric interface identifiers through an OUT parameter, indicating which landed cost shipment lines were successfully updated. While the source header dates to 2008, the package remains documented in ETRM for releases 12.1.1 and 12.2.2. It is classified as an OTHER API, indicating it is an internal or supporting routine rather than a fully supported public interface.

Key Procedures and Functions

The package exposes a single documented procedure:

• UPDATE_RTI — Populates and updates the landed cost values for records staged in the Receiving Transaction Interface. It takes an incoming PL/SQL table of landed cost records and returns an output collection containing the interface identifiers that were updated. Because the specification declares the OUT parameter with NOCOPY, callers receive the resulting identifier set efficiently without an intermediate copy. Only UPDATE_RTI is treated as a documented entry point; the record and table type declarations (rcv_cost_type, rcv_cost_table, lcm_int_table) exist to define the procedure's call signature.

Tables Accessed

Within the package's referenced scope, the following tables are touched through APPS synonyms:

• RCV_HEADERS_INTERFACE — the staging table for receiving header information; the package correlates the landed cost update to the correct interface header row.
• RCV_TRANSACTIONS_INTERFACE — the core RTI staging table holding transactions awaiting validation and processing; landed cost values are applied here so the Receiving Transaction Processor can consume them.
• RCV_INTERFACE_GROUPS_S — the sequence source used to obtain grouping identifiers for interface records.
• DUAL — used for scalar evaluations and sequence or expression lookups.
• PLITBLM — the standard Oracle Applications PL/SQL table manipulation package, used to manage the indexed collections of interface identifiers.

Usage Notes

RCV_UPDATE_RTI_LC is invoked as a sub-component of the broader receiving landed cost workflow, particularly where landed cost shipment lines must be reconciled back to staged interface records. It is referenced by one other package within the EBS schema, indicating that it is called internally by related receiving landed cost logic rather than directly from the standard Receiving or Landed Cost forms. Typical invocations occur during the pre-processing phase of the Receiving Transaction Processor, or from custom extensions that build landed cost records programmatically and require those values to be reflected in the interface tables before validation. Because the API is classified as OTHER and lies outside the supported public API surface, customizations that call it should be regression tested against any application patch level, as signatures and internal behavior are subject to change without the compatibility guarantees afforded to public interfaces.