My Oracle Support Banner

PC_POADJUST ABENDED at Step CA_SUM_RFSH.ChkNw1.NewInUse (SQL) -- RC = 805 (Doc ID 2492327.1)

Last updated on DECEMBER 13, 2019

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Purchasing Integration

PC_POADJUST ABENDED at Step PC_POADJUST.BIGLOOP.COPY (SQL) -- RC = 805

ERROR
-----------------------


Message_Log.docx contains the first abend as below

 
File:
  /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1708 Error
  Position: 0 Return: 805 - ORA-00001: unique constraint
  (SYSADM.PS_CA_SUM_IN_USE) violated Failed SQL stmt: INSERT INTO
  PS_CA_SUM_IN_USE (BUSINESS_UNIT, PROJECT_ID, ACTIVITY_ID, ANALYSIS_TYPE ,
  RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, BI_DISTRIB_STATUS,
  GL_DISTRIB_STATUS, FOREIGN_ CURRENCY, CONTRACT_CURRENCY, CONTRACT_NUM,
  CONTRACT_LINE_NUM, CA_FEE_STATUS, IN_USE_FLAG) SELECT BUS INESS_UNIT,
  PROJECT_ID, ACTIVITY_ID, ANALYSIS_TYPE, RESOURCE_TYPE, RESOURCE_CATEGORY,
  RESOURCE_SUB_C AT, BI_DISTRIB_STATUS, GL_DISTRIB_STATUS, FOREIGN_CURRENCY,
  CONTRACT_CURRENCY, CONTRACT_NUM, CONTRAC T_LINE_NUM, CA_FEE_STATUS, IN_USE_FLAG
  FROM PS_CA_SUM_T2_TAO5 WHERE PROCESS_INSTANCE = 4904546
Process 4904546
  ABENDED at Step CA_SUM_RFSH.ChkNw1.NewInUse (SQL) -- RC = 805


Once restarted then the second abend is at


  
File:
  /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1708 Error
  Position: 0 Return: 805 - ORA-00001: unique constraint
  (SYSADM.PS_PC_RES_PA_TA04) violated Failed SQL stmt: INSERT INTO
  PS_PC_RES_PA_TA04 (PROCESS_INSTANCE, BUSINESS_UNIT, PROJECT_ID, ACTIVIT Y_ID,
  RESOURCE_ID, RESOURCE_ID_FROM, BUSINESS_UNIT_GL, JOURNAL_ID, JOURNAL_DATE,
  UNPOST_SEQ, JOURNAL _LINE, FISCAL_YEAR, ACCOUNTING_PERIOD, ACCOUNT, ALTACCT,
  DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE,
  BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CH
  ARTFIELD2, CHARTFIELD3, BUS_UNIT_GL_FROM, CURRENCY_CD, STATISTICS_CODE,
  LEDGER_GROUP, ANALYSIS_TYPE, RESOURCE_TYPE, RESOURCE_CATEGORY,
  RESOURCE_SUB_CAT, RES_USER1, RES_USER2, RES_USER3, RES_USER4, RES _USER5,
  TRANS_DT, ACCOUNTING_DT, OPRID, DTTM_STAMP, JRNL_LN_REF, OPEN_ITEM_STATUS,
  LINE_DESCR, JRNL_
Process 4904546
  ABENDED at Step PC_POADJUST.BIGLOOP.COPY (SQL) -- RC = 805
4904546 PC_POADJUST
  BIGLOOP COPY SQL 805
AE_PC_POADJUST_4904546.stdout.txt shows PC_POADJUST.BIGLOOP.COPY (SQL) -- RC = 805 (108,524)




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run PC_POADJUST with all options checked and ran for all BUs.


Changes

 

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
Changes
Cause
Solution


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