My Oracle Support Banner

PSA_ACCTGGL Process Goes To NO Success After Applying Bug 27324291 (Doc ID 2422773.1)

Last updated on JULY 13, 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, Other

PSA_ACCTGGL Process goes to NO success after applying Bug 27324291 - CA -PSA_ACCTGGL IGNORE SOLD TO CUST ID OPTION WHEN PROCESSING INTERNAL CONTRACTS

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

File: e:\pt85515b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723  Error Position: 0  Return: 805 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_PSA_ACCTG_TA14' with unique index 'PS_PSA_ACCTG_TA14'. The duplicate key value is (1119571, SC001, 330000F0143, 3300C001, 31508959            ).
Failed SQL stmt: INSERT INTO PS_PSA_ACCTG_TA14 (PROCESS_INSTANCE, BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, RESOURCE_ID, ACCTG_FLG, CUR_EFFDT_TYPE, CONTRACT_NUM, CONTRACT_LINE_NUM, CONTRACT_PPD_SEQ, ACCT_PLAN_ID, EVENT_NUM, ACCOUNT, ALTACCT, ACCOUNTING_DT, DELETE_ME, BUSINESS_UNIT, BUSINESS_UNIT_BI, BUSINESS_UNIT_GL, BUSINESS_UNIT_TO, CA_RQST_SRC, GL_DISTRIB_STATUS, CUR_EFFDT, CURRENCY_CD, BASE_CURRENCY, FOREIGN_CURRENCY, FOREIGN_AMOUNT, RESOURCE_AMOUNT, PROJECT_TYPE, AMOUNT_BSE, AMOUNT, DST_ID, ANALYSIS_TYPE, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, RESOURCE_ID_FROM, LEDGER, LEDGER_GROUP, APPL_JRNL_ID, STATISTICS_CODE, STATISTICS_ACCOUNT, PROJ_TRANS_TYPE, PROJ_TRANS_CODE, RT_TYPE, MOVEMENT_FLAG, RATE_MULT, RATE_DIV, BUSINESS_UNIT_GL2, RESOURCE_QUANTITY, DEPTID, DST_ACCT_TYPE, DST_SEQ_NUM, SEQ_NBR, POST_SEQ_NUM, SYSTEM_SOURCE, DESCR, LINE_DESCR, UNIT_OF_MEASURE, TRANS_DT, ACTIVE_STATUS, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, IU_SYS_TRAN_CD, IU_TRAN_CD, CRIT_SEQ, INVOICE, BUSINESS_UNIT_WO, WO_ID, WO_TASK_ID, RSRC_TYPE, RES_LN_NBR, BUSINESS_UNIT_AR, CUST_ID, ITEM, ITEM_LINE, ITEM_SEQ_NUM, OPRID, ORDER_NO, RESOURCE_STATUS, EMPLID, RES_USER1, RES_USER2, RES_USER3, RES_USER4, RES_USER5, LEVEL1_CF, LEVEL2_CF, LEVEL3_CF, LEVEL4_CF, LEVEL5_CF) SELECT TA0.PROCESS_INSTANCE, TA0.BUSINESS_UNIT_PC, TA0.PROJECT_ID, TA0.ACTIVITY_ID, TA0.RESOURCE_ID, 'C', 'C', TA0.CONTRACT_NUM, TA0.CONTRACT_LINE_NUM, TA0.CONTRACT_PPD_SEQ, TA0.ACCT_PLAN_ID, TA0.EVENT_NUM, TA0.ACCOUNT, TA0.ALTACCT, TA0.ACCOUNTING_DT, TA0.DELETE_ME, TA0.BUSINESS_UNIT, TA0.BUSINESS_UNIT_BI, TA0.BUSINESS_UNIT_GL, TA0.BUSINESS_UNIT_TO, TA0.CA_RQST_SRC, TA0.GL_DISTRIB_STATUS, TA0.CUR_EFFDT, TA0.CURRENCY_CD, TA0.BASE_CURRENCY, TA0.FOREIGN_CURRENCY, TA0.FOREIGN_AMOUNT, TA0.RESOURCE_AMOUNT, TA0.PROJECT_TYPE, TA0.AMOUNT_BSE, TA0.AMOUNT, TA0.DST_ID, TA0.ANALYSIS_TYPE, TA0.RESOURCE_TYPE, TA0.RESOURCE_CATEGORY, TA0.RESOURCE_SUB_CAT, TA0.RESOURCE_ID_FROM, TA0.LEDGER, TA0.LEDGER_GROUP, TA0.APPL_JRNL_ID, TA0.STATISTICS_CODE, TA0.STATISTICS_ACCOUNT, TA0.PROJ_TRANS_TYPE, TA0.PROJ_TRANS_CODE, TA0.RT_TYPE, TA0.MOVEMENT_FLAG, TA0.RATE_MULT, TA0.RATE_DIV, TA0.BUSINESS_UNIT_GL2, TA0.RESOURCE_QUANTITY, TA0.DEPTID, TA0.DST_ACCT_TYPE, TA0.DST_SEQ_NUM, TA0.SEQ_NBR, TA0.POST_SEQ_NUM, TA0.SYSTEM_SOURCE, TA0.DESCR, TA0.LINE_DESCR, TA0.UNIT_OF_MEASURE, TA0.TRANS_DT, TA0.ACTIVE_STATUS, TA0.OPERATING_UNIT, TA0.PRODUCT, TA0.FUND_CODE, TA0.CLASS_FLD, TA0.PROGRAM_CODE, TA0.BUDGET_REF, TA0.AFFILIATE, TA0.AFFILIATE_INTRA1, TA0.AFFILIATE_INTRA2, TA0.CHARTFIELD1, TA0.CHARTFIELD2, TA0.CHARTFIELD3, TA0.IU_SYS_TRAN_CD, TA0.IU_TRAN_CD, TA0.CRIT_SEQ, TA0.INVOICE, TA0.BUSINESS_UNIT_WO, TA0.WO_ID, TA0.WO_TASK_ID, TA0.RSRC_TYPE, TA0.RES_LN_NBR, TA0.BUSINESS_UNIT_AR, TA0.CUST_ID, TA0.ITEM, TA0.ITEM_LINE, TA0.ITEM_SEQ_NUM, TA0.OPRID, TA0.ORDER_NO, TA0.RESOURCE_STATUS, TA0.EMPLID, TA0.RES_USER1, TA0.RES_USER2, TA0.RES_USER3, TA0.RES_USER4, TA0.RES_USER5, ' ', ' ', ' ', ' ', ' ' FROM PS_PSA_ACCTG_TA04 TA0 , PS_PROJ_AN_GRP_MAP PROJ_AN , PS_SET_CNTRL_REC REC , PS_CA_DTL_PROJ_VW DETPV WHERE TA0.PROCESS_INSTANCE = 1119571 AND 'CST' IN ('CST', 'ALL') AND PROJ_AN.ANALYSIS_GROUP = 'PSCST' AND TA0.BUSINESS_UNIT_PC = DETPV.BUSINESS_UNIT_PC AND TA0.PROJECT_ID = DETPV.PROJECT_ID AND TA0.ACTIVITY_ID = DETPV.ACTIVITY_ID AND TA0.ANALYSIS_TYPE = PROJ_AN.ANALYSIS_TYPE AND TA0.ANALYSIS_TYPE NOT IN ('UTL', 'UAJ') AND TA0.BUSINESS_UNIT = REC.SETCNTRLVALUE AND REC.RECNAME = 'PROJ_AN_GRP_MAP' AND PROJ_AN.SETID = REC.SETID AND NOT EXISTS ( SELECT 'X' FROM PS_PSA_ACCTG_TA14 TA1 WHERE TA1.PROCESS_INSTANCE = 1119571 AND TA1.RESOURCE_ID = TA0.RESOURCE_ID) AND ( EXISTS( SELECT 'X' FROM PS_CA_DTL_PROJ2_VW HDR WHERE TA0.BUSINESS_UNIT_PC = HDR.BUSINESS_UNIT_PC AND TA0.PROJECT_ID = HDR.PROJECT_ID AND TA0.ACTIVITY_ID = HDR.ACTIVITY_ID AND HDR.REV_RECOG_METHOD = '5' AND HDR.BUSINESS_UNIT = 'SC001' AND HDR.CA_FEE_TYPE in ('01') ) OR EXISTS( SELECT 'X' FROM PS_CA_DTL_PROJ2_VW HDR1 WHERE TA0.BUSINESS_UNIT_PC = HDR1.BUSINESS_UNIT_PC AND TA0.PROJECT_ID = HDR1.PROJECT_ID AND TA0.ACTIVITY_ID = HDR1.ACTIVITY_ID AND HDR1.REV_RECOG_METHOD <> '5' AND HDR1.BUSINESS_UNIT = 'SC001' AND HDR1.CA_FEE_TYPE in ('01') ) )

Process 1119571 ABENDED at Step PSA_ACCTGGL.Sel_PC.CostA (SQL) -- RC = 805 (108,524)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add Project/activity
2. Add a Standard contract
3. Add 2 contract lines. 1 amount price type and 1 rate price type
4. Assign bill plans
5. Assign revenue plans
6. Complete Amount allocations
7.Activate Contract
8. Associate the same project activity combination to both contract lines in contract terms.
9. Add rate plan to 2nd line.
10. Add a few cost transactions to the project activity.
11. Set GL_DIST_STATUS to 'N' for each transaction
12. Process transactions
13. Target rows created
14. Add accounting rule for ACT
15. Run psa_acctggl with Project type CAPTL same as project created. Process costs only.
16. Process goes to No Success
17. Process ABENDED at Step PSA_ACCTGGL.Sel_PC.CostA (SQL) -- RC = 805

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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