Search Results fnd_object_tablespaces_pub




Overview
Explore in AI Chat

Overview

FND_OBJECT_TABLESPACES_PUB is a public PL/SQL API package in the APPS schema that supports the Oracle E-Business Suite tablespace management framework. Its business purpose is to provide a programmatic interface for registering, maintaining, and validating the association between Oracle EBS database objects and the tablespaces in which they reside. In a multi-application environment such as EBS 12.1.1 or 12.2.2, the Applications DBA and system administration layers must track which tablespace is used for particular object categories so that schema deployment, cloning, and Online Patching (in 12.2.x) operations apply the correct storage attributes. FND_OBJECT_TABLESPACES_PUB encapsulates the create, update, and validate operations that maintain this metadata within the FND_OBJECT_TABLESPACES table, shielding callers from the underlying data model and enforcing the standard FND_API error-handling and validation conventions.

Key Procedures and Functions

The documented public interface exposes three procedures:

  • CREATE_OBJECT_TABLESPACES — Inserts a new object-to-tablespace mapping record, establishing the storage assignment for a given Oracle EBS object or object type.
  • UPDATE_OBJECT_TABLESPACES — Modifies an existing mapping, allowing changes to the tablespace associated with a registered object without deleting and recreating the record.
  • VALIDATE_OBJECT_TABLESPACES — Performs validation of the supplied data and the target tablespace definition, confirming that referenced objects, tablespaces, and application context are consistent before a create or update is committed.

Consistent with the PUB API classification, these routines are the supported entry points for external callers; callers should not manipulate the underlying base tables directly. The package conforms to the FND_API standard, as evidenced by its dependency on APPS.FND_API, which supplies message handling, return status constants, and error-stack management.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • FND_OBJECT_TABLESPACES — the primary transactional table holding object-to-tablespace assignments; created and updated by this API.
  • FND_TABLESPACES — the registered tablespace definitions used to validate that a referenced tablespace exists and is known to the application.
  • FND_APPLICATION and FND_PRODUCT_INSTALLATIONS — application and product registration data used to resolve application context and ownership.
  • FND_ORACLE_USERID — Oracle schema/user identity information associated with objects.
  • DBA_TABLES, ALL_QUEUE_TABLES, ALL_SNAPSHOTS, ALL_SNAPSHOT_LOGS — data dictionary views queried to determine physical storage attributes and identify advanced-queue or materialized-view-related objects relevant to tablespace assignment.

These accesses support both validation of user-supplied input and derivation of storage metadata from the live database.

Usage Notes

FND_OBJECT_TABLESPACES_PUB is an internal infrastructure API rather than an end-user-facing component. It is typically invoked by EBS system administration and database administration functionality — for example, during edition or tablespace configuration and during setup maintenance performed in the Oracle Applications Manager (OAM) or related administrative interfaces. Because it is declared as a PUB package, it is the sanctioned interface for custom code or concurrent programs that must register or alter object-to-tablespace mappings; direct DML against FND_OBJECT_TABLESPACES bypasses its validation logic and is not supported. The package depends on APPS.FND_API and STANDARD and is referenced by no other documented packages, indicating it functions as a leaf-level utility called by forms or administrative routines rather than reused by peer APIs. Developers extending EBS should call these procedures within the standard FND_API savepoint and message-handling pattern to ensure transactional integrity.