My Oracle Support Banner

SES Search Definition Index EP_CS_DOC_PURCHORDRS Fails When Crawling with Unique Constraint Error:ORA-00001: unique constraint (XXXX.PS_CS_DOC_ATT_SES) violated (Doc ID 2117957.1)

Last updated on JANUARY 04, 2021

Applies to:

PeopleSoft Enterprise SCM Supplier Contract Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

SES Search Definition fails when crawling EP_CS_DOC_PURHCORDRS

After deploying Search Definition, Creating a Run Control ID, then executing the Crawl the EP_CS_DOC_PURCHORDRS search definition fails with the below message.

Steps to reproduce the issue:

1. Deploy the EP_CS_DOC_PURCHORDRS
2. Run the build process to execute the Crawl


Error:

 





Cause

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
Symptoms
Cause
Solution


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