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

Last updated on SEPTEMBER 23, 2016

Applies to:

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

Symptoms

Intermittently the Pull replenishment requests errors out with the following message

ERROR

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.

STEPS

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

Changes

 

Cause

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