Fusion OTBI : Requester Name is blank in Procurement - Purchasing Real Time (Doc ID 2194390.1)

Last updated on OCTOBER 26, 2016

Applies to:

Oracle Fusion Purchasing Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Application Toolkit - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

Requester Name is blank in Procurement - Purchasing Real Time, Unable to join the Purchase requester name and PO Details


Procurement - Purchasing Real Time

SQL Query
SELECT
  0 s_0,
  "Procurement - Purchasing Real Time"."- Purchase Order Distribution Detail"."Requisition" s_1,
  "Procurement - Purchasing Real Time"."- Requester"."Purchase Requestor Name" s_2,
  "Procurement - Purchasing Real Time"."Purchase Order Header Detail"."Order" s_3
FROM "Procurement - Purchasing Real Time"
ORDER BY 1, 4 ASC NULLS LAST, 2 ASC NULLS LAST, 3 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY



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