Search Results dm_folder_path




Overview
Explore in AI Chat

Overview

APPS.DOM_REPOS_MIG_PKG is a migration and repository-maintenance package belonging to the Oracle E-Business Suite Document Management (DOM) module. Its principal business function is to support the migration and correction of folder hierarchies held in the document repository, specifically by rewriting the stored folder path values (the dm_folder_path column) that Oracle EBS uses to organize documents in a hierarchical, WebDAV-style folder structure. Because the repository stores each document's location as a single denormalized path string rather than as discrete parent/child node references, administrative changes to a repository node — renaming a repository, restructuring top-level folders, or rebuilding paths during an upgrade or data migration — require every dependent document row to be updated individually. This package provides that bulk path-rewriting capability.

Key Procedures and Functions

  • UPDATE_PATH — The core migration routine. It accepts an old path string and a new path string and rewrites the stored folder paths of affected documents. The procedure declares cursors that select the document identifier, the existing path, and a REPLACE-derived new path from the documents table, restricted to rows whose dm_folder_path matches the supplied old string pattern and whose dm_node corresponds to the repository being migrated. A second cursor handles the special case of paths that embed user names, including the first.last token substitution, the <f> initial token substitution, and the -Public suffix convention used by personal user folders. Output messages are returned through an x_msg CLOB parameter.
  • GET_NEW_PATH — A helper function that computes the replacement folder path string from the supplied old and new path values, encapsulating the token-substitution logic (user name and initial placeholders) used during migration so that callers need not reproduce it.

The package header identifies it as a non-shipped (noship) internal utility, version 120.1, last modified in 2006 for the Release 12 code line.

Tables Accessed

  • FND_DOCUMENTS — The primary target of the migration. The package reads document_id, dm_folder_path, and dm_node from this table and updates the folder path column.
  • FND_DOCUMENTS_TL — the translation table for documents, referenced where localized document attributes are affected.
  • DOM_REPOSITORIES — supplies repository definitions and node identifiers, resolving which repository a given dm_node belongs to.
  • ENG_ATTACHMENT_CHANGES — records attachment-level path change history, allowing the migration to be tracked or audited.
  • DUAL — used for scalar evaluation in support of the path transformation logic.

Usage Notes

This package is an internal administrative utility rather than a public API; it is not intended for direct invocation from Oracle Forms. It is typically executed from the database by a system administrator, or from a migration/upgrade script, when repository folder paths must be repointed after a repository rename or re-parenting operation. Because it performs set-based updates against FND_DOCUMENTS, it should be run within a controlled maintenance window with a validated backup, and its message CLOB should be inspected to confirm the affected document count. The ETRM metadata records no other package referencing DOM_REPOS_MIG_PKG, confirming it is a terminal (leaf) utility that callers invoke ad hoc rather than through a documented inter-package contract.