My Oracle Support Banner

Error "ORA-01086: savepoint 'PROCESS_ORDER_PUB' never established" When Selecting Quick Order From Parts Requirement Form (Doc ID 2403006.1)

Last updated on MAY 24, 2018

Applies to:

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

Symptoms

On : 12.1.3  Spares management

When attempting to select the 'Quick order' button on the parts requirement form the following error occurs.

ERROR
-----------------------
ORA-01086: savepoint 'PROCESS_ORDER_PUB' never established in this session or is invalid ORA-06512: at "APPS.JTF_PLSQL_API", line 65 ORA-06512: at "APPS.CSP_PARTS_ORDER", line 4392 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.CSP_PARTS_ORDER_W", line 215 ORA-06512: at line 1

The FND Debug log shows the following details:

csp.plsql.csp_parts_order.process_order Error in OE_Order_PUB.Process_Order API... Message = Item Validation Resulted in error(s).

fnd.framework.webui.OAPageErrorHandler "OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: ORA-01086: savepoint 'PROCESS_ORDER_PUB' never established in this session or is invalid
ORA-06512: at ""APPS.JTF_PLSQL_API"", line 65
ORA-06512: at ""APPS.CSP_PARTS_ORDER"", line 4392
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at ""APPS.CSP_PARTS_ORDER_W"", line 215
ORA-06512: at line 1



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create task and click on Part Requirement button
2. Select the item for the part requirement and click "Quick Order"
3. The error occurs

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!


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