We are upgrading to release 12.2.8 and getting the following error when trying to run update project and resource base summaries ORA-20044:
Environment is not setup to run summarization. Check PJI setup and PA
profiles
We checked the following profile options and it all looks correct
PJI: Organization Security Profile
PJI: Truncate PJI Summary Tables => No
PJI: Use DBI Request Set Generator => Yes
BIS: Enterprise Calendar
BIS: Global Start Date (mm/dd/yyyy)
BIS: Implementation Type
BIS: Period
BIS: Primary Currency
BIS: Primary Rate Type
BIS: Start Day of Week
MO: Security Profile
HR: Security Profile
And for 12.2.+
PA: Global Start Date (mm/dd/yyyy) (PA_GLOBAL_START_DATE)
PA: Primary Currency (PA_PRIMARY_CURRENCY_CODE)
PA: Primary Rate Type (PA_PRIMARY_RATE_TYPE)
PA: Secondary Currency (PA_SECONDARY_CURRENCY_CODE)
PA: Secondary Rate Type (PA_SECONDARY_RATE_TYPE)
PA: Enterprise Calendar (PA_ENTERPRISE_CALENDAR)
PA: Period (PA_PERIOD_TYPE)