Known Limit
After review by the development team, it has been determined that this issue is related to a known limitation with the software that lies outside of Esri's control. The issue's Additional Information section may contain further explanation.
Additional Information
No Public Explanation
Workaround
One way is to set Oracle parameter cursor_sharing=force, but this is not recommended setting and cause some other issues.