My Oracle Support Banner

Audit Trail Not Working On Custom Standalone Table Join Fields In TBUI (Doc ID 2339243.1)

Last updated on DECEMBER 01, 2020

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 values with custom standalone table join fields within TBUI.

Perform 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

Due to this issue, Users are not able to capture the history (via Audit Trail) of custom standalone table join field value changes with TBUI navigation.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.