| | OTM / EBS / JDE E1 Integration Information and topics specific to utilizing Oracle's pre-packaged integration flows between OTM (G-Log) and other Oracle Applications, such as the eBusiness Suite and JD Edwards E1. |  | 
March 5th, 2009, 06:01
| | Senior Member | | Join Date: Aug 2008
Posts: 123
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 2 | | | WSH Freight Costs from OTM Hi, We have integrated WSH OTM successfully for both Delivery to OTM and Planned Shipment from OTM to WSH. But we didn't get the freight costs updated in WSH. Can anybody help us on this. The integration guide says "After the plannedShipment message has been received, the freight costs are viewable at the delivery level as OTM Freight Cost." Thanks, Venkat. | 
March 9th, 2009, 14:36
| | Junior Member | | Join Date: Oct 2008
Posts: 22
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 5 Times in 5 Posts
Rep Power: 0 | | | Re: WSH Freight Costs from OTM Hi Venkat,
Yes, the freight costs are viewable at the delivery level as OTM Freight Cost.
You need to ensure that the Shipment you send from OTM satisfies the following criteria:
1. Create allocation rule for Service provider
2. Create delivery event for shipment which would change the status as ‘enroute completed’
3. Status of allocation should be ‘allocation completed’
This will work. Now when you go to the Delivery go to Action 'Assign Freight Costs'. You will see that the Freight Cost from OTM would have been updated there.
Let me know if there is any confusion.
Regards,
Divya | 
March 10th, 2009, 03:50
| | Senior Member | | Join Date: Aug 2008
Posts: 123
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 2 | | | Re: WSH Freight Costs from OTM Hi Divya,
Thank you for your information. Can you please let me know based on which action event, we need to change the status to enroute complete?
We have allocation rule profile for the service provider. So once we change the status we can check it.
Thanks,
Venkat. | 
March 10th, 2009, 04:27
| | Junior Member | | Join Date: Oct 2008
Posts: 22
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 5 Times in 5 Posts
Rep Power: 0 | | | Re: WSH Freight Costs from OTM Hi Venkat,
You need to update the Shipment Event Status as 'Delivered'. Once this event is updated, Shipment Status will change to Enroute Completed.
Regards,
Divya | 
March 10th, 2009, 06:39
| | Senior Member | | Join Date: Aug 2008
Posts: 123
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 2 | | | Re: WSH Freight Costs from OTM Hi Divya,
Thank you. We have integrated with EBS. How can we make enroute complete before we do ship confirm in EBS. From here we just send Planned shipment. Please clarify. We have an issue with allocation also. When we try to do allocate cost from Actions it says,
"No single status functor for type interface glog.ejb.shipment.Shipment, domain SASTAAL, function GC3_APPL_SHIP_ALLOCATION_ISSUED, current domain is SASTAAL"
Can you please help us on this.
Thanks,
Venkat. | 
March 10th, 2009, 14:18
| | Junior Member | | Join Date: May 2008
Posts: 9
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0 | | | Re: WSH Freight Costs from OTM Hi
you can get the freight cost to OTM, even without changing the status to 'enroute completed'. set the allocation rule for service provider in OTM, and allocate cost for the shipment. ensure the status is 'allocation completed'. push the shipment back to otm. query for the trip and invoke the action 'assign freight cost' in EBS to find the frieght cost.
Let me know if you face any issue
With Regards
Santhosh Amireddy | 
March 11th, 2009, 03:15
| | Senior Member | | Join Date: Aug 2008
Posts: 123
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 2 | | | Re: WSH Freight Costs from OTM Hi Santhosh,
Thank you for your clarification. I have an issue with allocation. Can you please check if you can help me on this.
The issue is "No single status functor for type interface glog.ejb.shipment.Shipment, domain SASTAAL, function GC3_APPL_SHIP_ALLOCATION_ISSUED, current domain is SASTAAL"
Thanks,
Venkat. |  | | Thread Tools | | | | Display Modes | Linear Mode |
Posting Rules
| | | | |