In Apps10 how can I keep the sticky notes visible but not editable?
I have tried to “grant query” on the presentation object EE_NOTES_CONFIG. But I can still edit.
And if I do not grant EE_NOTES_CONFIG at all, the notes are not visible.
I have tried it also in combination with the activity ManageNotes granted or not. But with no luck.
The presentation object sais Read Only Allowed. So why is it not working?
Thank you! Catherine
Best answer by Marcel.Ausan
@STXHILLSCA I don’t think you can make the Sticky Notes read-only. What you could try is have a Custom Event action on inserts / updates of fnd_note_book_tab → write a short PL/SQL block to throw an error message to the user when they try and update/create new stick note.
The event action block of code could be the one below:
BEGIN
Error_SYS.Record_General('StickyNotes', 'Due to Upgrade Prep for IFS Cloud you are no longer allowed to create or update Sticky Notes. Yours truly, IT Dept :).');END;
Also please see below post as it’s referring to the same topic.
@STXHILLSCA I don’t think you can make the Sticky Notes read-only. What you could try is have a Custom Event action on inserts / updates of fnd_note_book_tab → write a short PL/SQL block to throw an error message to the user when they try and update/create new stick note.
The event action block of code could be the one below:
BEGIN
Error_SYS.Record_General('StickyNotes', 'Due to Upgrade Prep for IFS Cloud you are no longer allowed to create or update Sticky Notes. Yours truly, IT Dept :).');END;
Also please see below post as it’s referring to the same topic.
Update: The custom event has the desired effect that no change and no new sticky note is possible, unfortunately the error is not displayed. So the users changes simply disappear.
But as this in only temporary until we move to cloud, it will do!
@STXHILLSCA it's a pitty that the error message doesn't get propagated in the EE client when users try to change the sticky notes. Glad you you could use the approach I suggested. All the best with your IFS Cloud project.
@STXHILLSCA sorry if I missed this somewhere, but what is your plan for the existing data on the sticky notes when you move to the cloud? Are you extracting the data and/or putting it somewhere else within IFS?
@MCRKAHALSEY it is worth mentioning that data is still there in IFS Cloud db, perhaps in order to show it you could do quick report to pull that info for any given business object in IFS that used to carry Sticky Notes.
@STXHILLSCA sorry if I missed this somewhere, but what is your plan for the existing data on the sticky notes when you move to the cloud? Are you extracting the data and/or putting it somewhere else within IFS?
Yes, we have moved the data to the Notes field. Where there was no notes available we have created a custom field. We have done so about 1-2 months before go live to limit the time needed for the cut over.
We have only done so for LUs with more than 100 notes (more or less).
select lu_name, count(p.note_id) from fnd_note_book_tab b, fnd_note_page_tab p where b.note_id = p.note_id group by LU_name
I have attached a sample script of how we moved the data in the Business Opportunity.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.