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)
Article ID: 88137
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:
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
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>
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.
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
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.
Do not use custom SQL statements within the "Defined Parameters" section.
Use the "Populate Values" button instead.
Attachments
Feedback
Yes
No
Powered by
