Accessing a View Automatically Sets the Last Updated System Fields (Doc ID 512542.1)

Symptoms

We have noticed that in some of our views, while a user accesses a view, the Last Updated By and Last Updated Date information automatically gets set. This happens even when the user has made no changes in the view.

Based on some investigation at our end and after going through some similar Service Request postings, we conclude that this happens due to the below mentioned reasons:
- MVL settings in a BC. Auto Primary set to Default.
- If for some reason, the primary id is null, Siebel automatically sets it to a value of 'No Match Row Id'. This can be seen in spool. This cannot be traced while debugging and puttting break pts in PrewriteRecord of BC.

There could be further reasons (substantiating the above) as well as to why this happens in our configuration:
- Addition of new MVGs and Primary fields during the course of the project as part of changes requested by users.
- Modification and viewing of same data through different BCs (and views). We have few copies of the Opportunity BC and have noticed that the properties of all the MVLs do not match. Some are missing in one of the BCs and some do not completely match, since they are not really needed.

This last updated information is very crucial to our users and hence we need your support in resolving this issue due to Siebel behaviour. We would request you for the following info:
1. Is our understanding (as explained above) of the issue correct?
2. How can we ensure that Siebel does not update the records automatically? Please note that we do need to use the Siebel standard auto Primary functionality.
3. Is there any workaround to ensure that Siebel does not update the past as well as future data? What measures can be taken?

Cause

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