My Oracle Support Banner

Row Lock Contention Observed with S_PROD_INV table and FDRs generated during Fulfillment and Process Shipment (Doc ID 2460773.1)

Last updated on JULY 09, 2020

Applies to:

Siebel Field Service - Version 8.1.1.11.11 [IP2013] and later
Information in this document applies to any platform.

Symptoms

On :  8.1.1.11.11 [IP2013] version, Field Service

ACTUAL BEHAVIOR  
---------------
While doing the process shipment concurrently by many users the S_PROD_INV TABLE gets locked and FDR files generated

EXPECTED BEHAVIOR
-----------------------
While doing the process shipment concurrently by many users the S_PROD_INV TABLE shouldn't be locked and FDR files shouldn't have generated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Navigate to Job card,
Do some partial fulfillment concurrently with many users
Application struck.

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.