My Oracle Support Banner

HDL Error When Trying To Withdraw From Course (Doc ID 2786600.1)

Last updated on JULY 01, 2021

Applies to:

Oracle Fusion Learning Management Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Data Load

When attempting to withdraw existing Learning Records via the same Learning Record HDL file, the following error occurs.

An error occurred. To review details of the error run the HCM Data Loader Error Analysis Report diagnostic test. Message details: JBO-handleLogicalCorrection()::oracle.jbo.JboException: JBO-updateLearningRecord()::oracle.jbo.JboException: JBO-validateAdvanceRulesAttributesforUpdate::oracle.jbo.JboException: JBO-Validation failed! Learning Record status cannot be updated when RENEWAL OPTION is enabled at Advanced Rules.: STRINGMANAGER: Key: 'Validation failed! Learning Record status cannot be updated

After updating the Renewal Option from enabled or Y to disabled or N in the Advanced Rules, the load completes as expected.

However, follow up question was asked What if a user, who has a learning assignment for the Course, logs in and completes the course? Will they get a future assignment based on Renewal Option? Or will that be skipped because the rules don't exist since I removed them
in which response was given

The "Default Assignment Rules" on the Course level is used as the default values for new required assignments created on the Course level. Changing the "Default Assignment Rules" on the Course level does not affect existing assignments. The customer can then edit the assignment, change the recurrence option, and click "Save Rules Override"; or withdraw/delete the active record from the UI instead of HDL

but then the follow-up concern was raised over a hundred Learners assigned to each Course, and there are dozens or more Courses which need be updated in bulk via HDL--Managing from UI is not feasible. Asked if there a way to use HDL to mimic the process of Save Rules Override?

The issue can be reproduced at will with the following steps:
1. Attempt to load LearningRecord.dat HDL file to withdraw courses
2. Encounter error message above
3. Able to load after updating the Renewal Option from enabled or Y to disabled or N in the Advanced Rules
4. still has concerns about this setting and how to mimic the process via HDL as in the Fusion OLC UI


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.