Search Results get_demand_class_fk




Overview
Explore in AI Chat

Overview

EDW_DEMAND_CLASS_PKG is an APPS-owned PL/SQL package within the Oracle E-Business Suite data warehousing layer, associated with the Enterprise Data Warehouse (EDW) demand classification utilities. Its classification in the ETRM repository is OTHER, indicating that it is not one of the seeded public APIs (such as those in the INV, OE, or WSH schemas) but rather an internal helper or utility package used by the EDW extraction and transformation components.

The package exists to resolve or derive a demand class foreign key value — a mapping of a demand class name or code to its surrogate key within the EDW local instance environment. Demand class is a core Oracle EBS construct used in Order Management, Advanced Pricing, and shipping to segment demand by source, channel, priority tier, or planning group. The EDW layer requires deterministic key resolution to join transactional facts to demand class dimensions, and this package encapsulates that logic so that multiple EDW loaders can call a single, consistent routine.

Key Procedures and Functions

The documented interface consists of one callable unit:

  • GET_DEMAND_CLASS_FK — Returns the foreign key (surrogate identifier) for a demand class as represented in the EDW local instance. It is the sole documented entry point in the package, indicating a narrowly scoped, single-purpose interface rather than a broad transformation API. Callers use the returned key to populate fact or dimension columns in EDW tables that reference demand class, avoiding hard-coded identifier logic in individual ETL routines.

Specific parameter lists are not documented in the ETRM metadata and should not be assumed. Implementers inspecting the package body will find the definitive signature, but the semantic contract is key resolution from demand class to its EDW foreign key.

Tables Accessed

The package references the following table via its APPS synonym:

  • EDW_LOCAL_INSTANCE — The EDW local instance registry. This table stores instance-specific configuration and context required to map source EBS entities to their warehouse-side keys. Access to this table allows the package to resolve the correct demand class identifier for the local warehouse instance being loaded, ensuring that multi-instance or multi-organization EDW deployments do not collide on key values.

The ETRM dependency list also shows the package referencing SYS.STANDARD, which reflects PL/SQL built-in type and runtime dependencies rather than application data access. No other application tables are documented as referenced.

Usage Notes

The package is not referenced by any other documented package (the "referenced by 0 other packages" note), which is consistent with an EDW-owned utility invoked directly by warehouse load logic rather than a shared application-layer API. Because its status is VALID and it resides in APPS, it is compiled and accessible to any APPS-schema session with EXECUTE privilege.

Typical invocation patterns include:

  • PL/SQL blocks and procedures inside EDW staging or fact-loading routines that must derive a demand class key from source order or pricing data.
  • Custom concurrent programs or data extract scripts in customer EBS 12.1.1 and 12.2.2 environments that build or refresh warehouse demand class references.
  • Direct ad hoc calls during implementation, migration, or reconciliation of demand class dimension data.

Because the function is a key-resolver rather than a transactional API, it is not invoked interactively through Oracle Forms; callers are expected to be batch ETL code or diagnostic scripts. Support and upgrade considerations are minimal: as an internal EDW utility rather than a seeded public API, the package is used at implementer discretion, and its behavior should be validated against the specific EDW schema version installed in the target environment.