Siebel 8.1.1 upgrep process takes long time to insert rows in table S_ASSET_BU
Last updated on MARCH 06, 2016
Applies to:Siebel Call Center - Version 18.104.22.168  and later
Information in this document applies to any platform.
When upgrading a Siebel version form 8.0 sea to 22.214.171.124 sia in development upgrade, upgrep step, poor performance is encountered during INSERT SQL statement. It is taking more than 4 hours.
insert into S_ASSET_BU
select .. from S_ASSET
where BU_ID not in ('0', 'No Match Row Id') and
not exists(select 'x' from S_ASSET_BU
where (ROW_ID = S_ASSET.ROW_ID) or
(ASSET_ID = S_ASSET.ROW_ID and BU_ID = S_ASSET.BU_ID
and CONFLICT_ID = S_ASSET.CONFLICT_ID))
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