OTA Workflow - Bulk Enrollment Notification And Cleanup (Doc ID 1633295.1)

Last updated on OCTOBER 03, 2016

Applies to:

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

Symptoms

On : 12.1 HRMS RUP6 version, Workflows and Notifications

ACTUAL BEHAVIOR
---------------


Bulk Enrollment Notification and Cleanup" is not clearing all the  processed bulk enrollment request and member table records.

Customer needs to clean up the records that are stuck in Tables:  OTA_BULK_ENR_REQUESTS and OTA_BULK_ENR_REQ_MEMBERS.




EXPECTED BEHAVIOR
-----------------------
Expect the tables: OTA_BULK_ENROLL_UTIL.DELETE_BULK_ENR_REQUEST not to have any rows in them, once all of the OTA Wokflows of type "Bulk Enrollment Notification and Cleanup" are Complete.





BUSINESS IMPACT
-----------------------
The issue has the following business impact :Workflows that are currently being processed through completion are not deleting rows from Tables OTA_BULK_ENR_REQUESTS and OTA_BULK_ENR_REQ_MEMBERS.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms