Search Results send_receipt_confirmation




Overview
Explore in AI Chat

Overview

APPS.RCV_TRANSACTIONS_UTIL2 is a Receiving (RCV) utility package body that supports the Oracle E-Business Suite Receiving transaction framework, particularly the interface between receiving transactions and the Oracle Workflow / transaction history infrastructure. Its principal role is to coordinate the recording and status maintenance of receiving events in the transaction history table, and to drive the notification and confirmation activities associated with Advanced Shipment Notice (ASN) and receipt confirmation flows. The package carries the header identifier RCVTXUTB.pls and is classified as an OTHER API in the ETRM metadata, reflecting that it is an internal utility rather than a published open interface.

A central concern of the package is the transaction history state machine. Procedures write status codes such as ST (success) and ER (error) against records held in MTL_TXNS_HISTORY, keyed by event name and event key. The package also incorporates diagnostic logging through the ASN_DEBUG facility, gated by the g_asn_debug flag, which writes the item type, item key, activity identifier, and function mode whenever the user has enabled ASN debugging (referencing Bug 9152790).

Key Procedures and Functions

  • UPDATE_TXN_HISTORY — The core history update routine. It records the outcome of a receiving transaction against the transaction history records, and is invoked by the workflow wrapper with a status such as ST. This procedure is the primary entry point that the user search term "update_txn_history" targets.
  • UPDATE_TXN_HIST_SUCCESS_WF — A Workflow-facing wrapper for successful transaction history updates. On a RUN function mode it calls UPDATE_TXN_HISTORY, inspects the returned status, and sets resultout to COMPLETE:SUCCESS when the return status matches rcv_error_pkg.g_ret_sts_success. If the status does not match, it raises the update_history exception, which updates the matching MTL_TXNS_HISTORY rows from IP (in progress) to ER (error), sets resultout to COMPLETE:FAILURE, and re-raises. A WHEN OTHERS handler performs the same IP-to-ER correction before propagating the error.
  • SEND_DOCUMENT — Supports the document delivery aspect of the receiving notification flow, generating or dispatching the document associated with a receiving event.
  • SEND_RECEIPT_CONFIRMATION — Issues receipt confirmation communication, typically in the ASN and advance receiving context, notifying the relevant party that goods have been received.

Tables Accessed

  • MTL_TXNS_HISTORY — The transaction history table. The package inserts and updates history records and transitions their transaction_status between IP, ST, and ER values.
  • MTL_CLIENT_PARAMETERS — Provides client-level setup and configuration values that govern receiving behavior.
  • HZ_CUST_ACCOUNTS — Supplies customer account information used when building outbound documents and confirmations.
  • PO_WF_ITEMKEY_S — The Purchasing workflow item key sequence, used to generate item keys for the workflow activities driven by the wrapper procedure.
  • DUAL — Used for single-row evaluations and sequence or expression retrieval.

Usage Notes

The package is invoked primarily through the Oracle Workflow engine, where UPDATE_TXN_HIST_SUCCESS_WF acts as a workflow activity function receiving item_type, item_key, actid, and funcmode. It is also called internally by other Receiving packages and business flows that need to persist or correct transaction history status. A single other package references it directly, indicating that it is a supporting utility rather than a top-level API surface. Custom code should call the documented procedures only, and developers should note that the package is not classified as a public API in the ETRM metadata; changes to transaction history status outside this package risk leaving records in an IP state.