Sign Up

Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.

Sign Up Here

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here

Sorry, you do not have a permission to add a post.

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Sign InSign Up

Oraask

Oraask Logo Oraask Logo

Oraask Navigation

  • Home
  • Blog
  • Knowledge Base
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Categories
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Developers
  • Wiki
    • SQL Tutorials
    • Java Tutorials
    • Python Tutorials
    • JavaScript Tutorials
  • Home
  • Blog
  • Knowledge Base
Home/ Questions/Q 5900
Next
Answered
Mina
  • 0
Mina
Asked: July 12, 20172017-07-12T16:43:30+03:00 2017-07-12T16:43:30+03:00In: Oracle Applications DBA

How can I cancel user Concurrent Requests in EBS R12 ?

  • 0

Hello ,

i need to cancel Concurrent Requests in back-end.

Thanks,

 

cancel concurrent request from backenddatabasefnd_concurrent_requests status_codehow to cancel concurrent request from backend in oracle appshow to kill concurrent request from backendhow to terminate concurrent request from backendoraceloracle EBS R12terminate concurrent program from backendterminate concurrent request from backendupdate concurrent request status from backend
  • 4 4 Answers
  • 5k Views
  • 0 Followers
  • 0
Answer
Share
  • Facebook

    Related Questions

    • Tablespace size
    • How to extracts DDL statements for specified objects ?
    • How to see lock on table and query?
    • How to query Gather schema statistic For Last week NonApps schemas in EBS R12?
    • How to query Gather schema statistic For Last week For Apps schema in EBS R12?

    4 Answers

    • Voted
    • Oldest
    • Recent
    1. Best Answer
      Mmorsy Explorer mahmoudmorsymm1985@gmail.com
      2017-07-16T10:57:12+03:00Added an answer on July 16, 2017 at 10:57 am
      This answer was edited.

      Hi,

      TO Cancel user requests ————————

      • Check for the user Id for the requests to be canceled.
      SELECT DISTINCT fu.user_id, fu.user_name, fu.employee_id, fu.start_date, fu.end_date, fu.creation_date, fu1.user_name AS "User Created By" FROM fnd_user fu, fnd_user fu1 WHERE fu.end_date IS NULL AND fu.created_by = fu1.user_id(+) AND fu.created_by NOT IN (0, 1) ORDER BY 1;
      • Check for the running request for that user to be canceled.
      SELECT * FROM fnd_concurrent_requests WHERE phase_code IN ('R') AND requested_by = 2111 ORDER BY last_update_date DESC
      • Cancel the request of that particular user from the back end.
      UPDATE fnd_concurrent_requests SET phase_code = 'C', status_code = 'D' WHERE phase_code = 'R' AND requested_by = 2933; 

      COMMIT;

      STATUS_CODE Column: A Waiting B Resuming C Normal D Cancelled E Error F Scheduled G Warning H On Hold I Normal M No Manager Q Standby R Normal S Suspended T Terminating U Disabled W Paused X Terminated Z Waiting

      • PHASE CODE column. C Completed I Inactive P Pending R Running

      Regards

      Mahmoud Morsy.

      • 1
      • Reply
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
        • Share on WhatsApp
    2. ilyas
      2021-07-11T22:14:53+03:00Added an answer on July 11, 2021 at 10:14 pm

      Jazakallah khair

      • 0
      • Reply
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
        • Share on WhatsApp
    3. Thorarinn Andresson
      2022-01-20T21:52:34+03:00Added an answer on January 20, 2022 at 9:52 pm

      Hi, when I try this I get this error:
      Routine FND_CONCURRENT.CANCEL_REQUEST cannot get information for your concurrent
      request

      • 0
      • Reply
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
        • Share on WhatsApp
      • Hassan AbdElrahman Leader Oracle ACE Pro ♠ | Oracle Senior Technical Consultant @ Cloud Solutions
        2022-01-20T21:57:53+03:00Replied to answer on January 20, 2022 at 9:57 pm

        Can you provide us with the exact statement you executed?

        • 0
        • Reply
        • Share
          Share
          • Share on Facebook
          • Share on Twitter
          • Share on LinkedIn
          • Share on WhatsApp

    Leave an answer
    Cancel reply

    You must login to add an answer.

    Forgot Password?

    Need An Account, Sign Up Here

    Sidebar

    Ask A Question
    Add A New Post
    • Popular
    • Answers
    • Beter

      oracle.apps.fnd.framework.OAException: Application: ICX, Message Name: Could not find the specified ...

      • 8 Answers
    • ditomathew

      Create Item not showing up in Personalize Table

      • 5 Answers
    • albert

      REP-52262 Diagnostic output is disabled when using oracle reports 11g

      • 4 Answers
    • Hassan AbdElrahman
      Hassan AbdElrahman added an answer To copy a table without copying its data, you can simply use this SQL statement: CREATE TABLE xx_oraask_tbl_bkp AS SELECT * FROM xx_oraask_tbl WHERE 1=0; But there is a limitation… June 25, 2022 at 2:43 pm
    • Hassan AbdElrahman
      Hassan AbdElrahman added an answer This error is thrown because there is a limit of 5 open HTTP connections per session in the Oracle database server. Usually, the application intends to open one connection at… June 25, 2022 at 2:09 am
    • Hassan AbdElrahman
      Hassan AbdElrahman added an answer It's not as simple as changing the ATTRIBUTE column size because there are a lot of dependencies that you need to pay attention to e.g. Changes to other tables that… June 25, 2022 at 1:46 am

    Adv 250x250

    Adv 250x250

    Adv 120x600

    Explore

    • Categories
    • Questions
      • New Questions
      • Trending Questions
      • Must read Questions
      • Hot Questions
    • Developers
    • Wiki
      • SQL Tutorials
      • Java Tutorials
      • Python Tutorials
      • JavaScript Tutorials

    Footer

    Oraask

    About

    Ask A Question and wait experts to answer you, or help others and build massive reputation in your filed - With Oraask you will never get stuck again.

    About Us

    • About Us
    • Contact Us

    Legal Stuff

    • Privacy Policy
    • Terms & Conditions

    Follow

    Oraask is licensed under CC BY-NC-SA 4.0Oraask CopyrightOraask CopyrightOraask CopyrightOraask Copyright

    © 2019 Oraask. All Rights Reserved
    With Love by Oraask.

    Insert/edit link

    Enter the destination URL

    Or link to existing content

      No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.