Skip to Content
0

How to modify the recurrance owner using BO SDK

Feb 07, 2017 at 09:27 PM

101

avatar image

Hi All,

We have a written an SDK code snippet to update the recurring instance owner. Once we run the code, the recurrence owner name gets updated in the CMS db(verified using query builder query). But the same owner name does not get updated when seen using BI Launchpad. This is weird, there is something we are missing here and requesting a helping hand.

Here is the code snippet:

NewOquery = "select si_id from ci_systemobjects where si_kind = 'user' and SI_NAME='"+NewOwnerNm+"'";

IInfoObject NewOwner=(IInfoObject)is.query(NewOquery).get(0);

NewOwnerID = NewOwner.getID();

schedulingInfo.properties().setProperty(CePropertyID.SI_SUBMITTERID,NewOwnerID);

Environment: BOBJ 4.1

Using Java SDK.

Thanks,

satya

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Dell Stinnett-Christy Feb 08, 2017 at 03:15 PM
0

You also have to updated the InfoObject's SI_OWNER (Owner UserName) and SI_OWNER_ID (owner SI_ID) properties.

-Dell

Share
10 |10000 characters needed characters left characters exceeded
Satya Vara Kalla Feb 10, 2017 at 02:51 PM
0

Thank you Dell, but whats the exact column name for recurrance owner. Is it not SI_SUBMITTER.

Could you let us know the difference between SI_SUBMITTER vs SI_OWNER?

Share
10 |10000 characters needed characters left characters exceeded
Dell Stinnett-Christy Feb 10, 2017 at 03:08 PM
0

SI_SUBMITTER is the person who created the schedule. SI_OWNER is the person who "owns" the schedule. Because you can schedule "for" someone else, the two don't have to be the same. SI_OWNER comes into play when you have something like "View instances that the user owns" security set up for a group of users. This way users in the group cannot see the schedules or results of schedules where they are not the SI_OWNER for the report. SI_OWNER is what shows up in BI Launchpad and the CMC.

-Dell

Share
10 |10000 characters needed characters left characters exceeded