Tuesday 21 November 2017

How to cancel Scheduled Concurrent Programs in Oracle apps

From Front End:

1) Login with the same user, who scheduled the concurrent program
2) Go to view requests from the responsibility it's been scheduled -->View Requests--> Query for the program
3) You should get one record in scheduled state
4) Click on view details end date the schedule and cancel the request.


Select * from fnd_concurrent_programs
WHERE CONCURRENT_PROGRAM_ID = ----------------

Select * from fnd_concurrent_programs_VL
WHERE USER_CONCURRENT_PROGRAM_NAME = 'Name'

Select * from fnd_concurrent_requests
WHERE CONCURRENT_PROGRAM_ID = ----------------




From Back End
Use below query to cancel scheduled concurrent program.

UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE status_code IN ('Q','I')
AND requested_start_date > SYSDATE
AND hold_flag = 'N'
AND CONCURRENT_PROGRAM_ID=&P_CONCURRENT_PROGRAM_ID;

COMMIT;



7 comments:

  1. Hi all, Oracle technical and fusion cloud SCM online classes, if you are interested please whatsapp to this number +91 7382582893, thank you.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Every year in the month of March 2021 – 2022, the Assam Education Board (SEBA) conducts the HSLC Final Examination; this year, SEBA will conduct a 30 percent Deleted Study Metrical HSLC Examination 2021 – 2022; Assam Board HSLC Students who successfully SEBA HSLC Model Paper 2022 registered online for the HSLC Examination 2021 – 2022; Assam Question Paper 2021 – 2022 for HSLC 30 percent Reduced SEBA Question Paper 2021 – 2022 for 10th Class are very important since they assist students practise and prepare for the next Assam Board Exam in a better way.

    ReplyDelete