EPMAgent Write-Back Issue - "Error: SQL compilation error: syntax error line >n> at position <n> unexpected '?B'"
(Doc ID 3000411.1)
Last updated on FEBRUARY 06, 2024
Applies to:
Oracle Enterprise Planning and Budgeting Cloud Service - Version 23.01.23 and laterInformation in this document applies to any platform.
Symptoms
When running the Integration for Data Export to On Premise Database target application, the following errors are thrown -
Error: SQL compilation error:
syntax error line <n> at position <n> unexpected '?B'.
syntax error line <n> at position <n> unexpected 'values'.
This integration was set up specifying a table name and having the system generate the INSERT statement automatically.
BATCH_ID is a column in the on premise database table and in the CSV file used for application registration.
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 |
| Cause |
| Solution |