Search Results upload_factor_table2_interface

Overview

FEM_WEBADI_FACT_TAB_UTILS_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM taxonomy as a PVT (private) API. It supports the Enterprise Territory Management / Profitability Manager factor table upload infrastructure used by the WebADI-based interface for loading allocation factor data. Factor tables in Oracle EBS represent the rules that govern how amounts are allocated across dimensions in profitability and territory management models. The WebADI framework allows users to upload structured spreadsheet content directly into staging interface tables, and this package provides the server-side PL/SQL routines that translate that uploaded content into the internal FEM factor table structures.

The package is dated to the 12.1.1 codebase (header revision 120.1, 2008) and remains present in 12.2.2 with the same logical structure. Because it is a private package, it is not intended for direct customer invocation; it is called internally by the WebADI uploader flow.

Key Procedures and Functions

The documented public surface of the package consists of five procedures, although the excerpt shows only partial definitions:

• UPLOAD_FACTOR_TABLE1_INTERFACE — Accepts a large parameter set describing a factor table upload: rule name, folder, rule and version descriptions, start and end dates, factor type, three matching dimensions with their hierarchies, versions, levels, relationship identifiers, member values, distribution dimension, force-to-hundred flag, object access code, and amount. Populates the interface structures for factor table 1.
• UPLOAD_FACTOR_TABLE2_INTERFACE — The analogous routine for factor table 2. Its parameter list omits P_DISTRIBUTION_DIM and P_DISTRIBUTION_DIM_MEM compared with table 1, reflecting the different dimensional configuration of the second factor table.
• UPLOAD_FACTOR_TABLE3_INTERFACE — The corresponding routine for factor table 3, following the same pattern (definition truncated in the source excerpt).
• POPULATE_RULE_DETAILS — Populates rule detail records derived from the uploaded factor table content.
• POPULATE_FACTOR_TABLE_DIMS — Populates the dimensional metadata associated with a factor table definition.

Parameters are consistently declared as VARCHAR2, with dates passed as character strings for interpretation during interface processing.

Tables Accessed

The package reads and writes the FEM factor table schema and the object catalog/definition tables used by the Application Object Library for object registration:

• FEM_FACTOR_TABLES, FEM_FACTOR_TABLE_DIMS, and FEM_FACTOR_TABLE_FCTRS — the core factor table, dimension, and factor fact structures into which uploaded rows are translated.
• FEM_FACTORS_ROW_NUM_SEQ — supplies sequential row numbers for factor rows.
• FEM_OBJECT_CATALOG_B and FEM_OBJECT_CATALOG_TL — the object catalog base and translation tables, used to register and name uploaded objects.
• FEM_OBJECT_DEFINITION_B and FEM_OBJECT_DEFINITION_TL, with FEM_OBJECT_DEFINITION_ID_SEQ and FEM_OBJECT_ID_SEQ — object definition metadata and surrogate key generation.
• FND_LANGUAGES and DUAL — language lookups for the _TL tables and simple PL/SQL expressions.

Usage Notes

This package is invoked through the WebADI uploader for factor tables rather than from a standard Oracle Forms window or a standalone concurrent program. End users create or edit factor table content in an Excel workbook that has been generated by the WebADI integrator, and submission of that workbook triggers upload processing that ultimately calls UPLOAD_FACTOR_TABLE2_INTERFACE (or the table 1 / table 3 variant, depending on the selected factor table) from PL/SQL server-side code. Custom code should not call these procedures directly, both because the package is private and because the parameter lists may change without notice. Any extension work should use the supported public APIs of the FEM profitability / territory management model instead. Because the package has no inbound dependencies from other packages in the documented dependency graph, replacement or patching can be scoped to the WebADI factor upload feature area.