Solved

How to get the list of reports from Oracle ebusiness suite 11

Posted on 2011-02-14
4
685 Views
Last Modified: 2012-05-11
Hi,

How can I get the list of reports used from Oracle ebusiness suite 11. Is it getting stored in any tables??
0
Comment
Question by:KOAC
  • 2
4 Comments
 
LVL 1

Accepted Solution

by:
Apps_DBA earned 500 total points
ID: 34914161
Hi

The main tables that you need to get a list are:
APPS.FND_CONCURRENT_PROGRAMS
APPS.FND_CONCURRENT_PROGRAMS_TL

The APPS.FND_CONCURRENT_PROGRAMS_TL table contains the USER_CONCURRENT_PROGRAM_NAME which is what the user will see when submitting Concurrent Requests, is also contains a description, but a lot of the time this is the same as the USER_CONCURRENT_PROGRAM_NAME.
If you have Multiple Languages installed then this will also contain the names in the different languages if you want to just get back the English names then you can use the following:

SELECT
     PRG.USER_CONCURRENT_PROGRAM_NAME,
     PRG.DESCRIPTION
FROM
     APPS.FND_CONCURRENT_PROGRAMS_TL PRG
WHERE 
     PRG.SOURCE_LANG = 'US';

Open in new window

You may also want to get the short name, this can be found in FND_CONCURRENT_PROGRAMS

So you could use this query
SELECT
     PRGS.CONCURRENT_PROGRAM_NAME PROGRAM_NAME,
     PRG.USER_CONCURRENT_PROGRAM_NAME LONG_NAME
FROM
     APPS.FND_CONCURRENT_PROGRAMS PRGS,
     APPS.FND_CONCURRENT_PROGRAMS_TL PRG
WHERE 
     PRG.APPLICATION_ID = PRGS.APPLICATION_ID 
AND PRG.CONCURRENT_PROGRAM_ID = PRGS.CONCURRENT_PROGRAM_ID 
AND PRG.SOURCE_LANG = 'US';

Open in new window

You can find more details on Oracle’s ETRM (https://etrm.oracle.com/) if you have a valid My Oracle Support Account.

Hope that helps.
0
 

Author Comment

by:KOAC
ID: 34941171
The query serves our purpose. Thanks a lot
0
 
LVL 1

Expert Comment

by:Apps_DBA
ID: 34949279
Hi
The points did not seem to be awarded to me, was this intentional?
Thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
null value 15 102
Oracle -- identify blocking session 24 52
Converting a row into a column 2 53
ORA-02288: invalid OPEN mode 2 31
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

777 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