OBIA 11g - Purchase Order Number Search Filter doesn't bring all applicable values back

(Doc ID 2350238.1)

Last updated on FEBRUARY 16, 2018

Applies to:

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

Symptoms

'Procurement and Spend - Purchase Order' Subject Area, Purchase Order Number is being sourced from multiple logical table (W_PURCH_COST_F and W_AP_XACT_F)

For the prompt PO Number column it sources data from W_AP_XACT_F (as that is economical table) versus in the report when the same PO Number column combined with other column then it goes to W_PURCH_COST_F.

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