Error: "Incorrect syntax near '~'." upon Writing Back to Custom INSERT Query
(Doc ID 2865261.1)
Last updated on MAY 02, 2022
Applies to:
Oracle Planning and Budgeting Cloud Service - Version 22.04.52 and laterOracle Financial Consolidation and Close Cloud Service - Version 22.04.52 and later
Information in this document applies to any platform.
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
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
Symptoms |
Changes |
Cause |
Solution |