otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
 Follow New Posts:Twitter
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTM Wiki

OTM SIG
OTM Wiki
MavenWire

Go Back   Oracle OTM / G-Log GC3 Community Support > OTM / G-Log - Functional Topics > Order Processing
Reload this Page

need order release update when order base is updated


Order Processing Shipment planning and order processing - including data requirements, line items, ship units, order bases and order releases.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old September 16th, 2008, 15:44
Junior Member
 
Join Date: Jul 2007
Posts: 7
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Brintha is on a distinguished road
Red face need order release update when order base is updated

Hi,
I have used the "is shippable" option in line item screen to release an OrderBase automatically when it is created. The order base screen has been customized to hold "is shippable" value as true permanantly. The same has been set to true in the transorder xml too.since this field is true, It always results in the creation of new order release when an order base is created or updated.
The requirement is that, When ever an order base is updated, It should only update the order release that already exists for that order base and should not create a new release.

Example:
new order base: 2741290
order release: 2741290-001

on update of order base: 2741290
order release: 2741290-001
order release: 2741290-002

Two releases are found for same order but i need 2741290-001 to be updated. Or is there any possibility to have 2741290-002 alone in the system by deleting the previous release for the worst case.

Could any one please help me to figure out some solution for this. Thanks in advance.

Regards,
Brintha
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old September 17th, 2008, 09:49
Member
 
Join Date: Mar 2007
Location: Bedfordshire England
Posts: 83
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 4
Thanked 15 Times in 12 Posts
Rep Power: 3
cunninghamg is on a distinguished road
Send a message via AIM to cunninghamg Send a message via MSN to cunninghamg Send a message via Skype™ to cunninghamg
Re: need order release update when order base is updated

Brintha

It sound like you want a one to one relationship between the OB and Release.

If this is the case - why bother with the Order Base at all?

Regards
Gary
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old September 17th, 2008, 11:10
Junior Member
 
Join Date: Jul 2007
Posts: 7
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Brintha is on a distinguished road
Re: need order release update when order base is updated

Hi Gary,

When planned shipment is sent out as outbound, it has two releases in case if order is edited and it would be redundant. The Order information comes inside OTM as orderbase so I need an one to one relation between these two. Is there any way accomplish this? thanks in advance.

Regards,
Brintha
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old October 3rd, 2008, 08:23
Member
 
Join Date: Mar 2008
Posts: 36
Groans: 1
Groaned at 0 Times in 0 Posts
Thanks: 3
Thanked 1 Time in 1 Post
Rep Power: 0
njoyotm is on a distinguished road
Re: need order release update when order base is updated

Hi Brintha,

You can set up an agent of type "Order Base" which can unassign your previous order release (order release: 2741290-001) by using the action "Unassign Order" in your agent.

Note your shipment assigned tou your previous order release will also get deleted.

Regards,
njoyotm
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Archiving Of Data Other Than Shipment / Order Release / Order Base / Items ianlo Database Administration 10 March 4th, 2010 09:36
How to View allocated costs on Order Base or Order Release Lines? vsevs Settlement 1 June 8th, 2009 09:36
How to release the whole Order base? vsevs Order Processing 27 May 29th, 2009 08:21
Auto Release Order Base from integration naveengupta4s Order Processing 3 April 21st, 2009 14:00
Want to create an url on the Order Base integration to the ORDER BASE LINES swaussie Branding, Screen Sets, XSL/CSS and Translations 0 March 28th, 2008 12:21



All times are GMT. The time now is 06:56.
Copyright © 2006-2009, Open Book Solutions LLC. All rights reserved.


Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40