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 MARCH 18, 2016

Applies to:

PeopleSoft Enterprise SCM Supplier Contract Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

SES Search Definition fails when crawling EP_PO_PURCHASE_ORDERS

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

Steps to reproduce the issue:

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


Error:

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1703 Error Position: 0 Return: 805 - ORA-00001: unique constraint (PSOFTFIN.PS_CS_DOC_ATT_SES) violated Failed SQL stmt: INSERT INTO PS_CS_DOC_ATT_SES (CS_DOC_ID, CS_DOC_TYPE, CS_SOURCE_TRANS, SCM_ATTACH_ ID, ATT_VERSION, CS_CONTENT_TYPE, CS_CONTENT_ID, BUSINESS_UNIT, VERSION_NBR, SETID, AUC_ROUND, AUC_V ERSION, ATTACH_DESCR, COMMENTS_254, EXT_FLAG, FILENAME, FILE_EXTENSION, OPRID, DATETIME_STAMP, CS_IM PORT_FLG) SELECT H.CS_DOC_ID, '096', H.CS_SOURCE_TRANS, F.SCM_ATTACH_ID, F.ATT_VERSION, '0008', K.PO _ID, K.BUSINESS_UNIT, 1, ' ', 0, 0, ' ', ' ', 'N', F.ATTACHUSERFILE, ' ', ' ', NULL, 'N' FROM PS_CS_ DOC_HDR H, PS_CS_POCOMMENT_VW F, PS_CS_DOC_DATE_SES T1 , PS_CS_DOC_PUR_KEYS K WHERE H.CS_DOC_ID = F. CS_DOC_ID AND H.CS_DOC_ID = T1.CS_DOC_ID AND H.CS_DOC_ID = K.CS_DOC_ID AND H.CS_SOURCE_TRANS= '03'

Process 3672711 ABENDED at Step CS_PREPROC_A.PURORD.POAtT10 (SQL) -- RC = 805





Cause

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