My Oracle Support Banner

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

Last updated on JANUARY 23, 2023

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.


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.

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.

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




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

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