Denormalized Columns are Not Properly Updated in Task Based UI (TBUI) When Immediate Commit In Task = True for the Business Component
(Doc ID 1311802.1)
Last updated on FEBRUARY 03, 2019
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!