Hi,
I have created a view with the below code. I have created an Interactive report based on this view.
CREATE OR REPLACE FORCE EDITIONABLE VIEW RFJVBASE.FCT_KPI_COCKPIT_RATING_V
(PROCESS_KEY_FCT, CURRENT_PROCESS_RATING_KEY, PROCESS_RATING_KEY, CREATED_FISCAL_WEEK, VALID_THROUGH_FISCAL_WEEK, PROCESS_NAME, PROCESS_GROUP, PROCESS, PROCESS_INDICATOR_CLASS, PROCESS_INDICATOR_SEQUENCE, PERFORMANCE_INDICATOR_NAME,
PERF_IND_SUB_LEVEL, UNIT, KPI_TYPE, ORG_UNIT, QUALITATIVE_RESULT, QUANTITATIVE_RESULT, TARGET, TARGET_ENABLE_FLAG, COMMENTS, DOC_UPLOAD, MIME_TYPE, DOC_NAME, DOC_LAST_UPDATE_DT, CHARSET, CREATED_DT, CREATED_BY,
LAST_UPDATE_DT, LAST_UPDATED_BY, AUDIT_KEY) AS
SELECT
FCT_KPI_COCKPIT_RATING.process_key_fct,
FCT_KPI_COCKPIT_RATING.current_process_rating_key,
FCT_KPI_COCKPIT_RATING.process_rating_key,
FCT_KPI_COCKPIT_RATING.created_fiscal_week,
FCT_KPI_COCKPIT_RATING.valid_through_fiscal_week,
DIM_KPI_COCKPIT_ATTRS.PROCESS_NAME,
DIM_KPI_COCKPIT_ATTRS.PROCESS_GROUP,
DIM_KPI_COCKPIT_ATTRS.PROCESS,
DIM_KPI_COCKPIT_ATTRS.PROCESS_INDICATOR_CLASS,
DIM_KPI_COCKPIT_ATTRS.PROCESS_INDICATOR_SEQUENCE,
DIM_KPI_COCKPIT_ATTRS.PERFORMANCE_INDICATOR_NAME,
DIM_KPI_COCKPIT_ATTRS.PERF_IND_SUB_LEVEL,
DIM_KPI_COCKPIT_ATTRS.UNIT,
DIM_KPI_COCKPIT_ATTRS.KPI_TYPE,
DIM_KPI_COCKPIT_ATTRS.ORG_UNIT,
FCT_KPI_COCKPIT_RATING.qualitative_result,
FCT_KPI_COCKPIT_RATING.quantitative_result,
FCT_KPI_COCKPIT_RATING.target,
DIM_KPI_COCKPIT_ATTRS.TARGET_ENABLE_FLAG,
FCT_KPI_COCKPIT_RATING.comments,
FCT_KPI_COCKPIT_RATING.doc_upload,
FCT_KPI_COCKPIT_RATING.mime_type,
FCT_KPI_COCKPIT_RATING.doc_name,
FCT_KPI_COCKPIT_RATING.doc_last_update_dt,
FCT_KPI_COCKPIT_RATING.charset,
FCT_KPI_COCKPIT_RATING.created_dt,
FCT_KPI_COCKPIT_RATING.created_by,
FCT_KPI_COCKPIT_RATING.last_update_dt,
FCT_KPI_COCKPIT_RATING.last_updated_by,
FCT_KPI_COCKPIT_RATING.audit_key
FROM RFJVBASE.DIM_KPI_COCKPIT_ATTRS, RFJVBASE.FCT_KPI_COCKPIT_RATING
WHERE FCT_KPI_COCKPIT_RATING.PROCESS_RATING_KEY = DIM_KPI_COCKPIT_ATTRS.PROCESS_KEY
and DIM_KPI_COCKPIT_ATTRS.EFF_TO_DT = TO_DATE('31-DEC-9000', 'DD-MON-YYYY')
and FCT_KPI_COCKPIT_RATING.CREATED_FISCAL_WEEK in (select run_dates('1-Jan-1900') from dual)
WITH CHECK OPTION;
I'm able to view the data correctly in the report. But when I try to modify any record from the Form page, I get below error, as shown in screenshot. I can however, update this view in the DB without any issues. Need suggestion on the same.
Please note that that columns that are pulled from the DIM_KPI_COCKPIT_ATTRS table are all set to display only, and the users need to modify only the columns that are being pulled from FCT_KPI_COCKPIT_RATING.
Thanks!!