My Oracle Support Banner

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

Last updated on JUNE 24, 2024

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.

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: xxxxx
The item specified is invalid or does 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 does 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

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


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