My Oracle Support Banner

Updating the Completion Date of a Course Recently Added in the Learning Path of an Appraisal is Erroring with ORA-01403: No Data Found In Package Ota_lp_member_enrollment_swi (Doc ID 2035591.1)

Last updated on APRIL 13, 2021

Applies to:

Oracle Performance Management - Version 12.2.4 and later
Information in this document applies to any platform.
This note provides a brief overview of Bug: 21286384 - APPRAISAL: UPDATE COURSE COMPLETION DATE ERRORS WITH ORA-01403: NO DATA FOUND


Problem Statement:

When attempting to update the completion date of a course recently added in the learning path of an appraisal, the following error occurs.

ORA-01403: no data found in Package ota_lp_member_enrollment_swi Procedure create_lp_member_enrollment

Steps to Reproduce:

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

  1.   Responsibility: Employee Self-Service responsibility

  2.   Function: Appraisals

  3.   See an appraisal for one employee

  4.   Update icon

  5.   Learning Path section - Add Courses button

  6.   See the Add courses page

  7.   Retrieve courses

  8.   Select 2 courses - Add Completion Date for one course

  9.   Apply

10. Both courses are added in Learning Path: Appraisal

11. Update the course having a completion date.

12. Now update date to a new one

13. Click continue

14. See the error.


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.