For more information, please refer to this announcement explaining best practices for getting answers to questions.
ESS error when enabling Redwood only for Learner 23D
Summary:
Enable Redwood self service for Learner
Content (please ensure you mask any confidential information):
I am in the process of enabling Redwood only for Learn on our test instance. I am running into issues Step #3 (https://docs.oracle.com/en/cloud/saas/talent-management/23d/faiml/enable-redwood-self-service-for-learners.html#u30236400) Below is the error log:
####[2024-01-03T11:45:25.616+00:00] [INFO] FndOSCSIndexIngestESS execution log
Entering execute of FndOSCSAvailabilityESS job
Fetching parameters: isP2TJob
Fetching parameters: Index Name for recreate
Parameters
indexName :::: fa-hcm-learningitem
Only performing recreate for index - fa-hcm-learningitem
ESS job FndOSCSIndexIngestESS failed with errorjava.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275