Results for “post_copy_function_name”

30 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PQH_COPY_ENTITY_FUNCTIONS is a configuration table in the Oracle E-Business Suite HR schema, owned by the Public Sector HR (PQH) product. It defines the context-sensitive function hooks that the copy-entity framework invokes when records are copied between entities. The table documents, per table route and per context, which pre-copy, copy, and post-copy database functions should be executed. Because the copy-entity mechanism must behave differently depending on the entity and the timing of the operation, this table acts as a registry of callable program units keyed by route and context.

The heuristic Data Vault classification mined from the foreign key structure is link. This reflects the fact that the table primarily serves to associate two other tables — PQH_TABLE_ROUTE and PQH_COPY_ENTITY_CONTEXTS — and to hold the function assignments that result from that association. It should be regarded as a modeling suggestion rather than a mandated classification, and analysts designing downstream integration models may treat it as either a link or a satellite depending on whether the function-name attributes are considered descriptive or associative. The object is reported as VALID under the HR schema in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The documented physical schema comprises 14 columns. The most significant are summarized below.

Common Use Cases and Queries

The primary use case is diagnosing copy behavior: identifying which functions run for a given table route and context. A typical query joining the function registry to its parent route table would be:

  • SELECT cef.COPY_ENTITY_FUNCTION_ID, cef.TABLE_ROUTE_ID, cef.CONTEXT, cef.FUNCTION_TYPE_CD, cef.PRE_COPY_FUNCTION_NAME, cef.COPY_FUNCTION_NAME, cef.POST_COPY_FUNCTION_NAME FROM HR.PQH_COPY_ENTITY_FUNCTIONS cef WHERE cef.TABLE_ROUTE_ID = :route_id;
  • Enumerating all contexts configured for a specific function type: WHERE cef.FUNCTION_TYPE_CD = :type_cd.
  • Auditing recently changed configurations using LAST_UPDATE_DATE and LAST_UPDATED_BY to detect unauthorized function substitutions.

Reporting scenarios include configuration matrices showing route/context coverage, gap analysis to find routes lacking pre- or post-copy functions, and impact analysis before a function name is changed or deprecated.

Related Objects

The following objects are the most significant dependencies, based on the documented foreign keys and the surrounding PQH copy-entity framework.

  • PQH_TABLE_ROUTE — referenced by PQH_COPY_ENTITY_FUNCTIONS.TABLE_ROUTE_ID; defines the copy route itself.
  • PQH_COPY_ENTITY_CONTEXTS — referenced by PQH_COPY_ENTITY_FUNCTIONS.CONTEXT; defines valid contexts.
  • PQH_COPY_ENTITY_FUNCTIONS_PK — the primary key index on COPY_ENTITY_FUNCTION_ID and ZD_EDITION_NAME.
  • The broader PQH copy-entity configuration tables and the PL/SQL packages that read this registry at runtime, which resolve the named functions and invoke them during copy processing.