My Oracle Support Banner

When Attempting To Open Multiple Notifications At Once From The Worklist The 'JBO-27122: SQL error during statement preparation. Invalid Column Index" Error Occurs (Doc ID 2466187.1)

Last updated on APRIL 15, 2020

Applies to:

Oracle Workflow - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to open multiple notifications at once by using select all then open from the worklist, after clicking next several times an exception error occurs:


The issue can be reproduced at will with the following steps:

1. From Home Page, select Full List button on the Top Right to the worklist
2. Select all notifications
3. Select Open
4. Click Next
5. Error occurs


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

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