Getting ORA-00904: OFSA_PROCESS_ID_RUN_OPTIONS_V.ARRAY_SIZE_ROWS: invalid identifier Running RM Process (Doc ID 455232.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Risk Manager - Version 4.5.39 and later
Information in this document applies to any platform.
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

In Oracle Risk Manager, a Process ID ends with an "internal error" and the following error appears in the ofsrm.xxxxx file on the server:

OCI Function: [4] - oexec(), oexn()
SQL Function: [0] - SQL function not found!
Oracle Error: ORA-00904: "OFSA_PROCESS_ID_RUN_OPTIONS_V"."ARRAY_SIZE_ROWS": invalid identifier

Driver Function: drv_oci::Execute()

SQL Statement: select
OFSA_PROCESS_ID_RUN_OPTIONS_V.STEP_NAME,OFSA_PROCESS_ID_RUN_OPTIONS_V.SYS_ID_NUM,OFSA_PROCESS_ID_RUN
_OPTIONS_V.NUM_OF_PROCESSES,OFSA_PROCESS_ID_RUN_OPTIONS_V.COMMIT_FREQUENCY,OFSA_PROCESS_ID_RUN_OPTIO
NS_V.ARRAY_SIZE_ROWS,OFSA_PROCESS_ID_RUN_OPTIONS_V.PROCESS_DATA_SLICES_CD,OFSA_PROCESS_ID_RUN_OPTION
S_V.PROCESS_PARTITION_CD,OFSA_PROCESS_DATA_SLICES_DTL.COLUMN_NAME,OFSA_PROCESS_DATA_SLICES_DTL.PROCE
SS_DATA_SLICES_SEQ from OFSA_PROCESS_ID_RUN_OPTIONS_V,OFSA_PROCESS_DATA_SLICES_DTL where
OFSA_PROCESS_ID_RUN_OPTIONS_V.PROCESS_DATA_SLICES_CD =
OFSA_PROCESS_DATA_SLICES_DTL.PROCESS_DATA_SLICES_CD(+) and ((SYS_ID_NUM = 0) or (SYS_ID_NUM=100053)) AND (PROCESS_ENGINE_CD = 2) order by OFSA_PROCESS_ID_RUN_OPTIONS_V.SYS_ID_NUM,
OFSA_PROCESS_ID_RUN_OPTIONS_V.STEP_NAME, OFSA_PROCESS_DATA_SLICES_DTL.PROCESS_DATA_SLICES_SEQ

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