OBIA - Purchase Order Number Is Read From AP Tables Instead Of PO Tables (Doc ID 2001428.1)

Last updated on JANUARY 31, 2017

Applies to:

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


You are implementing OBIA, Financial Analytics, Procurement and Spend Analytics, and Project Analytics.
When creating a new analysis from "Procurement and Spend - Purchase Orders" subject area, when you select Purchase Order Number from "Purchase Details" and try adding a filter on Purchase Order Number, all PO Numbers are not shown.
Looking at the session log you see that the PO Numbers are fetched from W_AP_XACT_F instead of W_PURCH_COST_F.  Hence, if PO is not associated with AP, it is not shown in the selection.

It is possible to put the value in the filter criteria instead of doing the search but the issue is not about adding the filter criteria for PO Number manually and not getting the results. The issue is about not able to see the PO Number when searched even though it exists.
This causes lot of confusion for the users since they frequently use the search button for selecting the values for a filter since this functionality is available in Answers.

 1.    Create a new Adhoc Report using «Procurement and Spend – Purchase Orders » Subject Area
 2.    Include the following columns in the report : "Purchase Details"."Purchase Order Number", "Fact - Purchase Orders"."PO Amount"



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