Search Results fii_fa_cat_c




Overview
Explore in AI Chat

Overview

FII_FA_CAT_C is a concurrent program owned by the Financial Intelligence (FII) product family within Oracle E-Business Suite. Its user-facing name is Update Assets Category Dimension, and its documented description is identically "Update Asset Category Dimension." The program is registered as enabled in the reference metadata associated with release 12.2.2. Its functional purpose is to populate or refresh the asset category dimension used by Financial Intelligence analytics, thereby ensuring that fixed asset category hierarchies and attributes are consistently represented within the FII reporting and dimensional model. The FII module is identified in the supplied ETRM extract as Obsolete, which is an important consideration: the program remains enabled in the environment, but it belongs to a product line that Oracle has designated as end-of-life. This status affects support, patching, and upgrade planning, even though the executable continues to be listed as active.

Execution Details

The documented execution attributes are as follows:

  • Product: FII - Financial Intelligence (Obsolete), Enabled: Yes
  • Execution Method: PL/SQL Stored Procedure
  • Argument Method: Standard
  • Executable: FII_FA_CAT_C
  • Execution Filename: FII_FA_CAT_C.Main
  • Subroutine Name: Not specified in the documented metadata

Because the execution method is PL/SQL Stored Procedure with the entry point FII_FA_CAT_C.Main, the program is invoked as a packaged procedure rather than as a host-language executable or Java class. The Standard argument method indicates that arguments, where defined, are presented to the user through the standard Oracle Applications concurrent program parameter window and are passed positionally to the stored procedure.

How to Run

The program is submitted in the conventional manner through the Submit Requests (SRS) window, accessible from the Requests > Run path in the EBS navigator, or through the Concurrent > Program > Define and related administrative flows when the program definition itself must be inspected. After selecting the request name "Update Assets Category Dimension," the user chooses a printer, layout, and any defined parameters, then submits the request. The supplied metadata documents no specific parameters; with a Standard argument method and no listed arguments, the program is typically executed without mandatory user input, operating against the current asset category setup for the appropriate operating unit or ledger context. Users should verify completion in the Requests window and review the concurrent request log and output file, since dimension refresh programs commonly report processing counts and any rows that could not be resolved. In multiorg environments, responsibility and MO: Operating Unit or MO: Security Profile settings determine the data visible to the run.

Related Objects

The program operates on data originating in Oracle Assets, principally the asset categories and their associated descriptive and hierarchical attributes. While the ETRM excerpt does not enumerate interface tables or APIs, the program is logically associated with the fixed asset category tables and with the FII dimensional and staging structures that consume category information. Related objects commonly encountered alongside it include the Oracle Assets category definition forms, the FII dimensional load and validation programs, and the standard concurrent manager infrastructure that governs submission and output. Reports and dashboards built on the FII asset category dimension depend on the successful completion of this program.

Considerations for 12.1.1 and 12.2.2

The metadata is consistent across the 12.1.1 and 12.2.2 references supplied, indicating that the program definition is essentially unchanged between those releases. Because the owning product is marked Obsolete, organizations should avoid building new dependencies on this program and should plan migration to a supported reporting or dimensional solution as part of upgrade and rationalization efforts. Existing submissions should continue to function until the product is fully removed from the environment.