eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.HR_DM_MIGRATIONS

Object Details

Object Name:	HR_DM_MIGRATIONS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_DM_MIGRATIONS
Subobject Name:
Status:	VALID

This table contains the data migration information. There is one row per migration in progress. Historical data is retained to enable the application of the business rules as discussed in the business rules section of this document.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Primary Key: HR_DM_MIGRATIONS_PK

MIGRATION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_DM_MIGRATIONS_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	MIGRATION_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_DM_MIGRATION_REQUESTS		HR_DM_MIGRATIONS	HR_DM_MIGRATION_REQUESTS MIGRATION_ID
HR_DM_PHASES		HR_DM_MIGRATIONS	HR_DM_PHASES MIGRATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MIGRATION_ID	NUMBER	(15)	Yes	System-generated primary key column.
SOURCE_DATABASE_INSTANCE	VARCHAR2	(30)	Yes	The name of the source database.
DESTINATION_DATABASE_INSTANCE	VARCHAR2	(30)	Yes	The name of the destination database
MIGRATION_TYPE	VARCHAR2	(30)	Yes	The type of migration being undertaken. This value is a lookup code of the lookup type HR_DM_MIGRATION_TYPE and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_VALUES.
APPLICATION_ID	NUMBER	(15)	Yes	The application for which data is to be migrated as defined in the table FND_APPLICATION.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	The business group ID as defined in the table HR_ALL_ORGANIZATION_UNITS.
BUSINESS_GROUP_NAME	VARCHAR2	(240)		The business group name as defined in the table HR_ALL_ORGANIZATION_UNITS.
BUSINESS_GROUP_CREATED	VARCHAR2	(1)		For an FW migration, the business group needs to be created in the destination database, after which this entry is set to Y.
MIGRATION_START_DATE	DATE			Start date of the last run of the data migrator tool.
MIGRATION_END_DATE	DATE			End date of the migration, when the migration status is F (Finished).
STATUS	VARCHAR2	(30)	Yes	Current status of the process. This value is a lookup code of the lookup type HR_DM_MIGRATION_STATUS and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES.
MIGRATION_PROCESS	VARCHAR2	(60)		The description of the current process being undertaken by the data migrator.
EFFECTIVE_DATE	DATE			Start date of the migration, which is the system date (sysdate) at which the row in the HR_DM_MIGRATIONS table was created.
MIGRATION_COUNT	NUMBER	(15)		The number of runs of the migration. If the migration is rerun then this value is incremented.
SELECTIVE_MIGRATION_CRITERIA	VARCHAR2	(2000)		Free form text describing the migration criteria.
ACTIVE_GROUP	NUMBER	(15)		The group_id for the group which is active during the delete phase of a delete migration. The group_id is defined in the table HR_DM_GROUPS.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
SECURITY_GROUP_ID	NUMBER	(15)		Foreign Key to FND_SECURITY_GROUPS.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MIGRATION_ID
,      SOURCE_DATABASE_INSTANCE
,      DESTINATION_DATABASE_INSTANCE
,      MIGRATION_TYPE
,      APPLICATION_ID
,      BUSINESS_GROUP_ID
,      BUSINESS_GROUP_NAME
,      BUSINESS_GROUP_CREATED
,      MIGRATION_START_DATE
,      MIGRATION_END_DATE
,      STATUS
,      MIGRATION_PROCESS
,      EFFECTIVE_DATE
,      MIGRATION_COUNT
,      SELECTIVE_MIGRATION_CRITERIA
,      ACTIVE_GROUP
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      SECURITY_GROUP_ID
FROM HR.HR_DM_MIGRATIONS;

Dependencies

[top of page]

HR.HR_DM_MIGRATIONS does not reference any database object

HR.HR_DM_MIGRATIONS is referenced by following:

APPS: HR_DM_MIGRATIONS; HR_DM_MIGRATIONS_WHO
PUBLIC: HR_DM_MIGRATIONS