Skip to main content
Solved

Sticky Notes read-only for move to cloud

  • October 11, 2024
  • 8 replies
  • 227 views

Forum|alt.badge.img+5

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.

https://community.ifs.com/topic/show?tid=39065&fid=50

View original
Did this topic help you find an answer to your question?

8 replies

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1142 replies
  • Answer
  • October 11, 2024

@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.

https://community.ifs.com/topic/show?tid=39065&fid=50


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 17 replies
  • October 12, 2024

Thank you @Marcel.Ausan ! That is a good idea. I will creat a custom event. 


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 17 replies
  • October 12, 2024

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! 


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1142 replies
  • October 12, 2024

@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.


Forum|alt.badge.img
  • Do Gooder (Customer)
  • 2 replies
  • January 15, 2025

@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?


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1142 replies
  • January 15, 2025

@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.


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 17 replies
  • January 16, 2025
MCRKAHALSEY wrote:

@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. 

 


Forum|alt.badge.img
  • Do Gooder (Customer)
  • 2 replies
  • January 16, 2025

@STXHILLSCA ​@Marcel.Ausan Thank you both!!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings