Shipment Batch And WSH_TRANSACTION_HISTORY Do Not Exist 12.1.2 Instance
(Doc ID 1987453.1)
Last updated on MARCH 08, 2017
Oracle Order Management - Version 12.1.3 and later Information in this document applies to any platform.
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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!