Search Results upload_factor_table1_interface

Overview

FEM_WEBADI_FACT_TAB_UTILS_PVT is a private PL/SQL package in the APPS schema belonging to Oracle Enterprise Performance Foundation / Enterprise Tax and Regulatory Management (ETRM), the profitability and cost management foundation of Oracle E-Business Suite. The package supports the WebADI-driven upload of factor table data into the Profitability Manager (FEM) repository. A factor table defines the matching and distribution relationships used to allocate, assign, or distribute amounts across dimension members, hierarchies, and levels for a specific rule and version. The procedures in this package accept the flat, denormalized payload delivered from a WebADI spreadsheet interface — including rule metadata, versioning attributes, matching dimensions, hierarchies, hierarchy versions, levels, hierarchy relations, distribution dimension, and an amount — and transform that payload into the normalized ETRM object catalog and factor table structures consumed by the profitability engine.

The package is classified as PVT (private), meaning it is not part of the supported public API surface. It is intended for internal use by the ETRM WebADI integration layer rather than by customer extensions.

Key Procedures and Functions

• UPLOAD_FACTOR_TABLE1_INTERFACE — Processes a single factor table row from the WebADI interface. It receives the rule name, folder name, rule description, version name, start and end dates, version description, factor type, up to three sets of matching dimension/hierarchy/hierarchy version/level/hierarchy relation attributes, the distribution dimension, force-to-hundred flag, object access code, matching dimension members, distribution dimension member, and amount. This is the procedure directly associated with the search term "upload_factor_table1_interface".
• UPLOAD_FACTOR_TABLE2_INTERFACE — The analogous handler for factor table type 2, using a comparable attribute set excluding the distribution dimension. It drives creation or update of the corresponding rule and factor table definitions.
• UPLOAD_FACTOR_TABLE3_INTERFACE — The handler for factor table type 3, following the same upload pattern for its respective structure.
• POPULATE_RULE_DETAILS — Builds and persists the rule-level metadata (rule, version, folder, description, effective dates) required before factor table dimensions and factors can be written.
• POPULATE_FACTOR_TABLE_DIMS — Derives and inserts the dimension member and hierarchy relationships that constitute each factor table row, resolving members against the object catalog for the identified dimensions.

Tables Accessed

• FEM_FACTOR_TABLES / FEM_FACTOR_TABLE_DIMS / FEM_FACTOR_TABLE_FCTRS — Store the factor table headers, dimension relationship rows, and factor values loaded by the upload.
• FEM_FACTORS_ROW_NUM_SEQ — Sequence supplying row numbers for factor table rows.
• FEM_OBJECT_CATALOG_B / FEM_OBJECT_CATALOG_TL — Catalog of rule and object definitions, used to resolve the rule and folder referenced by the upload.
• FEM_OBJECT_DEFINITION_B / FEM_OBJECT_DEFINITION_TL / FEM_OBJECT_DEFINITION_ID_SEQ / FEM_OBJECT_ID_SEQ — Hold the definition metadata and identifiers for the rules, versions, and dimensions identified during population.
• FND_LANGUAGES / DUAL — Utilized for language-code resolution in translated tables and for simple expression evaluation.

Usage Notes

This package is invoked by the ETRM WebADI upload integration when a user submits a factor table spreadsheet. Because the procedures are declared in a private package and are documented as PVT, they are not published as supported APIs and should not be called directly from custom code. Any customization involving factor table uploads should use the supported WebADI interface definitions and concurrent processing supplied by ETRM. The package is referenced by zero other packages in the documented metadata, confirming its role as a leaf-level utility within the WebADI upload chain rather than a shared API dependency.