My Oracle Support Banner

EAR9.2: When Building Search Index EP_AR_ITEMS, Geting TEMP Table Space Error (Doc ID 2468983.1)

Last updated on FEBRUARY 06, 2019

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When building search index EP_AR_ITEMS, geting TEMP table space error.


ERROR:
-------------
File: E:\pt85608c-retail\peopletools\src\pssys\qpm.cppSQL error. Stmt #: 7966 Error Position: 1686
Return: 1652 - ORA-01652: unable to extend temp segment by 128 in tablespace TEMP Failed SQL stmt:
SELECT A.SETID, A.BUSINESS_UNIT, A.CUST_ID, A.NAME1, A.ITEM, A.ITEM_LINE, A.ITEM_ST ATUS, A.CR_ANALYST,
A.AR_CR_ANAL_NAME, A.COLLECTOR, A.AR_COLLECTOR_NAME, A.SALES_PERSON, A.AR_SP_NAM E, A.AR_SPECIALIST,
NVL(A.AR_SPEC_NAME, SUBSTR(B.MESSAGE_TEXT,1,18)), A.ENTRY_TYPE, A.AR_ET_DESCR, A .ENTRY_REASON,
TO_CHAR(A.ACCOUNTING_DT,'YYYY-MM-DD'), A.PO_REF, A.DOCUMENT, A.CONTRACT_NUM, A.AGING_ CATEGORY,
A.COLLECTION_STATUS, A.BILL_OF_LADING, A.ORDER_NO, A.CONSOL_INVOICE, A.LC_ID, A.PPRC_PROMO _CD,
A.CLAIM_NO, A.BROKER_ID, A.DEDUCTION_STATUS, A.DISPUTE_STATUS, A.SUBCUST_QUAL1, A.SUBCUST_QUAL2 ,
A.SP_ID, A.INVOICE, A.PROOF_OF_DELIVERY, A.SHIP_TO_CUST_ID, A.SOLD_TO_CUST_ID, A.SUBROG_CASE_NUM,


STEPS
------------
1: Deploy the EP_AR_ITEMS search index
2: Run the build search index - full build.
3: Job appears to complete successfully, but get TEMP tablespace 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
References


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