Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

PM metrics data needs to be transferred from old org unit to new org unit

Highlighted
pradeep k.r.
Super Collector

PM metrics data needs to be transferred from old org unit to new org unit

Dear PPM'ers,

We've a change request for transferring PM metrics results data from one org unit to another.

Is this something we can do from the backend using the update statement herewith OR do we need to create a new request type with workflow execution steps to transfer org data from old to new org_unit using the validation script.

IF V_OLD_CAT_CODE = 'LAB' THEN --may be section or project_unit
-- ALL THE CHILD RECORDS
UPDATE kcrt_request_details
SET parameter7 = P_NEW_ORG_ID,
visible_parameter7 = V_NEW_ORG_NAME
WHERE
parameter7 = P_OLD_ORG_ID
and request_id in(select request_id from kcrt_request_types where request_type_name like '%PM Metric Results%');
COMMIT;

Thanks to let me know if more information.

Regards,
Pradeep
//Add this to "OnDomLoad" event