Thursday, 17 January 2013

Oracle iSetup General Foundation and its Dependencies


The purpose of this blog is to detail AOL objects which can be migrate, transform and update. The General Foundation Selection Set used for AOL Objects in iSetup. The Table below displaying object name, supports update and transformable.

Object Name
Supports Update
Transformable
Object Technical Name
 Lookups
Y

FND_Lookups
Printers
Y

FND_Printers
Request Groups
Y

FND_RequestGroup
Menus
Y

FND_Menu
Responsibilities
Y

FND_Responsibilities
Users
Y

FND_User
Key Flexfields
Y

FND_KeyFlexfields
Descriptive Flexfields
Y

FND_DescFlexfields
Document Sequence Assignment


FND_DocumentSequenceAssignments
Document Sequences
Y

FND_DocumentSequences
Value Set Values
Y

FND_ValueSetValues
Document Sequence Categories
Y

FND_DocumentSequenceCategories
Concurrent Programs
Y

FND_ConcPrograms
 
For successful migration user must be aware of the dependencies between different types of configuration data.
In many cases Isetup component will have dependencies on parent records existing on target instance. To use a simple example, if wish to migrate “Lookups” its required “Application” records being present on target instance which cannot be populate by iSetup. In same way when migrate “Responsibilities” which is depended on Menus and Request Groups, so need to migrate Menus and Request Groups first then Responsibilities.
The below table displaying Object Name, Parent and Child objects.

Object Name
Required Record not Populated by iSetup
Parent Objects
Child Objects
Lookups
Applications
·   None
·   None
Printers
None
·   None
·   None
Request Groups
Applications
·   None
·   Responsibilities
Menus
Applications
·   None
·   Responsibilities
Responsibilities
Applications
·   Request Groups
·   Menus
·   Users
·   Key Flexfields
·   Descriptive Flexfields
Users
None
·   Responsibilities
·   None
Key Flexfields
Applications
·   Responsibilities
·   Value Set Values
·   None
Descriptive Flexfields
Applications
·   Responsibilities
·   Value Set Values
·   None
Document Sequence Assignment
None
·   Document Sequence
·   Document Categories
·   None
Document Sequence
None
·   None
·   Document Assignment
Value Set Values
None
·   None
·   Key Flexfields
·   Descriptive Flexfields
Document Sequence Categories
None
·   None
·   Document Assignment
Concurrent Programs
Applications
·   Value Set Values
·   None

Dependency Detail Viva Diagram