E-AE: Application Engine SQL With If/Else Statement Fails With Error "Error Code: Return: 6100 - End of fetch" When It Updates Zero Rows (Doc ID 2992211.1)

Last updated on DECEMBER 13, 2023

Applies to:

Symptoms

When running Application Engine (AE), if it is using If/Else statement in the SQL action, it runs to SQL Error when the UPDATE SQL updates 0 rows.
This happens when sql syntax is specific to one database (e.g. MS SQL Server) and error can be seen in <ProgramName>_<Instance>.stdout file.

The issue can be reproduced at will with the following steps:
1. Create an AE program with sql action using If/Else that updates 0 rows in database.
2. Run application engine from PeopleTools > Process Scheduler > Schedule Process Request
3. Go to process monitor page from here and click on details for AE program
4. Notice the error in log here.  

Cause

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