E-CA Both Win 7 64bit 2008 64bit Clients Change Assistant Cannot Find Oracle Sql Query Tool On Validation. (Doc ID 2044017.1)

Last updated on OCTOBER 12, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.
To get all workstations working the re-install of the Oracle Client Connectivity is required on each box that will be use CA to apply fixes or run an upgrade job.

Symptoms

On : 8.54 version, Change Assistant

When attempting to run the validation the SQL Tool is not found.
the following error occurs.

ERROR
-----------------------
SQL Client tool not found




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open the Change Assistant as Administrator
2. Navigate to Tools > Validation
3. Start Validation


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the Change Assistant can't operate as designed.. No Job can be created.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms