Installing with sqlplus

  • Updated

Once you have downloaded the Cipher-Oracle.zip from the Cipher Label application, upload the zip file to your EBS database server and unzip to a directory.

  1. sftp Cipher-Oracle.zip to a directory on the Oracle database server.
    • e.g. /tmp
  2. Make a directory to unzip the Cipher-Oracle.zip.
    • e.g. /tmp/cipher-oracle
    • mkdir /tmp/cipher-oracle
  3. Unzip Cipher-Oracle.zip to the directory you created.
    • e.g. /tmp/cipher-oracle
    • unzip /tmp/Cipher-Oracle.zip -d /tmp/cipher-oracle/

The contents of the zip file look as follows:

 mceclip0.png

IMPORTANT: Before installing, ensure that you have run your Oracle database environment file to ensure that sqlplus can be found and will operate appropriately.

Install Cipher_Json Objects

This must be installed for both Cipher Freight and Cipher Label. If you are only installing one of these Cipher products, this is still a required library.

  1. Change directories to the Cipher_Json directory in the directory you unzipped the Cipher-Oracle.zip file to.
    • e.g. /tmp/oracle-cipher/Cipher_Json
    • cd /tmp/cipher-oracle/Cipher_Json
  2. Start sqlplus with the APPS user. 
    • sqlplus apps/<APPSPW>@<SID>
      • where APPSPW is the apps password and SID is your oracle service identifier or service name.
    • mceclip1.png
  3. Execute the install.sql script in the Cipher_Json directory. 
    • @install.sql
    • mceclip2.png
  4. The results of the script will be displayed in the terminal.
    mceclip3.png
  5. Quit sqlplus. 
    • quit
    • mceclip4.png

 

Install Cipher_Freight Objects

This is only required if you have purchased Cipher Freight. You can ignore it if you purchased only Cipher Label.

  1. Change directories to the Cipher_Freight directory in the directory you unzipped the Cipher-Oracle.zip file to.
    • e.g. /tmp/oracle-cipher/Cipher_Freight
    • cd /tmp/cipher-oracle/Cipher_Freight
  2. Start sqlplus with the APPS user. 
    • sqlplus apps/<APPSPW>@<SID>
      • where APPSPW is the apps password and SID is your oracle service identifier or service name.
    • mceclip1.png
  3. Execute the install.sql script in the Cipher_Freight directory. 
    • @install.sql
    • mceclip2.png
  4. The results of the script will be displayed in the terminal.
    mceclip0.png
  5. Quit sqlplus. 
    • quit
    • mceclip1.png

 

Install Cipher_Label Objects

This is only required if you have purchased Cipher Label. You can ignore it if you purchased only Cipher Freight.

IMPORTANT: Before proceeding with the Cipher_Label Object installation it is very important to note that this will overwrite the Oracle provided hook package body, INV_SYNC_PRINT_REQUEST. If you have previously added custom code to this package body and still need that custom code, please be sure to modify the INV_SYNC_PRINT_REQUEST.pkb in the Cipher-Oracle.zip/Cipher_Label directory before running the installation process so your required customizations are not lost.

  1. Change directories to the Cipher_Label directory in the directory you unzipped the Cipher-Oracle.zip file to.
    • e.g. /tmp/oracle-cipher/Cipher_Label
    • cd /tmp/cipher-oracle/Cipher_Label
  2. Start sqlplus with the APPS user. 
    • sqlplus apps/<APPSPW>@<SID>
      • where APPSPW is the apps password and SID is your oracle service identifier or service name.
    • mceclip5.png
  3. Execute the install.sql script in the Cipher_Label directory. 
    • @install.sql
    • mceclip6.png
  4. The results of the script will be displayed in the terminal.
    mceclip7.png
  5. Quit sqlplus. 
    • quit
    • mceclip8.png