Home > Ask the Oracle Database / Applications Experts > Oracle applications and 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?

>
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
Oracle applications and E-Business Suite
Is Oracle 11i Applications or E-Business Suite a variation of Oracle Forms?
Where can I get more information on the Oracle CRM E-Business Suite?
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

Oracle E-Business Suite
Part 3: The final ERP transition: Crossing the finish line successfully
Part 2: Maintaining your place in the race -- ERP project management
Revving your engines: Tuning up your ERP project plan
Ventana's Mark Smith on Hyperion and Oracle BI
Oracle delivers database fixes in Critical Patch Update
Oracle CRM On Demand data integration raises big issues
Oracle applications learning guide
SMART weighs Oracle vs. SAP, picks E-Business Suite 12 for IFRS compliance
Oracle's E-Business Suite consolidates HBO's financial operations
Ellison sees new opportunities for Oracle with Java on mobile devices

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



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

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




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