My Oracle Support Banner

Sales Order Pick Release With Auto Allocate Fails With Error 'Pick Release process could not allocate xx of item xxx for order xxx as there was insufficient quantity available Or Inventory allocations have failed, and the line has been back ordered' (Doc ID 2984242.1)

Last updated on OCTOBER 31, 2023

Applies to:

Oracle Warehouse Management - Version 12.2.11 and later
Oracle Inventory Management - Version 12.2.11 and later
Information in this document applies to any platform.

Symptoms

In Inventory Organization, the sales orders pick release process with auto allocate fails every time. Manual allocation from transact move order form works fine.

ERROR
-----------------------
Pick Release process could not allocate xx of item xxx for order xxx as there was insufficient quantity available Or Inventory allocations have failed, and the line has been back ordered.

The 'Pick Selection List Generation' request debug log shows :

wms.plsql.WMS_Rule_PVT.Apply.other_error: Other error - FNDFND_API.G_MISS_CHARFND_AS_UNEXPECTED_ERRORFND_API.G_MISS_CHARNFND_API.G_MISS_CHARPKG_NAMEFND_API.G_MISS_CHAR
WMS_Rule_PVTFND_API.G_MISS_CHARNFND_API.G_MISS_CHARPROCEDURE_NAMEFND_API.G_MISS_CHARApplyFND_API.G_MISS_CHARNFND_API.G_MISS_CHAR
ERROR_TEXTFND_API.G_MISS_CHARORA-06502: PL/SQL: numeric or value error: character to number conversion error

STEPS
-----------------------

1. Go to Order Management > Shipping > Release Sales Orders > Release Sales Orders
2. Perform pick release with auto allocate as Yes
3. Check log file of 'Pick Selection List Generation' concurrent program
4. The reported error can be seen

Changes

 Upgraded to 12.2.11

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.