E-AUDIT: DDDAUDIT Report - View PSCBO_PSRECDEFN Exists In Database But Not Found In Application Designer

(Doc ID 2310892.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.

Goal

DDDAUDIT report is showing the following error in PROD.

(VIEWS-2) Views defined in the Database and not found in the Application Designer:

View Name
------------------
PSCBO_PSRECDEFN

The view PSBO_PSRECDEFN is delivered by Oracle as part of the PSCBO Optimizer Statistics package for Peoplesoft databases.
See Metalink:-  pscbo_stats - Improving Statistics in Oracle RDBMS for PeopleSoft Enterprise (Doc ID 1322888.1)
 
Why is this view PSCBO_PSRECDEFN not defined in Application Designer?

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