Absent Member.. leewil1 Absent Member..
Absent Member..
194 views

What's the best way to load validation values?

We have several validations which contain values that are maintained in external systems.  We would like to eliminate manual re-entry of these values as they are maintained by other teams.  We would like to automate the load of these values into PPM.  A similar question(post) was posed regarding kenv_env_apps table and some experienced users pointed to the PACKAGE KENV_ENV_APPS_TH and PROCEDURE KENV_ENV_APPS_TH.Process_Row.

 

We have noticed there exists other similar  procedures.  In particular,  PACKAGE KNTA_LOOKUPS_TH.  Does anyone how to use it?  We have seen the procedure successfully run via PL/SQL.  That is, new values were added to the table KNTA_LOOKUPS and shown from database queries. However, the new values do not show up in the workbench.  Does anyone know what else must be done?  Does a report need to be run?  Is there a refresh process?

0 Likes
2 Replies
Erik Cole Acclaimed Contributor.
Acclaimed Contributor.

Re: What's the best way to load validation values?

In general, if you're updating things from the back end you need to also modify the last_update_date so that the server will know not to just display the currently cached items.

 

For values maintained in other systems, you might consider creating some validations that use SQL with a database link to the other databases and just query them directly.

0 Likes
Highlighted
Absent Member.. AlexSavencu Absent Member..
Absent Member..

Re: What's the best way to load validation values?

Hi, leewil1,

 

check out this post: http://h30499.www3.hp.com/t5/Project-Portfolio-Management/Sorting-validation-rows/m-p/5395871#M1713.

 

Do let us know if this helps.

 

cheers

alex


--remember to kudos people who helped solve your problem
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.