The "Time Distributed Interval" = Week Setting Is Not Present in the SETTINGS Table (Doc ID 2223177.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.1.3.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
The "time distributed interval" = Week setting is not present in the SETTINGS table.

EXPECTED BEHAVIOR

The "time distributed interval" = Week setting should be present in the SETTINGS table.

STEPS TO DUPLICATE:

The issue can be reproduced at will with the following steps:
1. Enable publication and set the "Time distributed" interval to "week" (Administer/application settings/services)
2. Run the following query :
    select * from settings where upper(namespace) like 'PX%' order by namespace;
3. Notice there is no "PxService.TimeDistribution " entry in the settings table.

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, the actual "Time distributed" interval is calculated per day.

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