aditya

• Nov 2nd, 2017

"plsql l_request_id := fnd_request.submit_request ( application => ONT, program => xx_test1, description => XXTest Employee Details, start_time => sysdate, sub_request => FALS...

Hemendra

• Aug 5th, 2016

DECLARE l_responsibility_id NUMBER; l_application_id NUMBER; l_user_id NUMBER; l_request_id NUMBER; l_boolean ...

Answer Question  Select Best Answer

Deepak

• Jul 3rd, 2017

Hi,
We can delete concurrent program name from back end with below command.
begin
FND_PROGRAM.DELETE_PROGRAM(XXA_PO_BRANDING_COST,Purchasing );
end;

Govind Palariya

• Nov 24th, 2016

Concurrent program can deleted from back end.

Begin
fnd_program.delete_program(program short name,schema);
fnd_program.delete_executable(program short name,schema);
commit;
End;

Answer Question  Select Best Answer

What are the gaps identified during upgradation of Oracle 11i to R12?
How will you rectify the gaps identified during R12 upgradation?

Sai Chaitanya

• Jun 3rd, 2015

The gaps can be removed only by going back to Flat File and check sure that junk data is not available, if junk is present we need to delete it

Answer Question  Select Best Answer

Lakshmi L

 Profile Answers by Lakshmi L Questions by Lakshmi L

• Feb 1st, 2013

Applsys Schema : Consists of files starts with FND, ALR, WF and AD.

Applsyshub Schema : Contains a collection of all public synonyms of all FND Tables, which are used for user verification.

skylabudin

• Nov 22nd, 2007

All the technical products' database objects are consolidated into a single schema called ApplsysApplsyspub is used for authentication by having read only views

Answer Question  Select Best Answer

suneel.jinka

 Profile Answers by suneel.jinka Questions by suneel.jinka

• Sep 20th, 2011

We can submit 2 or more programs from backend by using below FND

FND_CONCURRENT.WAIT_FOR_REQUEST

suneel

• Sep 20th, 2011

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

Answer Question  Select Best Answer

In which FND table independent value set will be stored?

sunilkaswan

 Profile Answers by sunilkaswan Questions by sunilkaswan

• Aug 20th, 2011

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

VidyaPrem

 Profile Answers by VidyaPrem Questions by VidyaPrem

• Jul 9th, 2009

If you want the base table where the name of the value set is stored then it isFND_FLEX_VALUE_SETS.

Answer Question  Select Best Answer

suryajosh

 Profile Answers by suryajosh Questions by suryajosh

• Jan 12th, 2011

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.

Gajanan Wayal

• Jan 25th, 2006

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

Answer Question  Select Best Answer

All are known creating of date,number,varchar2 by using we can create lov's. similar that can we create& attach calender ?

jith_in

 Profile Answers by jith_in Questions by jith_in

• Feb 26th, 2010

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'.

manveshv

 Profile Answers by manveshv Questions by manveshv

• Jan 11th, 2010

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...

Answer Question  Select Best Answer

Adi_phaniK

 Profile Answers by Adi_phaniK Questions by Adi_phaniK

• Oct 7th, 2009

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...

avinash singh

 Profile Answers by avinash singh Questions by avinash singh

• Aug 18th, 2008

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.

Answer Question  Select Best Answer

jvquestions

 Profile Answers by jvquestions Questions by jvquestions

• Sep 20th, 2008

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...

Vinod

• Jan 5th, 2007

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.

Answer Question  Select Best Answer

Post your answer

Brinda

• Jul 24th, 2006

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...

Manoj

• May 2nd, 2006

Please run the following concurrent program Workflow Directory Services User/Role Validation

Answer Question  Select Best Answer

What is the process of defining shipping parameters in OM

damus.sajja

 Profile Answers by damus.sajja Questions by damus.sajja

• Mar 16th, 2008

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>>...

Answer Question  Select Best Answer

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.

Shaik_fayaz

 Profile Answers by Shaik_fayaz Questions by Shaik_fayaz

• Dec 8th, 2007

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.

Answer Question  Select Best Answer

sri

• Oct 22nd, 2007

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.

Rajasekaran

• May 16th, 2007

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...

Answer Question  Select Best Answer

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

kirankumar.oluguri

 Profile Answers by kirankumar.oluguri Questions by kirankumar.oluguri

• Aug 2nd, 2007

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 ...

Usha

• Jul 31st, 2007

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

Answer Question  Select Best Answer

SELECT multi_org_flag FROM fnd_product_groups;

t1.venki

 Profile Answers by t1.venki Questions by t1.venki

• Jul 17th, 2007

SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPSy --THIS IS MULTIORG INSTALLEDn--MULTIORGNOT INSTALEEDBUSINESSGROUPS->LEGALENTITEIS->SETOFBOOKS->OPERATINGUNIT->INVENTORYORGANIZATION

Bonthu N Reddy

• Feb 13th, 2006

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.

Answer Question  Select Best Answer

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)

Vicky

• May 28th, 2007

It can be generated through submission of Concurrent Program from Application Developer responsibility.

J

• Jan 13th, 2006

Use adadmin

Answer Question  Select Best Answer

Sunil

• Dec 27th, 2006

Quick Code or Lookup Code are short names given to some field values. an example is two letter codes given to Country names.

suryaram

 Profile Answers by suryaram Questions by suryaram

• Jul 5th, 2006

quick code is that where we can hurry up the process of getting services and extended warranties quickly.surya

Answer Question  Select Best Answer

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 = /u01/appl/common $APPLLOG = log $APPLOUT = out The concurrent manager will place log files in...

Saurabh Sarkar

• Dec 9th, 2006

The output of the command below is the answerselect LOGFILE_NAME, OUTFILE_NAMEfrom fnd_concurrent_requestsSaurabhHindalco

raghavendran

• Jul 6th, 2005

Solution is good at the beginnner level .   can be still more infromative

Answer Question  Select Best Answer

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

kishore

• Nov 18th, 2006

Please open below package & see the coments. FND_REQUEST.submit_svc_ctl_request

Answer Question  Select Best Answer