Home > Ask the Oracle Experts > E-Business Suite Questions & Answers > Retrieving Oracle SID name in Reports
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Retrieving Oracle SID name in Reports

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: 05 April 2006
How do you retrieve an Oracle SID name? I am using Oracle Reports. I want to display the SID name on the report.

>
EXPERT RESPONSE

Select SID from v$session where module = <name>.

The <name> is either the concurrent request shortname or the executable shortname, I can't remember which offhand. This is assuming the report is not being run multiple times at the same time. You can insure that by making it incompatible with itself.


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
Query-only responsibility in Oracle Apps
ORA-01455 on Apps 11.0.3
Viewing Flexfield in its entirety
Validation process followed in GL interfaces
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