Issue In 'Build Sessions' With 'Delete Existing Sessions' - Data Mismatch In Parent Child Tables (Doc ID 2188789.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Issue in 'Build sessions' with 'Delete Existing Sessions' - Data mismatch in parent child tables  

If you give a session date less than the class start date, and 'Build sessions' with 'Delete existing sessions' check box selected => Existing sessions are not getting deleted , system will throw an error 'Session date prior to class start date' -> click OK -> still sessions will be created with the newly given session date(less than class start date)  ==> Leads to creation of two session ids in backend. Now if you revert back to the correct date >= class start date and build again with 'Delete existing sessions' selected=> A new session id will be created. The first session id will get deleted from PS_LM_SES, but not from PS_LM_SES_INSTR(Data mismatch in parent&child). The session id created for date< class date still remains. Please refer the attached document for more understanding.

EXPECTED BEHAVIOR
-----------------------
The existing sessions should be deleted when the 'Delete existing sessions' is checked, in the same way, when the system shows a message like "Session date prior to Class Start date", user expects the session will not create, but the system creating sessions,

REPLICATION STEPS
-----------------------
1. Pick a class , edit the session date to a date less than the class start date,add an instructor and 'Build sessions' with 'Delete existing sessions' check box selected => Existing sessions are not getting deleted
2.System will throw an error 'Session date prior to class start date' -> click OK -> select 'cancel' to continue in the next dialog box,Check the situation in backed. Still sessions will be created with the newly given session date(less than class start date)  ==> Leads to a situation of two session ids in backend.
3. Now if you revert back to the correct date which is >= class start date , and build again with 'Delete existing sessions' selected=> A new session id will be created(Total 3 till now). The first session id will get deleted from PS_LM_SES, but not from PS_LM_SES_INSTR(Data mismatch in parent&child). The session id created in step 2 remains. Please refer the attached document for more understanding


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