My Oracle Support Banner

Debrief Stuck in Pending Status Due to ORA-01086: savepoint 'BEFORE_FETCH' Error (Doc ID 2741914.1)

Last updated on JANUARY 11, 2021

Applies to:

Oracle Field Service - Version 12.2.6 to 12.2.10 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.X version, Debrief

ACTUAL BEHAVIOR
---------------
Debrief transactions are failing with the following error:

Debrief header ID: XXXXXXX
An instance could not be found for the item and location information
provided. Item ID: XXXXXX. Organization ID: XXXX. (SUBINV=MY_SUBINV)(LOCATOR=)

ORA-01086: savepoint 'BEFORE_FETCH' never established in this session or is invalid

The debrief is stuck in 'Pending' status, actual charge lines do not get generated and Material does not get consumed.

The first message is valid as the item has already been debriefed but the 'savepoint' error is causing the debrief to go to pending status and there is no way to further progress the transaction without a data fix.

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