My Oracle Support Banner

EAM9.2: AMALLOC Process Fails With Unique Constraint Error ORA-00001 At Step AMALLOC.UPDDIST.Step02 (SQL) (Doc ID 2433222.1)

Last updated on NOVEMBER 30, 2018

Applies to:

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

Symptoms

When attempting to run Asset Allocation process,
the following error occurs.

Error
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_DIST_LN) violated
Failed SQL stmt: INSERT INTO PS_DIST_LN (BUSINESS_UNIT , ASSET_ID , BOOK , DTTM_STAMP , CF_SEQNO , OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3 , BUSINESS_UNIT_PC, ACTIVITY_ID, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, ANALYSIS_TYPE , DEPTID , PROJECT_ID , ACCOUNT , ALTACCT , DISTRIBUTION_TYPE , TRANS_TYPE , ACCOUNTING_DT , CATEGORY , TRANS_IN_OUT , TRANS_CODE , COST_TYPE , APPL_JRNL_ID , AMOUNT , JOURNAL_ID , JOURNAL_DATE , JOURNAL_LINE , PROCESS_INSTANCE , GL_DISTRIB_STATUS , OPRID , LEDGER_GROUP , LEDGER , FISCAL_YEAR , ACCOUNTING_PERIOD , BUSINESS_UNIT_GL , PC_DISTRIB_STATUS , CURRENCY_CD , TXN_CURRENCY_CD , TXN_AMOUNT , RATE_MULT , RATE_DIV , RT_TYPE , DOC_TYPE , DOC_SEQ_NBR , DOC_SEQ_DATE , DOC_SEQ_STATUS , ALLOC_RUN , IU_ANCHOR_FLG , IU_MAP_KEY , IU_SYS_TRAN_CD , IU_TRAN_CD , IUT_JOURNAL_ID , TRANSFER_BU , TRANSFER_BOOK , TRANSFER_ASSET_ID , REVERSE_STATUS , REVERSE_DTTM_STAMP , BOOK_CODE) SELECT BUSINESS_UNIT , ASSET_ID , BOOK , ((DTTM_STAMP) + NUMTODSINTERVAL( 1, 'MINUTE')) , CF_SEQNO , OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3 , BUSINESS_UNIT_PC, ACTIVITY_ID, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, ANALYSIS_TYPE , DEPTID , PROJECT_ID , ACCOUNT , ALTACCT , DISTRIBUTION_TYPE , TRANS_TYPE , ACCOUNTING_DT , CATEGORY , TRANS_IN_OUT , TRANS_CODE , COST_TYPE , MIN(APPL_JRNL_ID) , SUM(AMOUNT) , ' ' , MIN(DOC_SEQ_DATE) , 0 , MIN(PROCESS_INSTANCE) , 'P' , MIN(OPRID) , MIN(LEDGER_GROUP) , MIN(LEDGER) , MIN(FISCAL_YEAR) , MIN(ACCOUNTING_PERIOD) , MIN(BUSINESS_UNIT_GL) , MIN(PC_DISTRIB_STATUS) , MIN(CURRENCY_CD) , MIN(TXN_CURRENCY_CD) , SUM(TXN_AMOUNT) , MIN(RATE_MULT) , MIN(RATE_DIV) , MIN(RT_TYPE) , MIN(DOC_TYPE) , MIN(DOC_SEQ_NBR) , MIN(DOC_SEQ_DATE) , MIN(DOC_SEQ_STATUS) , 'Y' , 'N' , IU_MAP_KEY , 'AMALC' , 'GENERAL' , ' ' , ' ' ,' ' ,' ' ,' ' ,NULL , BOOK_CODE FROM PS_ALLOC_TMP WHERE PROCESS_INSTANCE = 30695 GROUP BY BUSINESS_UNIT , ASSET_ID , BOOK , DTTM_STAMP, CF_SEQNO, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3 , BUSINESS_UNIT_PC, ACTIVITY_ID, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, ANALYSIS_TYPE , DEPTID,PROJECT_ID , ACCOUNT,ALTACCT , DISTRIBUTION_TYPE , TRANS_TYPE , ACCOUNTING_DT , CATEGORY , TRANS_IN_OUT ,TRANS_CODE , COST_TYPE , IU_MAP_KEY, BOOK_CODE

Process 30695 ABENDED at Step AMALLOC.UPDDIST.Step02 (SQL) -- RC = 805 (108,524)

Steps
1. Set up allocation basis.
2. Run AM_DPCLOSE.
3. Run AMALLOC.
4. Run AM_DPCLOSE with 'Reverse Posted Entries' checked.
5. Run AMALLOC.

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps containing the complete configuration and the replication steps necessary to reproduce the issue.

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
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.