1.Introduction
This document guides you through the steps required to install the Supply Chain Hub for Oracle E-Business Suite R12.
Supply Chain Hub is an add-on to Blitz Report and installs the following objects on your Oracle E-Business Suite server:
- Database tables, sequences, synonyms, indexes and views
- Database packages
- User interface form
- Application setups such as crm spreadtables, profile options, lookups, form functions, menus
All installed objects are prefixed with XXEN_SCHUB.
The basic installation steps are:
- Run the installation shell script on the application node using the application owner user.
- Perform additional manual application setup steps from the ‘System Administrator’ responsibility.
2. Prerequisites
2.1.Install Blitz Report in Oracle E-Business Suite
The Supply Chain Hub is built using Blitz Report functionality. Blitz Report must already be installed into the Oracle EBS instance
before it is possible to install the Supply Chain Hub.
3.Installation
1. Log in to the application tier node as the application owner user e.g. applmgr.
2. Copy or ftp the file ‘supply_chain_hub_*.zip’ to a location of your choice on the EBS application server node.
3. Extract the .zip file and navigate to the folder ‘supply_chain_hub’, located under the directory from where it is extracted. Add execution
permissions for shell scripts and perform the installation by running install.sh:
unzip supply_chain_hub_*.zip cd supply_chain_hub_* install.sh |
During execution, the script will ask for the APPS database user password.
Note: To run the installation non-interactively, you also can set the apps password before script execution, for example:
export APPS_PWD=apps |
Review the error summary and installation log file and in case of any errors, please contact our support and send us the created
install_logs_*.zip file to analyze the problem.
4.Application Setup
In order to make Supply Chain Hub available to the users, you need to add the Supply Chain Hub form function and sub-menu to
application menus.
4.1 Menu entry
Assign the Supply Chain Hub function and sub-menu manually, as shown below, to the menus you would like to access the Supply
Chain Hub from.
System Administrator > Application > Menu
5. Upgrade
To perform the Supply Chain Hub upgrade, download and deploy the latest installation file in the same way as for a new installation by following steps 1-3 in the installation section 3.
Ignore any ‘ORA-00955: name is already used by an existing object’ error messages.
6. Troubleshooting
We are not aware of any installation problems yet.