Search Results hr_dm_aol_files_v




Overview
Explore in AI Chat

Overview

HR_DM_AOL_FILES_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, registered under the PER – Human Resources product. It presents metadata about each AOL loader, configuration file, or parameter set consumed during the AOL download phase of the HR DataMart (HR_DM) extraction process, together with the filename assigned to the resulting output file. In Oracle EBS 12.1.1 and 12.2.2, the view is a reporting and integration surface for the HR DataMart loader framework, allowing DBAs and technical consultants to see exactly which loader configuration and parameters were applied to each extraction run without querying the encoded staging table directly.

The view does not store data itself. It is a projection over the HR DataMart export/import staging table, filtering the rows that describe AOL file definitions and pivoting the generic P_VALUE attribute columns into named, business-friendly columns. Status is documented as VALID.

Underlying Base Objects

The view is defined over a single base object, HR_DM_EXP_IMPS (referenced as a SYNONYM in the APPS schema). The defining query is:

SELECT EXP_IMP_ID, TABLE_NAME,
       PVAL001 APPLICATION_ID,
       PVAL002 LOADER_NAME,
       PVAL003 LOADER_CONC_PROGRAM,
       PVAL004 LOADER_CONFIG_FILE,
       PVAL005 LOADER_APPLICATION,
       PVAL006 PARAMETER1,
       ... PVAL015 PARAMETER10,
       PVAL016 FILENAME
FROM HR_DM_EXP_IMPS
WHERE TABLE_NAME = 'HR_DM_AOL_FILES_V';

The base table HR_DM_EXP_IMPS acts as a generic, denormalized store for DataMart export/import definitions. Configuration values are held in a set of generic PVAL001 through PVAL016 columns. The view self-selects rows where TABLE_NAME equals its own name, effectively acting as a discriminator for AOL file records. Because it is a simple single-table view, it inherits the base table's read consistency; no indexing or aggregation is introduced by the view itself.

Key Columns

  • EXP_IMP_ID – Primary identifier (export/import ID) of the AOL file record; the join key back to the base table.
  • TABLE_NAME – Discriminator column; always equals 'HR_DM_AOL_FILES_V' for rows returned by this view.
  • APPLICATION_ID – Maps from PVAL001; the application owning the AOL loader.
  • LOADER_NAME – Maps from PVAL002; the AOL loader entry point used.
  • LOADER_CONC_PROGRAM – Maps from PVAL003; the concurrent program that invokes the loader.
  • LOADER_CONFIG_FILE – Maps from PVAL004; the configuration file driving the loader.
  • LOADER_APPLICATION – Maps from PVAL005; the application context for the loader.
  • PARAMETER1 … PARAMETER10 – Map from PVAL006 through PVAL015; the parameter set passed to the loader.
  • FILENAME – Maps from PVAL016; the output file generated during the AOL download phase.

Common Use Cases and Queries

The view is used to audit and troubleshoot HR DataMart AOL download configuration, verify the parameter set applied to a given loader run, and document loader-to-file mappings.

  • List all AOL loader file definitions: SELECT loader_name, loader_conc_program, filename FROM hr_dm_aol_files_v;
  • Find the configuration file for a specific loader: SELECT loader_config_file, filename FROM hr_dm_aol_files_v WHERE loader_name = :loader;
  • Inspect parameters applied to a run: SELECT exp_imp_id, parameter1, parameter2, parameter3 FROM hr_dm_aol_files_v WHERE application_id = :app_id;
  • Trace an output file back to its loader: SELECT loader_name, loader_application FROM hr_dm_aol_files_v WHERE filename = :fname;
  • Join to the base table for full staging context: SELECT v.*, e.* FROM hr_dm_aol_files_v v, hr_dm_exp_imps e WHERE v.exp_imp_id = e.exp_imp_id;

Because the view is read-only and unfiltered beyond the discriminator, all queries execute efficiently against the base table and are safe for concurrent reporting use.