Search Results rcv_receipt_confirmation
Overview
The APPS.RCV_RECEIPT_CONFIRMATION package body is a server-side PL/SQL component within the Oracle E-Business Suite Receiving (RCV) module. Its business function is to support the receipt confirmation process — the workflow by which goods received against a purchase order, internal requisition, or advanced shipment notice (ASN) are validated and committed into Oracle Inventory and Purchasing. Confirmation of a receipt transitions inbound shipment data into the transactional record, updating on-hand balances and triggering downstream accounting and matching activities.
The package is stored in the APPS schema and holds a status of VALID in the documented environment. Its dependency footprint reveals heavy integration with the receiving data model: it references RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES, and RCV_TRANSACTIONS, as well as supporting infrastructure packages such as RCV_ERROR_PKG, RCV_TRANSACTIONS_UTIL2, FND_DATE, FND_LOG, and WMS_DEPLOY. The presence of WMS_DEPLOY indicates conditional handling for Oracle Warehouse Management-enabled organizations, while ASN_DEBUG and FND_LOG signal diagnostic and logging capabilities built into the confirmation logic.
Key Procedures and Functions
The ETRM metadata documents two callable units within the package body:
- SEND_CONFIRMATION — This procedure drives the confirmation dispatch logic. Based on the documented dependencies on
RCV_SHIPMENT_HEADERS,RCV_SHIPMENT_LINES, andRCV_TRANSACTIONS, it assembles and transmits receipt confirmation details for the applicable shipment. Its reliance onFND_LOGandASN_DEBUGimplies structured logging of confirmation attempts and outcomes. - GET_OU_NAME — This function retrieves the operating unit (OU) name associated with the receipt context. It supports multi-organization reporting and notification, since confirmation output must identify the correct operating unit. The reference to
ORG_ORGANIZATION_DEFINITIONSin the dependency list corroborates that OU name resolution is performed against organization definitions.
The API classification is recorded as OTHER, meaning the package is not formally registered as a public or private API within the standard classification framework. The metadata lists no parameters for either unit; accordingly, no parameter lists are asserted here.
Tables Accessed
- RCV_SHIPMENT_HEADERS — The header-level record of an inbound shipment. The package reads shipment context such as supplier, ASN, and receiving organization to determine what confirmation content is required.
- RCV_SHIPMENT_LINES — Line-level shipment detail. Provides the item, quantity, and receipt line references needed to build confirmation records.
- RCV_TRANSACTIONS — The receipt transaction table representing confirmed receiving activity. Access here supports correlation of the shipment to its resulting inventory transactions.
Additionally, the documented dependency list includes ORG_ORGANIZATION_DEFINITIONS, used to resolve organization and operating unit attributes.
Usage Notes
This package is most commonly invoked from the Receiving forms and from concurrent or background confirmation processing when receipt confirmation output must be generated and dispatched. Because it is documented as referenced by zero other database objects, it sits at the top of its call chain rather than functioning as a shared utility reached by other packages. Customizations and extensions that need to emit receipt confirmations typically call SEND_CONFIRMATION directly, passing shipment context derived from RCV_SHIPMENT_HEADERS; GET_OU_NAME is useful where the operating unit name must be displayed or embedded in confirmation content. Implementers should treat the package as a receiving-internal component, respect its dependency on WMS-enabled and logging infrastructure, and review environment-specific behavior on both 12.1.1 and 12.2.2 when integrating print or EDI confirmation logic.
-
PACKAGE BODY: APPS.RCV_RECEIPT_CONFIRMATION
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:RCV_RECEIPT_CONFIRMATION, status:VALID,
-
PACKAGE: APPS.RCV_RECEIPT_CONFIRMATION
12.2.2
-
PACKAGE: APPS.RCV_RECEIPT_CONFIRMATION
12.2.2
owner:APPS, object_type:PACKAGE, object_name:RCV_RECEIPT_CONFIRMATION, status:VALID,
-
PACKAGE: APPS.RCV_TRANSACTIONS_UTIL2
12.2.2
owner:APPS, object_type:PACKAGE, object_name:RCV_TRANSACTIONS_UTIL2, status:VALID,
-
PACKAGE: APPS.RCV_ERROR_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:RCV_ERROR_PKG, status:VALID,
-
PACKAGE: APPS.ASN_DEBUG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ASN_DEBUG, status:VALID,
-
PACKAGE: APPS.WMS_DEPLOY
12.2.2
owner:APPS, object_type:PACKAGE, object_name:WMS_DEPLOY, status:VALID,
-
SYNONYM: APPS.RCV_SHIPMENT_HEADERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_SHIPMENT_HEADERS, status:VALID,
-
PACKAGE BODY: APPS.RCV_RECEIPT_CONFIRMATION
12.2.2
-
SYNONYM: APPS.RCV_SHIPMENT_LINES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_SHIPMENT_LINES, status:VALID,
-
APPS.RCV_RECEIPT_CONFIRMATION dependencies on RCV_RECEIPT_CONFIRMATION
12.2.2
-
SYNONYM: APPS.RCV_TRANSACTIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_TRANSACTIONS, status:VALID,
-
VIEW: APPS.ORG_ORGANIZATION_DEFINITIONS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:INV.ORG_ORGANIZATION_DEFINITIONS, object_name:ORG_ORGANIZATION_DEFINITIONS, status:VALID,
-
PACKAGE: APPS.FND_DATE
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_DATE, status:VALID,
-
PACKAGE: APPS.FND_LOG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_LOG, status:VALID,
-
APPS.RCV_RECEIPT_CONFIRMATION dependencies on ASN_DEBUG
12.2.2
-
12.2.2 DBA Data
12.2.2
-
12.2.2 DBA Data
12.2.2