Error In Step 16/49 Part 2/2: ORA-00904: "SYS_STG_WF_PROCESS"."current_step_name": invalid identifier When Running ETL Process Against a Unifier Oracle Database.

(Doc ID 2294648.1)

Last updated on OCTOBER 25, 2017

Applies to:

Primavera Analytics - Version 15.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting the first run of the Unifier Analytics ETL Process, the following error occurs in Step 16/49 Part 2/2:

----------------------
staretl [INFO] (Message) - ORA-06512: at "STARUSER.EXTRACT2STAGING", line 93
staretl [INFO] (Message) - Exception: Error during extract for table STG_WORKFLOWTASK: ORA-00904: "SYS_STG_WF_TASK"."s
staretl [INFO] (Message) - (100,SYS_STG_WF_TASK,STG_WORKFLOWTASK,n/a,n/a)
staretl [INFO] (Message) - DECLARE
staretl [INFO] (Message) - *
staretl [INFO] (Message) - ERROR at line 1:
staretl [INFO] (Message) - ORA-00904: "SYS_STG_WF_TASK"."step_end_date": invalid identifier
staretl [INFO] (Message) - ORA-06512: at "STARUSER.EXTRACT2STAGING", line 141
staretl [INFO] (Message) - ORA-06512: at line 4
staretl [INFO] (Progress) - Finished Script STG_WORKFLOWTASK.sql
staretl [INFO] (Message) - Adding sql script W_CASH_FLOW_FS.sql to the job queue
staretl [INFO] (Progress) - Starting Script W_CASH_FLOW_FS.sql
staretl [INFO] (Message) - ORA-06512: at "STARUSER.EXTRACT2STAGING", line 93
staretl [INFO] (Message) - Exception: Error during extract for table STG_WORKFLOWPROCESS: ORA-00904: "SYS_STG_WF_PROCE
staretl [INFO] (Message) - (100,SYS_STG_WF_PROCESS,STG_WORKFLOWPROCESS,n/a,n/a)
staretl [INFO] (Message) - DECLARE
staretl [INFO] (Message) - ORA-06512: at "STARUSER.EXTRACT2STAGING", line 93
staretl [INFO] (Message) - *
staretl [INFO] (Message) - Exception: Error during extract for table STG_WORKFLOW: ORA-00904: "SYS_STG_WORKFLOW"."step
staretl [INFO] (Message) - ERROR at line 1:
staretl [INFO] (Message) - (100,SYS_STG_WORKFLOW,STG_WORKFLOW,n/a,n/a)
staretl [INFO] (Message) - ORA-00904: "SYS_STG_WF_PROCESS"."current_step_name": invalid identifier


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