Custom LMS Report when no Story Reports enabled.

3 weeks ago

Corgi Sap

1 minute

Custom reports created directly in LMS (this means in Plateau) have to be design through the “Plateau Report Designer (PRD)”.

SAP Help “how to” with videos step by step	https://help.sap.com/docs/SUPPORT_CONTENT/lm/3354618691.html

It is required to call the following tables:

PA_VLE_ENROLL_SEAT
PA_VLE_EVENT

The duration is shown in seconds, but the EVENT_DURATION is by hour (ie 1.0 = 1 hour, 1.1 = 1 hour 6 mins, etc.)

https://community.sap.com/t5/human-capital-management-q-a/in-table-pa-vle-enroll-seat-there-is-a-field-attendance-duration-need-to/qaq-p/13772278

Troubleshooting

There is an error in get connection, java.sql.SQLException: de.simplicit.vjdbc.VJdbcException: User is null

Probably you have 2 test instances stage and test.

The VJDBC connections are given to only one stage or test instance per customer, but you can request to transfer the VJDBC connection to another preview instance.

https://me.sap.com/notes/2171592