Search Results get_cancellation_status

Overview

POS_CANCEL_ASN is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM documentation as an "OTHER" API. Its principal business function is to manage the cancellation of Advance Shipping Notices (ASNs), also known as shipment headers, within the Oracle Purchasing and Receiving (RCV) modules. When goods are in transit and an ASN has been created but the receipt has not yet been finalized, business users may need to cancel the ASN — for example, when a supplier withdraws a shipment, when quantity corrections are required, or when the transaction must be reversed before it affects on-hand inventory and accounting. The package provides the programmatic means to identify ASNs eligible for cancellation, execute the cancellation, and report on processing and cancellation status.

The package is recorded as VALID in ETRM and references the SYS STANDARD package. It is referenced by one other package as well as by the POS_LINES_V view, which indicates that ASN cancellation state is exposed to downstream purchasing-line reporting.

Key Procedures and Functions

ETRM documents six procedures and functions within the package. Parameter lists are not published, so only purposes are described.

• CANCEL_ASN — The core procedure that performs the cancellation of a specified advance shipping notice. It orchestrates the validation and reversal logic required to void the ASN.
• GET_PROCESSING_STATUS — Returns the current processing status of an ASN cancellation request, allowing callers to poll or verify the state of an in-flight cancellation.
• GET_CANCELLATION_STATUS — Reports the cancellation status of a given ASN, indicating whether the cancellation completed, failed, or remains pending.
• FIND_PROCESSING_CANCELLATION — Locates cancellations currently in process, enabling callers to identify outstanding or incomplete cancellation operations.
• GET_LINE_STATUS — Returns status information at the shipment-line level, providing granular visibility into which lines of an ASN are affected by cancellation processing.

Tables Accessed

The package reads and writes a well-defined set of tables through APPS synonyms:

• RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES — The primary ASN header and line records that the cancellation logic must update or reverse.
• RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE, and RCV_INTERFACE_GROUPS_S — The Receiving Open Interface staging tables; cancellation may propagate related interface records.
• PO_HEADERS_ALL — Used to validate the associated purchase order and linkage to the ASN.
• AP_INVOICES and AP_INVOICES_ALL — Referenced to detect invoice matching against the shipment, since cancellation may be constrained when invoices exist.
• GL_PERIOD_STATUSES — Used to validate that the relevant accounting period permits the reversal activity.
• FND_ATTACHED_DOCUMENTS and FND_NEW_MESSAGES — Supporting Framework objects for attachments and notification messaging.
• MO_GLOB_ORG_ACCESS_TMP — A temporary organization-access table supporting multi-org security checks.
• DUAL — Used for simple scalar queries.

Usage Notes

POS_CANCEL_ASN is typically invoked from Oracle Purchasing and Receiving forms when a user cancels an ASN, and may also be called by concurrent programs that purge or reprocess receipt data. Because POS_LINES_V depends on it, the package's status functions feed purchasing-line reporting views. Custom extensions and integrations that need to programmatically cancel ASNs or query cancellation status should call these packaged APIs rather than updating the RCV tables directly, preserving validation, multi-org security, and interface integrity.