My Oracle Support Banner

Issue With Custom Substitution VO on the Manager Self-Service Assignment Page (Doc ID 2445350.1)

Last updated on JULY 07, 2020

Applies to:

Oracle Self-Service Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.


Created and deployed a substitution VO for UsJobLovVo. The new VO gets an error under specific circumstances the following error is received:

"oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation."

The page is "/oracle/apps/per/selfservice/deployperson/webui/AssignmentPG ", and if you delete or change the job name that defaults then the new VO works, if you leave the default value and click on the magnifying glass, then try to query you get the error message.

How can this be corrected?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.