I've been looking through some of the feature requests from the business, and have come across these tables which seem to adjust the behaviour of the system.
In particular, I'm looking at CMN_OPTION 'PAC_FRC_FREEZE_DATE' and what it might do for us.
But in general, is there docs that someone could point me to that lists out what some/each do? (hoping much?)
Especially trying to reach out to John_George from this post How to Modify the Limit on the Number of Investments and Roles included in a Portfolio in CA Clarity 13.2 | CA Clarity P…
I unfortunately do not have an answer for you at this time. But, I will reach out to my Clarity team members to see if they may be able to help you, so please stay tuned.
John W. George
Not answering your question at all, but
I cam across the cmn_options with cross site vulnerability error. See TEC567263_Crosssite_vulnerability
The instruction did not work so I had to do it manually.
For that particular problem the work around (which was supposed to be done with the instructions of TEC567263) was
create the value CSRF_EXEMPTED_ACTIONS in CMN_OPTIONS and record the ID
then create values in CMN_OPTION_VALUES for that ID.
The values were picked from the app-niku.log when the cross site vulnerability error occured.
In my case they were
I should expect in your case there are values in the CMN_OPTION_VALUES table which match the ID of the action 'PAC_FRC_FREEZE_DATE' in the CMN_OPTION
You might get a little further if you look at the values.
Thanks urmas, that value is null in the values table, and I'd like to know what it would do if it wasn't null, before I change it! (and any subtle rules around it too...)
Thanks John, I'm on 13.1 on demand if that assists at all.
If you are on demand you can't do any unsupported hacking so you are limited to supported solutions.
Open a Request for Information case with support and describe the behaviour you see, your desired behaviour or just ask for details how this option is designed to work.
I wasn't considering hacking it (updates to the db using an out of the box store procedure as referenced in my first posts' link from CA was what I was following - this I would presume would be somewhat supported)...
The tables you mention are updated through different pages in the Administration side of the application and correspond to system-level settings. Typically tables that contain system settings are not documented in the Technical Reference Guide because they are not intended to be used for developing portlets or reports.
The 'Freeze Date' relates to the Financial Entity, Plan Defaults setting. There are some KBs and product documentation that describes how to configure this setting and what it is used for in the investment financial planning functionality.
Thanks Kathryn - I guess I was following on from that first link, showing how some of the items can only be updated through the clarity provided store procedure (which aren't available on your typical admin/studio screens).
I guess the reason for querying that particular field, is that I have a value in the Entity Freeze Date (2nd Sep 2014 at the moment), and it does stop manual edit of cost plans on projects upto and including September 2014 for all projects, but that option value in the DB is null.
from cmn_options co
join cmn_option_values cov on cov.option_id = co.id
where co.option_code = 'PAC_FRC_FREEZE_DATE'
yields one row, with null values for COV.USER_ID and COV.VALUE
Would this be expected / should it be in sync with Clarity Studio Entity on the UI (is it a bug?)
Hi samos2, I see that you have a conversation going with Kathryn_Ellis about your question, so you are in very good hands! After you have worked together to get a resolution, may I ask you to please mark this as "Answered".
Thank you and have a good rest of your day.
John W. George
Thanks John, will do!
Further to the above, along with the cmn_options and cmn_option_values being null for PAC_FRC_FREEZE_DATE, there ARE values for the date saved against the entity via the Studio UI in the FIN_PLAN_DEFAULTS table for this entity. My question remains, should the UI be in sync with the CMN_OPTION_VALUES table? Is it the missing link that allows 'populate from task assignments' to update the cost plan cost forecasts in the past, even though through XOG you can't do the same?