My Oracle Support Banner

E-AUDIT: DDDAUDIT Report - View PSCBO_PSRECDEFN Exists In Database But Not Found In Application Designer (Doc ID 2310892.1)

Last updated on MARCH 01, 2021

Applies to:

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


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

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?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.