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 AUGUST 04, 2016

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms