1. Connect to Stat DB, with the user Stat and run the following instruction:
CREATE OR REPLACE FORCE NONEDITIONABLE VIEW "STAT"."BUS_RULES_CSR_PARAMS_VW1"
("SD_CD", "CSR_ID", "SERVICE_DOMAIN", "TITLE", "CUSTOMER_LAST_NAME", "CUSTOMER_FIRST_NAME", "APPLICATION_CODE", "APPLICATION", "ENVIRONMENT_CODE", "ENVIRONMENT", "CSR_TYPE_CODE", "CSR_TYPE", "PRIORITY_CODE"
, "PRIORITY", "CUST_PRIORITY_CODE", "CUST_PRIORITY", "PROJECT_CODE", "PROJECT", "WORKFLOW_ID", "WORKFLOW", "STATUS_CODE", "STATUS", "DEPARTMENT", "IS_CLOSED", "TRACKING_NUMBER", "OPEN_DATE", "CLOSE_DATE"
, "UPDATE_DATE", "LAST_UPDATE_DATE", "CREATED_USER_ID", "UPDATED_USER_ID", "ASSIGNED_USER_ID", "QUEUE_ID", "QUEUE", "HAS_BEEN_READ_FLAG") AS
SELECT A.SD_CD, A.CSR_ID, B.DESCR, A.DESCR_SHORT, C.LAST_NAME, C.FIRST_NAME, D.APPL_CD, D.DESCR, E.APPL_ENV_CD, E.DESCR, F.CSR_TYPE_CD, F.DESCR, G.PRIORITY_CD, G.DESCR, H.PRIORITY_CUST
, H.DESCR, I.PROJ_CD, J.DESCR, K.WRKFLW_ID, K.WRKFLW_NAME, L.CSR_STATUS_CD, L.DESCR, M.DESCR, N.CLOSED_STATUS_FLAG, A.TRACKING_NUMBER, N.OPEN_DT, N.CLOSE_DT, A.UPDATE_DT
, CLU.UPDATE_DT, -- added for STAT-5713
N.OPEN_USERID, N.UPDATE_USERID, N.ASSIGNED_USERID, QU.QUEUE_ID, QU.DESCR, N.HAS_BEEN_READ_FLAG
FROM STAT.CSR_MASTER_TBL A
JOIN STAT.SERVICE_DOMAIN B ON B.SD_CD = A.SD_CD
JOIN STAT.CUSTOMERS C ON C.CUST_ID = A.CUST_ID
JOIN STAT.DEPARTMENT M ON M.DEPT_ID = C.DEPARTMENT
JOIN STAT.APPL_TYPE D ON D.SD_CD = A.SD_CD AND D.APPL_CD = A.APPL_CD
LEFT JOIN STAT.APPL_ENV E ON E.SD_CD = A.SD_CD AND E.APPL_CD = A.APPL_CD AND E.APPL_ENV_CD = A.APPL_ENV_CD
JOIN STAT.CSR_TYPE_CD F ON F.SD_CD = A.SD_CD AND F.CSR_TYPE_CD = A.CSR_TYPE
JOIN STAT.CSR_STATUS N ON N.SD_CD = A.SD_CD AND N.CSR_ID = A.CSR_ID
JOIN STAT.PRIORITY G ON G.PRIORITY_CD = N.PRIORITY_CD AND G.SD_CD = N.SD_CD
LEFT JOIN STAT.CUSTOMER_PRIORITY H ON H.SD_CD = N.SD_CD AND H.PRIORITY_CUST = N.PRIORITY_CUST
JOIN STAT.CSR_STATUS_CD L ON L.SD_CD = N.SD_CD AND L.CSR_STATUS_CD = N.CSR_STATUS_CD AND L.CSR_TYPE_CD = A.CSR_TYPE
LEFT JOIN STAT.PROJ_CSRS I ON I.SD_CD = A.SD_CD AND I.CSR_ID = A.CSR_ID
LEFT JOIN STAT.PROJ_DEFN J ON J.PROJ_CD = I.PROJ_CD
LEFT JOIN STAT.CSR_WRKFLW_DEFN K ON K.SD_CD = A.SD_CD AND K.CSR_ID = A.CSR_ID
JOIN STAT.QUEUE QU ON QU.SD_CD = N.SD_CD AND QU.QUEUE_ID = N.QUEUE_ID
JOIN STAT.CSR_LAST_UPDATE CLU ON CLU.SD_CD = A.SD_CD AND CLU.CSR_ID = A.CSR_ID;
2. If you still get the error ORA-38824, try to run the same statement deleting the word "NONEDITIONABLE" from the script.
3. If the first 2 step doesn't work, connect to the Stat database as SYSTEM and run the following statement:
ALTER STAT.BUS_RULES_CSR_PARAMS_VW1 ENABLE EDITIONS, then run the original script again.
