Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Wednesday, 18 October 2017

Query to Get Concurrent Program details in Oracle Apps


--Concurrent Programs details

SELECT fcp.concurrent_program_id,
       fcp.concurrent_program_name,
       fcpt.user_concurrent_program_name,
       fcpt.description,
       fe.executable_name,
       fet.user_executable_name,
       fe.execution_file_name
  FROM apps.fnd_concurrent_programs fcp,
       apps.fnd_concurrent_programs_tl fcpt,
       apps.fnd_executables fe,
       apps.fnd_executables_tl fet
 WHERE     fe.executable_id = fet.executable_id
       AND fcp.concurrent_program_id = fcpt.concurrent_program_id
       AND fcpt.language = fet.language
       AND fcp.executable_id = fe.executable_id
       AND fcp.executable_application_id = fe.application_id
       AND fcpt.language = 'US'
       AND fcpt.user_concurrent_program_name LIKE
              'Meter Collection Main Program'



--To find Responsibilities having a particular Concurrent Program

  SELECT frt.responsibility_name, fcpt.user_concurrent_program_name
    FROM fnd_concurrent_programs fcp,
         fnd_concurrent_programs_tl fcpt,
         fnd_request_group_units frgu,
         fnd_responsibility fr,
         fnd_responsibility_tl frt
   WHERE     fcp.concurrent_program_id = fcpt.concurrent_program_id
         AND fcp.application_id = fcpt.application_id
         AND fcp.concurrent_program_id = frgu.request_unit_id(+)
         AND frgu.unit_application_id(+) = fcp.application_id
         AND frgu.request_group_id = fr.request_group_id(+)
         AND fr.responsibility_id = frt.responsibility_id(+)
         AND fr.application_id = frt.application_id(+)
         AND frgu.request_unit_type(+) = 'P'
         AND frt.language(+) = 'US'
         AND fcpt.language = 'US'
         AND fcpt.user_concurrent_program_name LIKE 'I%Materialized%'
ORDER BY frt.responsibility_name



--Concurrent Request Details

SELECT           
        fcr.request_id request_id,
         NVL (fu.description, fu.user_name) requested_by,
         DECODE (fcp.concurrent_program_name,
                 'FNDRSSUB', 'Request Set - ' || fcr.description,
                 fcpt.user_concurrent_program_name)
            concurrent_program,
         DECODE (fcr.phase_code,
                 'I', 'Inactive',
                 'P', DECODE (fcr.hold_flag, 'Y', 'Inactive', 'Pending'),
                 'R', 'Running',
                 'C', 'Complete',
                 fcr.phase_code)
            phase,
         DECODE (
            fcr.status_code,
            'U', 'Disabled',
            'W', 'Paused',
            'X', 'Terminated',
            'Z', 'Waiting',
            'M', 'No Manager',
            'Q', 'Standby',
            'R', 'Normal',
            'S', 'Suspended',
            'T', 'Terminating',
            'D', 'Cancelled',
            'E', 'Error',
            'F', 'Scheduled',
            'G', 'Warning',
            'H', 'On Hold',
            'I', CASE
                    WHEN fcr.request_date < fcr.requested_start_date
                    THEN
                       'Scheduled'
                    ELSE
                       'Normal'
                 END,
            'A', 'Waiting',
            'B', 'Resuming',
            'C', 'Normal',
            fcr.status_code)
            status,
         fcr.argument_text,
         TO_CHAR (fcr.request_date, 'DD-Mon-RRRR HH12:MI:SS AM') date_requested,
         TO_CHAR (fcr.requested_start_date, 'DD-Mon-RRRR HH12:MI:SS AM')
            requested_start_date,
         TO_CHAR (fcr.actual_start_date, 'DD-Mon-RRRR HH12:MI:SS AM')
            date_started,
         TO_CHAR (fcr.actual_completion_date, 'DD-Mon-RRRR HH12:MI:SS AM')
            date_completed,
         fcr.oracle_process_id,
         fcr.os_process_id,
         fcr.logfile_node_name || ': ' || fcr.logfile_name logfile_name,
         fcr.outfile_node_name || ': ' || fcr.outfile_name output_name
    FROM fnd_concurrent_requests fcr,
         fnd_concurrent_programs fcp,
         fnd_concurrent_programs_tl fcpt,
         fnd_user fu
   WHERE     fcr.concurrent_program_id = fcp.concurrent_program_id
         AND fcp.concurrent_program_id = fcpt.concurrent_program_id
         AND fcr.program_application_id = fcp.application_id
         AND fcp.application_id = fcpt.application_id
         AND fcr.requested_by = fu.user_id
         AND fcpt.language = 'US'
ORDER BY fcr.request_date DESC
Share this article :

16 comments:

  1. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com

    ReplyDelete
  2. As per a report by Statista, as of January 2018, there were over 3.7 billion individual portable clients on the planet. Additionally, because of the serious cell phone innovation being used today, versatile cell phones represented almost half of the complete worldwide web utilization volume. whats mod apks

    ReplyDelete
  3. FMWhatsApp APK is usually favored over the traditional variant of WhatsApp. All Thanks to the unique set of features and functionalities that it offers.

    ReplyDelete
  4. Holy moly thank you, I have been searching for a query like this for days now!

    ReplyDelete
  5. Nice & Informative Blog !
    Finding adequate technical services for QuickBooks in this competitive world is quite challenging. Our team at QuickBooks Phone Number 1-855-652-7978 is always available to offer you the best technical help for QuickBooks.

    ReplyDelete
  6. When i started using Oracle, I used to think that Status code "A" means active but letter I got to know on Yo WhatsApp from a group that "A" a for waiting status code,

    ReplyDelete
  7. Thanks for the post. I have found this codes much similar as in universal remote code apps source code.
    Thanks a lot
    Ishan Shezan
    Universalremotebest.com

    ReplyDelete
  8. Great article Lot's of information to Read...Great Man Keep Posting and update to People..Thanks spy phone app

    ReplyDelete
  9. Excellent blog, keep sharing such things. It was helpful. Also try Nulls Clash.

    ReplyDelete
  10. Nulls Brawl Apk
    Nulls Brawl Alpha APK 36.270 Buzz ve Griff Android Oyun İndir Son Sürüm Hileli Sınırsız Elmas Sınırsız Para

    ReplyDelete
  11. I love Orcale app thanks for sharing this I am preparing this app called Gbwhatsapp let me know how is it?

    ReplyDelete
  12. Offshore Hosting with 100% DMCA ignored Hosting, Offshore Dedicated Server, Offshore VPS Hosting. https://offshorededi.com/ is the Most Secure Offshore Host. Providing Offshore Streaming Servers as well.

    ReplyDelete
  13. Thanks for the wonderful blog, I suggest you add videos in the blog. Inshot App Para PC is a great software for downloading the videos and making the blog more attractive. Use the software to edit the videos.

    ReplyDelete
  14. Wow great skills, also take a look at my website Thoptv For PC

    ReplyDelete
  15. fortnite sistem gereksinimleri? nedir diye soruyorsanız fortnite sistem gereksinimleri haberimize göz atmayı unutmayın.

    ReplyDelete