CRM 9.2 SYS Database Installation populates records incompletely (Doc ID 2194847.1)

Last updated on JANUARY 30, 2017

Applies to:

PeopleSoft Enterprise CRM Support - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

While performing a fresh installation of SYS database, when installing the CRM SYS database, a customer is reporting an issues with some values 'Translate Tables','Trees','Tree Structures','Colours' that are missing in CRM demo database. As a workaround, the customer has manually inserted and fixed the error. This issue also restricts the users from login in to application designer etc , if Peoplesoft Administrator role is removed.
The tables below are missing rows for the above mentioned values in a CRM 9.2 SYS database:
select * from PS_APP_DES_OBJECTS ;
select * from PS_APPDES_OBJ_PERM;

Customer is asking to fix the SYS database and Demo data database package for CRM 9.2 as a permanent solution.

 

Environment:
----------------
Environment Type: SYS
PeopleTools: 8.54
Platform: Linux x86-64 Red Hat Enterprise 7
Application: Peoplesoft CRM 9.2

Actual Behavior
-------------------
Missing rows from PS_APP_DES_OBJECTS and PS_APPDES_OBJ_PERM records on a fresh SYS database install. These are causing the permission list App Designer access to show "Invalid Value" for several prompt values (such as Merge, Visual Merge Page).

Expected Behavior
------------------------
Application packages should be delivered with these rows available.

Replication Steps
--------------------
1. Perform a classical installation until the step of creating Datamover import script (see page 181, Task 6A-22-2: Running Database Setup to Create Data Mover Import Scripts of PeopleTools 8.54 Installation for Oracle)
2. Select PeopleTools System Database for CRM installation
3. The import step that writes data in the CRM database is the one from PS_APP_HOME\log\crengs.db and this is an application delivered script
4. The above import step does not populate records PS_APP_DES_OBJECTS and PS_APPDES_OBJ_PERM completely (some rows are missing and further causes issues in the application)


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