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

Staffing Profile Status - Lock Down

Highlighted
dlinetsk
Member

Staffing Profile Status - Lock Down

Guys,

 

In the HP Resource Management User's Guide for version 9.10, page 77, one of the status choises is "Lock Down". We are running 9.13 and we do not have this choice for status. I looked for any info on this in all the release documents for 9.10 - 9.13, but no luck. 

 

Does anyone have any information on the issue - search in Knowledge Base did not give us anything.

 

Thanks,

Dmitry

 

9 REPLIES
dlinetsk
Member

Re: Staffing Profile Status - Lock Down

a bit more info... the user I am using does have all the necessary Access Grants

- Edit All Staffing Profiles

- Update Staffing Profile Status

 

in fact, I am using admin user that has all the access grants.

 

Celil
Esteemed Contributor

Re: Staffing Profile Status - Lock Down

Hi Dmitry,

To articulate problem, where you are looking? Staffing Profile itself or filters that show Staffing Profiles. Because a staffing profile with the status of Lock Down, Completed, or Cancelled is not displayed by the filter and any filter haven't got these statuses.


PS: If you glad to my answer please KUDOS me.
Celil

IT Governance Professional
& PPM Solution Architect
dlinetsk
Member

Re: Staffing Profile Status - Lock Down

Hi Celil,

 

I am looking at the Staffing Profile itself. When looking at Staffing Profile header (where you define the name, manager and period), there is Status field - HP documentation states that there should be an option to Lock Down the staffing profile.  We do not have this option status in this feild.

 

So, I am wondering what are we missing - Validation, config parameter, or something else...  I cannot find any guide on making it available aside from Access Grants - which are set right.

 

Thanks,

Dmitry

dlinetsk
Member

Re: Staffing Profile Status - Lock Down

More info, just run a query from the Staffing Profile Validation - there is no status "Lock Down" for staffing profile in our DB.  

 

Can someone please check their instance of PPM version 9.x to see if such status is available staffing profiles?

 

We do not want submitting a case to HP if there if there is a simple answer to our issue.

 

Thanks,

Dmitry

Celil
Esteemed Contributor

Re: Staffing Profile Status - Lock Down

Hi Dmitry,

 

We running 9.12 and we have it.

Lets run some check over your system:

1) lets run below query and please tell me what is return:

SELECT lookup_code, meaning
       FROM knta_lookups
      WHERE lookup_type like 'RSC - Staffing Profile Status'
        AND enabled_flag = 'Y'
        AND lookup_code in (1, 2, 3, 7)
   ORDER BY seq

 

2) There are OOTB validation of SP of status. Please compare your validation with these:

RM - Active Staffing Profile Status

SELECT lookup_code, meaning
       FROM knta_lookups
      WHERE lookup_type like 'RSC - Staffing Profile Status'
        AND enabled_flag = 'Y'
        AND lookup_code in (1, 2, 3, 7)
   ORDER BY seq


RSC - Staffing Profile Status

SELECT lookup_code, meaning
FROM knta_lookups
WHERE lookup_type = 'RSC - Staffing Profile Status'
and enabled_flag = 'Y'  
and UPPER(meaning) like UPPER('?%')  
and (meaning like upper(substr('?',1,1)) || '%'    
or meaning like lower(substr('?',1,1)) || '%') 
order by seq


RSC - Staffing Profile Status (Lookup)

SELECT lookup_code, meaning, default_flag
FROM knta_lookups WHERE lookup_type = 'RSC - Staffing Profile Status'
and enabled_flag = 'Y'
ORDER BY seq

 

3) Finally please provide me with some screenshots:

a) Project overview screen which is carrying SP

b) SP header and status dropdown screen

These two screen must come from the same project.

Celil

IT Governance Professional
& PPM Solution Architect
dlinetsk
Member

Re: Staffing Profile Status - Lock Down

Celil,

 

here are the results on the queries, and screenshots:

 

1) lets run below query and please tell me what is return:

SELECT lookup_code, meaning

       FROM knta_lookups

      WHERE lookup_type like 'RSC - Staffing Profile Status'

        AND enabled_flag = 'Y'

        AND lookup_code in (1, 2, 3, 7)

   ORDER BY seq

 

 

1              Active

2              In Planning

3              Completed

7              Rejected

 

 

2) There are OOTB validation of SP of status. Please compare your validation with these:

RM - Active Staffing Profile Status

SELECT lookup_code, meaning

       FROM knta_lookups

      WHERE lookup_type like 'RSC - Staffing Profile Status'

        AND enabled_flag = 'Y'

        AND lookup_code in (1, 2, 3, 7)

   ORDER BY seq

  

 

1              Active

2              In Planning

3              Completed

7              Rejected

 

 

RSC - Staffing Profile Status

SELECT lookup_code, meaning

FROM knta_lookups

WHERE lookup_type = 'RSC - Staffing Profile Status'

and enabled_flag = 'Y'  

order by seq

 

 

1              Active

2              In Planning

3              Completed

4              Cancelled

5              Baseline

6              Approved

7              Rejected

 

 

RSC - Staffing Profile Status (Lookup)

SELECT lookup_code, meaning, default_flag

FROM knta_lookups WHERE lookup_type = 'RSC - Staffing Profile Status'

and enabled_flag = 'Y'

ORDER BY seq

 

 

1              Active   N

2              In Planning          Y

3              Completed         N

4              Cancelled            N

5              Baseline               N

6              Approved            N

7              Rejected              N

 

3) Finally please provide me with some screenshots:

A) Project Overview Screen Which Is Carrying Sp

 

 

 

b) SP header and status dropdown screen

 

 

 

 

Finally, here is the version of our instance:

 

 

Erik Cole
Honored Contributor

Re: Staffing Profile Status - Lock Down

I'm 9.12 and I have it. Were you previously running 9.12 and had it?

dlinetsk
Member

Re: Staffing Profile Status - Lock Down

Unfortunately I do not know, I took over the instance when it was already upgraded to 9.13

 

dlinetsk
Member

Re: Staffing Profile Status - Lock Down

Submitted a case to HP.

//Add this to "OnDomLoad" event