PSRM 2.3.1 SP2 Modifies Owner Flag to Base for Parameters of Algorithm CM-CSH-AC-CA (Doc ID 1960569.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Public Sector Revenue Management - Version 2.3.1.2.0 to 2.3.1.2.0 [Release 2.3]
Information in this document applies to any platform.

Symptoms

After installing SP2 successfully into a TEST Environment, the Owner Flag of a custom Algorithm, CM-CASH-ACC, based on Algorithm Type C1-CASH-ACC, is set to C1 instead of CM.
It is now impossible to delete this algorithm from the GUI.



before SP2:
select * from ci_alg_parm where ALG_CD = 'CM-CSH-AC-CA';

ALG_CD EFFDT SEQNO ALG_PARM_VAL VERSION OWNE
CM-CSH-AC-CA 01-JAN-50 1 ACCTTRUE 1 CM
CM-CSH-AC-CA 01-JAN-50 2 N 2 CM


after SP2:
select * from ci_alg_parm where ALG_CD = 'CM-CSH-AC-CA';

ALG_CD EFFDT SEQNO ALG_PARM_VAL VERSION OWNE
CM-CSH-AC-CA 01-JAN-50 1 ACCTTRUE 1 C1
CM-CSH-AC-CA 01-JAN-50 2 ASMT 1 C1
CM-CSH-AC-CA 01-JAN-50 3 1 C1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. upgrade to ETPM 2.3.1 SP2
2. navigate to algorithm CM-CSH-AC-CA
3. Try to delete this cm algorithm, an error is raised saying that it is not possible to delete because the owner flag is base.

BUSINESS IMPACT
-----------------------
This algorithm is used as the cash accounting algorithm on the obligation type. This issue contributes to having a parameter not found error while posting some forms.



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