Financial Management - PSFT (MOSC)

MOSC Banner

SQL error: incorrect settings: 'QUOTED_IDENTIFIER'

edited Sep 19, 2020 5:04AM in Financial Management - PSFT (MOSC) 1 commentAnswered

We getting a sql error in our voucher posting process.

Partial error message pasted below:

file: e:\pt857p07b_1905200503-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725  Error Position: 0  Return: 8601 - [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or f

Failed SQL stmt: INSERT INTO

Our DBA has run of ideas about why would we get this SQL error.

Our settings for : 'QUOTED_IDENTIFIER' are set to ON (enabled) as recommended by GSC.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center