My Oracle Support Banner

Proc-Procure To Pay Real Time Throw Error When Including Invoice Columns (Doc ID 2673226.1)

Last updated on JUNE 01, 2020

Applies to:

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

Symptoms

On : 11.13.20.01.0 version, Technology Management - Reports/Analytics

When attempting to include Invoice columns to "Proc-Procure to Pay Real Time" Subject Area the following error occurs.

SELECT
0 s_0,
"Procurement - Procure To Pay Real Time"."Invoice"."Invoice" s_1,
"Procurement - Procure To Pay Real Time"."Ship To Location"."Town or City"
s_2
FROM "Procurement - Procure To Pay Real Time"


ERROR
-----------------------
[2020-03-10T12:29:33.290+00:00] [OracleBIServerComponent] [TRACE:7] [] [] [ecid: 005c7x5bj9b5i^E_R5k3yd0003f_0001wr,0:1:2:1:23:5] [tid: 6dbf700] [messageid: USER-34] [requestid: cc690022] [sessionid: cc690000] [username: sbalraj-ext] -------------------- Query Status: [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: ADFException-3010: The View Link "oracle.apps.financials.payables.invoices.transactions.publicView.analytics.link.InvoiceDistributionPVOLocIdToLocationPVO" cannot be used to join View Object "FscmTopModelAM.PartiesAnalyticsAM.Location (Dim_FscmPartiesAM_Location_Ship_To_InvoiceDistributionProcPVO_P2P)". [[
[nQSError: 43119] Query Failed:



Changes

Attempting to include Invoice columns to "Proc-Procure to Pay Real Time" Subject Area 
SELECT
0 s_0,
"Procurement - Procure To Pay Real Time"."Invoice"."Invoice" s_1,
"Procurement - Procure To Pay Real Time"."Ship To Location"."Town or City"
s_2
FROM "Procurement - Procure To Pay Real Time"

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