My Oracle Support Banner

ECM: Concurrent Runs of Reverse Accounting Entries (TR_RVSL_DRV) Process Results in No Success Due To Unique Constraint Error (Doc ID 2589923.1)

Last updated on SEPTEMBER 25, 2019

Applies to:

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

Symptoms

One or more instances of the Reverse Accounting Entries process fails when multiple instances of it are executed simultaneously. The issue occurs for both Manual as well as Automated scheduling.

Steps:

1) Navigate to Cash Management > Treasury Accounting > reverse Accounting Request
2) Schedule multiple run control ids for CM accounting entries reversal process.

Or

1) Reconcile External Transactions with Bank Statement using Semi-Manual reconciliation.
2) Run Automated Accounting and check created entries.
3) Run Journal Generator for the Accounting created.
4) On Semi Manual Reconciliation page, Un-reconcille the transactions reconciled in Step 1.
5) Check that multiple instances of Reverse Accounting Entries process is triggered.

Error:

One or more instances of the process failed with following error:

SQL error. Stmt #: 1725  Error Position: 0  Return: 805 - ORA-00001: unique constraint (SYSADM.PS_TRA_ACCTG_LINE) violated

Failed SQL stmt: INSERT INTO PS_TRA_ACCTG_LINE (BUSINESS_UNIT, ACCOUNTING_ID,
ACCOUNTING_LINE, ACCOUNTING_DT, ACCOUNT, ALTACCT, DEPTID, OPERATING_UNIT,
PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE,
AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3,
PROJECT_ID, STATISTICS_CODE, FOREIGN_AMOUNT, FOREIGN_CURRENCY, RT_TYPE,
MONETARY_AMOUNT, CURRENCY_CD, STATISTIC_AMOUNT, JRNL_LN_REF, DESCR60,
LINE_DESCR, ACCOUNTING_PERIOD, FISCAL_YEAR, BUSINESS_UNIT_GL, LEDGER,
LEDGER_GROUP, JOURNAL_ID, JOURNAL_DATE, GL_DISTRIB_STATUS, COMBO_STATUS,
APPL_JRNL_ID, JOURNAL_LINE, RATE_MULT, RATE_DIV, PROCESS_INSTANCE,
IU_ANCHOR_FLG, IU_SYS_TRAN_CD, IU_TRAN_CD, ACCTG_LINE_SOURCE,
AMOUNT_CALC_TYPE, DOC_TYPE, DOC_SEQ_NBR, DOC_SEQ_DATE, DOC_SEQ_STATUS,
DTTM_STAMP, MC_AMOUNT_SW) SELECT BUSINESS_UNIT, ACCOUNTING_ID,
ACCOUNTING_LINE, ACCOUNTING_DT, ACCOUNT, ALTACCT, DEPTID, OPERATING_UNIT,
PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE,
AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3,
PROJECT_ID, STATISTICS_CODE, FOREIGN_AMOUNT, FOREIGN_CURRENCY, RT_TYPE,
MONETARY_AMOUNT, CURRENCY_CD, STATISTIC_AMOUNT, JRNL_LN_REF, DESCR60,
LINE_DESCR, ACCOUNTING_PERIOD, FISCAL_YEAR, BUSINESS_UNIT_GL, LEDGER,
LEDGER_GROUP, JOURNAL_ID, JOURNAL_DATE, GL_DISTRIB_STATUS, COMBO_STATUS,
APPL_JRNL_ID, JOURNAL_LINE, RATE_MULT, RATE_DIV, PROCESS_INSTANCE,
IU_ANCHOR_FLG, IU_SYS_TRAN_CD, IU_TRAN_CD, ACCTG_LINE_SOURCE,
AMOUNT_CALC_TYPE, DOC_TYPE, DOC_SEQ_NBR, DOC_SEQ_DATE, DOC_SEQ_STATUS,
DTTM_STAMP, 'N' FROM PS_ACCTG_LNE_TAO4 WHERE PROCESS_INSTANCE = 183965

Process 183965 ABENDED at Step TR_RVSL_PROC.Populate.iLines (SQL) -- RC = 805 (108,524)


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
References


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