Can Not Build LM_AP_CM_ENR_VW View - Getting Invalid Column Error due to EOAW_COMMENTS Record Missing OPERATOR ID Field (EOAW_OPRID) (Doc ID 2110748.1)

Last updated on FEBRUARY 25, 2016

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ELM 9.2 Unable to build the View LM_AP_CM_ENR_VW - Gets Invalid Column error, due to EOAW_OPRID field is missing from PS_EOAW_COMMENTS table.

STEPS TO REPLICATE
--------------------
Built the record LM_AP_CM_ENR_VW in the Application Designer

ERROR MESSAGE
-----------------------
Invalid column name 'EOAW_OPRID'.

BUSINESS IMPACT
-------------------
Due to this issue, Learning Admin can't enroll the students in the class.

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