Error: "Incorrect syntax near '~'." upon Writing Back to Custom INSERT Query (Doc ID 2865261.1)

Last updated on MAY 02, 2022

Applies to:

Symptoms

When attempting to writeback to database table,
the following error occurs.

Error

======

-------------------- File Download Complete----------------------
--------------- Creating Insert Statements for table: null ----------
--------------- Insert Statements:INSERT into <TABLE_NAME>(Account,CostCenter,Currency,Detail,Scenario,ScenarioView,Version,Year,Amount)
values(~Account~,'CC_XXXXX','USD','XXXXX','Budget','Programs','Working','FY22','12345.0001')
--------------- Executing Custom Event :BefExport ---------------
--------------- Query Execution: START ----------
Error: Incorrect syntax near '~'.
Error: java.sql.BatchUpdateException: Incorrect syntax near '~'.
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeBatch(SQLServerStatement.java:1837)
at oracle.epm.aif.agent.queryprocessor.QueryProcessor.executeQuery(QueryProcessor.java:456)
at oracle.epm.aif.agent.service.WritebackServiceExecutor.call(WritebackServiceExecutor.java:132)
at oracle.epm.aif.agent.service.WritebackServiceExecutor.call(WritebackServiceExecutor.java:42)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

--------------- Completed execution for sessionId:563 ---------------
Job execution failedIncorrect syntax near '~'.
: java.sql.BatchUpdateException: Incorrect syntax near '~'.
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeBatch(SQLServerStatement.java:1837)
at oracle.epm.aif.agent.queryprocessor.QueryProcessor.executeQuery(QueryProcessor.java:456)
at oracle.epm.aif.agent.service.WritebackServiceExecutor.call(WritebackServiceExecutor.java:132)
at oracle.epm.aif.agent.service.WritebackServiceExecutor.call(WritebackServiceExecutor.java:42)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Changes

Cause

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