PC_POADJUST Abends At Step PC_POADJUST.PR_INS.INSERT (SQL) RC = 805 (108,524)

(Doc ID 2316091.1)

Last updated on OCTOBER 16, 2017

Applies to:

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

Symptoms

On : 9.2 version, Project Team

ACTUAL BEHAVIOR
---------------
PC_POADJUST abends at Step PC_POADJUST.PR_INS.INSERT (SQL)

PC_POADJUST abends at Step PC_POADJUST.PR_INS.INSERT (SQL) RC = 805 (108,524)
File: e:\pt85412c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PROJ_RESOURCE) violated
Failed SQL stmt: INSERT INTO PS_PROJ_RESOURCE (BUSINESS_UNIT, PROJECT_ID, ACTIVITY_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, CHARTFIELD2, 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_LINE_STATUS, JOURNAL_LINE_DATE, FOREIGN_CURRENCY, RT_TYPE, FOREIGN_AMOUNT, RATE_MULT, RATE_DIV, CUR_EFFDT, PROCESS_INSTANCE, PC_DISTRIB_STATUS, GL_DISTRIB_STATUS, PROJ_TRANS_TYPE, PROJ_TRANS_CODE, RESOURCE_STATUS, DESCR, SYSTEM_SOURCE, UNIT_OF_MEASURE, EMPLID, EMPL_RCD, SEQ_NBR, TIME_RPTG_CD, JOBCODE, COMPANY, BUSINESS_UNIT_AP, VENDOR_ID, VOUCHER_ID, VOUCHER_LINE_NUM, APPL_JRNL_ID, PYMNT_CNT, DST_ACCT_TYPE, PO_DISTRIB_STATUS, BUSINESS_UNIT_PO, REQ_ID, REQ_LINE_NBR, REQ_SCHED_NBR, REQ_DISTRIB_NBR, PO_ID, DUE_DATE, LINE_NBR, SCHED_NBR, DISTRIB_LINE_NUM, AM_DISTRIB_STATUS, BUSINESS_UNIT_AM, ASSET_ID, PROFILE_ID, COST_TYPE, BOOK, INCENTIVE_ID, MSTONE_SEQ, CONTRACT_NUM, CONTRACT_LINE_NUM, CONTRACT_PPD_SEQ, BI_DISTRIB_STATUS, BUSINESS_UNIT_BI, BILLING_DATE, INVOICE, REV_DISTRIB_STATUS, BUSINESS_UNIT_AR, CUST_ID, ITEM, ITEM_LINE, ITEM_SEQ_NUM, DST_SEQ_NUM, BUSINESS_UNIT_IN, SCHED_LINE_NO, DEMAND_LINE_NO, INV_ITEM_ID, PAY_END_DT, BUSINESS_UNIT_OM, ORDER_NO, ORDER_INT_LINE_NO, EX_DOC_ID, EX_DOC_TYPE, RESOURCE_QUANTITY, RESOURCE_AMOUNT, BUDGET_HDR_STATUS,

EXPECTED BEHAVIOR
-----------------------
PC_POADJUST should go to success

STEPS
-----------------------
Steps are something similar to the following
1. Create a Project/Activity
2. Create Req, PO and Voucher and interface to PC such that data in PROJ_RESOURCE looks like below.. Voucher amount < PO so that a CCA row gets created when integration processes are run.
3. Run PC_PO_TO_PC, PC_AP_TO_PC and PC_POADJUST for all date options

Data population in Proj_resource
Analysis_Type Transaction DT Accounting_DT Resource_Amount

CCA 03-APR-17 31-DEC-16 2112
CRV 13-DEC-16 13-DEC-16 32328
COM 03-APR-17 31-DEC-16 34440
RRV 03-APR-17 31-DEC-16 34440
REQ 03-APR-17 31-DEC-16 34440
ACT 13-DEC-16 13-DEC-16 32328

4. Rerun the PC_POADJUST using Accounting date of 13-DEC-16.
5. The process fails with the above abend at step ABENDED at Step PC_POADJUST.PR_INS.INSERT (Action SQL) -- RC = 805

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