E-QR: PSQRYACCLSTRECS And PSVERSION Are Not Synchronized After Splitting The Database (Doc ID 1959770.1)

Last updated on FEBRUARY 17, 2015

Applies to:

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

Symptoms

 The PSQRYACCLSTRECS and PSVERSION tables got out of sync after splitting the database (e.g. CS/HCM)

When attempting to query the database, the PSQRYACCLSTRECS table it shows multiple values, while the PSVERSION shows only one VERSION value.

For example the VERSION value in PSVERSION for 'QAL' is 47 and the VERSION values that appear in PSQRYACCLSTRECS are 47, 678 and 6540.

Steps
-------
The issue can be reproduced at will with the following steps:

1. Open the SQL database Test Tool

2. Query the following tables:

SELECT * FROM PSVERSION where OBJECTTYPENAME = 'QAL';

Results:

OBJECTTYPENAME        VERSION               

------------------------------     -------------------

        QAL                                    47    

SELECT DISTINCT(VERSION) FROM PSQRYACCLSTRECS;

Results:

VERSION               

----------------------

47

678

6540

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