Audit Trail Not Working On Custom Standalone Table Join Fields In TBUI

(Doc ID 2339243.1)

Last updated on DECEMBER 14, 2017

Applies to:

Siebel CRM - Version 15.15 [IP2015] and later
Information in this document applies to any platform.


On : 15.15 [IP2015] version, Task Based UI

Audit trail should capture the new and old field value in case of custom standalone table join fields within the TBUI

Audit train not capturing the New Field value in case of custom standalone table join fields within the TBUI

The issue can be reproduced at will with the following steps:
configuration in Siebel Tools to create custom standalone table and join the custom table to account BC
1. Create Custom Table CX_TEST with following columns
Name : TEST1, Type = Extension, Physical Type = Varchar, Length = 100
Name : TEST2, Type = Extension, Physical Type = Varchar, Length = 100
Name : TEST3, Type = Extension, Physical Type = Varchar, Length = 100

publish and activate the table

2. Create BC with custom table reference
Name : Test Audit
Class : CSSBusComp
Table : CX_TEST

Field Details :-
Name : TEST1, Column : TEST1
Name : TEST2, Column : TEST2
Name : TEST3, Column : TEST3

3. Create dynamic Pick List "Test Audit" based on custom BC : Test Audit

4. Add new BC : "Test Audit" under Account BO

5. Create Pick Applet with all the 3 fileds based on Custom BC "Test Audit"
Name : Test Audit Pick, BC : Test Audit, Class : CSSFrameList, Type : Pick List
Add following user Property
Name : EnableStandardMethods
Value : Y

6. Create Join under Account BC with custom Table
Table : CX_TEST, Alias : CX_TEST, Outer Join Flag : True
Join Specification :-
Name : CX_TEST
Destination Column : TEST3
Source Field : Name

7. Add join fields as below under Account BC
Name : TEST1, Join : CX_TEST, Column : TEST1, Pick List : Test Audit
Name : TEST2, Join : CX_TEST, Column : TEST2

Add pickmap for "TEST1" join field
Field : Name, Picklist Field : TEST3
Field : TEST1, Picklist Field : TEST1
Field : TEST2, Picklist Field : TEST2

8. Clone the *SIS Account List Applet* applet and give name "SIS Account List Applet1"
under this new applet add new list columns refering to "TEST1", "TEST2" fields
for TEST1 field add pick applet "Test Audit Pick" and make runtime property TRUE
display these 2 list columns in UI(Webtemplaet Item)
Add following user Property
Name : EnableStandardMethods
Value : Y

==> Task Configuration
1. Create New Task View "Test Audit" with *Account* bo reference and add following applets
SIS Account List Applet1
Task Playbar Applet - Bottom
Task Playbar Applet - Top

2. Create New Task "Test Audit" with following steps
Step A : Start
Step B : Task View : Test Audit
Step C : End

3. Create new Task Group "Test Audit" and add newly created Task under this Task Group

4. Add newly created Task Group under Task Pane View

==> Changes in application
1. Add newly created Task and View under responsibility
2. Go to Administration - Audit Trial and add following Account BC field for Auditing
Do clear cache

Compile all the changes

Scenario :-
1. Launch the application ,  open task pane and launch *Test Audit* Task
2. Open pick applet on TEST1 field and change this field value
Now Account Name, TEST1,TEST2 field values got changed
3. Finish the Task

Now go to Audit trail and Audit Trial Items
Observed that only old value captured for "TEST1" and "TEST2" fields

expected :- Old and New values should be captured properly in audit trial in case standalone table related join fields as well in side the task

Note :- Same scenario working fine when we change the field value out side the TBUI

The issue has the following business impact:
Due to this issue, users cannot .


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