Results for “fii_ar_trx_dist_f_d”

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

Overview

The package body APPS.FII_AR_TRX_DIST_F_D is a utility package within the Oracle E-Business Suite Financial Intelligence (FII) / Enterprise Data Warehouse (EDW) integration layer. Its name, combining the FII prefix with the AR_TRX_DIST (Accounts Receivable Transaction Distributions) and the _F_D suffix, identifies it as a fact-table staging and extraction utility for the Receivables transaction distribution fact table used by the FII analytical schema. In the Oracle EBS 12.1.1 and 12.2.2 architectures, FII packages support the Oracle Financials Intelligence / Daily Business Intelligence (DBI) and related EDW extract flows by staging transactional data from the OLTP (Online Transaction Processing) EBS schema into the warehouse. This particular package is responsible for creating and populating temporary tables that hold AR transaction distribution records prior to loading into the EDW fact structures.

Key Procedures and Functions

The ETRM metadata documents eight procedures within the package body:

• INIT — Initializes the package, performing setup and prerequisite declarations required before the table-building and data-population steps execute.
• DROP_TABLE — Removes the temporary tables created by earlier runs, ensuring a clean starting state and preventing stale data from contaminating a new extraction cycle.
• CREATE_OLTP_TRX_TMP_TABLE — Creates the temporary table that holds Accounts Receivable transaction distribution data sourced from the OLTP schema.
• POPULATE_OLTP_TRX_TMP_TABLE — Populates that OLTP temporary table with the extracted AR transaction distribution rows.
• CREATE_EDW_TRX_TMP_TABLE — Creates the temporary table that holds the transformed data destined for the EDW fact layer.
• FIND_EXTRA_TRX_EDW — Identifies transactions present in the EDW that lack a corresponding OLTP source record, typically a reconciliation or exception-detection step.
• COUNT_EXTRA_TRX_EDW — Counts the extra or orphaned EDW transactions identified by the preceding procedure, often for logging and validation.
• INSERT_STAGING — Inserts the reconciled and transformed data into the staging table used by subsequent EDW load processes.

Tables Accessed

The package references the following objects, resolved through APPS synonyms and the SYS STANDARD package:

• EDW_SOURCE_INSTANCES — Consulted to resolve the source instance context for the extraction, determining which EBS instance the AR data is drawn from.
• ALL_TABLES — Queried to check for the existence of the temporary tables before creating or dropping them, enabling idempotent execution.
• STANDARD — The SYS package providing built-in PL/SQL functionality used for dynamic operations such as drop or create table.
• FII_AR_TRX_DIST_F_D and FND_INSTALLATION — Referenced for installation and self-referential dependency resolution.

Usage Notes

This package is invoked as part of the FII/EDW data extraction and load cycle rather than interactively from an EBS form. In practice it is driven by concurrent programs or scheduled extract jobs that stage AR transaction distribution data for warehouse loading. It is not referenced by any other database object, confirming it is a terminal utility invoked at the top of its dependency chain. Because it manipulates temporary staging tables with dynamic DDL, DBAs should invoke it only during maintenance windows or through the standard FII extract scheduling framework. The package is validated as VALID in the APPS schema and is classified under API type OTHER in the ETRM metadata for release 12.1.1, with equivalent behavior expected in 12.2.2 where FII fact tables and EDW sourcing remain fundamentally unchanged.