Import Rules Directly from Microsoft Excel Spreadsheets

You can import rules directly from a spreadsheet by using a macro. The provided spreadsheet contains field selection lists and validations to help you catch any errors while you enter data.

The Import and Populate buttons connect to the environment. Sign in with your user name and password for the correct environment for the import. In the Host Name field, enter the portion of the URL of your environment between https:// and the forward slash /. You can get the correct host name from the URL by signing in to your application. Don't copy the host name from your application sign-in page because the URL is different.

1. Go to My Oracle Support and download the spreadsheet and .jar file.

2. To enable validation and the field selection lists, go to the List of Values tab and click Populate LOV Values from Server.

3. Enter your rules definitions.

4. Click the Create Import Activity button to start your import. The macro performs some basic validations and then starts the import.

5. To check the status of your import, click Activity Details.

6. The Generate Log button is enabled if you have errors. Click it to generate log files.

7. Review the errors listed in the error tab. Use the links in the errors to go to the specific record and correct it.

8. Import again to add your corrected records. The import doesn't include records that were successfully imported and display Imported in the status column.

Your import is visible in Import Management.