Search Results fnd_object_tablespaces_pkg




Overview
Explore in AI Chat

Overview

The APPS.FND_OBJECT_TABLESPACES_PKG package body is a standard Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 database object owned by the APPS schema. Its object type is a PACKAGE BODY with a status of VALID, and the ETRM repository classifies its API type as OTHER. The package provides the maintenance interface for the FND_OBJECT_TABLESPACES foundation table, which defines the recognized tablespaces used by the EBS environment and associates them with Oracle schema/user identifiers and product installations. It is an internal, low-level APPLSYS/FND utility package rather than a published public API; its documented procedures support data manipulation of the underlying tablespace registry (insert, update, load, and delete operations) that supports edition and object management in Release 12.

Key Procedures and Functions

The ETRM metadata documents five procedures/functions for this package (four named in the excerpt):

  • INSERT_ROW — Inserts a new tablespace record into the FND_OBJECT_TABLESPACES registry, assigning the primary key and column values for the new definition.
  • UPDATE_ROW — Modifies an existing tablespace record, applying changed attribute values to the identified row.
  • LOAD_ROW — Performs an upsert-style load: inserts the record if absent, or updates it if it already exists. This is the documented mechanism used by upgrade and patching scripts to seed or refresh tablespace definitions deterministically.
  • DELETE_ROW — Removes a tablespace record from the registry, typically when a tablespace is deprecated or deleted during environment changes.

No parameter lists are asserted here; the procedures follow the standard EBS maintain-API convention of small, single-purpose wrappers around the base table. A fifth documented entry completes the set of five objects reported by ETRM.

Tables Accessed

The package body references the following objects, per the dependency listing:

  • FND_OBJECT_TABLESPACES — the primary target table; holds the tablespace definitions maintained by the four DML procedures.
  • FND_ORACLE_USERID — the Oracle user/schema registry, consulted to resolve the database account associated with a tablespace entry.
  • FND_PRODUCT_INSTALLATIONS — the product installation registry, used to associate tablespaces with installed EBS products and releases.
  • FND_USER — the application user table, referenced for audit information (created-by/updated-by) on row changes.

Dependencies also list STANDARD (the Oracle-supplied package specification) and the schema APPS itself. All base tables are reached through APPS synonyms.

Usage Notes

FND_OBJECT_TABLESPACES_PKG is not referenced by any database object according to the ETRM dependency report, indicating it is called directly rather than through another stored program. In practice it is invoked during installation, upgrade, and maintenance activities — patching utilities, seed-data loaders, and administrative scripts that need to register or reorganize tablespace definitions in a Release 12 environment (12.1.1 or 12.2.2). Because it is an FND internal object with no published interface contract, custom code should avoid direct calls and instead rely on supported AD utilities and the EBS AutoConfig/tablespace-management tooling. The package is marked VALID, so its compiled body is present and usable in the queried environment, and it participates in the broader FND object and edition infrastructure that supports online patching in 12.2.