Incorrect Translate Values Are Referred In SQL View LM_ACT_AUTO2_VW (Doc ID 2234863.1)

Last updated on FEBRUARY 17, 2017

Applies to:

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

Symptoms

Incorrect Translate values are referred in SQL definition in LM_ACT_AUTO2_VW view

Steps

----------

Open the Application Designer
Open the Record "LM_ACT_AUTO2_VW"
Open the SQL View for this record
now, the criteria for the filed LM_ACT_STATUS is as below:
AND LM_ACT_STATUS NOT IN ('COMP', 'INCO')
which is incorrect the field LM_ACT_STATUS has translate values of 1,2,3,4,5 but in the SQL view its checked against 'COMP and 'INCO' status.

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