ORA-01086 Savepoint 'PROCESS_ORDER' Never Established In Session Or Session Invalid
Last updated on JANUARY 02, 2018
Applies to:Oracle Order Management - Version 12.1.3 to 12.2.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 17-MAR-2015***
On : 12.1.3 version,
When attempting to run order import the system tries to create a sales order for EDI Orders the Order import
fails giving the above and a number of other error messages.
Error ORA-01086: savepoint 'PROCESS_ORDER' never established in the session or is invalid.
ORA-01086: savepoint 'LINES_NON_PARTIAL' never established in this session or is invalid.
ORA-06512: at "APPS.OE_ORDER_PVT", line 3708
ORA-01086: savepoint 'LINES' never established in this session or is invalid
ORA-06510: PL/SQL: unhandled user-defined exception in Package OE_Order_GRP Procedure Process_Order
Order Number: 1794442
The item specified is invalid or dos not exist in the warehouse you specified. Please enter a valid item-warehouse combination.
You are trying to insert an existing order or update an order that dos not exist. Please enter a correct operation code.
Both value and ID columns have been supplied for this attribute (Atrribute:sold_to_org). ID column for this attribute will be used while processing this order.
This Customer's PO Number is referenced by another order.
*Observe: In spite of the Errors , Oracle is creating the Order header without order line > Manual Creation of the Order and Order line is successful.
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Run Order Import Process
3. Correction Form shows ORA-01086 and ORA-06510 error messages.
4. Sales Order is created with header information but no line information
5. *User must manually create the line information on order 1794442
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms