Search Results fii_ar_customer_dimension_pkg




Overview
Explore in AI Chat

Overview

APPS.FII_AR_CUSTOMER_DIMENSION_PKG is a PL/SQL package that supports the Oracle E-Business Suite Financial Intelligence / Enterprise Performance Foundation customer dimension. In the EBS 12.1.1 and 12.2.2 environments, this package implements the customer dimension maintenance program for the Receivables (AR) source system, building and refreshing the customer hierarchy and customer account data that downstream analytical and reporting applications rely upon. Its two entry points correspond to the two standard maintenance modes: a full population run and a change-driven refresh run. The package resides in the APPS schema and is classified as an OTHER API, meaning it is not a public, externally supported interface but rather a program unit invoked by the dimension maintenance infrastructure itself.

Key Procedures and Functions

  • Init_Load — This is the main procedure of the customer dimension maintenance program for the initial load. It receives the standard concurrent program error buffer and return code outputs, initializes all necessary package-level and program-level variables, and then calls the appropriate internal routines to perform the full initial population of the customer dimension. Because it is the entry point documented specifically for the initial load, it is the procedure located by searches for "init_load".
  • Incre_Update — This is the main procedure of the customer dimension maintenance program for the incremental update. Like Init_Load, it accepts the standard error buffer and return code outputs and initializes all required variables before invoking the appropriate processing routines. Its scope is the refresh of the dimension based on changes recorded since the last successful run, rather than a complete rebuild.

No additional public functions are documented in the package specification; both procedures share the same two-argument concurrent-program signature (errbuf and retcode).

Tables Accessed

The package operates against a set of global temporary tables and permanent dimension tables in the APPS schema. The temporary tables include FII_AR_CACCTS_DELTA_GT, FII_AR_CACCTS_D_GT, FII_AR_CACCTS_TMP_GT, FII_AR_CUST_HIER_D_GT, FII_AR_CUST_HIER_TMP_GT, FII_AR_CUST_HIER_UI_GT, FII_AR_CUST_LNODES_GT, FII_AR_CUST_RLNS_GT, FII_AR_PARTIES_DELTA_GT, FII_AR_PARTIES_LEVEL1_GT, FII_AR_PARTIES_LEVEL2_GT, and FII_AR_TOP_TO_SOURCE_GT. These staging structures hold extracted Receivables customer accounts, parties, party hierarchies (child and rollup nodes), delta records, level-by-level party extractions, and the mapping of hierarchy top nodes back to their source records. The permanent tables written or maintained are FII_CUST_ACCOUNTS, FII_CUSTOMER_HIERARCHIES, and FII_CHANGE_LOG. FII_CUST_ACCOUNTS and FII_CUSTOMER_HIERARCHIES represent the materialized customer dimension, while FII_CHANGE_LOG records change activity used by the incremental path.

Usage Notes

In practice, FII_AR_CUSTOMER_DIMENSION_PKG is invoked through concurrent programs that maintain the customer dimension, with Init_Load used for the initial full load and Incre_Update used for subsequent periodic refreshes. The value of the errbuf and retcode parameters confirms its design as a concurrent-program-compatible entry point; parameter metadata beyond these standard outputs is not documented in the specification excerpt. Because the package is classified as OTHER and is referenced by zero other packages, it is not intended for direct invocation from forms or custom code. Customers and implementers should treat it as internal infrastructure and rely on the supported concurrent program and dimension maintenance flows rather than calling Init_Load or Incre_Update directly, since dependencies on the documented global temporary tables and the FII_CUST_ACCOUNTS and FII_CUSTOMER_HIERARCHIES structures are subject to change across releases.