ECM: Automated Accounting ABENDED at Step TR_ACCTG.TRA2242.TRA2242A (Doc ID 1909298.1)

Last updated on MARCH 17, 2016

Applies to:

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

Symptoms

Instrument type has two lines defined.  The Accounting Event Interest Accrual for each line uses a different accounting template.  The accounting lines on the accounting templates have substitution rules that replace to the same chartfield value.

When Automated Accounting is run an abend at TR_ACCTG.TRA2242.TRA2242A will occur.

ERROR
File: e:\pt85310c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623  Error Position: 0  Return: 805 - ORA-00001: unique constraint (SYSADM.PS_TRA_CFSUB_TAO4) violated Failed SQL stmt: INSERT INTO PS_TRA_CFSUB_TAO4( PROCESS_INSTANCE, BUSINESS_UNIT, TRA_SOURCE_CD, EVEN T_ID, EVENT_DT, SEQ_NBR, TRANSACTION_LEG, ACCTG_EVENT_TYPE, ACCTG_TMPL_LINE, TEST_ATTRIBUTE, SET_CF, TRA_ATTR_VALUE, TRA_CHRTFLD_VALUE ) SELECT W.PROCESS_INSTANCE, W.BUSINESS_UNIT, W.TRA_SOURCE_CD, W. EVENT_ID, W.EVENT_DT, W.SEQ_NBR, W.TRANSACTION_LEG, W.ACCTG_EVENT_TYPE, W.ACCTG_TMPL_LINE, F.TEST_AT TRIBUTE, F.SET_CF, T.TRA_ATTR_VALUE, T.TRA_CHRTFLD_VALUE FROM PS_TRA_BNK1_TAO4 W , PS_SET_CNTRL_REC S , PS_TRA_SUB_RULE R , PS_SUB_RULE_FIELDS F , PS_SUB_RULE_TRANSL T , PS_TRX_HEADER_TR A WHERE W.PRO CESS_INSTANCE = 970798 AND W.SUBSTITUTE_CF = 'Y' AND S.SETCNTRLVALUE = W.BUSINESS_UNIT AND S.RECNAME

STEPS

1. Create two substitution rules which replaces to the same dept chartfield value when COUNTERPARTY = USBNK
Cash Management > Treasury Accounting > Define Substitution Rules

2a.  Create two accounting templates that are a copy of IRP-INTACC.
Cash Management > Treasury Accounting > Accounting Templates

2b. Assign one of the substitution rules to each of the accounting templates.

3. Update Instrument Type REPO where the Interest Accrual event for each line has one of the accounting templates.
Deal Management > Administer Deals > Define Instrumentes

4. Create deal with instrument type REPO
Deal Management > Capture Deals > Deals

5. Run Automated Accounting
Cash Management > Treasury Accounting > Automated Accounting

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