Home > Ask the Oracle Experts > E-Business Suite Questions & Answers > Query-only responsibility in Oracle Apps
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Query-only responsibility in Oracle Apps

Russell Arno EXPERT RESPONSE FROM: Russell Arno

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Oracle tips, scripts, and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 13 July 2006
Hi Russell, my question is regarding the possibility of creating a query-only responsibility in Oracle Apps. I understand that there is a way to create a read-only DB account and tie that Oracle ID to the data group that eventually would use the query-only responsibility. My question is: What's the type of privileges or DB roles that particular DB account should have associated with it, in order for my query-only responsibility to work properly?

>
EXPERT RESPONSE
My 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.

I am not up to speed on 11.5.10 forms personalization enough to say if it can be used instead of CUSTOM.PLL. I don't know if you would have to make changes to all the forms in the menu of the responsibility (which could be a lot of work). With CUSTOM.PLL, all forms use it.

Hope this helps,
Russell


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


RELATED CONTENT
E-Business Suite
Is Oracle 11i Applications or E-Business Suite a variation of Oracle Forms?
Changing APPS password in Oracle Financials
Account queries in Oracle AR Receivables
Determining which table and column a field is stored in
Migrating data to legacy system as functional consultant
ORA-01455 on Apps 11.0.3
Viewing Flexfield in its entirety
Validation process followed in GL interfaces
Retrieving Oracle SID name in Reports
Documents for beginner to E-Business Suite

Oracle E-Business Suite
Special report: Collaborate '08
Oracle forced migration fears a matter of education, OAUG says
Oracle password best practices
The E-Business Suite user's guide to Oracle OpenWorld 2007
Oracle OpenWorld 2007 Special Report
Oracle buys GRC firm LogicalApps
SunGard challenges Oracle in public sector
Millipore swaps out SAP for Oracle
Oracle and SAP passed over for IFS by water desalination firm
Why no integrity constraints in Oracle E-Business Suite?

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2003 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts