EAP: Building Search Index for EP_AP_PAYMENTS receiving error -- Unable to extend temp segment by 128 in tablespace PSTEMP Failed" [SES] (Doc ID 1594848.1)

Last updated on AUGUST 21, 2017

Applies to:

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

Symptoms

Building Search Index for delivered Search Definition of EP_AP_PAYMENTS errors out. [Search Framework / SES ]

ERROR
File: /vob/peopletools/src/pssys/qpm.cppSQL error. Stmt #: 7072 Error Position: 0 Return: 1652 - O RA-01652: unable to extend temp segment by 128 in tablespace PSTEMP Failed SQL stmt: SELECT A.BUSINESS_UNIT, A.VOUCHER_ID, A.PYMNT_CNT, A.PREPAID_APPLIED_BU, A.PREPAID_ APPL_VCHR, A.PYMNT_ID, A.BANK_SETID, A.BANK_CD, A.BANK_ACCT_KEY, B.DESCR, C.PAY_CYCLE, C.PAY_DOC_ID, C.DISCOUNT_TAKEN, C.INVOICE_ID, A.LATE_CHRG_AMT, D.DESCR, C.BUSINESS_UNIT, CASE WHEN NVL(C.BUSINE SS_UNIT,'No Value') = ' ' THEN 'No Value' ELSE NVL(C.BUSINESS_UNIT,'No Value') END FROM (PS_PYM NT_VCHR_XREF A LEFT OUTER JOIN PS_BUS_UNIT_TBL_FS B ON A.PREPAID_APPLIED_BU = B.BUSINESS_UNIT ), ( PS_PYMNT_ADVICE C LEFT OUTER JOIN PS_BUS_UNIT_TBL_FS D ON C.BUSINESS_UNIT = D.BUSINESS_UNIT ) W HERE ( A.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.PAY_CYCLE = A.PAY_CYCLE AND C.PAY_CYCLE_S

STEPS
1. First deploy the Search objects
Main Menu > PeopleTools > Search Framework > Administration > Deploy/Delete Object

2. Build Search Index for EP_AP_PAYMENTS
Main Menu > PeopleTools > Search Framework > Administration > Schedule Search Index

3. Process Monitor shows Process PTSF_GENFEED errors out with the above error

Changes

 

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