Top Ten Orders By Invoice Days Report In Supply Chain Management Dashboard Is Not Working . (Doc ID 1958921.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

The Top Ten Orders by Invoice Days Report generates physical SQL that includes the following predicates:

W_STATUS_CLASS = 'FULFILLMENT_STATUS' & W_STATUS_CODE ='ORDER FULLY INVOICED'


However, your data does not have any dimension rows with this combination.

Source is eBS 12.1.3.

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