Entity Registry Missing Values In Database Installation Revision 5 (Rev 5) (Doc ID 1563631.1)

Last updated on DECEMBER 12, 2016

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.

Goal

How is it possible to fix objects missing within SYS database pertaining to the entity registry?

When Human Capital Management and Campus Solutions 9.0 - Revision 5 (V30469-01) is downloaded as a SYS database and CS bundles 24, 25, 26, 27, 28 and 29 and HRMS bundles 19, 20 and 21 are installed, there are missing entries in the entity registry. There are a number of entries missing in the entity type table, and the parameter and the properties records are missing a lot of entries as well.

This causes all the sync processes to fail, functionality is not usable and PeopleCode errors occur. In checking a demo database at bundle 28, all the entries are in it.  The install file (HCENGS.DB) is missing these entries as well, where HCENGL.DB actually has these values.  The bundles that were installed have these values, too.
 

Solution

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