CRM 9.2 SYS Database Installation populates records incompletely
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.
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 Type: SYS
Platform: Linux x86-64 Red Hat Enterprise 7
Application: Peoplesoft CRM 9.2
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).
Application packages should be delivered with these rows available.
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)
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