EAP Brazil Localization: Automated Accounting (TR_ACCTG) abends at Step TR_ACCTG.BRLINST4.TRA3423 (Action SQL) -- RC = 805 (Doc ID 1992672.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

When attempting to run Automated Accounting (TR_ACCTG), an error occurs.

ERROR
-- 17.31.49 Process 13089 ABENDED at Step TR_ACCTG.BRLINST4.TRA3423 (Action SQL) -- RC = 805
ROLLBACK
/
-- 17.31.50 SQL Error: ORA-00001: restrição exclusiva (SYSADM.PS_TRA_ACCTG_LINE) violada

STEPS
1.  Set Up Financials/Supply Chain > Common Definitions > Historical Definition > Historical TR
SetID = BTGL1
Source Code = Investment Pools
Accounting Template ID = TRP_POOL_MTM

2.  Cash Management > Treasury Accounting > Accounting Templates
SetID = BTGL1
Accounting Template ID = TRP_POOL_MTM

3.  Cash Management > Investment Pools > Pool Information

4.  Cash Management > Investment Pools > Participant Information

5.  Cash Management > Investment Pools > Participant Transactions

6.  Cash Management > Treasury Accounting > Accounting Events
Investment Pools (Initial Payment) - Status = Not Processed

7.  Cash Management > Treasury Accounting > Automated Accounting
LOG: Event generated no accounting lines. BU = US001, Source = P, ID = IP999PT001, Date = 2015-02-04, Seq# =3, Leg =1, Event = 01 (13552,28)

8.  Above error occurs

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