HC_HR_JOB_DATA Real Time Update Triggers Error in App Server Log - "ORA-00947: not enough values"
(Doc ID 3066741.1)
Last updated on JANUARY 13, 2025
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
After enabling real time indexing for the HC_HR_JOB_DATA index, the following error occurs.
PSRTISRV.2783248 (0) [2024-12-11T17:31:59.391] - - - (1) Unable to execute Appc class Process
PSRTISRV.2783248 (0) [2024-12-11T17:31:59.437] - - - (1) GenMessageBox(0, 0, M): PeopleCode Manager (Update): SQL error. Function: SQLExec
Error Position: 12
Return: 947 - ORA-00947: not enough values
Statement: insert into PS_HR_JOB_SRCH_DAT (SELECT * FROM PS_HR_JOB_RTI_DAT1 A WHERE A.EMPLID = :1 AND A.EMPL_RCD = :2)
Original Statement: INSERT INTO PS_HR_JOB_SRCH_DAT (SELECT * FROM PS_HR_JOB_RTI_DAT1 A WHERE A.EMPLID = :1 AND A.EMPL_RCD = :2)
PSRTISRV.2783248 (0) [2024-12-11T17:31:59.437] - - - (1) GenMessageBox(2, 277, E): CPCHost.ShowError: SQL Error in Compile. (2,277) HR_ES_SRCH_RTI.JobDataSearch.OnExecute Name:Process PCPC:14759 Statement:197
Steps to reproduce the issue:
1. Enable RTI for HC_HR_JOB_DATA
Navigate to Peopletools > Search Framework > Real Time Indexing > Configure Real Time Indexing
2. Generate and run the triggers in the database
3. Enable RTI on the Process Scheduler
4. Enable LogFence=4 in the Process Scheduler
5. Bounce the Process Scheduler
6. Log out and log in PeopleSoft
7. Go to Workforce Administration, Job Information, Job Data , Search for an EMPLID
8. On Work Location tab, Work Location Details, add a row.
9. Add a new Effective Date and select a new value in the Position Number field
10. Check on the other tabs that all the required fields are not empty.
11. On Compensation tab, click on the 'Calculate Compensation' button link and Save with warnings.
12. Observe errors in App server.
Changes
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 |