My Oracle Support Banner

Error On CAS Maintenance Page (SAD_PB_CAS) Unable To Update - Page data is inconsistent with database. (18,1) (Doc ID 2970339.1)

Last updated on AUGUST 26, 2023

Applies to:

PeopleSoft Enterprise CS Recruiting and Admissions - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


When attempting to delete or add a row on the CAS Maintenance page, the following error occurs:

"Page data is inconsistent with database. (18,1)"




The issue can be reproduced at will with the following steps:
1. Navigate to Student admissions > CAS Staging Data
2. Identify a record that is pending.
3. Map this to a career and career number for which there is not currently a row in the SAD_PB_CAS table.
4. If there are no rows in the CAS Staging Data you could probably stage them by inserting into the SAD_PB_CAS_STG table.
5. After mapping a staging record navigate to Student admissions > PBI Processing > Import CAS details and run the process with the institution entered and the xml path/file Name left blank.
6. This process should create a row in the SAD_PB_CAS table.
7. View the row by navigating to Student admissions > PBI Processing > CAS maintenance.
8. Try to add a new row and save it. error message should be presented.



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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