PSA_ACCTGGL ABENDED at Step CA_ACCTGRULE.Rules2.Default1 (Action SQL) -- RC = 805 (Doc ID 2146795.1)

Last updated on JUNE 10, 2016

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise FIN Contracts - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Functionality

When attempting to PSA_ACCTGGL
the following error occurs.

ERROR
-----------------------
-- 13:26:14.694 Process 373 ABENDED at Step CA_ACCTGRULE.Rules2.Default1 (Action SQL) -- RC = 805
ROLLBACK
/
-- 13:26:14.718 SQL Error: ORA-00001: unique constraint (SYSADM.PS_PSA_ACCTDSTGL21) violated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Accounting Rule #1: Set up accounting rule for FDS Analysis Type with wild card.
2. Accounting Rule #2: Set up another Accounting rule for FDS Analysis Type with additional selection criteria. For example Account = 60810, Resource Type = STATE & Resource Sub Category = OPTRN.
3. Create a Journal – Journal has CF’s that match the selection criteria for the Accounting Rule #2- Journal uses account 60810/ Resource Type = STATE & Resource Sub Category = OPTRN.
4. Journal uses a Project. This Project has Funds distribution rules set up.
5. Run Cost collection to collect the Journal.
6. Upon Cost collection Journal gets split and creates FDS row.
7. Run Process Project Accounting. PSA_ACCTGGL and the above error is received.

 

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