Search Results jdr_mds_internal




Overview
Explore in AI Chat

Overview

JDR_MDS_INTERNAL is a private PL/SQL package in the APPS schema that provides the internal repository services underlying the Oracle E-Business Suite XML Publisher and Oracle Reports metadata repository. The "JDR" prefix identifies the Java Definition Repository lineage (JDK-based repository), and "MDS" denotes the Metadata Services layer that persists document and package definitions used by the XML Publisher data model, template, and report definition objects. The package is tightly coupled to the ETRM (E-Business Suite Technical Reference Manual) documented object set for release 12.1.1 and 12.2.2.

The package is declared with AUTHID CURRENT_USER, meaning all SQL statements execute with the privileges of the invoking user rather than the defining user. The header indicates a ship-home component (noship) and a lock wait timeout constant, MAX_SECONDS_TO_WAIT_FOR_LOCK, set to 10 seconds, reflecting the package's role in concurrency-sensitive repository maintenance.

Key Procedures and Functions

The ETRM metadata documents 19 callable units. The most significant are:

  • CREATEPATH — two overloaded functions. One creates a jdr_paths entry from a fully qualified path name for a document or package, creating the package if it does not exist. The other creates a child entry using a pathname, owner ID, and path sequence. Both accept username and docType ('PACKAGE' or 'DOCUMENT') and return the created path ID.
  • DELETEDOCUMENT and DROPDOCUMENT — remove document definitions and their path registrations.
  • EXPORTDOCUMENTASXML and EXPORTXLIFFDOCUMENT — serialize repository content to XML and to XLIFF localization format respectively.
  • GETDOCUMENTID, GETDOCUMENTIDS, GETDOCUMENTNAME, GETPACKAGEDOCUMENT — retrieval functions used to resolve identifiers, enumerate documents, and load package-level documents.
  • GETMINJRADVERSION and GETREPOSITORYVERSION — return version metadata used for compatibility checks.
  • LOCKDOCUMENT — acquires a repository lock, bounded by MAX_SECONDS_TO_WAIT_FOR_LOCK.
  • PREPAREDOCUMENTFORINSERT — stages a document prior to persistence.
  • REFACTOR and REMOVEDANGLINGREFERENCES — maintenance routines that repair repository structure and eliminate orphaned references.

Tables Accessed

The package reads and writes the core repository tables through APPS synonyms:

  • JDR_PATHS — the primary path registry; CREATEPATH inserts here and references PATH_OWNER_DOCID and PATH_SEQ columns.
  • JDR_ATTRIBUTES and JDR_ATTRIBUTES_TRANS — attribute storage, including the translated attribute set used by EXPORTXLIFFDOCUMENT.
  • JDR_COMPONENTS — component-level records linked to documents and packages.
  • JDR_DOCUMENT_ID_S — the sequence supplying document IDs returned by CREATEPATH.
  • DUAL — used for scalar and version queries.
  • PLITBLM — the PL/SQL integer table type used for bulk collections within the package.

Usage Notes

JDR_MDS_INTERNAL is not intended for direct invocation by end users or by customer extensions. It is invoked internally by XML Publisher and Oracle Reports runtime services, typically during template upload, report definition creation, repository migration, and XLIFF translation export. The package is referenced by four other packages in the APPS schema, which act as the public-facing API surface (for example, the JDR_MDS public wrapper package).

Because the package uses AUTHID CURRENT_USER, any custom code that calls it must run with sufficient privileges on the JDR_* tables. Customization should be performed through the supported public JDR_MDS APIs rather than by invoking JDR_MDS_INTERNAL directly, since the internal package is subject to change between patch levels and is shipped without direct support. The 10-second lock timeout means concurrent repository operations may return lock errors under contention, and callers should anticipate retry handling.