Posts

Showing posts from October, 2012

Query to Identify the Concurrent Program for Long time.....................

Step1 :  Run the first query ,  this will list all the programs that currently running in Application. Take the SID and use it in the second query. SELECT       f.user_name       ,a.request_id "Req Id"       ,a.concurrent_program_id "Prg Id"       ,a.RESPONSIBILITY_ID Responsibility       ,a.phase_code,a.status_code       ,b.os_process_id "OS"       ,vs.sid       ,vs.serial# "Serial#"       ,vp.spid       ,TO_CHAR(request_date,'DD-MON-YY hh24:mi:ss') request_date       ,(NVL(a.actual_completion_date,SYSDATE)-a.actual_start_date)*1440 "Time"       ,c.concurrent_program_name||' - '||c2.user_concurrent_program_name "Program" FROM APPLSYS.fnd_Concurrent_requests a     ,APPLSYS.fnd_concurrent_processes b     ,applsys.fnd_concurrent_queues q     ,APPLSYS.fnd_concurrent_programs_tl c2     ,APPLSYS.fnd_concurrent_programs c     ,APPLSYS.fnd_user f     ,v$session vs     ,v$process vp WHERE       a.controlling_mana

Oracle WorkFlow Basics....................

Image
WorkFlow Overview : This article will illustrate how to create or define workflow attributes, notifications, messages, roles or users, functions, processes and last but not the least, how to launch a workflow from PL/SQL. The workflow concepts are better explained using an example. Business Requirement: When an item is created in inventory, workflow needs to be launched and it should collect the details of the item created and sends a notification to group of users along with the details and link to master item form. Process flow : When an item is created it will create/insert a record in MTL_SYSTEM_ITEMS_B so create a database trigger on the table and launch workflow from that trigger. All you need to do is create the workflow, create the trigger, pl/ sql package, roles and finally create an item in inventory. Open WFSTD and save as new workflow Create Attributes Create Functions Create Notification Create Messages Create Roles Create database trigger Create P