My Oracle Support Banner

WMSDYREPL - Pull Replenishment Error ORA-01086: Savepoint 'Dynamic_replenishment_sp' Never Established (Doc ID 1448339.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

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


Intermittently the Pull replenishment requests errors out with the following message


This is happening in a typical case where delivery lines have been split because of partial picks but the order line has not.
In such a case the procedure to calculate effective available to reserve qty  is not calculating the correct qty and thinks there is qty available when there is not.


The issue can be reproduced at will with the following steps:
1. Pick Multiple Orders which cause lines to be split and all material to be consumed.
2. Run pick release again with pull replenishment = Yes


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

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