TransferShipmentReport and TransferShipmentCarton Reports Do Not Show Any Output in BI Publisher (Doc ID 2206337.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 15.0.1 and later
Information in this document applies to any platform.

Symptoms

TransferShipmentReport and TransferShipmentCarton reports do not show any output in BI Publisher 15.0 version if no data exists in PARTNER table, and no External Partner is set.
Unlike previous versions of SIM, SIM v15 depends on the PARTNER table to populate these reports.

TransferShipmentCartonReport depends on PARTNER table in Report Query Set.
TransferShipmentReport depends on view RPRT_TSF_SHIP_V, which depends on PARTNER table to fetch data as per CREATE VIEW DDL statement.

Once the dependency is removed or an entry is added in PARTNER table, these reports display correct output.


Steps to Reproduce:

  1. Do not set up any External Partner in SIM v15. PARTNER table has no data.
  2. Create a Store to Store Transfer from store A to Store B.
  3. Assign a container to this shipment.
  4. Receive this Transfer in store B.
  5. Run these reports in BI Publisher and check for any output.
  6. Reports run without any error but there is no output.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms