PERSON_BASIC_SYNC Called From Several Processes Fails With Error 'Invalid column name 'PROCESS_INSTANCE', After Applying PUM 33
(Doc ID 3054231.1)
Last updated on JANUARY 07, 2025
Applies to:
PeopleSoft Enterprise CS Campus Community - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
After applying PUM 33, loading an ISIR from suspense fails. Examination of the log file created shows the following message.
PERSON_BASIC_SYNC called from Admissions transcript processing experiences the same error.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180
Statement: SELECT A.EMPLID, (CONVERT(CHAR(10),A.EFFDT,121)), A.SCC_BIRTH_GENDER, A.SCC_GENDER_ID, A.SCC_GENDER_ID_OTH, A.SCC_SEXUAL_ORT, A.SCC_SEXUAL_ORT_OTH, A.SCC_PRONOUNS, A.SCC_PRONOUNS_OTH, A.SCC_BIO_ATTRB_1, A.SCC_BIO_ATTRB_2, A.SCC_BIO_ATTRB_3, A.SCC_BIO_ATTRB_4, A.SCC_BIO_ATTRB_5, A.SCC_BIO_ATTRB_6, A.SCC_BIO_ATTRB_7, A.SCC_BIO_ATTRB_8, A.SCC_BIO_ATTRB_9, A.LASTUPDDTTM, A.LASTUPDOPRID FROM PS_SCC_PERS_BIOG A WHERE A.PROCESS_INSTANCE = :1 ORDER BY A.EMPLID, A.EFFDT
Original Statement: Select A.EMPLID, ÚteOut(A.EFFDT), A.SCC_BIRTH_GENDER, A.SCC_GENDER_ID, A.SCC_GENDER_ID_OTH, A.SCC_SEXUAL_ORT, A.SCC_SEXUAL_ORT_OTH, A.SCC_PRONOUNS, A.SCC_PRONOUNS_OTH, A.SCC_BIO_ATTRB_1, A.SCC_BIO_ATTRB_2, A.SCC_BIO_ATTRB_3, A.SCC_BIO_ATTRB_4, A.SCC_BIO_ATTRB_5, A.SCC_BIO_ATTRB_6, A.SCC_BIO_ATTRB_7, A.SCC_BIO_ATTRB_8, A.SCC_BIO_ATTRB_9, ÚteTimeOut(A.LASTUPDDTTM), A.LASTUPDOPRID from %Table(:1) A where A.PROCESS_INSTANCE = :2 order by A.EMPLID, A.EFFDT
The issue can be reproduced at will with the following steps:
1. Navigate to Financial Aid, File Management, ISIR Import, 2024 - 2025 Suspense Management;
2. Select a record using the appropriate search criteria;
3. Click the Process ISIR button;
4. Review the log file created and note the error.
Changes
The fix for Bug 35105555 - ADOPTION OF GLOBAL NAME FORMATTING IN CS - PBS was applied.
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 |
| Changes |
| Cause |
| Solution |
| References |