EGL 9.1: Several Commitment Control Budget Processor (FS_BP) Issues, Including Due To Temp Tables Space (Doc ID 2162832.1)

Last updated on JULY 19, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Issue/error
--------------
Commitment Control Budget Processor (FS_BP) is failing in production due to following error:

 /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1623  Error Position: 12  Return: 16 52 - ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Failed SQL stmt:
INSERT INTO PS_BP_ACT_TAO11 (SEQNBR, KK_TRAN_ID, KK_TRAN_DT, KK_TRAN_LN, REFERENCED _BUDGET, BALANCING_LINE, LEDGER_GROUP, LEDGER, FISCAL_YEAR, ACCOUNTING_PERIOD, RVRSL_FLG, RVRSL_FLG2 , KK_CLOSE_FLAG, BUSINESS_UNIT, ACCOUNT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROG RAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHART FIELD3, BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, RESOURCE_TYPE, BUDGET_PERIOD, FOREIGN_CURRENCY, F OREIGN_AMOUNT, BASE_CURRENCY, MONETARY_AMOUNT, STATISTICS_CODE, STATISTIC_AMOUNT, KK_QUANTITY, BUDGE T_DT, KK_PROCESS_PRIOR, AFFECT_SPEND_OPTN, POSTED_FLAG, PROCESS_INSTANCE, ENTRY_EVENT, EE_PROC_STATU

- This issue is related to process failing due to Oracle error -  ORA-01652: unable to extend temp segment by 128 in tablespace TEMP.   
- Customer has120GB of tablespace for TEMP and DBAs believe that is sufficient for this process to run successfully.   
- Recently upgraded to Oracle 12c and suspected to cause the issue.

Environment
----------------
FSCM 9.1

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