Wednesday, 10 April 2013

How to Find Request Group and Application for Concurrent Programs


SELECT FAT.APPLICATION_NAME,FRG.REQUEST_GROUP_NAME,FCP.CONCURRENT_PROGRAM_NAME PROGRAM_SHORT_NAME,FCP.ENABLED_FLAG
,(SELECT USER_CONCURRENT_PROGRAM_NAME FROM FND_CONCURRENT_PROGRAMS_TL WHERE CONCURRENT_PROGRAM_ID=FCP.CONCURRENT_PROGRAM_ID) PROGRAM_NAME
,FRGU.APPLICATION_ID ,FRGU.REQUEST_GROUP_ID,FRGU.REQUEST_UNIT_ID,FRG.DESCRIPTION
FROM FND_REQUEST_GROUP_UNITS FRGU
    ,FND_APPLICATION_TL FAT
    ,FND_REQUEST_GROUPS FRG
    ,FND_CONCURRENT_PROGRAMS FCP
WHERE FRGU.APPLICATION_ID=FAT.APPLICATION_ID(+)
AND FRG.APPLICATION_ID=FAT.APPLICATION_ID
AND FRG.REQUEST_GROUP_ID=FRGU.REQUEST_GROUP_ID
AND FCP.CONCURRENT_PROGRAM_ID =FRGU.REQUEST_UNIT_ID
--AND FRGU.APPLICATION_ID=FCP.APPLICATION_ID(+)
AND FCP.CONCURRENT_PROGRAM_NAME = NVL(:P_SHORT_NAME,FCP.CONCURRENT_PROGRAM_NAME)
AND FAT.APPLICATION_NAME        = NVL(:P_APPLICATION_NAME,FAT.APPLICATION_NAME)
AND FRG.REQUEST_GROUP_NAME      = NVL(:P_REQUEST_GROUP_NAME,FRG.REQUEST_GROUP_NAME)

Monday, 8 April 2013

How to Check the File Version in Oracle Application


Check the File version

Two ways to check version of file.

    1. Adident    2. Strings

 ADIDENT Utility in ORACLE application is used to find version of any file.

 1st Method

   Syntax : adident Header filename.

   e.g If you want to find out the version of appvndrb.pls
        $ cd AP_TOP/patch/115/sql
        $ adident Header appvndrb.pls
        o/p :
         appvndrb.pls:
         $Header appvndrb.pls 120.78.12010000.83 2010/04/27 21:00:55 vinaik ship


2nd Method :

 Using Strings:

  Syntax : strings -a Top_name/location of file/filename | grep '$Header'
   e.g $ strings -a $AP_TOP/patch/115/sql/appvndrb.pls | grep '$Header'
   o/p : /* $Header: appvndrb.pls 120.78.12010000.83 2010/04/27 21:00:55 vinaik ship $ */
                                              OR
      $ cd $AP_TOP/patch/115/sql
      $ strings -a appvndrb.pls | grep '$Header'

OR

grep '$Header' $INV_TOP/patch/115/sql/INVTXGGB.pls