Search 800 + Posts

Aug 20, 2011

How to Copy Sales Order Line level sets in Order Management (R12i Feature) - Part 1

In R12 Oracle has introduced a new feature, where you can copy the Line Sets (fulfillment/Ship/Arrival) while copying the sales order, this will be great help to customers where they have very large sales order with Line sets. Till now user has no option , but to copy the sales order without sets and then manually added line to the sets in new-copied sales order , this process is very tedious and time consuming if the # of lines Order are large and these lines belongs to multiple Sets. But with new functionality their job is really very easy.

This new feature to copy the Sets , has nothing to do with the existing feature of fulfillment set at the order header level , but it do results in some issues/error is not take care properly.

For this new feature Oracle has provided 2 additional checkbox in the Copy Order Form.
1. Fulfillment Set
2. Ship /arrival Set
By default these will be unchecked and also if user is not copying the Order line then these 2 check boxes will be disabled.

Copy to Create New Order
Now when user creates a new sales order by copying the existing sales order, New order will have all the sets copied from the original order and these sets will have same name in the new order as that in the Source Order.

Copy lines (with sets) in already existing Sales Order

If customer try to add the order line/group of lines (with set) in an existing sales order and if the destination order doesn’t have sets with the similar name as that of the set in the source order then the sets copied as is from source order to destination order.

BUT if the lines from the source order has the same set name as that of the set in the destination sales order , then system will add the line/group of lines from source Order to existing sets in destination sales order ( Please note that Set in the destination order should be open), But in case Destination order has same set name as that of the source order , but the set is close then system will throw an error message and will not copy .

Please Refer My below Presentation on Same for More Details.

1 comment:

  1. i have a doubt regarding order copy.
    When i tried, value for the field ,'warehouse' is 'PEN' in BV instance. but in CG1 , it is shown as 'TAU'. what might be the reason for this? if anyone can answer pls reply and advice a solution for this. Thanks in advance