PJM - R12 - Pick Release Failing to Allocate Project Sales Orders After Applying Inventory Management Rollup Patch
Last updated on DECEMBER 19, 2017
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Oracle Shipping Execution - Version 12.1.3 and later
Oracle Project Manufacturing - Version 12.1.3 and later
Information in this document applies to any platform.
Form: PJMFDOGP.fmb - PJM Organization Parameters
Form: INVTOTRX.fmb - Transact Move Orders
Form: WSHFSTRX.fmb - Shipping Transactions
Concurrent: WSHPSGL - Pick Selection List Generation
Concurrent: WSHPSRS - Pick Selection List Generation - SRS
On release 12:
After patching, pick release / allocation of Pick Wave (Sales Order) move orders is failing for project sales orders with the following errors, whereas there is enough available quantity for the item, either in common stock or for different project/task. (eg different than the project/task stamped on the sales order line)
Related organization is Project Manufacturing (PJM) enabled.
-- Error #1
In the request log of the pick release for a run with Auto Allocate=Yes:
"Pick Release process could not allocate ... of item ... for order ... as there was insufficient quantity available Or Inventory allocations have failed, and the line has been back ordered."
-- Error #2
In Transact Move Orders form:
"Error: The material sourcing Process failed to create picking suggestions for line ... of Move order number ..."
When there is not enough available quantity for the project/task stamped on the sales order line, expect the system to allocate the material from common stock or from different project/task if any is available, like before patching.
How to get the old behavior back?
The issue can be reproduced at will with the following steps:
1. Launch the pick release with Auto Allocate=Yes
2. See the Pick Selection List Generation request completed with Warning
3. Review the request log and see error #1
1. Launch the pick release with Auto Allocate=No
2. Go to Transact Move Orders form
3. Query the sales order
4. In Transact Move Orders (main) window, press button Allocate
5. See error #2
-- Business immpact
Due to this issue, sales orders are getting backordered and then products cannot be shipped out to customers.
The problem started to occur after applying INV/RCV RUP8 rollup patch for release 12.1 (<Patch:R12.INV.B.delta.8>),
-OR- after applying any subsequent rollup patch (and prior Inventory rollup patch level was lower than INV/RCV RUP8),
-OR- after applying <Patch:17868828:R12.INV.B>.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms