Search Results fii_non_dbi_time_c

Overview

FII_NON_DBI_TIME_C is a small, single-purpose PL/SQL package owned by the APPS schema and classified under the API classification type OTHER in Oracle E-Business Suite. Its name indicates that it supports time and calendar-related processing for the FII (Financial Intelligence/Intelligence) product family, and the "_C" suffix conventionally designates it as a specification-only package body with its implementation stored in a corresponding body unit. The package is not part of the standard DBI (Daily Business Intelligence) offering; the "NON_DBI" prefix distinguishes it as a supplementary utility used outside the core DBI intelligence schema. Its principal business function is to load and maintain calendar name information that downstream intelligence and reporting logic relies upon to resolve period and calendar references. The $Header line (FIICMT2S.pls, version 120.1, dated 2005/10/30) confirms the package has been stable since the early 11i lineage and carries forward into 12.1.1 and 12.2.2 with only incremental changes, which is typical for low-level reference-data utilities.

Key Procedures and Functions

The documented interface exposes exactly one procedure:

• LOAD_CAL_NAME — Loads calendar name data into the FII time calendar name table. It is the sole entry point of the package and functions as a data-seeding or refresh routine rather than a generalized API. No parameter list is documented in the ETRM metadata and none should be assumed; callers invoke it by name without arguments as documented.

Because the package specification contains only this one procedure and no functions, its responsibility is deliberately narrow: populating or re-populating the calendar name reference set used by FII time intelligence objects.

Tables Accessed

The metadata records two tables referenced through APPS synonyms:

• FII_TIME_CAL_NAME — the target table for the calendar name data loaded by LOAD_CAL_NAME. This is the primary write target of the package and holds the calendar-to-name mappings consumed by FII time-based reporting.
• GL_PERIODS — the General Ledger period definition table, read as the source of authoritative calendar and period information. This confirms that the package derives its calendar names from the standard GL accounting calendar rather than from an independent definition, ensuring consistency with the enterprise calendar configuration.

The read of GL_PERIODS and write to FII_TIME_CAL_NAME form a straightforward extract-and-load pattern with no documented dependency on staging or interface tables.

Usage Notes

FII_NON_DBI_TIME_C is referenced by one other package, indicating it occupies a supporting role in a small dependency chain rather than being called directly by forms or concurrent programs at the application layer. In practice, LOAD_CAL_NAME is invoked during setup or after changes to the GL accounting calendar, so that the FII time calendar name table reflects current period definitions. Typical invocation points include initialization or setup routines in the FII intelligence flow and, potentially, custom setup scripts executed by an administrator following calendar maintenance. Because the package is small, stable, and synchronized from GL_PERIODS, it carries minimal risk if re-executed, though repeated invocation should be expected to refresh rather than duplicate reference rows. Implementers extending FII time reporting should treat it as an internal utility: query FII_TIME_CAL_NAME for calendar names, and call LOAD_CAL_NAME only when the underlying GL calendar definitions have changed.