Search Results fnd_object_tablespaces

Overview

FND_OBJECT_TABLESPACES is a configuration table owned by the APPLSYS schema within the Oracle E-Business Suite 12.1.1 and 12.2.2 Application Object Library (FND) product. It stores tablespace classifications for database objects such as tables and materialized views, categorizing each object according to its I/O characteristics. This classification allows the EBS infrastructure to route high-volume transactional objects, read-intensive reporting objects, and mixed-workload objects into purpose-built tablespaces, thereby reducing contention and improving storage administration.

From a Data Vault modeling perspective, the documented foreign key structure suggests a satellite-leaning classification. The table records descriptive attributes (tablespace type, custom flag, username) attached to an application object key, and it references FND_TABLESPACES as a parent classification source. It is therefore best understood as an attribute-bearing satellite rather than a true hub or link.

Key Information Stored

The table is defined with 14 documented columns. The primary key, FND_OBJECT_TABLESPACES_PK, is a composite surrogate key composed of APPLICATION_ID, OBJECT_NAME, and OBJECT_TYPE.

• APPLICATION_ID — identifies the EBS application that owns the object; part of the primary key.
• OBJECT_NAME — the database object name being classified; part of the primary key.
• OBJECT_TYPE — the object class (for example, TABLE or MATERIALIZED VIEW); part of the primary key.
• TABLESPACE_TYPE — the tablespace classification code; foreign key to FND_TABLESPACES and part of the unique index.
• CUSTOM_TABLESPACE_TYPE — a customer-defined tablespace classification that overrides or supplements the seeded type.
• CUSTOM_FLAG — indicates whether the row represents a customer customization versus a delivered classification.
• OBJECT_SOURCE — the origin of the object definition within the EBS data model.
• ORACLE_USERNAME — the Oracle schema owning the underlying physical object.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.
• ZD_EDITION_NAME — editioning column supporting online patching in EBS 12.2.x.

The unique index FND_OBJECT_TABLESPACES_U1 (APPLICATION_ID, OBJECT_NAME, OBJECT_TYPE, TABLESPACE_TYPE, ZD_EDITION_NAME) is the strongest business-key candidate, distinguishing classifications that share an application and object name across multiple tablespace types.

Common Use Cases and Queries

DBAs and system administrators query this table to audit tablespace placement, verify that objects are assigned to the intended I/O classification, and identify customizations prior to upgrades or online patching. A typical query resolves a classification to its parent tablespace:

SELECT o.APPLICATION_ID, o.OBJECT_NAME, o.OBJECT_TYPE,
o.TABLESPACE_TYPE, o.CUSTOM_FLAG, o.ORACLE_USERNAME
FROM APPLSYS.FND_OBJECT_TABLESPACES o
WHERE o.CUSTOM_FLAG = 'Y';

Joining to FND_TABLESPACES on TABLESPACE_TYPE yields the underlying physical tablespace name. Reporting use cases include storage-tier reporting, capacity planning for high-I/O objects, and pre-upgrade impact analysis of customer-added rows.

Related Objects

• FND_TABLESPACES — parent reference table; joined via FND_OBJECT_TABLESPACES.TABLESPACE_TYPE = FND_TABLESPACES.TABLESPACE_TYPE.
• FND_TABLESPACE_TYPE — classification lookup supporting the tablespace type values.
• DBA_TABLES / DBA_MVIEWS — dictionary views supplying physical object and tablespace attributes for cross-verification.
• FND_OBJECTS — registry of EBS application objects that provides context for OBJECT_NAME and OBJECT_TYPE.
• FND_APPLICATION — resolves APPLICATION_ID to the owning product short name.
• AD_ZD_TABLE / AD_ZD_ADOP — 12.2 online patching infrastructure that consumes ZD_EDITION_NAME during editioning.