My Oracle Support Banner

How To Resolve the Error "User XXX does not have permission to access report definition SF_MATRDY. (235,2022)" which Is Issued when Running the 'Production Readiness Report' (SF_MATRDY) (Doc ID 1565847.1)

Last updated on JANUARY 13, 2018

Applies to:

PeopleSoft Enterprise SCM Manufacturing - Version 9.1 and later
Information in this document applies to any platform.

Goal

The below error is issued when running the 'Production Readiness Report' (SF_MATRDY):

User XXX does not have permission to access report definition SF_MATRDY. (235,2022) PSXP_RPTDEF.NMANAGER.ReportDefn.OnExecute

Process ABENDED at Step SF_MATRDY.ProcComp.WriteXML (PeopleCode)


When navigating to (depending on the release 9.1 Bundle you have installed):

* Reporting Tools, XML Publisher, Report Definition
* Reporting Tools, BI Publisher, Report Definition

you cannot find the SF_MATRDY report. However a query against the PSXPRPTDEFN table shows that the report exists.


How to resolve the error?

Solution

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