STARETL Fails With Error: "ORA-20101: Calculation for W_ACTIVITY_WORK_DOWN_HF.REMAINING_UNITS does not exist" (Doc ID 1578418.1)

Last updated on OCTOBER 07, 2016

Applies to:

Primavera Data Warehouse - Version R3.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the STARETL process, the following error occurs.

ERROR
-----------------------
(Progress) - Step 18/48 Part 1/1 - FAILED (20101) (0 hours, 0 minutes, 0 seconds, 530 milliseconds)

staretl [INFO] (Progress) - Step 18/48 Part 1/1 - [08/16/2013 15:02:18] CreateBaselineSpreadView part 2 -- Create the baseline spread views (create_baseline_spread_views_2.sql)
staretl [INFO] (Message) - === Step 18, Part 1 ====================================================
staretl [INFO] (Message) - === Create the baseline spread views (create_baseline_spread_views_2.sql)
staretl [INFO] (Message) - BEGIN
staretl [INFO] (Message) - *
staretl [INFO] (Message) - ERROR at line 1:
staretl [INFO] (Message) - ORA-20101: Calculation for W_ACTIVITY_WORK_DOWN_HF.REMAINING_UNITS does not
staretl [INFO] (Message) - exist.
staretl [INFO] (Message) - ORA-06512: at "STARUSER.METADATA", line 36
staretl [INFO] (Message) - ORA-06512: at "STARUSER.CALCULATION", line 11
staretl [INFO] (Message) - ORA-06512: at "STARUSER.WORKDOWN_VIEWS", line 6
staretl [INFO] (Message) - ORA-06512: at "STARUSER.WORKDOWN_VIEWS", line 241
staretl [INFO] (Message) - ORA-06512: at line 3
staretl [INFO] (Progress) - Step 18/48 Part 1/1 - FAILED (20101) (0 hours, 0 minutes, 0 seconds, 530 milliseconds)

staretl [INFO] (Message) - Reading Properties file

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the STARETL process.

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