My Oracle Support Banner

PC_POADJUST RAN TO NO SUCCESS - Step PC_POADJUST.QUANTITY.COND_1 (SQL) -- RC = 805 (108,524) (Doc ID 2390592.1)

Last updated on APRIL 24, 2018

Applies to:

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

Symptoms

On :  9.2 version, Usability

PC_POADJUST RAN TO NO SUCCESS

ERROR
-----------------------
PC_POADJUST RAN TO NO SUCCESS - Step PC_POADJUST.QUANTITY.COND_1 (SQL) -- RC = 805 (108,524)

Process 1495660 ABENDED at Step PC_POADJUST.QUANTITY.COND_1 (SQL) -- RC = 805 (108,524)

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PC_RES_PA_TA117) violated
Failed SQL stmt INSERT INTO PS_PC_RES_PA_TA117 (PROCESS_INSTANCE, 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,
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_DISTRI




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add a new project
2. Create PO.    
3. Drill down on the Schedule/Distribution icon for the PO line.
4. Update Distribution GL, Project & Activity created from step 1. Save.
5. Dispatch PO.
6. Run PC_PO_TO_PC    
7. Run PC_PO_TO_PC to bring PO to project costing
8. COM row created.
9. Create a voucher by copying the PO.
10. Change unit price to $1,000.00 and add freight of $50.00. Save.
11. Post voucher
12. Run PC_AP_TO_PC with the Application Options set to “Detail”
13. Run PC_POADJUST
14. Issue replicated.
 
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot .

Changes

 < Internal Only

Documents:

Replication Steps

Unit Testing

Code Change

Internal Only >

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!


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