After Upgrade Application Hangs because of a Never Ending Query Running On S_ASSET_CON

(Doc ID 1956567.1)

Last updated on AUGUST 21, 2017

Applies to:

Siebel Field Service - Version [IP2013] and later
Siebel CRM - Version [23021] to [23021] [Release V8]
Information in this document applies to any platform.


After upgrade to there were reported hang behaviors when using functionalities involving assets.

When S_ASSET table is queried and based on the result number of the assets/records, application instantiates the BS "FINS Data Transfer Utilities" which further tries to write on BC - Asset Mgmt - Asset which has a Run Time Event  with Action set "AssetToAssetContact - Upsert" created. This causes a repeating query against S_ASSET_CON table and the application hangs.


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