Supply Chain Hub Installation Guide

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:

1.  Run the installation shell script on the application node using the application owner user.
2.  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.

Note: If you are running decentralized ASCP and wish to use the Action Release/Reschedule/Cancel recommendations functionality from the Supply Chain Hub running in the EBS Instance; then you must also install Blitz Report on the decentralized ASCP instance.

3.Installation

1. Log in to the application tier node as the application owner user e.g. applmgr.
2. Download the installation file ‘supply_chain_hub_*.zip’ and copy or ftp it 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:

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:

Review the error summary and installation log file and in case of any errors, please contact our support and send us the created
supply_chain_hub_install_logs_*.zip file to analyze the problem.

Note: If you are running decentralized ASCP and wish to use the Action Release/Reschedule/Cancel recommendations functionality from the Supply Chain Hub running in the EBS Instance; then you must also install Blitz Report on the ASCP instance.

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

4.2 Choosing ASCP or MRP as the Planning Source

By default the Supply Chain Hub will use ASCP as the planning source.

If you are using MRP instead of ASCP, the following profile option should be set at site level to instruct Supply Chain Hub to look at MRP as the planning source instead of ASCP.

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

6.1 PL/SQL ERROR 302, when compiling XXEN_SCHUB_WIPDJMDF.fmb

For some clients on older patching levels, the custom form XXEN_SCHUB_WIPDJMDF.fmb may fail compilation during the installation of Supply Chain Hub.

In the event this error is encountered, the following setup change should be made to use the standard WIP Discrete Jobs form in place of the custom form for drilldowns.

Query back the Lookup type and the Lookup Code specified above.

Change the description of the Lookup Code from XXEN_SCHUB_WIPDJMDF to WIPDJMDF as shown below and save the change.

6.2 Index synchronization performance issues

If you face performance issues with mass updates of item descriptions. E.g. updating items’ long description via the EGO Spreadsheet Java Concurrent Program. You can reduce the intermedia index synchronization frequency from on commit to daily. The following commands schedules the synchronization daily at 2 AM:

sqlplus system/*****
grant create job to inv;
alter index inv.xxen_mtl_sys_items_tl_t1 rebuild parameters('replace sync(every "trunc(sysdate)+1+2/24")');
alter index inv.xxen_mtl_sys_items_tl_t2 rebuild parameters('replace sync(every "trunc(sysdate)+1+2/24")');