Home » Oracle » hyperion » How to generate epm registry report and edit it

How to generate epm registry report and edit it

epmsys_registry utility is used to generate the report and edit it

How to generate epm registry report

You create the report by running the epmsys_registry utility with no parameters

cd /d d:\Oracle\Middleware\user_projects\epm_system1\bin
epmsys_registry

An HTML formatted report is saved to:

<Middleware_Home>\user_projects\\epm_system1\diagnostics\reports\deployment_report.html

This registry report will contain all the information stored in the registry.

How to edit the epm registry

We have various options available with the epm_registry utility to edit the information in the registry

  • view
  • updateproperty
  • removeproperty
  • addencryptedproperty
  • updateencryptedproperty
  • addfile
  • updatefile
  • removefile
  • createlink
  • removelink
  • createcomponenthierarchy
  • deletecomponent
  • updatehost
  • viewencryptedproperty
  • viewhierarchy
  • addproperty

The most common of use in view and update property

View examples

If we need to see all the properties of the component

D:\Oracle\Middleware\user_projects\epm_system1\bin>epmsys_registry.bat view <component id>
example
D:\Oracle\Middleware\user_projects\epm_system1\bin>epmsys_registry.bat view #89698696ghdhddd

If we need to see a particular property of the component

D:\Oracle\Middleware\user_projects\epm_system1\bin>epmsys_registry.bat view <component id>/@<property> 
example D:\Oracle\Middleware\user_projects\epm_system1\bin>epmsys_registry.bat view #89698696ghdhddd/@filesystem.artifact.path

updateproperty examples

If we need to update a particular property of the component

D:\Oracle\Middleware\user_projects\epm_system1\bin>epmsys_registry.bat updateproperty <component id>/@<property>   <new value>
example D:\Oracle\Middleware\user_projects\epm_system1\bin>epmsys_registry.bat updateproperty #89698696ghdhddd/@filesystem.artifact.path  e:/oracle/temp

viewencryptedproperty examples

If you want to view the password stored in epm registry, then this option can be used

epmsys_registry.sh viewencryptedproperty aif_product/database_conn/@dbPassword

deletecomponent example

epmsys_registry deletecomponent #componentID

I hope you like this article and it helps you

See also  Enabling TLS in Oracle Apps R12.2

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top