How to schedule the concurrent programs from back end(PL/SQL) -not from srs form.
How do I submit a sherie of requests from PL/SQL?
we can submit 2 or more programs from backend by using below FND
FND_CONCURRENT.WAIT_FOR_REQUEST
if we need to submit 2 or more programs serieally
we need to submit from back end by using below FND
FND_CONCURRENT.WAIT_FOR_REQUEST
How can we delete a concurrent program which is already registered?
From front end we can not delete the concurrent program. We can only enable or disable the program.
We can delete the concurrent program from back end.
fnd_program.delete_program('Short Name', 'Application');
fnd_program.delete_executable('Short Name', 'Application');
Regards,
Sunil Kaswan
Through the Application Front end its not possible to delete CP. But from backend we can delete it.TO DELETE CONCURRENT PROGRAM---------------------------------------------beginfnd_program.delete_prog...
Table for independent value set
In which fnd table independent value set will be stored?
The name of the table where value set stores:-
1) fnd_flex_value_sets
The name of the table where values stores:
2) fnd_flex_values
3) fnd_flex_values_tl
Regards,
Sunil Kaswan
If you want the base table where the name of the value set is stored then it is
FND_FLEX_VALUE_SETS.
What is the role of applsys and applsyspub
All the technical products' database objects are consolidated into a single schema called Applsys
Applsyspub is used for authentication by having read only views
How can I disabled and enabled the standard button's in Apps window?
Forms personalization is the best way to enable and disable the standard button's in apps window. The other option is using by logical apps rules.
You can do this with Custom.pll and if ur using apps version greater that 11.5.9 then you can do this with form personlization too.Gajanan
How do you create calender value set?
All are known creating of date,number,varchar2 by using we can create lov's. Similar that can we create& attach calender ?
Field must be DATE type.
In the KEY_LIST_VAL trigger you must add the code:
CALENDAR.SHOW;
In the properties of the field, you should set "Validate from List" to 'No'.
We can do this in Apps Forms.Prerequisite: We need to load all the predefined plls for example, APPDAYPK for calendars.Once we have all the dll's required, Assign the key list lamb LOV to th...
What is the difference between organization id and master organization id?
If the enterprise has a multi org structure then it would have a Master org and inv/child orgs. All items should have an entry in Master org before they can be assigned to inventory orgs. The items in...
Whenever an item receives in an operating unit then it will receive in master orgnization id only after that we assigns the items to take different orgnization ids. Therefore there must be an unique master orgnization id and can be multiple orgnization ids with in an operating unit.
What is us directory under any top?
US directory is one directory for save the reports or forms or programs to be used in US language, if you want to use Spanish language option you should save the programs in ESA directory. It mea...
Forms and reports directories contains the language directories,
Means which language apps is using, apps supports multiple languages.
US is the standard language used by Oracle.
vinod.
How do I recover the responsibility in Apps if it is disabled?
Post your answer
Here is the API script which add the System Administrator responsibility through which you add the other responsibility.DECLARECURSOR c1_cur IS SELECT u.user_name &n...
Please run the following concurrent program
Workflow Directory Services User/Role Validation
What is the process of defining shipping parameters in om
This is detail about Shipping Parameters..for OM.. The below details are breifly descripb u.. If any clarifications plz.. go to India Local Order Management>> Shipping>> Setup>>...
How do I open a form in query-only mode?
Navigate to the form functions form (application->function) query the particular form and add the parameter query_only=yes not all forms will accept this parameter however.
go to applcation developer responsibilitynavigation->Application/function.query the function name then goto form tab then goto parameters field then write the following code in that fieldQUERY_YES="YES"save the changes and then see the forms get affected in query only mode.
What is a concurrent program and a concurrent request set ?
Concurrent program is nothing but instance of execution file along with parameters and incompatabilities.
By using concurrent request set we can submit multiple programs at a time through srs window.
after creation of request set we can attach it to request group.
A concurrent program is an executable file that runs simultaneously with other concurrent programs and with online operations, fully utilizing your hardware capacity. Typically, a concurrent program i...
How do I submit a concurrent request from PL/SQL?
Use fnd_request.Submit_request example: req_id := fnd_request.Submit_request('fnd', 'fndscaru'); note that this can only be called from a concurrent program see the coding standards for parameter details
Hi Usha,If you wanna find out the USER_ID, ORG_ID, RESP_ID, RESP_APPL_ID, connect to the system and open any window and flow the below mentiioned navigation to find the values..Help -> Diagnostics ...
I am not able to see the userid or org-id going to the home page of applications under the help menu. There is no diagnostics menu at all when I expand it...I don't know where to see it atll.
Thanks,
Usha
How do I check if multi-org is installed?
Select multi_org_flag from fnd_product_groups;
SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS
y --THIS IS MULTIORG INSTALLED
n--MULTIORGNOT INSTALEED
BUSINESSGROUPS->LEGALENTITEIS->SETOFBOOKS->OPERATINGUNIT->INVENTORYORGANIZATION
U can check whether Multi - org is installed or not by using following query.
Select multi_org_flag from fnd_product_groups ;
If the result is
' Y ' then it is set to be multi - org.
' N ' then it is not set to be multi - org.
Cheers,
Bonthu.
How do I generate a message file (usaeng.Msb)?
Use: fndmdcmf applsys/pwd 0 y app usaeng where: applsys/pwd is the applsys user and password and app is the short name of the application (like PO or inv)
It can be generated through submission of Concurrent Program from Application Developer responsibility.
use adadmin
How do you attach Javascript to a menu ? When user clicks on a menu it should display simple message
What is quick code? Why is it called a quick code?What is steps of defining a quick code?
Quick Code or Lookup Code are short names given to some field values. an example is two letter codes given to Country names.
quick code is that where we can hurry up the process of getting services and extended warranties quickly.
surya
Where do concurrent request log files and output files go?
The concurrent manager first looks for the environment variable $applcsf if this is set, it creates a path using two other environment variables: $appllog and $applout it places log files in $applcsf/$appllog output files go in $applcsf/$applout so for example, if you have this environment set: $applcsf...
The output of the command below is the answer select
from fnd_concurrent_requests
Saurabh
Hindalco
solution is good at the beginnner level .
can be still more infromative
How do I cancel a running concurrent request?
Navigate to the concurrent request summary form select a request in character, do a quickpick on the status column you can select cancel or hold in gui, use the cancel or hold buttons the sysadmin responsibility can cancel or hold any running request
Please open below package & see the coments.
FND_REQUEST
.submit_svc_ctl_request
We also can able to submit from back end by using API called 'fnd_request.submit_request',it consist following
program,Description,arguments .Before this we must initialize by using fnd_apps.global_intialize
You can try FND_REQUEST.SET_REPEAT_OPTIONS to run at specific times