My Oracle Support Banner

OTBI - Procurement - Procure To Pay Real Time Subject Area "Delivery Obsolete" Errors Out [nQSError: 77031] (Doc ID 2494931.1)

Last updated on FEBRUARY 01, 2020

Applies to:

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

Symptoms

After adding "Procurement - Procure To Pay Real Time"."Delivery Obsolete"."Receipt Date" to the analysis, the results error with:

 

State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: ADFException-3007: The View Object "FscmTopModelAM.PersonAM.PersonRefPVO" is used as the destination of more than one View Link. (HY000)

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency1';
SELECT0 s_0,"Procurement - Procure To Pay Real Time"."Delivery Obsolete"."Receipt Date" s_1,
"Procurement - Procure To Pay Real Time"."Invoice"."Delivery Amount" s_2,
"Procurement - Procure To Pay Real Time"."Invoice"."Invoice" s_3,
"Procurement - Procure To Pay Real Time"."Invoice"."Receipt Date" s_4,
"Procurement - Procure To Pay Real Time"."Invoice"."Receipt Number" s_5,
"Procurement - Procure To Pay Real Time"."Purchase Order"."Order" s_6,"
Procurement - Procure To Pay Real Time"."Requisition"."Requisition Number" s_7,
"Procurement - Procure To Pay Real Time"."Supplier"."Supplier Name" s_8,
"Procurement - Procure To Pay Real Time"."Purchase Order Measures"."Delivered Quantity" s_9
FROM "Procurement - Procure To Pay Real Time"
FETCH FIRST 75001 ROWS ONLY





Changes

 Added "Delivery Obsolete"."Receipt Date" to the Analysis

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.