Search Results fnd_documents_s

Overview

APPS.DOM_ATTACHMENT_UTIL_PKG is the central utility package within the Oracle E-Business Suite (EBS) Document Management (DOM) module responsible for creating, maintaining, and removing attachments that link documents held in the FND_DOCUMENTS repository to EBS business entities. In the context of Oracle EBS 12.1.1 and 12.2.2, the Attachment Framework stores file content, short text, and long text in the FND_DOCUMENTS family of tables, while the FND_ATTACHED_DOCUMENTS tables associate those documents with specific application records such as a purchase order, invoice, or employee. DOM_ATTACHMENT_UTIL_PKG abstracts the underlying complexity of this framework, providing a programmatic interface that EBS forms, concurrent programs, and custom extensions can call to register, update, version, and delete attachments without touching the base tables directly. The package operates in the APPS schema and is documented as an OTHER-classified API (not a public, supported interface), meaning it is intended primarily for internal EBS use.

Key Procedures and Functions

The package body exposes ten documented procedures and functions that collectively manage the attachment lifecycle:

• ATTACH — establishes the association between an existing document and a business entity, creating the linkage row that makes the document accessible from an EBS form or page.
• CREATE_ATTACHMENT — creates a new document and its attachment association in a single operation, typically used when a file or text is uploaded for the first time.
• DETACH — removes the association between a document and its parent entity while leaving the underlying document record intact.
• DELETE_ATTACHMENTS — removes attachment records, and where appropriate the associated documents, for a given entity.
• UPDATE_DOCUMENT — modifies document attributes such as description, file name, or media details.
• CHANGE_VERSION — advances a document to a new version, supporting the versioning model used by DOM repositories.
• CHANGE_STATUS — transitions a document between defined lifecycle statuses.
• GET_REPOS_DOC_VIEW_URL — returns the view URL used to open or retrieve a document from its repository, enabling browser-based access.
• COPY_DOCUMENTS — duplicates document records, supporting reuse of content across entities.
• COPY_ATTACHMENTS — duplicates attachment associations, allowing attachments from one entity to be replicated onto another.

Tables Accessed

DOM_ATTACHMENT_UTIL_PKG reads and writes through APPS synonyms for the FND_DOCUMENTS tables and the DOM repository tables. FND_DOCUMENTS holds the master document record; FND_DOCUMENTS_TL and FND_DOCUMENTS_VL supply translated and view-layer descriptions; FND_DOCUMENTS_SHORT_TEXT and FND_DOCUMENTS_LONG_TEXT store inline text content; FND_LOBS stores binary large objects for uploaded files; and FND_ATTACHED_DOCUMENTS, together with the FND_ATTACHED_DOCUMENTS_S sequence and the FND_DOCUMENTS_S sequence, provides the entity-to-document linkage and key generation. DOM_REPOSITORIES and DOM_FILE_EXT supply repository configuration and file-extension metadata. FND_USER and FND_WEB_SEC are referenced for user identity and web security context, and DUAL, STANDARD, and the FND_ATTACHED_DOCUMENTS_PKG and FND_DOCUMENTS_PKG packages are used for standard utility and sequencing operations.

Usage Notes

This package is invoked from Oracle Forms attachment blocks, from concurrent programs that process or migrate attachments, and from custom PL/SQL that must programmatically manage documents. Because it is classified as OTHER rather than a supported public API, custom code should call the documented procedures with care, recognizing that signatures may change across patches. In EBS 12.2.2 the same logic underpins the web-based attachment UI in the OAF and forms-based interfaces. Developers searching for "fnd_documents_s" will find that sequence referenced here for generating document identifiers, confirming the package's role as a control point for the full attachment and document lifecycle.