Pull Replenishment - Error Creating Move Order: -1426, ORA-01426: Numeric Overflow
(Doc ID 2668222.1)
Last updated on JUNE 04, 2021
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, Cycle and Physical Counts
When trying to allocate Sales Order using Release Sales Order form with pull replanishment flag on WMS enabled warehouse, the user receives the error below:
ERROR
-----------------------
Pull Replenishment - Error creating move order: -1426, ORA-01426: numeric overflow
Request Pull Replenishment finishes with error:
Cause: FDPSTP failed due to ORA-01086: savepoint 'DYNAMIC_REPLENISHMENT_SP' never established in this session or is invalid
ORA-06512: at "APPS.WMS_REPLENISHMENT_PVT", line 2009
ORA-06510: PL/SQL: unhandled user-defined except13-JAN-2020 15:29:24
...
13-JAN-20 15:29:33] WMS_REPLENISHMENT_PVT: Number of reservations found: 1
[13-JAN-20 15:29:33] WMS_REPLENISHMENT_PVT: CREATE_REPL_MOVE_ORDER: Error creating move order: -1426, ORA-01426: numeric overflow
[13-JAN-20 15:29:33] WMS_REPLENISHMENT_PVT: Error from API process_replenishment
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Warehouse management responsibility
2. Outbound logistics - Release pick waves
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 |
Cause |
Solution |
References |