My Oracle Support Banner

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

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
Symptoms
Cause
Solution
References


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