E-AE: %SqlHint Not Working and Errors Out With ' SQL Error: ORA-01742: comment not terminated properly'

(Doc ID 2380902.1)

Last updated on MARCH 30, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

Trying to add a hint within an AE program code using %SqlHint but the process is ending with error:

SQL Error: ORA-01742: comment not terminated properly

Example that fails with %SqlHint()

%SqlHint (UPDATE, 1, '/*+ INDEX_RS_ASC(PSDJRNL_LN) */'
UPDATE PS_%Bind(GL_JEDIT_WK_AET.RECNAME_JRNL_LN,NOQUOTES)
SET MONETARY_AMOUNT=%RoundCurrenty....
WHERE PROCESS_INSTANCE IN (%Bind(PROCESS_INSTANCE), %Bind(GL_JEDIT_WK_AET.PROCESS_INSTANCE2))
AND BUSINESS_UNIT=%Bind(GL_JEDIT_WK_AET.BUSINESS_UNIT)....

 

Environment:

FSCM 9.2.17, Tools 8.55.11 on Oracle 12.1.0.2











Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms