Search Results fem_object_definition_id_seq




Overview
Explore in AI Chat

Overview

The package body APPS.FEM_WEBADI_FACT_TAB_UTILS_PVT is a private (PVT) PL/SQL utility package in the Oracle E-Business Suite Profitability and Enterprise Performance Foundation (FEM) schema. It supports the WebADI-based loading of factor table definitions into the Enterprise Performance Foundation data model. Its primary business function is to accept inbound interface rows describing factor tables, factor table dimensions, and factor table factors, validate and resolve them against the existing FEM metadata model, and then materialize the corresponding object definitions in the FEM object catalog and object definition tables. The package is classified as a private utility, meaning it is intended for internal use by other FEM packaged APIs and the WebADI integration layer rather than being called directly by end users.

Key Procedures and Functions

The documented interface exposes five procedures and functions, all concerned with the factor table upload lifecycle:

  • UPLOAD_FACTOR_TABLE1_INTERFACE — Processes the first-stage interface rows for a factor table upload, handling validation and the initial resolution of factor table header information.
  • UPLOAD_FACTOR_TABLE2_INTERFACE — Continues the upload for the second-stage interface, typically dealing with factor table dimension records.
  • UPLOAD_FACTOR_TABLE3_INTERFACE — Completes the upload for the third-stage interface, generally covering individual factor (measure) assignments to the factor table.
  • POPULATE_RULE_DETAILS — Populates the rule detail structures associated with the uploaded factor table, resolving rules referenced by the interface data.
  • POPULATE_FACTOR_TABLE_DIMS — Populates the factor table dimension rows, mapping the uploaded dimension identifiers to FEM_FACTOR_TABLE_DIMS.

The staging pattern of three numbered interface procedures reflects the layered structure of a factor table: header, dimensions, and factors.

Tables Accessed

The package reads and writes the core FEM factor table model. It inserts into and queries FEM_FACTOR_TABLES, FEM_FACTOR_TABLE_DIMS, and FEM_FACTOR_TABLE_FCTRS, and obtains row identifiers from the sequence FEM_FACTORS_ROW_NUM_SEQ. Metadata validation relies on FEM_DIMENSIONS_VL, FEM_DIMENSION_GRPS_VL, FEM_FOLDERS_VL, and FEM_LOOKUPS, with additional support from FEM_DIMENSION_UTIL_PKG. Object definitions are created through FEM_OBJECT_CATALOG_B, FEM_OBJECT_CATALOG_TL, FEM_OBJECT_CATALOG_VL, FEM_OBJECT_DEFINITION_B, FEM_OBJECT_DEFINITION_TL, and FEM_OBJECT_DEFINITION_VL, using the sequences FEM_OBJECT_ID_SEQ and FEM_OBJECT_DEFINITION_ID_SEQ. The latter sequence, FEM_OBJECT_DEFINITION_ID_SEQ, is the key generator that new factor table object definitions draw from, which is why searches on fem_object_definition_id_seq surface this package. Supporting calls to FND_GLOBAL, FND_LANGUAGES, FND_MESSAGE, FND_PROFILE, APP_EXCEPTION, and DUAL provide session context, NLS handling, error messaging, profile lookups, and exception management.

Usage Notes

Because this is a private package, it is not intended for direct invocation from custom code or standard concurrent programs. It is called by the WebADI integration framework when a user uploads a factor table spreadsheet through the Enterprise Performance Foundation WebADI interface. The three-stage upload procedures are invoked in sequence during that process, with POPULATE_RULE_DETAILS and POPULATE_FACTOR_TABLE_DIMS performing the dependent metadata population. The package is not referenced by any other database object, confirming its role as a leaf utility in the FEM WebADI stack. Oracle EBS 12.1.1 and 12.2.2 deployments rely on the FEM schema being fully patched, since the package depends on the object catalog and object definition APIs. Any troubleshooting of factor table upload errors, sequence exhaustion on FEM_OBJECT_DEFINITION_ID_SEQ, or missing catalog entries should begin with the exception messages raised by this package.