Resetting Presentation Object Change Repository

Presentation object change repository is used to keep track of the changes done to the presentation objects. This is used to generate the change information of the presentation objects. The change information can be "New", "Modified" or "Removed".

Before Upgrade

Before doing an upgrade or delivery make sure the presentation object change repository is reset. If not the new changes will not be clearly distinguishable.

After Upgrade

After an upgrade or delivery; security grants for new and modified presentation objects in the delivery should be updated accordingly. The presentation object change information can be used to find out which presentation objects and database objects need to be granted to the permission sets.

The objects which need to be looked into can be found by selecting all presentation objects in the Presentation Object Grants form with a "New" or "Modified" change info, or by looking at the pres_object_changes.log which is created in the deployment process. These presentation objects needs to be regranted. In order to make this process easier, use one of the mechanisms described in the Upgrade Permission Sets.

Afterwards, a security validation must be done from the customer’s security requirement perspective to verify and ensure that the security settings are as required.

Once all the presentation objects are granted, and verified that the permission sets contain the correct grants for the changed presentation objects; the presentation object change repository should be reset. This action will clear change date and the change information. It is very important to note that this is a mandatory step and should be done only after verifying the changed presentation objects are granted as required, and completed successfully.

How to Reset the Presentation Object Change Repository

There are two ways to reset the change repository.

1. You can select to reset this information for the selected presentation objects or for all presentation objects in a component (the component for the selected presentation object) or for all presentation objects by using the right mouse button click option, "Reset Change Information" available in "Presentation Object Grants" form.
2. Or you can execute these PL/SQL blocks shown below.

   
   Use this method to reset the change information for all the modules.
   

   BEGIN
   Pres_Object_Util_Api.Reset_Change_Repository(module_ => '%');
   COMMIT;
   END;

   Or use the method to reset the change information for a single module at a time.

   Example: 'FNDBAS'
   

   BEGIN
   Pres_Object_Util_Api.Reset_Change_Repository(module_ => 'FNDBAS');
   COMMIT;
   END;