My Oracle Support Banner

Error With API Fnd_transaction.synchronous, SQLERRM: ORA-01086 (Doc ID 2813236.1)

Last updated on JULY 20, 2023

Applies to:

Oracle Concurrent Processing - Version 12.2 and later
Oracle Inventory Management - Version 12.2.10 to 12.2.10 [Release 12.2]
Information in this document applies to any platform.

Symptoms

When trying to use INV_Pick_Wave_Pick_Confirm_PUB.Pick_Confirm API to transact against work order/wip issue related transactions noticed
it completed with error.


inv_pick_wave_pick_confirm_pub.pick_confirm $INV_ITI_062_GBL[20210907033939]: SQLCODE: -1086
SQLCODE: -1086
SQLERRM: ORA-01086: savepoint 'TO_TRX_LINE_SAVE' never established in this session or is invalid ORA-06510: PL/SQL: unhandled user-defined exception


Error with API fnd_transaction.synchronous
related to RAC-PCP instances only

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.