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

(Doc ID 2310892.1)

Last updated on APRIL 26, 2018

Applies to:

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

Goal

Note:
Oracle does not certify or test the pscbo_stats utility for support purposes. Its use is considered to be a customization.
If there is a problem or question with pscbo_stats, the Global Support Center will not be handling service requests regarding its use.
The best approach would be to post to the Lifecycle Management PSFT Community, reaching out to other customers for information and assistance.

 

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