Project and Portfolio Management Practitioners Forum
cancel

Create Request from PL/SQL

Highlighted
Rafał Maliszews
Regular Contributor.

Create Request from PL/SQL

Hi

Is there possibility to call PPM PL/SQL code to create request.

regards
7 REPLIES
ak5250
Regular Contributor.

Re: Create Request from PL/SQL

Yes. You can call below function to create a request - Kcvs_Utilities.create_request

Hope it helps.
Rafał Maliszews
Regular Contributor.

Re: Create Request from PL/SQL


I have PPM 8 and there is not any kcsv_request package?

Any other suggestion?
Erik Cole_1
Outstanding Contributor.

Re: Create Request from PL/SQL

Hi,

You would populate the interface tables with the request data, then run kcrt_request_int.run_interface()

Have a look at the code in that kcrt_request_int package.
Rafał Maliszews
Regular Contributor.

Re: Create Request from PL/SQL


I try to import data via KCRT_REQUESTS_INT but after firing report IMPORT REQUEST and filling group id each recored was in:
PROCESS_PHASE 7(completed) and PROCESS_STATUS 3(error).

So I have faw question:

1. Which columns I should insert to complete creating request.

2. Have You any example firing Kcrt_Request_Int.Run_Interface with correct values of parameters )

regards
Rafał Maliszews
Regular Contributor.

Re: Create Request from PL/SQL


Ok, sorry I hurried up.

I successfull did this procedure:

1. Populate KCRT_REQUEST_INT table according to open interface ppm 8.0 docs

2. Run procedure KCRT_REQUEST_INT.run_interface as group_id passed value of inserted row in previous point

3. All was done correctly accept appliaction cannot display generated Request

May I should flush cache or something?

regards
Rafał Maliszews
Regular Contributor.

Re: Create Request from PL/SQL

Sorry, I forgot to commit changes.

Everything works fine for now.

best regards
Rafał Maliszews
Regular Contributor.

Re: Create Request from PL/SQL

-