MS SQL Syntax Error in HR_DIRECT_REPORTS.DirectReportsTablesServices.OnExecute (Doc ID 2085075.1)

Last updated on DECEMBER 03, 2015

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Errors caused by incorrect SQL syntax for MS SQL.
The error was triggered by Event Framework and the error SQL is located in app package HR_DIRECT_REPORTS.DirectReportsTablesServices.OnExecute
method AddAccessType5
method AddAccessType6

Using abbreviation 'A' does not work for MS SQL server.

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