Solved

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

Posted on 2009-07-06
7
3,266 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 47

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 47

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now