My Oracle Support Banner

Exception While Executing SQL Rule With Insert Script In PMF Workflow (Doc ID 3043089.1)

Last updated on AUGUST 27, 2024

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.1 and later
Information in this document applies to any platform.

Symptoms

Exception while executing SQL Rule with Insert script in PMF workflow :

Execution rule type activity fails even though underlying insert statement provided in the rule is successful.
Below is the Implementation rule value provided for the execution rule


insert into testnum(num1) values ('123');

it is failing with below error in OFSAA.log

Error while execution sql query task:java.sql.SQLException: Invalid column index

[01-08-24 02:50:48,194 GMT AM] [DEBUG] [WEB] [NA] [NA] Invalid column index

Changes

 NA

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
References


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