Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2009-07-06
7
Medium Priority
?
3,464 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
4 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
What we learned in Webroot's webinar on multi-vector protection.
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 is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

783 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