My Oracle Support Banner

Min-Max Errors ORA-01086 Savepoint 'SP_DO_RESTOCK' Never Established In This Session Or Is Invalid (Doc ID 1907146.1)

Last updated on FEBRUARY 20, 2019

Applies to:

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

Symptoms

The Min-Max planning is not generating purchasing requisition.

Error

[11-JUL-14 09:12:44] INV_Minmax_PVT.RUN_MIN_MAX_PLAN: -1086, ORA-01086: savepoint 'SP_DO_RESTOCK' never established in this session or is invalid
ORA-06512: at "APPS.INV_MINMAX_PVT", line 3796
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06510: PL/SQL: unhandled user-defined exception
[11-JUL-14 09:12:44] INV_MMX_WRAPPER_PVT.EXEC_MIN_MAX($Revision: 120.6 $): INV_Minmax_PVT.run_min_max_plan failed with expected error for subinventory TESTSUB returning message: ORA-01086: savepoint 'SP_DO_RESTOCK' never established in this session or is invalid
ORA-06512: at "APPS.INV_MINMAX_PVT", line 3796
ORA-06510: PL/SQL: unhandled user-defined exception


Steps to reproduce

1. Inventory > Planning > Min/Max Planning
2. Enter subinventory level panning
3. Run Min/Max Planning Report

Changes

 

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.