LastModifiedBy Column In AsRequirement Is Not Being Populated/updated

(Doc ID 2337443.1)

Last updated on DECEMBER 08, 2017

Applies to:

Oracle Insurance Policy Administration J2EE - Version 11.0.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 11.0.2.5 version, Activity

ACTUAL BEHAVIOR
---------------
Whether the Requirement is created manually, using the AdRequirement button on the Requirements screen, or by the system, using the AddRequirements Business Rule, the LastModifiedBy column in AsRequirement is not being populated. When updating the requirement on the screen, the LastModifiedBy column is still not updated and remains NULL. We need the system to maintain this information, whether the requirement is created/updated by the system or by the user. This used to work in V10, as confirmed by Devika Ravindran.

EXPECTED BEHAVIOR
-----------------------
When a requirement is added/modified in OIPA the LastModifiedBy column in AsRequirement is updated with the user who made this change whether it be a user or the system.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Process 1:
1) Navigate to a Policy in OIPA where you can add a requirement via the 'Add Requirement' button
2) Add a requirement to this policy, any requirement will work
3) Once added query the AsRequirement table and the LastModifiedBy column will be NULL

Process 2:
1) Configure a transaction to add requirements via the Addrequirement attached rule
2) Navigate to a policy in OIPA where you can process this transaction
3) Add and process this activity, once again choose any available requirement
4) Query the AsRequirement table and notice the LastModifiedBy column is NULL

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the system does not maintain this information, whether the requirement is created/updated by the system or by the user.

Changes

 

Cause

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