My Oracle Support Banner

ECA 9.2: CA_ACCT_RULES_CI Has a Limit for CRIT_SEQ As 99999 So Cannot Add More LA Accounting Rules (Doc ID 2899024.1)

Last updated on SEPTEMBER 30, 2022

Applies to:

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

Symptoms

 
 Unable to create LA accounting rules due to criteria sequence being maxed out which is 99999.  

 

Error:
----------
The negative number is assigned to an unsigned field: PSA_RULES_HDR.CRIT_SEQ. (2,121) ...


Replication Steps:
-----------------------
1: Goto setup Financials/Supply Chain -Product Related - Lease Administration - LA Accounting Rules.

2: Make sure you have 99999 rules for a business unit (This can be achieved using Excel o CI). Check CA_RULES_DEFN.CRIT_SEQ should be 99999 for CA_TXN_SOURCE = 'FRE'.

3: Try to add one more. The error will pop up.

 


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.