The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Where is a a field (which is a validation) is stored

Highlighted
riznad
Regular Collector

Where is a a field (which is a validation) is stored

Hi;

We have a field feed from PFM - Business Units validation.

I want to find out in data base where is this field stored?

 

Here screen shot of the field. There is no storage field. I am also attaching query result of all related table.

A text field is stored in parameter 31. I am also sending screen shot of project. I found the left one (isteği yapan müdürlük) but I could not find the right one (iş birimi)

 

13 REPLIES
Jason Nichols K
Honored Contributor

Re: Where is a a field (which is a validation) is stored

This is stored in KCRT_FG_PFM_PROJECT in two fields: PRJ_BUSINESS_UNIT_CODE and PRJ_BUSINESS_UNIT_MEANING. Most of the Project Field Group fields will be stored in this table.

 

If you look back at your query, those values are in columns KX and KY.

riznad
Regular Collector

Re: Where is a a field (which is a validation) is stored

Yes Jason.

But Kx and KY values come from KRSC_ORG_UNITS

table. Not from PFM - Business Units validation.

in PFM - Business Units validation there is no such unit as Performans Yönetim Müdürlüğü

Jason Nichols K
Honored Contributor

Re: Where is a a field (which is a validation) is stored

The OOTB validation for that field is PFM - Business Unit, but looking at your screen shot, it's not using that validation.  All that's visible is 'Units (Enabled)'  Can you post the the SQL for the validation that is being used?

Mohit_Agrawal
Frequent Visitor

Re: Where is a a field (which is a validation) is stored

Hi Riznad,

 

Just try select * from kcrt_requests where request_id = '';

 

It will list all the columns for which there is no storage tab..

 

Thanks!

Mohit Agrawal

 

jsalass
Frequent Visitor

Re: Where is a a field (which is a validation) is stored

Hi riznad,

 

The fieldgroups fields are stored in their own table.

 

You are checking the KCRT_REQUESTs tables and the table you need to check is KCRT_FG_PFM_PROJECT or KCRT_FG_PFM_PROPOSAL, etc.

 

There you will find the field columns for the businnes fields.

 

Check that table and let us know.

 

Hope this helps!,

 

Regards,

Jonathan

jsalass
Frequent Visitor

Re: Where is a a field (which is a validation) is stored

I forgot to mention that in the KCRT_FG_PFM_PROJECT table you will see these columns PRJ_BUSINESS_UNIT_CODE and PRJ_BUSINESS_UNIT_MEANING.

You can filter the result by request id.

select * from KCRT_FG_PFM_PROJECT where request_id=<your requestid>

Regards,
Jonathan
riznad
Regular Collector

Re: Where is a a field (which is a validation) is stored

Hi ;

Rule PFM - Business Units (Enabled Only):

 

select lookup_code, meaning, description
from knta_lookups
where lookup_type = 'PFM - Business Units'
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 UPPER(meaning)

 

 

Hi ;

My attached file contains result of query:

select kr.*,rhd.*,krd.*,p.*,kfpr.*,rt.*

from
ppmtfkb_usr.KCRT_REQ_HEADER_DETAILS rhd, ppmtfkb_usr.kcrt_requests kr, ppmtfkb_usr.kcrt_request_details krd,
PPMTFKB_USR.PM_PROJECTS p, PPMTFKB_USR.KCRT_FG_PFM_PROJECT kfpr,PPMTFKB_USR.KCRT_REQUEST_TYPES rt
where
kr.request_id=rhd.request_id
and rhd.request_id=p.pfm_request_id
--and rhd.request_type_id=30282--Master
and kr.request_type_id=rt.request_type_id
and kfpr.prj_project_id=p.project_id
and krd.request_id=kr.request_id
and kr.request_id=32430

 

I could not find the field.

 

Hi Jlass;

KCRT_FG_PFM_PROJECT.PRJ_BUSINESS_UNIT_CODE and KCRT_FG_PFM_PROJECT. PRJ_BUSINESS_UNIT_MEANING fields retrives data from kcrt_org_units table. Not from validation.

Jason Nichols K
Honored Contributor

Re: Where is a a field (which is a validation) is stored

What do you get when you run this query manually:

 

select lookup_code, meaning, description
from knta_lookups
where lookup_type = 'PFM - Business Units'
and enabled_flag = 'Y'
order by UPPER(meaning)

riznad
Regular Collector

Re: Where is a a field (which is a validation) is stored

Here I am attaching the result

Jason Nichols K
Honored Contributor

Re: Where is a a field (which is a validation) is stored

It's definitely not in that list, but I also notice that the fields are read-only.  Do you have a rule that sets those values or are they set earlier in the workflow and then set to read-only?  Also, try this query, just rule out that it may have been available before:

 

select lookup_code, meaning, description, enabled_flag
from ppmtfkb_usr.knta_lookups
where lookup_type = 'PFM - Business Units'

and meanins like 'P%'

riznad
Regular Collector

Re: Where is a a field (which is a validation) is stored

Hi jason;

here is the result:

 

PYSA_OPRSYNL_RSK_MDRLUGU Piyasa ve Operasyonel Risk Müdürlüğü  Y
PRFRMNS_IZLEME_KPSTE_SERV Performans izleme ve Kapasite Pl.  Servisi Bilgi Sistemleri Y

 

the field can be selected from a list ov values. The possible values comes from PFM - Business Units.

It can be selected at first state. after the selection it is read only

jsalass
Frequent Visitor

Re: Where is a a field (which is a validation) is stored

Hey riznad,

did you check if the corrected values are stored here:

select * from KCRT_FG_PFM_PROJECT where request_id=<your requestid>

Regards,
Jonathan
Jason Nichols K
Honored Contributor

Re: Where is a a field (which is a validation) is stored

The only other option I can think of is that is was available at one time in that list but has been removed, or the validation has changed. The next thing to check would be to see if you are still able to select that value on a new Project.
//Add this to "OnDomLoad" event