EAP: Building Search Index EP_AP_VOUCHERS abends at Step VH_PREPROC_A.ROLLBACK.ROLLBACK (Doc ID 1969166.1)

Last updated on MARCH 18, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When trying to build the Search Index for the delivered Search Definition of EP_AP_VOUCHERS, the SES Feed Generation Process (PTSF_GENFEED) is abending at Step VH_PREPROC_A.ROLLBACK.ROLLBACK (Do Select) with an error.

ERROR
File: e:\pt85311b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #:1623 Error Position: 0 Return: 1652 - ORA-01652: unable to extend temp segment by 128 in tablespace PSTEMP
Failed SQL stmt: SELECT DISTINCT A.BUSINESS_UNIT , A.VOUCHER_ID FROM PS_AP_ARC_VOUCH_H A , PSARCHAUDIT B , PS_VOUCHER V WHERE A.PSARCH_ID = B.PSARCH_ID AND A.PSARCH_BATCHNUM = B.PSARCH_BATCHNUM AND B.RECNAME = 'VOUCHER' AND B.PSARCH_EVENTDTTM >= TO_TIMESTAMP('1900-01-01-00.00.00.000000','YYYY-MM-DD-HH24.MI.SS.FF') AND EXISTS ( SELECT VOUCHER_ID FROM PS_VOUCHER VOU WHERE VOU.BUSINESS_UNIT =
A.BUSINESS_UNIT AND VOU.VOUCHER_ID = A.VOUCHER_ID)

Process 13459379 ABENDED at Step VH_PREPROC_A.ROLLBACK.ROLLBACK (Do Select)
-- RC = 1652 (108,524)

It appears that there is a cartesian join in the above SQL.

STEPS
1. Navigate to PeopleTools > Search Framework > Administration > Deploy/Delete Object
2. Deploy the Definition for EP_AP_VOUCHERS
3. Navigate to PeopleTools > Search Framework > Administration > Schedule Search Index
4. Select the Search Definition for EP_AP_VOUCHERS
5. Indexing type = Full Index, Language Option = Base Language
6. Process will abend with the above error

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