Some companies have several instances of Oracle E-Business Suite and need to be able to access many of these from the More4apps Wizard Workbooks. The following functionality enables you to set up one instance list and then copy it into other More4apps workbooks.
To copy your list of instances between workbooks (from ‘Workbook A’ to ‘Workbook B’), follow these steps:
1.Open Workbook A and check the Instance List is set up correctly.
Opening a data-entry form for the first time will open the Login page. Click on the […] button to view the list of instances.
2.Open a Blank Workbook:
•Microsoft Excel 2003 – File > New > Blank Workbook
•Microsoft Excel 2007 or Later – Office Button > New > Blank and Recent
3.Click on the ‘Export Login Configuration’ icon on the Setup Ribbon.
Your instance definitions will have been copied into cell A1 etc.
Save this workbook (e.g. Instance List.xls), you may want to use it in the future.
Close Workbook A, but keep ‘Instance List.xls’ open.
4.Open Workbook B, but switch back to the ‘Instance List.xls’ so that it is the current workbook.
5.Click on the ‘Import Login Configuration’ icon on the Setup Ribbon.
You should receive the message ‘Login configuration settings imported from current workbook’.
Now you will have the new list of instances available in ‘Workbook B’. You can continue to open other workbooks and import the Instance List using the ‘Instance List.xls’ that you created.
