Query to get Concurrent Program's Parameters, Value Sets and Default Values in Oracle Apps R1. SELECT fcpl. user. Current Running SQL for a Concurrent Program. Query To Get The Oracle Concurrent Program Parameters SELECT df. Query to list concurrent program details with its parameter. Query to list concurrent program details with its. Query to findout locked objects in Oracle and. Query to find out concurrent program details select prog.user. FYI, Note the values for Spawned is 'A'. Registering a PLSQL stored procedure as concurrent program. Create Parameters and it is Better to Create Value Set. Now when you query it you will get the Request group as shown in the below screenshot. Query To Find Concurrent Program's Parameters and Value Sets SELECT fcp. SQL Query to Find Scheduled Concurrent Programs By running below sql query in toad or sql develper, you can get list of scheduled concurrent requests. A Concurrent Program can be attached to a multiple Request Groups. So, if the query returns more than one row do NOT get confused. Labels: AOL Concepts Concurrent Programs. Oracle Apps Guy: Query to find the Request Group.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2017
Categories |