Search Results up_fnd_ums_bugfix

Overview

FND_OAM_UMS_LOADER is an Oracle E-Business Suite Application Object Library (AD) package that supports the Oracle Update Manager / Unified Management System (UMS) subsystem used to load and maintain bugfix metadata within an EBS instance. Its header identifies it as an AFOAMUMSLDS member, indicating that it belongs to the Applications Technology patch and maintenance infrastructure rather than to any functional application module.

The package operates on the FND_UMS_* family of tables, which store information about bugfixes, patch sets, internal fixes, individual files, file versions, and the relationships between fixes. Through this package, metadata describing a bugfix — including its classification, prerequisite and replacement relationships, and constituent file versions — is uploaded into the EBS database so that it can subsequently be queried and applied by the patching tools.

The DSL constants declared in the package specification are central to its purpose. Bugfix types are enumerated as BUGFIX, PATCHSET, and INTERNAL. Relationship types include PREREQS, INDIRECTLY_PREREQS, INCLUDES, INDIRECTLY_INCLUDES, REPLACED_BY, REPLACES, and REPLACED_BY_FIRST_NON_OBSOLETE. Download modes range from NONE and FILES_ONLY through REPLACEMENTS_ONLY, PREREQS_ONLY, LINKS_ONLY, and the combined variants such as LINKS_FILES. The value LINKS_FILES, referenced by many users searching this object, is the constant DL_MODE_LINKS_FILES, a download mode expressed as the literal 'LINKS_FILES'. It instructs the loader to process both link relationships and the associated files for a given bugfix during download.

Key Procedures and Functions

• SET_DEBUGGING — Sets the internal debug flag (for example 'Y' or 'N') that controls diagnostic output emitted by the loading routines, primarily for troubleshooting failed or partial uploads.
• UP_FND_UMS_BUGFIX — Uploads a single bugfix header record into the UMS repository, establishing its type and primary attributes.
• UP_FND_UMS_BUGFIX_FILE — Uploads file-level metadata associated with a bugfix, populating the file and file-version information that defines what a fix delivers.
• UP_FND_UMS_BUGFIX_RELATIONSHIP — Uploads a relationship between two bugfixes, using the relationship-type constants (PREREQS, INCLUDES, REPLACES, and so on) to record dependency and replacement structure.
• UP_FND_UMS_ONE_BUGFIX — Coordinates the upload of one complete bugfix, invoking the header, file, and relationship loaders as required.
• UP_FND_UMS_BUGFIXES — Drives the upload of a set of bugfixes, serving as the primary entry point for bulk metadata loading.
• NEWLINE — A formatting helper used when assembling textual output or debug messages.

Tables Accessed

• FND_UMS_BUGFIXES — Stores bugfix header records and their types.
• FND_UMS_BUGFIX_RELATIONSHIPS — Stores dependency and replacement links between fixes.
• FND_UMS_FILES and FND_UMS_FILE_VERSIONS — Store file definitions and their versions for uploaded fixes.
• FND_UMS_BUGFIX_FILE_VERSIONS — Associates bugfixes with specific file versions.
• FND_ORACLE_USERID and FND_PRODUCT_INSTALLATIONS — Provide Oracle schema credentials and installed product context.
• DBA_TABLES, DBMS_LOCK, DBMS_UTILITY, and DUAL — Used for existence checks, serialization, and utility services.

Usage Notes

FND_OAM_UMS_LOADER is an internal AD utility. It is invoked by Oracle Update Manager and related patching components rather than by end users, and no other documented packages reference it. The DL_MODE_LINKS_FILES constant governs the download path where both link definitions and files are processed. Custom code should not call these routines directly; the documented interface is intended solely for the supported patching infrastructure in EBS 12.1.1 and 12.2.2.