Search Integrity

The following table describes the audit queries and resolutions for the PeopleSoft Search Framework:

Query	Description	Resolution
PTSF-01	Search definition mapped in a search category is missing.	If the definitions are delivered by Oracle and not modified, contact My Oracle Support. If the definitions are customized or the issue appears after a project migration or upgrade, please verify the related definitions are included in the project. Also check PeopleTools, and then Search Framework, and then Designer, and then Define Search Definitions.
PTSF-02	There is no search category created for a search definition.	If the definitions are delivered by Oracle and not modified, contact My Oracle Support. If the definitions are customized or the issue appears after a project migration or upgrade, verify the related definitions are included in the project. Also check, PeopleTools, and then Search Framework, and then Designer, and then Define Search Categories.
PTSF-03	Search category does not contain a search definition with the same name as search category.	This report is provided for informational purposes. It is not necessary for a category to have a definition with the same name. However the reverse case is a mandate. A search category can contain any number of search definitions which are deployed by its own categories.
PTSF-04	Source name in search definition is not available in Query or Connected Query definitions.	If the definitions are delivered by Oracle and not modified, contact My Oracle Support. If the definitions are customized or the issue appears after a project migration or upgrade, verify the related definitions are included in the project. Also check Reporting Tools, and then Query, and then Query Manager.
PTSF-05	Delete query mapped to a search definition is missing in query definition.	If the definitions are delivered by Oracle and not modified, contact My Oracle Support. If the definitions are customized or the issue appears after a project migration or upgrade, verify the related definitions are included in the project. Also check Reporting Tools, and then Query, and then Query Manager.
PTSF-06	Pre/Post processing AE mapped to a search definition is missing in Application Engine library.	If the definitions are delivered by Oracle and not modified, contact My Oracle Support. If the definitions are customized or the issue appears after a project migration or upgrade, verify the related definitions are included in the project.
PTSF-07	Security Application Class specified in a search definition is missing in Application Class library.	If the definitions are delivered by Oracle and not modified, contact My Oracle Support. If the definitions are customized or the issue appears after a project migration or upgrade, verify the related definitions are included in the project.
PTSF-08	Indexed field in a search definition does not exist in the query fields list.	If the definitions are delivered by Oracle and not modified, contact My Oracle Support. If the definitions are customized or the issue appears after a project migration or upgrade, verify the related definitions are included in the project.
PTSF-09	Attribute selected in a search definition is missing in the search attribute list.	If the definitions are delivered by Oracle and not modified, contact My Oracle Support. If the definitions are customized or the issue appears after a project migration or upgrade, verify the related definitions are included in the project.
PTSF-10	Selected attribute display name does not exists in the field label definition.	If the definitions are delivered by Oracle and not modified, contact My Oracle Support. If the definitions are customized or the issue appears after a project migration or upgrade, verify the related definitions are included in the project.
PTSF-11	Attribute in the search attribute list is not referenced by any search definition.	Use your SQL Editor to delete the unused attributes from record PSPTSF_ATTRS.
PTSF-12	The role for insights dashboard with edit or view access does not exist in the Role Definition table.	The insights dashboard role defines user access to the dashboard (view or edit). Either create this role in the role definition or replace it with the right role. Access the Insights Privileges page by selecting PeopleTools > Search Framework > Administration > Assign Dashboard Roles.