# Maintain History of Changes made to Palette user from Palette

A Rules Palette user having appropriate security management privileges in Rules Palette can create, modify, remove OIRP users, and make changes to their Security Role. The history of changes for OIRP Users done via Rules Palette is stored in AsHistory and AsHistoryDetail tables. To increase the performance of history tables, history related to various entities is being segregated to entity wise history tables. With this enhancement all the changes made to Palette user made via Palette will be moved to IVSUserHistory and IVSUserHistoryDetail tables and will be available for auditing purposes. For logging changes made to Palette user via Palette IVS should be ON and history will not get recorded if IVS is OFF.

1. History for Palette user will get recorded when:

2. A new user is added to OIRP.

3. Existing user information is modified.

4. Existing user's security role is modified.

5. User is Deleted.

New tables to store Palette users' history are:

Table | Column | Definition
IvsUserHistory | USERHISTORYGUID | This column stores the client historyguid. And will be the primary key.
| USERGUID | This column stores the UserGuid. (IVSUSER)
| OPERATIONCODE | This column stores code for the operation.
| CREATEDBY | This column stores the USERNAME (IVSUSER) of the palette user who has done the modification.
| CREATEDGMT | This column stores the created GMT.
| DETAILS | This column stores the details
IVSUserHistoryDetail | USERHISTORYGUID | This column stores the client historyguid.
| FIELDNAME | This column stores the field name like SecurityRole
| FROMDATA | This column stores the old value.
| TODATA | This column stores the new value.

Below codes are added to IVSCode table for Palette user history changes lookup:

Table | CodeName | Value | Definition
ASIVSUserHistory | PaletteUserHistoryOperation | ADD | This code will be used to reference the Add History Operation in IvsUserHistory
| PaletteUserHistoryOperation | UPDATE | This code will be used to reference the Update History Operation is IvsUserHistory
| PaletteUserHistoryOperation | DELETE | This code will be used to reference the Delete History Operation is IvsUserHistory

## Upgrade Utility Updates

- Creates new schema for OIRP history tables and creates the tables in IVS database.

- AsCodeHistoryType for PaletteUserHistory will be deleted.

- New codes for PaletteUserHistoryOperation will be created in IVSCode table.

- If the customer has Palette history details in AsHistory and AsHistoryDetail tables scripts will be provided to migrate data from AsHistory and AsHistoryDetail table to IVSHistory and IVSHistoryDetail table.

- Palette user history data will be deleted from AsHistory and AsHistoryDetail tables.

Column mapping for data migration from AsHistory to IVSHistory table and ASHistoryDetail and IVSHistoryDetail tables as below:

ASHistory Column Name | IVSHistory Column Name
HistoryGUID | UserHistoryGUID
RelatedGUID | UserGUID
OperationCode | OperationCode
UpdatedBy | CreatedBy
UpdatedGMT | CreatedGMT
Details | Details

ASHistoryDetail Column Name | IVSHistoryDetail Column Name
HistoryGUID | UserHistoryGUID
FieldName | FieldName
DataTypeCode | DataTypeCode
FromData | FromData
ToData | ToData

## Manual Configuration Updates

If the SQL in any of the existing business rule's configuration is using Palette user's historical data, the same must be manually updated to reflect the new tables IVSHistory and IVSHistoryDetail .

### Maintain History of Changes made to Application User

Administration of OIPA Application users is done in Rules Palette. Rules Palette User with necessary security management privileges in Rules Palette can create, modify, remove and reactivate the OIPA Application users, and change their links to the Security Groups. The history of changes made to the Application users is recorded in AsHistory and AsHistoryDetail tables in OIPA. To increase the performance of history tables, history related to various entities is being segregated to entity wise history tables. With this enhancement all the changes made to Application users made through Palette will be moved to AsUserHistory and AsUserHistoryDetail tables and will be available for auditing purposes

The history of changes for OIPA Users gets recorded on

- Adding a new OIPA user

- Modifying information related to OIPA user

- Adding a security group to the OIPA user

- Deactivating security group from the OIPA user

- Inactivate the OIPA user

- Reactivate the OIPA user

Table Name | Column | Definition
ASUSERHISTORY | USERHISTORYGUID | This column stores the User historyguid, also it is the primary key
| CLIENTGUID | This column stores the clientguid of the OIPA User for which the change was done.
| OPERATIONCODE | This column stores code for the operation.
| CREATEDBY | This column stores the USERNAME of the palette user who has done the modification.
| CREATEDGMT | This column stores the createdgmt.
| DETAILS | This column stores the details
ASUSERHISTORYDETAIL | USERHISTORYGUID | This column stores the client historyguid.
| FIELDNAME | This column stores the fieldname.
| DATATYPECODE | This column stores the datatypecode.
| SECURITYGROUPGUID | This column stores the SecurityGroupGUID for a case when FROMDATA and TODATA are for a Security Group
| FROMDATA | This column stores the old value.
| TODATA | This column stores the new value.

### Upgrade Utility Updates

- Creates new schema for OIPA history tables and creates the tables in OIPA database.

- AsCodeHistoryType for AppUserHistory and AppUserRoleHistory with values 28 and 29 will be deleted.

- New codes for User history Operation will be created in ASCode table.

- Migrates data from AsHistory and AsHistoryDetail table to AsUserHistory and AsUserHistoryDetail table.

- Application user history data will be deleted from AsHistory and AsHistoryDetail tables.

### Manual Configuration Updates

If the SQL's in any of the existing business rule's configuration is using Application user's historical data, the same must be manually updated to reflect the data from new tables AsUserHistory and AsUserHistoryDetail.

| Copyright © 2025, Oracle and/or its affiliates. All rights reserved. | About Oracle Insurance | Customer Support