Denormalized Columns are Not Properly Updated in Task Based UI (TBUI) When Immediate Commit In Task = True for the Business Component
Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 8.1.1  and later
Information in this document applies to any platform.
It was reported that denormalized columns on S_SRV_REQ_BU are NOT properly updated when Service Request record is created in Task Based UI (TBUI) when transaction has been disabled in the task for the Service Request business component.
Note that transaction can be disabled for the entire task with the task property "Transactional" set to False, or by setting the "Immediate Commit In Task" Business Component User Prop on the business component to True.
Regular UI: When a new Service Request is created outside of Task Based UI task flow in the ad-hoc regular UI the denormalized columns on the intertable S_SRV_REQ_BU are populated properly.
Task Based UI - transactional: When Immediate Commit in Task was set to FALSE (or this user property was removed entirely from the Service Request Business Component) the denormalized columns on the intertable S_SRV_REQ_BU were populated properly.
Task Based UI - transaction disabled: It was found that when task transaction had been disabled, the denormalized columns were NOT being properly updated.
This issue in Task based UI with denormalized columns and disabled task transaction is likely present for other business components which have denormalized columns.
The following is a screenshot of the denormalized columns on the S_SRV_REQ_BU table:
There are 8 denormalized columns on the S_SRV_REQ_BU table, as shown above.
SR_AREA, SR_CST_NUM, SR_NUM, SR_SEV_CD, SR_STAT_ID, SR_SUB_STAT_ID, SR_TITLE, SR_TYPE_CD
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