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