My Oracle Support Banner

The view LM_INSTR_SRCH Returns Multiple Rows for the same OPRID (Doc ID 2779213.1)

Last updated on MAY 31, 2021

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

When querying the view LM_INSTR_SRCH (SELECT * FROM PS_LM_INSTR_SRCH) is returning multiple rows for the same OPRIDS linked with different Person Ids.
What is the reason for this behaviour?
 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.