Project and Portfolio Management Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

Using PPM commands through PL/SQL

Occasional Contributor

Using PPM commands through PL/SQL

Hi,

 

Can we use PPM commands through PL/SQL?

 

The actual requirement is to create Financial Summary Snapshots of projects in the system. The 'Take Snapshot' commands takes request ID as a parameter. Can't think of a way to call this command repeatedly for all projects. 

 

 

Thanks

5 REPLIES

Re: Using PPM commands through PL/SQL

Hey Keeko,

 

Use the OOB command

 

ksc_take_snapshot

 

which takes the following four arguments as parameters:

1) Req ID, 2) Snapshot name 3) Snapshot Desc and 4) Plan of Record (T or F).

 

if the version was upgraded all the budgets would have automatically converted to FS, however please us the above command in PL SQL code to achieve your goal.

Occasional Contributor

Re: Using PPM commands through PL/SQL

Hi Bharat,

 

I know about that command, but the question is how can I use it to create snapshots of all the active projects in the system at one go. Trying of doing it through a report, but I'm not sure how to do it. I mean, creating a FS snapshot for single project is one thing, and creating FS snapshopts for all active projects is another. Need some ideas on that

Highlighted
Honored Contributor

Re: Using PPM commands through PL/SQL

Create a command which loops through the requested Projects/Proposals (can hard code it), then pass the ID one by one in ksc_take_snapshot.

Call this command in Report.

It works, I had done the same to mass update the work plan status.
Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Occasional Contributor

Re: Using PPM commands through PL/SQL

That would be really useful, but I would not know how to start to prepare the list of projects and then go through one by one to call the 'take snapshot' special command using commands.

 

Any  prepared examples?

Honored Contributor

Re: Using PPM commands through PL/SQL

Well, using web servies is the asiest way to do.

 

In case of using command; you can create a CSV file (Project ID, Snapshot description..etc)... and use the method described in this post (below).

 

http://www.unix.com/shell-programming-scripting/31608-read-csv-file-assign-values-variable.html

 

You can google to get more example.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)