Is There Any API To Update POD Signed Field (pod_by, pod_date) in wsh_delivery_legs? (Doc ID 2162907.1)

Last updated on MARCH 08, 2017

Applies to:

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

Goal

Want to update the following values in the Bill of Lading form.  These values will be updated from values taken from OTM.
These columns are in table WSH_DELIVERY_LEGS table. 

POD Signed By  (Port of Discharge)
POD Signed Date  (Port of Discharge)
Shipper Signed By
Shipper Signed Date
Carrier Signed By
Carrier Signed Date

Is there any API we can use to update these fields or can we directly update the table with the data from OTM?

1. OM Super User. Navigate: Shipping--Transactions
2. Search for the delivery to be confirmed.
3. In the Deliveries tab, click on the Details button.
4. In the Delivery Details form, click on the 'Legs' tab
5. Click on the Details button in this form.

 

Currently, there no Public API for this requirement
Please see ER Bug 8853707 - DEV: NEED AN API TO UPDATE THE POD (POD_BY, POD_DATE) WSH_DELIVERY_LEGS

 

Solution

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