Registering a PLSQL stored procedure as concurrent program. To register a PLSQL procedure as concurrent program we have four steps. Step : 1 . Imagine that each time to run a package or procedure a customer has to login to his database and running and for that we have to educate the client. Instead of this, registering a concurrent is best method to run the API because user will be assigned to responsibility and then he can run the program. It is a way to deliver to customer. To register a program as concurrent open Oracle apps and go to the following Navigation. The Navigation is. Login into. Program. Description: Description. Execution Method: Based on this field, your file has to be placed in respective directory or. If you register a PL/SQL Procedure in a package you have to give the packagename. So I go with the table. To get data from table,select validation type as table and click the Edit Information Button Enter the Value and ID to be passed. Linking value set to parameter and the Navigation is. Application Developer . And click on parameters to define parameters and in parameter form you can also enter default type. The above is Example for creating a parameter. JAVA Concurrent Program Requirements. You may decide to dump that into $JAVA. What’s my purpose to sample Project? File Merge sample program. It explains the need of Java concurrent. Why We Need Java Concurrent Program? Java Concurrent Program import oracle.apps. Java Concurrent Programs in Oracle. You may need to FTP those classes from $JAVA. Before I paste a sample java concurrent program. Just observe the below screenshot. Here There is a selection in Enabled. If it is. Checked then the parameter gets enabled and When the Display button is checked we can see the display in Oracle apps concurrent page. We can also give the Default type. The below is another sample of a parameter. It is better to choose FND. This format is (DD- MON- YYYY)To Enter a Date and if we are not in need of Value Set. Number : Click on LOV in Value Set and search by typing %Num%Char : Click on LOV in Value Set and search by typing %CHAR%Date. Time : Click on LOV in Value Set and search by typing %Stan%Date%Query to Check for Concurrent and the info about the Log fileselect cp. Now our Objective is to attach inside a request group to run the concurrent. Step : 4 . We have to make sure that we attach the concurrent program to the responsibility. I have chosen the Responsibility as Global HRMS Manager. Now when you query it you will get the Request group as shown in the below screenshot. The Navigation is. System Administrator . You may not get it listed while searching in the submit request. So Just go to the Below Navigation and check the responsibility Data group. In the below screen shot it is above the marking. The mark represents the Request group and top of it si Data group. So if your application is in Data group then you can see in Request Group. Refer till two below screen shots. To add to Request group go to the Data group and Query the attached name. In my case it is standard. Note over. Submit a new Request and run your concurrent. Here you may be prompted the parameter. Just Remember we had three parameters and we disabled the one so now we got two left. After submission we get the Request Id for our reference. Now we have our output. We can view the output but ours is a procedure so there will be nothing. But we can view the log whether this program worked or not. Thats it your API is deployed. Registering a PLSQL stored procedure as concurrent program. To register a program as concurrent open Oracle apps and. The below is another sample of. Oracle Apps: Concurrent Program : Host: program Return WARNING status. For those who are looking for complete sample code.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2017
Categories |