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 laterInformation 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
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 |