How To Register A Package As A Concurrent Program
MOAC Setup - Concurrent Program CREATE SECURITY PROFILE. This program calls the package CDMAP_TEST_PKG.MAIN, It using the Oracle View AP_INVOICES view, it will returns the data once the OU is initialized. Register / Attach WEBADI Function to Responsibility in R12. Also I need the steps to work with the concurrent program in oracle application so that when I run the executable file in the oracle Application, I should get the output in the oracle SQL developer for the executed procedure in the Oracle Application.
END; VARIABLE DESCRIPTION executable Name of executable (for example, ‘FNDSCRMT’). Application The short name of the executable’s application, for example, ‘FND’.
Description Optional description of the executable. Execution_ method The type of program this executable uses. Possible values are ‘Host’, ‘Immediate’, ‘Oracle Reports’, ‘PL/SQL Stored Procedure’, ‘Spawned’, ‘SQL*Loader’, ‘SQL*Plus’. Execution_ file_name The operating system name of the file. Required for all but Immediate programs. Midtown madness 2 free download for pc.
This file name should not include spaces or periods unless the file is a PL/SQL stored procedure. Subroutine_name Used only by Immediate programs. Cannot contain spaces or periods. Icon_name Reserved for future use by internal developers only. Specify NULL.
Language_code Language code for the name and description, for example, ‘US’. 2) Registering the Concurrent program from back end. END; VARIABLE DESCRIPTION program The user-visible program name, for example ‘Menu Report’. Application The short name of the application that owns the program. The program application determines the Oracle user name used by the program. Enabled Specify either “Y” or “N”.
Short_name The internal developer program name. Description An optional description of the program. Executable_name The short name of the registered concurrent program executable. Executable_ application The short name of the application under which the executable is registered.
Execution_ options Any special option string, used by certain executables such as Oracle Reports. Priority An optional program level priority. Save_output Indicate with “Y” or “N” whether to save the output. Print Allow printing by specifying “Y”, otherwise “N”.
Cols The page width of report columns. Rows The page length of report rows. Style The default print style name.
Style_required Specify whether to allow changing the default print style from the Submit Requests window. Printer Force output to the specified printer. Detective conan 3gp download. Request_type A user-defined request type. Request_type_ application The short name of the application owning the request type. Use_in_srs Specify “Y” to allow users to submit the program from the Submit Requests window, otherwise “N”. Allow_ disabled_values Specify “Y” to allow parameters based on outdated value sets to validate anyway. Specify “N” to require current values.
Run_alone Program must have the whole system to itself. (“Y” or “N”) output_type The type of output generated by the concurrent program. Either “HTML”, “PS”, “TEXT” or “PDF”.
Enable_trace Specify “Y” if you want to always enable SQL trace for this program, “N” if not. Nls_compliant Reserved for use by internal developers only.