Setting Defined Parameters for SRS Program Jobs in OEBS throws an exception: java.sql.SQLException: (ErrorCode 17041) (SQLState 99999)
search cancel

Setting Defined Parameters for SRS Program Jobs in OEBS throws an exception: java.sql.SQLException: (ErrorCode 17041) (SQLState 99999)

book

Article ID: 88137

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
java.sql.SQLException: (ErrorCode 17041) (SQLState 99999) SELECT APPLICATION_NAME FROM FND_APPLICATION_VL WHERE APPLICATION_ID = :$FLEX$.XLA_SRS_SUBLEDGERS

Setting Defined Parameters for SRS Program Jobs throws an exception:
 
Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
Caused by: java.sql.SQLException: (ErrorCode 17041) (SQLState 99999) SELECT APPLICATION_NAME FROM FND_APPLICATION_VL WHERE APPLICATION_ID = :$FLEX$.XLA_SRS_SUBLEDGERS


<Please see attached file for image>

0EMb0000001UwtI.png



 

Environment

OS Version: N/A

Cause

Cause type:
By design
Root Cause: As designed functionality. SQL from the OEBS database may need to be edited before it can be used for parameters.

Resolution

This SQL is meant to run from within the Oracle EBS forms (when a user runs the job from Oracle EBS itself).

Fix Status: No Fix

Fix Version(s):
N/A

Additional Information

Workaround :
Do not use custom SQL statements within the "Defined Parameters" section.
Use the "Populate Values" button instead.

Attachments

1558693519047000088137_sktwi1f5rjvs16m8n.png get_app