EMM: When Running Search Index, EP_WM_WO_RESOURCES_KIB Throws SQL Error "Left-of-decimal digits truncated from FETCHed value (SQLSTATE PS150)" In Microsoft SQL Server.
(Doc ID 3016786.1)
Last updated on APRIL 16, 2024
Applies to:
PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When running the search index, EP_WM_WO_RESOURCES_KIB in MS SQL server, the following error is displayed.
Replication Steps:
1) Navigate to PeopleTools -> Search Framework -> Search Admin Activity Guide -> Administration -> Deploy/Delete Object.
2) Select EP_WM_WO_RESOURCES_KI search index and click deploy button.
3) Build search index on the above one by navigating to PeopleTools -> Search Framework -> Search Admin Activity Guide -> Administration -> Schedule Search Index.
4) Click Run and process goes to success. But there is an error in the message log.
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 |