My Oracle Support Banner

E-AD: Fields TGTDBNAME & TGTOPRID in PSPROJECTDEFN Do Not Get Updated When Using Command Line Interface Application Designer (Doc ID 2954657.1)

Last updated on SEPTEMBER 28, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.


Fields TGTDBNAME & TGTOPRID in PSPROJECTDEFN table do not get updated when using Command Line Interface Application Designer.

This issue is true for both pside (Windows) and psidex (Linux) Command Line Interface.
The fields TGTDBNAME & TGTOPRID in PSPROJECTDEFN do not get updated when using -PJM to compare a project.
On the other hand, LASTUPDDTTM & LASTUPDOPRID get updated by both methods.

Whereas, all four fields get updated when performing a compare via the Graphical User Interface (GUI) version of Application Designer on Windows.

Steps to Replicate:

1. On Linux (psidex) or Windows (pside), open a command line window, and enter the following:

psidex (on Linux, or replace with pside on Windows) -CT ORACLE -CD PH1DEV -CO IPS -CP **PASSWORD** -CI PEOPLE -CW


Note: Replace the database, oprid, and project name values with the ones valid in the environment, and fill in the correct passwords in all four places in the above command.

2. Then, view the project properties (File->Project Properties) in Application Designer.

3. Under Application Upgrade Target, observe that the Database and User field values remain unchanged (are the same as prior to the compare).
If the compare is run through the GUI version of Application Designer, all the field values mentioned above are updated.



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.