Search Results fii_fa_cat_dimensions_s

Overview

FII_FA_CAT_C is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM documentation as an "OTHER" API. Its documented purpose in Release 12.1.1 and 12.2.2 is the maintenance of fixed asset category mappings against the Oracle Business Intelligence / Enterprise Performance Management asset analytics schema. Specifically, the package coordinates the creation and synchronisation of FA category rows into the FII_FA_CAT_DIMENSIONS family of tables, which serve as the warehouse-side dimension store that feeds asset category reporting in the FII (Financial Intelligence for Assets) subject areas. Entries written here allow the transactional EBS asset register to be presented consistently against the analytical category dimension, including the segment structure defined for the asset key flexfield.

Key Procedures and Functions

• NEW_CAT_IN_FA — The primary routine that handles a newly created (or changed) asset category from the FA application side. It determines which category rows require propagation into the FII category dimension tables and performs the associated insert or update logic, including derivation of the flexfield segment values associated with the category.
• MAIN — The driver entry point for the concurrent or batch execution of the package. It governs the overall synchronisation flow, orchestrates the processing performed by the package, and manages commit and error handling via the shared FII utility and exception-checking routines.

Only these two procedures are formally documented. The package body is marked VALID, indicating it compiles cleanly against the referenced dependencies in the target release.

Tables Accessed

• FA_CATEGORIES and FA_CATEGORIES_B — The base and translation tables of the asset category entity; read to identify new or modified categories and their descriptive attributes.
• FA_SYSTEM_CONTROLS — Used to determine whether Oracle Assets is installed and configured in the current operating unit context.
• FII_FA_CAT_DIMENSIONS, FII_FA_CAT_DIMENSIONS_S, FII_FA_CAT_DIMENSIONS_S1 — The analytical category dimension and its sequences; the primary targets written by this package and the objects surfaced by the searched term "fii_fa_cat_dimensions_s".
• FII_FA_CAT_SEGMENTS — Stores the segment-level breakdown of each category for the FII dimension.
• FII_CHANGE_LOG — Tracks category maintenance events for downstream incremental load processing.
• FND_ID_FLEX_SEGMENTS, FND_ID_FLEX_STRUCTURES_TL, FND_SEGMENT_ATTRIBUTE_VALUES, FND_FLEX_VALUE_SETS, FND_FLEX_VALIDATION_TABLES — Read to resolve the asset key flexfield structure, segment labels, and value-set validation rules.
• FND_CONCURRENT, FND_PROFILE, FND_GLOBAL, FND_INSTALLATION — Provide concurrent request context, profile option values, session identity, and installation status.
• DUAL, PLITBLM — Standard control and PL/SQL table plumbing.

Usage Notes

FII_FA_CAT_C is not called from a standard Oracle Assets form path; it is an internal integration package intended for the FII reporting layer. In practice it is invoked through the concurrent program associated with the MAIN procedure, scheduled whenever asset categories are added or amended and the analytical dimension must be refreshed, or invoked programmatically by other FII packages (the metadata notes it is referenced by one other package). Customers and partners extending the FII asset analytics line should treat the package as an internal API: direct invocation from custom code is possible but carries regression risk across 12.1.1 to 12.2.2 upgrades because the package depends on the FII_FA_CAT_DIMENSIONS_S sequence and the segment structures of the asset key flexfield. Test in a cloned environment before re-running outside the delivered concurrent schedule.