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.
Incorrect Translate values are referred in SQL definition in LM_ACT_AUTO2_VW view
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.
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