Search Results po_att




Overview
Explore in AI Chat

Overview

PO_ATT is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, documented as VALID in both the 12.1.1 and 12.2.2 releases. The package encapsulates the attachment-handling logic used by the Purchasing (PO) module. Its principal role is to create, maintain, and retrieve attachments — notes, short text, and long text documents — that are associated with purchasing documents such as requisitions, purchase orders, releases, quotations, and their associated lines and distributions. Rather than each Purchasing form or concurrent program implementing its own attachment logic against the FND_DOCUMENTS family of tables, PO_ATT centralizes that logic and exposes it for reuse.

Key Procedures and Functions

The ETRM metadata for the 12.2.2 release records no separately documented procedures or functions for this package body, indicating that PO_ATT is an internal implementation unit rather than a published public API. In practice, the package contains private helper routines that wrap the standard Oracle Attachment Framework calls (FND_ATTACHED_DOCUMENTS and its APIs) so that Purchasing entities can register, query, and remove attachments against the correct document entity and category. Because these procedures are not part of the documented public interface, customizations should not call them directly; the supported approach is to use the Oracle Attachment Framework APIs or the standard Purchasing forms.

Tables Accessed

The dependency listing shows that PO_ATT reads and writes the core attachment tables. FND_DOCUMENTS, FND_DOCUMENTS_TL, and FND_DOCUMENT_CATEGORIES provide the document definition, its translated descriptions, and the category that classifies the attachment. FND_ATTACHED_DOCUMENTS and FND_ATTACHED_DOCUMENTS_S link a document to a specific entity (the purchasing document) and act as the association bridge. FND_DOCUMENTS_SHORT_TEXT and FND_DOCUMENTS_SHORT_TEXT_S store short-text attachments, while FND_DOCUMENTS_LONG_TEXT and FND_DOCUMENTS_LONG_TEXT_S store long-text attachments. The package also references PO_NOTES, the Purchasing notes table, and PO_ATT_TMP_RECORDS, a temporary staging table used during processing. FINANCIALS_SYSTEM_PARAMETERS supplies operating-unit level setup values that govern attachment behavior. The query a user searched for, FND_DOCUMENTS_SHORT_TEXT_S, is therefore relevant because it is one of the principal attachment-data tables PO_ATT manipulates when a short-text attachment is created or retrieved for a purchasing document. SYS.DUAL and the STANDARD package supply routine SQL and error-handling support.

Usage Notes

PO_ATT is invoked indirectly. Users interact with it through the Purchasing and iProcurement forms and self-service pages whenever they attach, view, or delete a note or text attachment on a requisition, purchase order, or related line. Concurrent programs that copy or import purchasing documents, and internal Purchasing APIs such as the requisition and PO import APIs, also rely on this logic to carry attachments forward. The ETRM metadata states that PO_ATT is not referenced by any other database object, confirming its position as a leaf dependency used by the application layer rather than a shared library. Custom code should avoid calling PO_ATT directly and should instead use the documented Oracle Attachment Framework APIs, so that attachment records remain consistent across FND_DOCUMENTS, FND_ATTACHED_DOCUMENTS, and the short- and long-text tables.