Set up the Oracle EBS spoke

Integrate the ServiceNow instance and your Oracle EBS instance using a basic authentication to authenticate the ServiceNow requests.

始める前に

• Request an Integration Hub subscription.
• Activate the Oracle EBS spoke.
• Admin access to the Oracle EBS account.
• Role required: admin.

手順

1. From the ServiceNow® Store download the project file, Oracle_e-business_suite spoke_dependencies.zip and save it in the required local folder.
2. Unzip the contents of the Oracle_e-business_suite spoke_dependencies.zip file.
3. In SQL Developer or an SQL client, compile all the PKB and PLS files in the APPS schema.

   図 : 1.

   

4. In Oracle EBS server, deploy the Oracle EBS REST API.

   For the steps to enable the REST API per extension, see Administering Custom Integration Interfaces and Services.

   You must perform these steps for every PLS file. While deploying each PLS file, you must provide the relevant values. Here, the procedure is outlined using XXSN_CREATE_PO_PKG.pls as an example.

   1. Copy and upload the compiled package .pls files to these respective directories:
      • $PO_TOP/patch/115/sql/tmp/
      • $PO_TOP/patch/115/sql/

      注:

      Ensure that you replace the $PO_TOP with the module the package belongs to such as, $AP_TOP, $PO_TOP, and so on.
   2. Log in to PuTTY of your Oracle EBS server and execute the Integration Repository Parser.
      1. To generate an iLDT (*.ildt) file, execute the Integration Repository Parser using this syntax:

         $IAS_ORACLE_HOME/perl/bin/perl $FND_TOP/bin/irep_parser.pl -g -v -username=sysadmin po:patch/115/sql:XXSN_CREATE_PO_PKG.pls:12.0=$PO_TOP/patch/115/sql/tmp/XXSN_CREATE_PO_PKG.pls

      2. If you aren't generating .ildt file for the XXSN_CREATE_PO_PKG.pls file, replace po and $PO_TOP with required Top.
      3. If you aren't generating .ildt file for the XXSN_CREATE_PO_PKG.pls file, replace XXSN_CREATE_PO_PKG.pls with the required package name.

      図 : 2.

      

   3. Upload the generated iLDT file to Integration repository by executing this command:

      $FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/wfirep.lct XXSN_CREATE_PO_PKG_pls.ildt

      注:

      Replace XXSN_CREATE_PO_PKG_ with the required package name.

      図 : 3.

      

   4. Log in to your Oracle E-Business Suite instance as system administrator.
   5. Switch to the Integrated SOA Gateway responsibility and select Integration Repository.

      図 : 4.

      

   6. Search for the web service with the internal name, XXSN_CREATE_PO_PKG.

      図 : 5.

      

   7. Click the link in the search result to access the list of available metods in the interface package.

      図 : 6.

      

      注:

      In the PL/SQL interface type, both SOAP and REST web services are available. However, this procedure focuses on the REST web service.
   8. Click the REST Web Service tab.
      1. Set an alias for this service. For exmaple, hr.
      2. Click Deploy.
   9. View the Create PO method by clicking the REST Web Service tab.

      図 : 7.

      

      図 : 8.

      

   10. Enter the unique service alias name, select the Create PO method, and click Deploy.

       図 : 9.

       

       A confirmation message is displayed that the service is successfully deployed.
   11. Click View WADL to access the physical location of the service endpoint where the service is hosted.
   12. Open the Grants tab, select Create PO, and click Create Grant.

       図 : 10.

       

   13. Select a grantee type, enter the user name to whom you want to give the grant access to use the web service, and click Create Grant.

       図 : 11.

       

       A confirmation message is displayed mentioning that the grant has been successfully created.

       図 : 12.

       

       注:

       To revoke grant, click Revoke Grants in the Grants tab and select the required users.
   14. Perform the above steps for all the required actions and ensure that you use the same names (associated with the respective action) as mentioned in the Resource Path column of the following table:

       

   15. Restart the server and using PuTTY, perform these steps up on logging in to the Oracle EBS server.
       1. Execute the commands: cd $ADMIN_SCRIPTS_HOME and ./adadminsrvctl.sh stop.
       2. Enter the WebLogic password and EBS password.
       3. Execute the command, ./adadminsrvctl.sh start.
       4. Enter the WebLogic password and EBS password.
       5. To check the status, execute the command, ./adadminsrvctl.sh status.
5. Create a credential record for the Oracle EBS spoke.
   1. Navigate to Connections & Credentials > Credentials.
   2. Click New.
      The system displays the message What type of Credentials would you like to create?.
   3. Select Basic Auth Credentials.
   4. On the form, fill these values.

      Field	Description
      Name	Name to uniquely identify the credential record. For example, OEBS Cred.
      User name	User name to log in to the Oracle EBS instance.
      Password	Password to log in to the Oracle EBS instance.
      Active	Option to actively use the credential record.

   5. Click Submit.
6. Create a connection record for the Oracle EBS spoke.
   1. Navigate to Connections & Credentials > Connection & Credential Aliases.
   2. Open the record for the Oracle EBS spoke.
   3. From the Connections tab, click New.
   4. On the form, fill these values.

      Field	Description
      Name	Name to uniquely identify the connection record. For example, OEBS Conn.
      Credential	Credential record you created for the Oracle EBS spoke.
      Connection URL	Connection URL to connect to your Oracle EBS instance.

   5. Click Submit.