Creating the integration schema

Edit online

You must create a schema for managing the Maximo® integration framework in the Oracle E-Business Suite database. You can create multiple integration schemas on the same database instance to support multiple Maximo Manage application servers.

About this task

The procedure uses MAXORA as the schema username for the Oracle E-Business Suite integration. You can specify any username for the schema, but the name must be the same as the username configured for the endpoint in the System tab of the External Systems application.

Procedure

  1. In the Maximo_root\ORACLEAPIS\install directory, open the cremxora.sql file.
  2. Replace all instances of MAXORA with your integration schema name.
  3. Replace all instances of USER_DATA with your table space name.
  4. Save the cremxora.sql file.
  5. Start SQL* Plus and connect to the Oracle E-Business Suite database as a database administration user.
  6. Create and grant privileges to the integration schema by entering the following command:

    SQL > start Maximo_root\ORACLEAPIS\install\cremxora <Enter>

  7. Review and correct any errors that you see on the screen.