My Oracle Support Banner

Unable To Approve OLM Enrollment Class Notifications (Doc ID 1484041.1)

Last updated on SEPTEMBER 02, 2021

Applies to:

Oracle Learning Management - Version 12.1 HRMS RUP5 and later
Information in this document applies to any platform.


On : 12.1 HRMS RUP5 version, Workflows and Notifications.

Unable to approve OLM enrollment class notification.

Function OTA_LEARNER_HOME_SS “&PApprovalMode=Y” does have the Y in parameter code.

When there is a notification in the Worklist  the manager clicks on it to open to review and approves, then the screen changes to a window that states:

Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.

 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.

The issue can be reproduced at will with the following steps:
1. Click on worklist notification- error is generated.


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.