ANALYSIS_DATE Always Seems to be on a Sunday in the MSC_SUPPLIERS_F Table (Doc ID 1949538.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Planning Command Center - Version 12.2.3 and later
Information in this document applies to any platform.

Goal

In a VCP 12.2.3 Instance:
ANALYSIS_DATE always seem to be on a Sunday in the MSC_SUPPLIERS_F table. What is influencing this?

Noticed all of the dates in ANALYSIS_DATE is on Sunday even though the ASCP plan has 30 days of daily buckets and there are supply orders on other days of the weekend.

-- Navigation path, on how to consistently reproduce the issue.
Create a horizontal supplier dashboard at the day level or look at the data in the MSC_SUPPLIERS_F table
 

Solution

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