SQL Statements Will Not Work After Upgrading From 12.2.4 To 12.2.10
(Doc ID 2880546.1)
Last updated on NOVEMBER 27, 2022
Applies to:
Oracle Demantra Demand Management - Version 12.2 to 12.2.11 [Release 12.2]Information in this document applies to any platform.
Symptoms
On : 12.2.10 version, Workflow, Non-Production Environment
When attempting to run Workflow with condition step of SQL statements having DML statements will not work went upgrading from 12.2.4 to 12.2.10.
Condition steps are missing after upgraded from 12.2.4 to 12.2.10. When try to add them back from production instance, can not save the changes. Receive an error when validate the workflows.
the following error occurs.
ERROR
-----------------------
Error step in xxxx.SQL string is not a Query
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgraded from 12.2.4 to 12.2.10
2. Applied recommended patches
3. Log into the Demantra local application:dm/dm
4. Select Workflow Management from Settings and Actions
5. Run workflow which has condition step of DML SQL
6. Does not run successfully
7. Edit and validate , error occurs
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 |