EGL 9.1: Several Commitment Control Budget Processor (FS_BP) Issues, Including Due To Temp Tables Space
Last updated on DECEMBER 20, 2017
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.
*** Checked for currency on 20 Dec 2017 ***
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.
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