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