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

Last updated on MAY 05, 2023

Applies to:

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

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