Forum

Notifications
Clear all

Comparing two different LMS systems report for missing entries in one of them

5 Posts
2 Users
0 Reactions
87 Views
(@ramezattar)
Posts: 3
Active Member
Topic starter
 

Hi Experts, 

In my Org. we're using two LMS systems (Oracle LMS -entries entered manually for purpose of trackingand it's linked to payroll-  & SAP Success Factor -main LMS system in use and auto update entries-) been informed that Oracle entries are not matching SAP records so there is missing in entires in report from 01.01.2022 to 10.12.2022

How I can check specially a lot of employee IDs is repeated as they could have done more than one training (multiple transactions per ID)

Number of rows in Oracle report (which missing entries) is even more than number of rows in SAP report which is rigid.

I have current employee list from payroll, but some employees has left business since Jan 2022 so their IDs might appear in Orcale / LMS reports but not in current employee list.

 
Posted : 11/12/2022 4:38 pm
(@mgbsher)
Posts: 35
Trusted Member
 

If you may post a sample of the layout files that would be helpful in solving it.

 
Posted : 11/12/2022 6:55 pm
(@ramezattar)
Posts: 3
Active Member
Topic starter
 

@MGB

Attached

 
Posted : 12/12/2022 10:16 am
(@mgbsher)
Posts: 35
Trusted Member
 

Hi R.A.

Please, some extra questions:

  1. Which file was generated from the Oracle system? is it OLM-01012022-05122022-1.xlsx (659 KB)?
  2.  Regarding the date you mentioned, is it the 12th of October, or the 10th of December because the earlier one is 01.01.2022?
  3. Are employees that left the business those who have Ex-employee under the Person Type column in the file OLM-01012022-05122022-1.xlsx?
  4. Pending Termination under the Assignment Status in the file Employee-list-NOV2022.xls, are they regular employees?

Also after a quick scan of the data, I've found some changes as shown in pictures.

The reason for my questions is to know the main starting point for comparing and building on it.

 

Screenshot_20221212_080242.png

Screenshot_20221212_080304.png

Screenshot_20221212_080315.png 

Thanks

MGB

 
Posted : 13/12/2022 2:09 pm
(@mgbsher)
Posts: 35
Trusted Member
 

Hi,

The data is really not clean.

The only column that may be used is the employee ID.

The training name is not titled the same in both sheets, but sometimes it is titled followed by month and others without it, and for those that include the month name, the name of the month sometimes is the full name and other times not.

The suggested solution from my side is attached.

It takes a lot of manual work indeed, and so far I've spent 4 hours working on it.

I am not an expert with Excel but this is the best I can do.

You can continue what I did, or maybe some other members have an advanced solution for your issue like a formula that collects and match.

Good luck.

https://www.mediafire.com/file/q6qgxmv9v7q3p6y/Book1.xlsx/file

 
Posted : 13/12/2022 6:10 pm
Share: