ORA-01086 Savepoint 'PROCESS_ORDER' Never Established In Session Or Session Invalid (Doc ID 1588316.1)

Last updated on AUGUST 17, 2016

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

Symptoms

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
-----------------------
Corrections Form:
------
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

Processing Message:
------
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.

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


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