idbasolutions

idbasolutions.com September 23, 2004

Reinstalling Vertex/Quantum
Install or reinstall Vertex
Install, reinstall or upgrade Quantum Vertex

This procedure also can be used to upgrade Vertex to a higher version; for example from 2.6.0 to 2.7.0.

This document outlines the steps involved in removing and reinstalling Quantum for oracle apps (11.5.9) and might be helpful to you if you need to reinstall Quantum for oracle apps.

Disclaimer: Apply to a TEST environment first. Use on production systems is at DBAs own risk.

Quantum for oracle apps notes:

Removing and re-installation for HP:

In some situations, Oracle might ask you to remove your current version of Vertex and re-install it.

In this document Quantum 2.5.1 will be removed and re-installed.

1) logon as the application owner

2) cd $PAY_TOP

3) mkdir backup_251

4) cd $PAY_TOP/vendor

5) cp -Rp * $PAY_TOP/backup_251

6) rm -Rf $PAY_TOP/vendor/*

7) logon to the application URL as US HRMS manager responsibility and run “Quantum Program Update Installer”. Specify your platform (Here is HPUX) but leave Install in Directory to default location which should point to $PAY_TOP/vendor/quantum. This would run for a few minutes and should create subdirectories lib and utils under $PAY_TOP/vendor/quantum

cd $PAY_TOP/vendor/quantum

9) mkdir data

10) copy the latest version of qfpt.dat or the one that you should currently use in your systems to $PAY_TOP/vendor/quantum/data. You may download the latest version of qfpt.dat from http://www.vertexinc.com/customercafe

11) logon to the application URL as US HRMS manager responsibility and run “Quantum Data Update Installer” and leave the parameters data source and data file location blanc which would then use the default location $PAY_TOP/vendor/quantum/data. This would run for about 20 minutes and once successfully completed, it would populate the data subdirectory $PAY_TOP/vendor/quantum/data

12) Done. Vertex Quantum was removed and re-installed.

Current version of Vertex:

cd $PAY_TOP/vendor/quantum/utils

./diagnos

choose option 1

give full path to data location, do not include parameter in the path

(sample: /u08/app/R11i/testappl/pay/11.5.0/vendor/quantum/data)

Troubleshooting:

If “Quantum Data Update Installer” fails you may try the following solution:

Solution:

Run the following if they are not already set:

update pay_action_parameters

set PARAMETER_VALUE=’/u08/app/R11i/testappl/pay/11.5.0/vendor/quantum/lib’

where PARAMETER_NAME=’TAX_LIBRARIES’;

insert into pay_action_parameters (PARAMETER_NAME, PARAMETER_VALUE)

values (’TAX_DATA’, ‘/u08/app/R11i/testappl/pay/11.5.0/vendor/quantum/data’);

Then rerun your current hrglobal

adpatch my current hrglobal.drv and then rerunning “Quantum Program Update Installer, then I rerun “Quantum Data Update Installer”

/u08/app/R11i/testappl/admin/TEST/log/adpatch_05312006_hrglobal.log

The problem went away.

Note: Change path accordingly to match your target system.