My Oracle Support Banner

After Upgrade Cash Flow Not Updating with changes to Cost Sheet and Schedule Sheet, and Displays Alert Error 'ORA-00904: "A"."PERIOD_DATES": Invalid Identifier'. (Doc ID 2667466.1)

Last updated on MAY 06, 2020

Applies to:

Primavera Unifier Cloud Service - Version 19.12.4.0 to 19.12.4.0 [Release 19.12]
Primavera Unifier - Version 19.12.4.0 to 19.12.4.0 [Release 19.12]
Information in this document applies to any platform.

Symptoms

When updating a Cost Sheet Value or Schedule Sheet Date, saving the changes to a project that existed before the 17.7 > 19.12 Upgrade the changes are not recording in the Cash Flow Curve Data.

ERROR

'ORA-00904: "A"."PERIOD_DATES": Invalid Identifier'.

STEPS TO REPRODUCE

  1. Access a User with access to Cash Flow / Cost Sheets and Schedule Sheet
  2. Navigate to a project that was in existence before upgrade
  3. Review Cash Flow Sheet for Capital - Check Estimated "Expected Final Cost" and Dates To and From
  4. Navigate to Cost Sheet, Make change to "Expected Final Cost" Save or Apply depending on screen
  5. Select Cash Flow, and Refresh the Cash Flow Capital
  6. When refresh is complete Open Cash Flow Capital
    RESULTS:
    1. SEE the Alert(Error) link and open 'ORA-00904: "A"."PERIOD_DATES": Invalid Identifier'.
    2. No change to the Value in the "Expected Final Cost" as saved in step 4
  7. Navigate to "Schedule Sheet " Make a "Start" or "End" Date change
  8. Select Cash Flow, and Refresh the Cash Flow Capital
  9. When refresh is complete Open Cash Flow Capital
    RESULTS:
    1. SEE the Alert(Error) link and open 'ORA-00904: "A"."PERIOD_DATES":Invalid Identifier'.
    2. No change to the Dates as saved in step 4

Changes

 Upgrade from 17.7 > 19.12

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.