How to View or Change a Planning Application Owner (Doc ID 1327618.1)

Applies to:
Hyperion Planning – Version: 9.2.0.0.00 to 11.1.2.1.000 – Release: 9.2 to 11.1
Information in this document applies to any platform.

Goal
How can we determine which user is the owner of a Planning application?
How can we change which user owns the application?

Solution
Only one user can be the owner of a Planning application. That user has all the ordinary rights of an administrator user, plus the additional rights to delete the application.

The user who created the application originally (or deployed it from EPMA originally) is the initial owner. Only that user can hand over ownership to another administrator user. To hand over the ownership (assuming you know who the owner is):

1.Log into the Planning application with the application owner

2.Administration > Application Settings

3.At the bottom of this page is a menu that allows the owner to hand over the ownership to any other provisioned administrator for this application. Only the owner can see this menu.

If you do not know who the owner is, the easiest way to determine this is by looking in the Planning application database schema. You can also change ownership directly in the tables, although we recommend that it is changed via the user interface, as above.

1.Look at the contents of the HSP_USERS table. The owner has a ROLE value of 3. Ordinary administrators have a ROLE of 0.

2.Make a note of the USER_ID of the user with a ROLE of 3

3.Look in the HSP_OBJECT table for a record with an OBJECT_ID that matches the USER_ID recorded in the previous step

4.This record’s OBJECT_NAME is the user name of your application owner

If you want to reset ownership you can change the ROLE of an existing administrator to 3, and set the current owner’s role to 0. As above, you will need to look at the HSP_OBJECT table to work out which user corresponds to which USER_ID.

Restart the Planning service after modifying the database in order for the changes to take effect.

Note: Before making any manual changes to the relational repository please ensure that you have a working backup of the database.

Advertisements
This entry was posted in Oracle EPM, Oracle Hyperion Planning and tagged , , , . Bookmark the permalink.

3 Responses to How to View or Change a Planning Application Owner (Doc ID 1327618.1)

  1. raphael laigneau says:

    Hey I am a EPM consultant living in the US. I am thinking about relocating to Brazil. Can we please discuss?

  2. ヴィトン says:

    I simply could not go away your site prior to suggesting that I extremely loved the
    usual information an individual provide on your visitors?
    Is going to be back continuously to inspect new posts

  3. Suyog Mandloi says:

    Really useful information

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s