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

Last updated on JUNE 11, 2017

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.get_reord_stat: ILOPEZ: -1086, ORA-01086: savepoint 'SP_DO_RESTOCK' never established in this session or is invalid
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06510: PL/SQL: unhandled user-defined exception
[11-JUL-14 09:12:44] INV_Minmax_PVT.RUN_MIN_MAX_PLAN: ILOPEZ: -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 $): ILOPEZ: 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

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