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:

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
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

Supply-chain-meny-entry.

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.

Profile OptionValue
Supply Chain Hub: Use MRP for Planning SourceYes

5. Profile Options


The Supply Chain Hub includes a set of configurable profile options that determine system behavior, UI availability, and integration with other Oracle applications. These profile options must be reviewed and set according to the organization’s supply planning, release management, pricing, and performance requirements.

Important: After installation, many of these options may appear blank. This is expected, and administrators are advised to populate them explicitly based on intended usage scenarios and planning sources (ASCP or MRP).

Profile OptionDescriptionDefault
Supply Chain Hub: Enable ReleaseEnable Release of Planned Orders from Supply Chain Hub

  • ASCP – supports Planned Order Release of Purchase Requisition and Work Order recommendations
  • MRP – only supports Release of Work Order recommendations
Yes
Supply Chain Hub: Enable Reschedule and Cancel ActionsEnable Reschedule and Cancel Actions

  • Only applicable to ASCP.
  • Allows for the schedule in/schedule out/cancel recommendations to be actioned from Supply Chain Hub
  • This is done via the Release Button or via the Right Click Release Planned Order menu option.
Yes
Supply Chain Hub: Calculate PriceCalculate Selling Price from Price List

  • If yes a call to the Pricing Engine will be made to determine the selling Price of the Item which is displayed in the Item Details Tab
Yes
Supply Chain Hub: Demand Price ListPrice list for price display on the item details tab
Supply Chain Hub: Drilldown after ReleaseDrilldown to Work Order after Planned Order Release

  • Only Applies to MRP Release to Work Orders
Yes
Supply Chain Hub: Exclude Complete Work OrdersExclude Complete Work Orders from Supply/DemandNo
Supply Chain Hub: Exclude Inventory Master OrganizationsExclude Inventory Master Organizations from the Organizations List of ValuesYes
Supply Chain Hub: Item Attachment CategoryCategory for attachment title and description display in Supply Chain Hub Item Details Tabnull
Supply Chain Hub: Show KPIs in Item Details TabShow Item KPI Quantities in the Item Detail Tab

  • generally only disabled if performance is an issue in the Item Details Tab
Yes
Supply Chain Hub: Show KPIs in Item Search TabShow Item KPI Quantities in the Item Search Tab

  • generally only disabled if performance is an issue in the Item Search Tab
Yes
Supply Chain Hub: Show Release ButtonShow the Release Button in the Supply/Demand Tab

  • If Yes, a Release button is displayed in the left hand panel of the Supply/Demand tab
  • If No, the Release Planned Orders action is accessible as a menu option in the Right Click Menu after selecting the Planned Orders to Release
No
Supply Chain Hub: Show Tooltip HelpEnable or disable tooltip help display for Supply Chain HubYes (Enabled)
Supply Chain Hub: Use MRP for Planning SourceTells Supply Chain Hub to use MRP instead of ASCPNo (ASCP)
Supply Chain Hub: Use Quick Sales Orders FormSupply Chain Hub: Use Quick Sales Orders Form for Drilldowns

  • By default Supply Chain Hub drills down to the Orders Workbench
  • This profile can be used to direct Supply Chain Hub to drill down to the Quick Orders Sales Order form instead.
No
Supply Chain Hub: Use Purchasing Buyer Work CenterSupply Chain Hub: Use Purchasing Buyer Work Center for Drilldowns

  • By default Supply Chain Hub drills down to the Purchasing Forms
  • This profile can be used to direct Supply Chain Hub to drill down to the Purchasing Buyers Work Center instead
No

Best Practices:

  • Review and set profile options explicitly based on your planning approach (MRP vs ASCP), user workflows, and UI preferences.
  • Performance tuning: Disable KPI and tooltip options in large data environments if performance becomes a concern.
  • Drilldown configurations: Adjust drilldown forms (e.g., Quick Sales Orders Form, Buyer Work Center) based on user roles and departmental preferences.
  • Testing: Always validate profile option settings in a non-production environment before deploying to production.

Note:

  • Unset (blank) values may result in default behaviors, but these are not always suitable for every deployment.
  • Some profile options, such as those related to drilldown forms or price lists, are environment-specific and may require coordination with functional consultants and business owners.

6. 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.

7. Troubleshooting


7.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.

ResponsibilityApplication Developer
MenuApplication – Lookups – Application Object Library
Lookup TypeXXEN_SCHUB_FORMS
Lookup Code5

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.

Supply-chain-meny-entry.

7.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")');

7.3 Planned Orders


If using MRP (on-prem):

  • Only Work Orders are currently supported for release.
  • Purchase Requisitions are not supported yet for release from SCHUB (see image below – hidden column Release Order Transaction ID must be present).
  • EBS user must have update access to the SCP Workbench for the Planned Organization.
Supply-chain-hub

If using ASCP (centralized or distributed):

  • Blitz Report must be installed in the ASCP instance.
  • The EBS user must exist in ASCP with the same username and be granted the APS_RELEASE responsibility (does not need to be active).
  • User must have update access to the SCP Workbench under some responsibility in ASCP.
  • Supports release to both Work Orders and Purchase Requisitions, including batch releases, date/quantity overrides.
Supply-chain
Supply-chain

Understanding Supply/Demand Grid Behavior

  • The Release Order Transaction ID column determines if a planned order can be released.
  • If this column is not populated, the order cannot be released.
  • Right-click on the Supply/Demand grid headers to make this column visible.

Make vs Buy Confusion Across Orgs

  • The Make or Buy attribute is organization-specific.
  • A part might be Make in one org (e.g., Plant 006) and Buy in another (e.g., Plant 001).
  • SCHUB reflects the selected Plan Organization from the top-right Planning Fields.
Supply-chain
  • If set to All Planned Orgs, it shows Supply/Demand across all Orgs.
  • Item attributes shown in the Supply/Demand tab are relative to the selected Plan Org, not necessarily the org from the search tab.
Supply-chain-meny-entry.

Visibility of Cross-Org Fulfillment

  • Use the Pegging Info column in the Supply/Demand tab to trace fulfillment sources (image5.png).
    • Click the hyperlink to navigate the object chain and verify originating demand (e.g., internal requisition linking Plant 001 to Work Order in Plant 006).
Supply-chain-meny-entry.

Known Gaps & Upcoming Enhancements

  • Backport of Purchase Requisition release for MRP is in progress.
  • This update will also include:
    • Batch release support
    • Ability to modify quantity and dates at release time

Find out more