ezds.com : Kintana Scripts

Free Kintana Scripts

ZDS

By: Dave Goodall

If you are a Kintana / Mercury ITG / HP PPM (Project and Portfolio Management) database administrator these SQL and PL/SQL scripts will help you manage the 'Demand' and 'Deliver' modules.

The scripts are packaged in a zip file as Toad ready .sql files together with this index page.

You can download them from the link at the foot of the page.

Unzip to a convenient directory and go...

Audit
Deleted Packages	Deleting packages is very bad practice. How to hunt down the malfeasers.
Commands
Deployment Command Scripts	A swiss army knife query to slice and dice your command scripts.
Command Script Diagnostics	Fixing run-time errors for new command scripts.
Special Commands	Everything you need to know about your special command code.
Report Command Scripts	List the command code for your Reports.
Dblinks
Grant Create Dblink Rights to User	Grant the rights you need to maintain dblinks for Object Migrator.
Deployment
Locate Package Lines for Files, Users, Objects	Locate packages and lines used to migrate files, or objects.
Missing App Codes Environments	How to find and fix missing application codes that have not been defined in all environments.
Missing App Codes Security Groups	How to find and fix missing application codes restricted by security groups.
Package Line Trans History	List what you see when highlighting a package line and clicking [View] 'Line Trans History'.
Package Lines with Null App Codes	User failure to enter app codes is a popular cause of failed migrations.
Status tab visible workflow steps	Whether a user sees a workflow step column on a package-line's status tab depends on several settings.
Demand
Open Requests	List requests more than a month old that have not been closed or cancelled.
Request Make A Copy Button	Which users can or cannot see the 'Make a Copy' button?
Request Field Info	Locate request field information where you know the parameter and batch number.
Request Reassignments	List requests that must be re-assigned when someone leaves or is transfered.
Design
Decisions Required 'All' Steps	Review your workflows for potential bottlencks.
Step Source	This script pulls together a record of all the code you have used in a workflow.
Standardize Approval Names	Using consistent names for decisions can help your users make the right choice.
Standardize Icon Usage	Using the same icon to represent the same action is just as important.
Steps With Duplicate Names	Ensure that when you re-open to a step, there's just one unique step with that name.
Steps Without Statuses	The workflow verify button catches a lot of problems. Missing step status names aren't one of them.
Workflow Step Names And Statuses	List status for each step of a workflow.
eMail
Locate the step that sent that email notification	Find out what step(s) that notification originated from.
User Not Getting Emails?	A user complains he isn't getting email notifications? Run this script.
Troubleshooting email Notifications	All of a sudden no-one's getting email notifications? Start trouble-shooting here.
Notifications to individual users	Naming users explicitly on workflow step notification tabs is not good practice.
Unresolved Recipient Tokens	Emails will not be sent if the recipients email address tokens are not resolved properly.
Locate pending emails by DR, Subject,User	locate pending emails by request number, subject line, or the user's email address.
Environments
Environments	Get a hard copy list of the environment table.
Environments In Use	List environments (servers) in use by workflows.
Environments Not In Use	List environments (servers) NOT in use by workflows.
Environments Update Base Paths	Replace Server and Client base paths en-masse for a copied environment.
Environments Unable To Open	If the dialog for an environment won't click open it probably contains a corrupt password.
Object Migrator
Object Migrator Version	Get currently installed OM and GL Migration version numbers.
Kintana Users with Oracle Apps Usernames Set	List Kintana user records with the user's Oracle Applications username set on the 'User Data' tab.
Oracle Applications
Oracle Applications Short Names	Sql for a Kintana validation to return a list of short names.
Oracle Applications Concurrent Programs	Sql for a Kintana validation to return a list of concurrent programs.
Oracle Applications FND Tables	A collection of useful queries against APPLSYS FND_ tables in support of Object Migrator.
Security
Kintana Access Grants	Access to Kintana system functionality is controlled by access grants.
Workflows Migrating to Specified Environment	Identifies Deliver workflows with steps that migrate into a specified environment.
Security Groups And Users	The SOX audit is nigh. Time to do that zero base review of who should be in your security groups that you've been putting off for ever.
Security Controlling Access to Specified Environments	Verify that your security group policy for migrations into destination environments in being followed.
Remove Security Groups from Disabled Users	When a user record's end date is set, any security groups should be removed!
Restrict User Access to Request Type	If you want to restrict user access to a request type this script can help.
Step Security Tabs with User Names	Naming users explicitly on workflow step security tabs is very bad practice!
System
V$ Grants	Oracle v$ View grants are essential for close control of the database.
Extensions Installed	Find out what extensions you have installed.
Patch level, Deployments, Upgrade Logs	Get the current patch level, deployment, and upgrade history.
Extension Information	Get extension/accelerator information for environments.
Database Time	Check the database time is being synced correctly to your time server.
Kintana Oracle database Version	Get the current version of the Kintana Oracle database.
User Database Privileges	Review user access grants for security purposes or check the rights you have.
Oracle ORA-02020 error	Handle an Oracle ORA-02020 'too many database links in use' error.
Oracle Database Time Zone Version	Your Kintana Oracle database should be using latest version 3 (US) time zone files.
Users
Active Users	Get hardcopy on who is using your per-seat licenses.
LDAP Authentication	Keep the admin accounts on native login when switching over to LDAP authentication.
Sync Contacts and Users	Keep (Demand) contact and (SysAdmin) user records in sync.
Unused Underused Licenses	Run your system without paying for more licenses than you really need.
Validations
SQL Source	Locate and list source code for SQL based validations.
Validations with Security Group Names	Validations with hard coded security group names will fail if the name is changed.

Download

KintanaScripts.zip (64 Kb)

Kintana™, 'Mercury IT Governance™', 'HP PPM (Project and Portfolio Management)™
are trademarks of Kintana, Mercury Interactive Corporation, and Hewlett Packard Corporation respectively.