Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

How do I create an Oracle EBusiness Suite - Read Only Responsibility

Posted on 2009-07-06
7
3,300 Views
Last Modified: 2013-11-16
I have the need to create read only versions of some existing responsibilities in Oracle Applications R12.
0
Comment
Question by:Brendan_Cleary
  • 2
7 Comments
 
LVL 48

Expert Comment

by:schwertner
ID: 24801669
A suggestion would be to use CUSTOM.PLL to fire a WHEN-NEW-FORM-INSTANCE trigger. If the responsibility is one you want to be Query Only, then set the standard form level parameter: QUERY_ONLY = YES. I would suggest a Flex value set to store the responsibility name and ID. That way you can add or remove them without having to hard-code values in CUSTOM.PLL.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24801675
0
 

Accepted Solution

by:
Brendan_Cleary earned 0 total points
ID: 24809502
Thanks schwertner.

I already found your first post on the internet and it's not the way we want to go, but thanks anyway.  The 2nd post is talking about creating a read only database schema. So that doesn't fit.

I've logged an SR with Oracle, but they are not supporting this feature via any simple means yet. There is an ER logged with them for possible Enhancement in the future.

I am going to mess around with RBAC and some other messier mechanism that the organisation has used in the past. I just wanted to see if the community had come up with anything better.

I'll leave the question open for a few more days, if no one comes back with anything I will close it out.

Thanks for you  help to date.
0
 

Expert Comment

by:leenus2b
ID: 25195187
Hi ,

You mentioned the  ER#  BUG_ID: 4355862 ,

The workaround is to duplicate each function of the menus and set its parameter to QUERY_ONLY=YES ,

You can see the Metalink DocID :       400380.1 (How To Create a QUERY-ONLY FORM)

Best Regards/
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question