ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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



 

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.

Environment

OS Version: N/A

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