\n1. Create procedure
\n2. Create Executable
\n3. Create Program
\n4. Add this program to the required request group<\/p>\n
1. Create Procedure:<\/span> Below is the code snippet of the procedure. Compile the same by connecting to the database as APPS user. We can also use API\u00a0 fnd_concurrent.set_completion_Status to set the concurrent program status.<\/p>\n 2. Create Executable: Enter the below details and save. b.Short Name: This should be unique and used for internal purposes<\/p>\n c.Application: Specify under which application you want to register this Concurrent Program, normally all customizations will be registered under custom application.<\/p>\n d.Description: Description<\/p>\n e.Execution Method: Choose PL\/SQL Stored Procedure since we want to register a procedure<\/p>\n f.Execution File Name: Enter the procedure name. You don’t need to specify any parameters of procedure here. If your procedure is encapsulated within a package, then executable file name should be entered as <package name>.<procedure name><\/p>\n 3. Create Program: Enter the below details and save the work. b.Short Name: This should be a unique name and for system reference<\/p>\n c.Application: Enter the application under which you want to register this concurrent program<\/p>\n d.Executable Name: Enter the Executable Short Name created in Step 2.<\/p>\n e.Method: This will be populated automatically from Executable Definition<\/p>\n f.Output Format: Select the format of the output you want<\/p>\n g.Output Style: Select A4 to print on A4 Paper<\/p>\n h.Printer: You can default any printer or you can enter while submitting concurrent program.<\/p>\n i.Enable Trace: Check this if you want to enable trace on this program. This is normally for debugging performance issues.<\/p>\n j.Use in SRS: Check this box if you want the users to be able run this program from Submit Request window.<\/p>\n Click on Parameters button to define the parameters for your concurrent program.<\/p>\n Enter the below details and save the work. b.Parameter: Enter a name for the parameter.<\/p>\n c.Description: You can see this description while submitting the concurrent program.<\/p>\n d.Value set: Enter a valid value set name. You can use the standard value sets provided as well.<\/p>\n e.Default Type and Value: These fields are optional. They are to be used when you want to default any particular value for a parameter.<\/p>\n Current Date : Will be used to pass the Sysdate as default value f.Prompt: This is the actual parameter name displayed while submitting the concurrent program<\/p>\n g.Token: This should be used only when you are registering a report.This is used to link this parameter to the parameter defined in actual report file(.rdf)<\/p>\n h.Enabled\u00a0 CheckBox: will be used to enable or disable the parameter 4.Assign to Request Group: First find out the request group of this responsibility. Navigation: System Administrator Responsibility > Security > Responsibility > Request Now place the cursor under Requests section and click on ADD icon in the Menu.<\/p>\n Enter the below details and save the work. Register PL SQL stored procedure in Oracle Apps: You have a PL\/SQL procedure in your database and you want the user to be able to execute it from Oracle Apps front end. To do so, we have to register the procedure in Oracle Apps. Now let’s see how to do that. Steps to register a […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,8],"tags":[],"class_list":["post-4865","post","type-post","status-publish","format-standard","hentry","category-articles","category-sysadmin-and-aol"],"yoast_head":"\n
\nLet’s create a procedure that will take\u00a0 input as Item name and returns the respective Item ID.
\nIf you want to register a procedure, the procedure should be created with the two below mandatory parameters:
\nerrbuf : For printing out the error messages.
\nretcode: return 0 for successful execution
\nreturn 1 to end the concurrent program in warning
\nreturn 2 to end the concurrent program in error<\/p>\n
\n
\nPROCEDURE erps21_conc_prog(
\nerrbuf OUT VARCHAR2,
\nretcode OUT VARCHAR2,
\nv_name VARCHAR2 )
\nIS
\nv_item_id VARCHAR2(100);
\nBEGIN
\nSELECT inventory_item_id
\nINTO v_item_id
\nFROM mtl_system_items_b
\nWHERE segment1 = v_name
\nAND rownum =1;
\nfnd_file.put_line(fnd_file.output, 'Parameter received:' || v_item_id);
\nEXCEPTION
\nWHEN OTHERS THEN
\nRETCODE := 2;
\nerrbuf := 'Entered EXCEPTION block';
\nEND;
\n<\/code><\/p>\n
\nNavigation: System Administrator \/ Application Developer responsibility > Concurrent > Executable<\/p>\n
\na.Executable: Enter any meaningful name<\/p>\n![\"Screenshot_042914_100026_PM\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Screenshot_042914_100026_PM.jpg\")
<\/p>\n
\nNavigation: System Administrator\/Application Developer responsibility > Concurrent > Program<\/p>\n
\na.Program: User Understandable Program Name<\/p>\n![\"Screenshot_042914_100905_PM\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Screenshot_042914_100905_PM.jpg\")
<\/p>\n
\na.Seq: It’s always better to enter sequences in multiple of 5 or 10 so that you can insert any additional parameters if you want later in between.<\/p>\n
\nCurrent Time : Will be used to pass the Systime as default value
\nConstant\u00a0\u00a0\u00a0\u00a0 : Will be used to pass the constant number or date or string as default value
\nSegment\u00a0\u00a0\u00a0\u00a0\u00a0 : will be used to get the Previous parameter value as default to the next parameter
\nSQL Statement: We can pass the SELECT statement result as default value
\nProfile : This will be used to pass the user profile value as default like userid ,username,respid,respname and so on.
\nRequired CheckBox : This will be used to make the parameter as mandatory or optional<\/p>\n
\ni. Display\u00a0 CheckBox: will be used to hide or display the parameter<\/p>\n![\"Screenshot_042914_101856_PM\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Screenshot_042914_101856_PM.jpg\")
<\/p>\n
\nSay you want this program to be accessible to Inventory responsibility.<\/p>\n
\nNavigation: System Administrator Responsibility > Security > Responsibility > Define<\/p>\n![\"Screenshot_042914_102856_PM\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Screenshot_042914_102856_PM.jpg\")
<\/p>\n
\nQuery for the Request Group obtained above.<\/p>\n![\"Screenshot_042914_103117_PM\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Screenshot_042914_103117_PM.jpg\")
<\/p>\n
\n1. Type: Enter Program if this is a concurrent program. Enter Set if this is a request set.
\n2. Name: Enter the concurrent program \/set name.
\n![\"Screenshot_042914_103402_PM\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Screenshot_042914_103402_PM.jpg\")
<\/p>\n","protected":false},"excerpt":{"rendered":"