Search Results get_directory_name

Overview

APPS.DDR_ETL_UTIL_PKG is a utility package body belonging to the DDR product schema within Oracle E-Business Suite. Its header revision ($Header: ddruetlb.pls 120.5.12010000.2 2008/09/13) indicates it is a long-standing component carried forward across EBS 12.1.1 and 12.2.2. The package implements generic extract-transform-load (ETL) plumbing used by the DDR application to move data between the database and flat files, to manage materialized view refresh cycles, and to capture and replay error information. It is classified as an "OTHER" API rather than a public, supported interface, meaning it is intended primarily for internal DDR use and for extension by DDR-aware custom code.

The package declares package-level constants that reflect its file-oriented design, including a delimiter character (defaulting to a space, with commented alternatives for tilde and tab), an owner name of 'DDR', a maximum column value size, and a maximum line size suitable for UTL_FILE operations. These globals govern how delimited records are parsed and written.

Key Procedures and Functions

• GET_MV_REFRESH_JOB_ID — Retrieves the identifier of the materialized view refresh job, used to correlate submission and logging.
• REFRESH_MV — Performs the materialized view refresh, typically delegating to DBMS_MVIEW.
• REFRESH_MV_ODI — Variant of the refresh routine targeted at the ODI (Oracle Data Integrator) refresh path.
• TRUNCATE_MV_LOG — Clears the materialized view refresh log table.
• TRUNCATE_MV_LOG_WRP — Wrapper around the truncate operation, providing an alternative invocation entry point.
• EXPORT_DATA — Writes table contents to a flat file using the package delimiter and line-size conventions.
• IMPORT_DATA — Reads delimited flat-file records and loads them into the target table.
• TRANSFER_DATA — Orchestrates a combined export/import or source-to-target movement of records.
• EXPORT_ERROR — Serializes error information for external storage or transmission.
• IMPORT_ERROR — Reconstructs error information previously exported.

The declaration section also contains private helpers, notably RAISE_ERROR, which raises application error -20001, VALIDATE_PARAMETERS, which verifies table and file names against ALL_TABLES, and the overloaded IS_STRING and IS_NUMBER predicates used to classify column data types during dynamic processing.

Tables Accessed

• DDR_U_MV_RFRSH_LOG — Log of materialized view refresh activity; written by refresh routines and cleared by TRUNCATE_MV_LOG.
• DDR_U_MV_RFRSH_SEQ — Sequence source for refresh job identifiers.
• ALL_TABLES — Used by VALIDATE_PARAMETERS to confirm the target table exists and is owned by DDR.
• ALL_TAB_COLUMNS — Provides column metadata for type-sensitive import/export handling.
• DBA_DEPENDENCIES — Consulted for dependency resolution during refresh or validation.
• DUAL — Standard single-row selection for scalar values.

Program units from DBMS_MVIEW, DBMS_SQL, UTL_FILE, and PLITBLM are referenced, providing the refresh, dynamic SQL, file I/O, and PL/SQL table capabilities the package depends upon.

Usage Notes

Because the package is an internal DDR utility, it is normally invoked from DDR concurrent programs, from other DDR packages, or from custom PL/SQL that requires delimited file interchange between the EBS database and the operating-system file system. UTL_FILE directory objects and database directory privileges must be configured before EXPORT_DATA, IMPORT_DATA, or TRANSFER_DATA are called. The refresh entry points are intended to be scheduled as concurrent requests or invoked programmatically by the DDR scheduling layer. ETRM records no other packages referencing this package, confirming it sits near the leaf of the DDR call hierarchy and is not a shared EBS platform utility. Developers extending DDR functionality may call these procedures directly, but should not assume support coverage, as the package is documented as an OTHER-classification API.