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

Last updated on JUNE 24, 2024

Applies to:

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

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