Shipment Batch And WSH_TRANSACTION_HISTORY Do Not Exist 12.1.2 Instance (Doc ID 1987453.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, All Shipping Reports

Customer has the following requirement to integrate Host and DWMS instance for outbound Sales orders. As part of this requirement they have configured two instances.
And have performed following steps:
1. Setup our organization as a Distributed Org
2. Setup Profile options for integration
3. Created batches through Create shipment batch program
4. The batch ids generated are visible through WSH_SS2_SHIPITEMS_V

However During this process

Customer was receiving error displayed - see file Gen_SR_error.docx

Per further investigation on customer side , they have stated It looks like one of the causes of script failure is missing WSH_SS2_SHIPMENT_V view in the host instance.

This is the output when I ran
Select * from WSH_SS2_SHIPMENT_V; in the host instance.
ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"

When customer attempted to recompile the odf file 'wshvw.odf' available in the path: patch/115/odf and verify the issue.
 
They have been able to get past the errors. The script executes successfully but throws a message:

anonymous block completed
Sales Order does not exists

It looks like the message is because of this cursor
script:
select document_number,
  organization_id,
  organization_code,
  ship_from_location_id,
  customer_id,
  ship_to_site_use_id,
  invoice_to_site_use_id,
  deliver_to_site_use_id,
  ship_to_contact_id,
  invoice_to_contact_id,
  deliver_to_contact_id,
  ship_method_code,
  freight_terms_code,
  fob_code,
  currency_code,
  org_id
  from apps.wsh_ss2_shipment_v
  where shipment_batch_id = c_batch_id;

On executing the query separately we have found that deliver_to_site_use_id, ship_to_contact_id, invoice_to_contact_id, deliver_to_contact_id, are null for this shipment batch. I think this would require us to add this information to the customer but before that i just wanted to confirm with you if our approach is correct and if these fields are must required for us to be able to insert interface record in the distributed instance?



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