Shipment Batch And WSH_TRANSACTION_HISTORY Do Not Exist 12.1.2 Instance
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.
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
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?
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