Strategic Sourcing Event Posting Process Fails with Error-"CreateSQL Error Position: 0 Return: 8603 - Incorrect syntax near 'S'. Statement(s) could not be prepared." If Event is Created With a Category Id Containing Apostrophe like "PLAYER'S CLUB".
(Doc ID 2942001.1)
Last updated on APRIL 25, 2023
Applies to:
PeopleSoft Enterprise SCM Strategic Sourcing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When Sourcing Event with category ID Containing Apostrophe like "PLAYER'S CLUB" is posted,AUC_EVT_PDF process fails with below error message .
Steps to reproduce the issue :
1. Create an Item category with apostrophe like PLAYER'S CLUB.Navigation: Items > Define Controls > Item Categories.
2. Associate an Item with the category created .Navigation:ItemsDefine > Items and Attributes > Define Item.
3. Create a sourcing event with the item in the category created and post .Navigation: Sourcing > Create Events > Create Event Details.
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 |