My Oracle Support Banner

PRC:SSP: Error Exists when View Requisition Summary Report (Doc ID 2451406.1)

Last updated on JUNE 22, 2020

Applies to:

Oracle Fusion Self Service Procurement - Version 11.13.18.05.0 and later
Oracle Fusion Self Service Procurement Cloud Service - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

Symptoms

Analysis report is created through using subject area [Procurement - Requisitions Real Time].

The creator account can view it normally.

Report is saved into sharefolder/custom/procurement.

The report generation fails when tested with the requester's account. Encountered error by showing as follows:

Error getting drill information: SELECT "Requisition Header Detail"."Requisition Number" saw_0, "Requisition Header Detail"."Justification" saw_1, "- Requisition Distribution Detail"."UOM Description" saw_2, "- Purchasing Line Type"."Purchase Line Type Code" saw_3, "- Requisition Line"."Requisition Quantity" saw_4, "- Requisition Line Detail"."Line Description" saw_5, "- Requisition Line Detail"."Note to Supplier" saw_6, "- Requisition Line Detail"."Purchase Order Number" saw_7, "- Requisition Line Detail"."Unit Price" saw_8, "- Buyer"."Purchase Buyer Name" saw_9, "- Requisition Line Status"."Line Status Meaning" saw_10, "- Procurement Item"."Category Name" saw_11, "Document History"."Performed By" saw_12 FROM "Procurement - Requisitions Real Time" WHERE "- Requisition Line Status"."Line Status Meaning" IN ('Approved', 'Incomplete', 'On hold', 'Pending approval', 'Returned', 'Withdrawn')...

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