How to send OTM Shipment Cost to SAP/EBS/Fusion/external system

1.       Validation whether the Shipment Exists in OTM or Not.

·         To be done by OTM consultant by writing a query for the selected shipment

Select count(*) from shipment where shipment_gid in ()

1.       Validation whether the Accessorial Code ID is updated for the Shipment or Not

·         It has to be done by OTM consultant by writing a query for the selected shipment

·         OTM Consultant should try to identify the reason for missing the accessorial Code ID.

To Update the Accessorial Code ID, Consultant should run Agent: - TEMP_COST_SEND for the selected set of shipment. This Agent will update the Accessorial Code ID on the Shipment Cost Line,

Select count(*) from shipment_cost where accessorial_code_gid is null and shipment_gid in ()

Group by shipment_gid

Having count(accessorial_code_gid)=1

1.       Validation of the Shipment Cost, no Shipment Cost line should be duplicated for the same Accessorial Code ID

·          It has to be done by the OTM consultant by writing a query for the selected shipment.

· Agent:- TEMP_COST_SEND will perform below actions:-

                                                         i.      Update the Accessorial Code ID

                                                       ii.      Sum up the Shipment cost with Same Accessorial code ID

2.       Creation/Modification of the Saved Query for the list of Shipment for which cost needs to be interfaced.

3.       Post saved Query Creation, the consultant needs to trigger the Agent to send the Shipment Cost to SAP. Two Agent is created to send the Shipment in creating & modify mode as below:-

·         Domain name_TEMP_SEND_COST_CREATE

·         Domain name_TEMP_SEND_COST_MODIFY

4.       Below are the steps to trigger the Agent to Interface Shipment Cost to SAP:-

·         Navigate to Path: - Business Process Automation > Process Management > Business Process Automation > Data Query.

·         Select “Data Query Type” as “Shipment”

·         Consultant will selected the Saved Query created above in the “Based on” Field and the Agent Event to be triggered to send the Shipment Cost to SAP.

·         After that the click the Submit button.