My Oracle Support Banner

Unable to Ship Confirm On Weekends When Using API WSH_DELIVERIES_PUB (Doc ID 2366160.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Open Interfaces & Public APIs

When ship confirming using API wsh_deliveries_pub, the process fails due to validation with Shipping/Receving calendar.
The log shows the following:

Log shows the following:
msg_buffer ==> Some deliveries selected for Ship Confirm have errors or warnings.

End of log shows this:
Confirmation API failed with the following message:
Warning: Some deliveries selected for Ship Confirm have errors or warnings.
Warning: The initial pick-up date of 05-JAN-2018 for delivery xxxxxxxx does not match the shipping and/or carrier calendar.
The nearest valid date is 08-JAN-2018.
Warning: The ultimate drop-off date of 06-JAN-2018 for delivery xxxxxxxx has been modifed to 09-JAN-2018, as per the changes in initial pick-up date.
1 deliveries will be marked as In-Transit/Closed.

Other Details

Shipping/Receving calendar is set for Monday - Friday.
Use WSH API for importing details into Oracle from 3rd party.
Issue only occurs when attempting to ship outside of Shipping/Receving calendar
As workaround, users have to manually go to OM - Setup - Calendars and make Sat/Sun available for Shipping, 
then go to OM - Shipping Transactions form (WSHFSTRX) and manually Ship Confirm. Very inefficient, due to volume of shipments.

The issue can be reproduced at will with the following steps:
1. Ship confirm using the API on a weekend
2. Process fails and throws the mentioned error


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.