E1: BSSV Multiple JDE/BSSV Sessions Are Causing Row Locks On The Database (DB lock)
Last updated on DECEMBER 04, 2017
Applies to:JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.
You have custom integrations using BSSV solutions. Both Provider and Consumer. Provider does some table I/O against F0006 by calling a custom BSFN. When Oracle FMW calls the BSSV, it generates 6 sessions and F0006 gets locked.
Because of that, any of the E1 users who use applications or UBE's that access the F0006, get an error.
You have a dedicated logic server for the BSSV integrations. You would like to know why the BSSV requests are causing the table lock.
In order to fix the issue, you have to kill the kernels and db sessions to stop the lock.
You might see this issue using the JAVA Interop Solution.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms