After Upgrade Application Hangs because of a Never Ending Query Running On S_ASSET_CON
Last updated on AUGUST 21, 2017
Applies to:Siebel Field Service - Version 22.214.171.124.9 [IP2013] and later
Siebel CRM - Version 126.96.36.199  to 188.8.131.52  [Release V8]
Information in this document applies to any platform.
After upgrade to 184.108.40.206 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
Million Knowledge Articles and hundreds of Community platforms