My Oracle Support Banner

OBIA 11g: Measure "# Of On Hold Fulfillment Lines" Is Empty (Doc ID 2428691.1)

Last updated on FEBRUARY 19, 2019

Applies to:

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

Symptoms

On OBIA:  11.1.1.10.2 version, Analytics
Source: EBS 12.2.6
Module: Finance, HR and SC


Measure "Fact - Sales Order Lines.# of On Hold Fulfillment Lines" is empty
All reports that depend on this fact returns no values, whereas in source many order lines are 'On hold'.

The following query returns no values.

select * from W_SALES_ORDER_LINE_F t where t.ON_HOLD_FLG = 'Y'

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
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.