Search Results fnd_ts_mig_cmds




Overview
Explore in AI Chat

Overview

FND_TS_MIG_CMDS is a table owned by the APPLSYS schema within the FND – Application Object Library product of Oracle E-Business Suite. It stores the commands generated for migrating database objects from an old tablespace to a new tablespace. In effect, it functions as the execution ledger for tablespace migration operations: each row captures a discrete migration command targeted at a specific schema object, together with the metadata needed to track its generation, execution, and outcome. This makes the table central to space-management and storage-reorganization activities in EBS environments, where large numbers of tables and indexes must be relocated between tablespaces with minimal disruption.

The object is documented with a primary key, FND_TS_MIG_CMDS_PK, defined on the LINENO column, and a unique index, FND_TS_MIG_CMDS_U1, also on LINENO. From a Data Vault modeling perspective, the mined foreign-key structure classifies this table as standalone, suggesting a hub-like role keyed by the surrogate LINENO rather than a link or satellite that depends on external business keys.

Key Information Stored

The table contains 21 documented columns, of which the following are the most operationally significant:

  • LINENO — the surrogate primary key and the column referenced by both FND_TS_MIG_CMDS_PK and the unique index FND_TS_MIG_CMDS_U1. It uniquely identifies each migration command row.
  • MIGRATION_CMD — the generated DDL or DML statement (for example, an ALTER TABLE ... MOVE or ALTER INDEX ... REBUILD) that performs the actual move.
  • MIGRATION_STATUS — the current lifecycle state of the command, indicating whether it is pending, executed, or failed.
  • ERROR_TEXT — the diagnostic message captured when a command fails during execution.
  • OWNER, OBJECT_NAME, OBJECT_TYPE, SUBOBJECT_TYPE — identify the database object targeted by the command, including the schema owner and the object or subobject type.
  • OLD_TABLESPACE and NEW_TABLESPACE — the source and destination tablespaces for the migration.
  • TOTAL_BLOCKS — the size of the object in blocks, used for progress estimation and workload planning.
  • PARENT_OWNER, PARENT_OBJECT_NAME, PARENT_LINENO — establish the hierarchical relationship between parent objects and their dependent objects, such as a table and its indexes.
  • PARTITIONED — flags whether the target object is partitioned, affecting how commands are generated.
  • EXECUTION_MODE and INDEX_PARALLEL — control how the migration command is executed, including parallel degree for index operations.
  • START_DATE, END_DATE, GENERATION_DATE, LAST_UPDATE_DATE — provide the auditing timestamps for command generation, execution start, completion, and row updates.

Common Use Cases and Queries

Typical usage centers on monitoring migration progress, diagnosing failures, and reporting on storage-reorganization activity. A common query lists failed commands for remediation:

  • SELECT LINENO, OWNER, OBJECT_NAME, MIGRATION_CMD, ERROR_TEXT FROM APPLSYS.FND_TS_MIG_CMDS WHERE MIGRATION_STATUS = 'FAILED';
  • SELECT OBJECT_TYPE, COUNT(*) FROM APPLSYS.FND_TS_MIG_CMDS GROUP BY OBJECT_TYPE; — summarizes the object types included in a migration set.
  • SELECT SUM(TOTAL_BLOCKS) FROM APPLSYS.FND_TS_MIG_CMDS WHERE MIGRATION_STATUS = 'PENDING'; — estimates remaining workload.
  • Joining on PARENT_LINENO to reconstruct parent-child object hierarchies, enabling ordered execution of commands.
  • Comparing START_DATE and END_DATE to derive elapsed execution time per command for performance reporting.

Related Objects

The documented relationship data classifies the table as standalone, so no foreign-key dependencies are specified in the ETRM metadata. Its principal related objects are therefore those that share the APPLSYS schema and participate in tablespace migration workflows, including the FND tablespace migration driver and logging objects. Practically, the most significant relationships are internal to the table itself:

  • FND_TS_MIG_CMDS_PK — the primary key constraint on LINENO.
  • FND_TS_MIG_CMDS_U1 — the unique index on LINENO.
  • Self-referencing parent-child linkage — via PARENT_LINENO, PARENT_OWNER, and PARENT_OBJECT_NAME.
  • Other FND Application Object Library tablespace management and concurrent program log tables that consume the generated commands.