Parallel Pick Release R12

Oracle has introduced lots of interesting features in R12.In this post I will talk about the one such feature.

Parallel Pick Release

With this feature user can now run the Pick Release processes in parallel and improve the over all performance.

Advantages

One of Key Advantage of with Parallel Processing of the Pick release process is user can apply /engage additional (if available) resources to process the Pick release data that was previously process by 1 process only and hence save lot of time by submitting this process in Parallel.

Following are the changes made for this feature –

1. A new Parameter has introduced in Pick release Concurrent Program.

2. A new profile option has introduced.

Parameter –

No. Of Child Processes – This parameter indicates how many child processes you want to spawn.

Profile Option -

WSH: No. Of pick release child processes. – Indicate how many child processes you want to spawn.

If we run the Pick release from SRS or Public API then profile option determine the # of child processes to be spawned.

If we run the Pick release from in Online Mode or Public API (online mode) then only 1 child processes to be spawned ( as good as existing behavior).

Some Constraints -

Irrespective of the parameter value and the profile option only 1 child process will be spawned if

1. Auto Create Delivery = Y and print Pick Slip is set as Immediate

2. Auto Create Delivery = Y and Delivery is enabled as Pick slip Grouping rule.

Setup

WSH: No. of pick release child processes.

If value of this profile option is Null or 1 then only 1 Child Process will be submitted.

If value of this profile option is > = 2 ( 2 to n) then N no. of Child Process will be submitted for Pick release ( some restriction applied , as discussed below).

By setting this profile option to any value doesn’t mean system will spawned that many child process. The # of child process spawned depend upon this profile option as well as the Unique item in the data SELECTED for the pick release.

Or more precisely we say No. of child process available for Pick release depend on the # of unique “Item and Organization “ combination.

e.g –

1. If Organization V1 has 100 unique item

2. Profile option is set to value of 10

Case #1

If in the data selected for pick release has 20 Unique items, the # of child process submitted for Parallel Pick release will be 10.

Case #2

If in the data selected for pick release has 4 Unique items, the # of child process submitted for Parallel Pick release will be 4 , irrespective of Profile option is set to value of 10.

Concurrent Program

As explained earlier a new Parameter (No. of Child Processes) has been introduced in concurrent Program “ Pick Selection List Generation – SRS”.

No. of child processes spawned are depend on the value you enter in this parameter , and by default value from the Profile option “WSH: No. of pick release child processes” defaulted for this parameter , but here we have advantage to overwrite the value of profile.

Note – both the case#1 and case#2 will valid here too.

Note - # of pick slip reports not depend on this profile options, they still depend on the pick slip Grouping rules.

Other Considerations

• If we submit the pick release process from the Shipping Transaction UI, then only 1 process will be launch, parallel Pick release will not applicable, but if we launch the Pick Release process from Shipping transaction UI , Tools > then the Parallel Pick release Process will work fine.

• In SRS window, all the child process will carry the Parent Request ID of the parent.