Oracle Apps Technical Information

  How to kill a session which is locked in Oracle apps This Article is used to explain how to kill a session which is locked a.            Check if the Package or table are locked using the below query SELECT b.object_name,               a.session_id,                               a.oracle_username,                               a.os_user_name,                               a.process,      ...

ASCP Pegging Script SELECT DISTINCT msc.organization_code m_organization_code,                       msc.category_name m_category_name,                       item_segments m_item_segments,                       msc.description m_description,                       order_type_text m_order_type_text,                       TO_CHAR (new_due_date) m_new_due_date,                       TO_CHAR (quantity_rate) m_quantity_rate,                                             --                TO_CHAR (msc.disposition_...

SELECT request_group_name, concurrent_program_name   FROM fnd_request_group_units a,        fnd_concurrent_programs_vl b,        fnd_request_groups c,        fnd_responsibility_vl d  WHERE a.request_unit_id = b.concurrent_program_id    AND a.request_group_id = c.request_group_id    AND c.request_group_id = d.request_group_id    AND user_concurrent_program_name LIKE '%XX%'    AND (request_unit_type = 'P') --   AND (a.request_group_id = 295) SELECT distinct  RESPONSIBILITY_NAME  , CONCURRENT_PROGRAM_NAME  from FND_RESPONSIBILITY_VL a ,  FND_REQUEST_GROUP_UNITS  B ,   fnd_concurrent_programs_vl c WHERE 1=1 --and REQUEST_GROUP_ID=1 AND RESPONSIBILITY_NAME LIKE '%ZAMBIA%' and a.REQUEST_GROUP_ID=b.REQUEST_GROUP_ID and a.APPLICATION_ID=b.APPLICATION_ID and b.request_unit_id = c.concurrent_program_id