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

What is TABLE & PARAMETER for "Parent" value of a Package in PPM ?

Highlighted
Raj Ghimire
Occasional Visitor

What is TABLE & PARAMETER for "Parent" value of a Package in PPM ?

Hi Everyone,

Can anyone help us determine the TABLE & PARAMETER name related to the "Parent" value of a Packge in PPM ?

 

This value gets popualted automatically when you create a Package from a request WF, but for various situations, we are in need of populating this value ourselves somehow to an existing Package. May be through direct table update or using a wf commnd.  Any Suggestions ?

 

Thanks in advance !
- Raj

4 REPLIES
Mohit_Agrawal
Frequent Visitor

Re: What is TABLE & PARAMETER for "Parent" value of a Package in PPM ?

Hi Raj,

 

I found hits for 'Parent' in below tables. I don't know if this could be of any help:

 

KCRT_REQUESTS.DESCRIPTION
KCRT_REQUESTS_BAK_2810.DESCRIPTION
KCRT_REQUEST_DETAILS.PARAMETER42
KCRT_REQ_DETAIL_BAK_2810.PARAMETER42
KCRT_REQ_DETAIL_BAK_2810.PARAMETER41
KCRT_REQ_HEADER_DETAILS.PARAMETER41


KDLV_PACKAGES.DESCRIPTION
KDLV_PACKAGE_LINES.OBJECT_NAME
KDRV_ROLLUP_METHODS.UPDATE_VALUES_SQL
KDSH_DATA_SOURCES_NLS.BASE_FROM_CLAUSE
KDSH_DATA_SOURCE_COLUMNS.NAME
KDSH_DATA_SOURCE_FILTERS.WHERE_CLAUSE

KNTA_PARAM_RULES.PARAM_RULE_NAME
KNTA_PARAM_SET_FIELDS_NLS.REFERENCE_CODE

 

Thanks!!

Mohit Agrawal

 

bzdafro
Collector

Re: What is TABLE & PARAMETER for "Parent" value of a Package in PPM ?

We ran into the same issue, but never figured it out either. Its crazy because the value is right there in the package header information section. We spawn a package from a request, and it creates the package. We open the package and PPM fills in the header fields. Parent: shows "Request 34643" but we cannot find any tokens that will resolve to this. Its frustrating because I need to reference some tokens from the request, and cant get to them in the object type.
bzdafro
Collector

Re: What is TABLE & PARAMETER for "Parent" value of a Package in PPM ?

I just got this to work!!!! [PKG="[PKG.NUMBER]".PARENT_REQUEST_ID]
Raj Ghimire
Occasional Visitor

Re: What is TABLE & PARAMETER for "Parent" value of a Package in PPM ?

Great that you had this working from TOKEN side....

In my case,  I had to udpate it from backend usign a Script. And we were fianlly able to do that by updating a couple of Tables.

- KWFL_STEP_TRANSACTIONS.CHILD_PACKAGE_ID

&

- KDLV_PACKAGES.PARENT_STEP_TRANSACTION_ID

 

Thanks.

-Raj

//Add this to "OnDomLoad" event