Pre trigger
Answered by:
Pre form trigger ans post form trigger
Form first trigger and last trigger
When a form will open, which trigger will fire first and last?
Whenever we open the WHEN_NEW_FORM_INSTANCE and we will close the form then PRE_FORM Triggers is fired...
Hi,
first trigger is pre form trigger
last trigger is post form trigger
thanks
How to transfer from AP to GL?
Run the create accounting automatically flows all entries in GL
Run the create accounting automatically flows all entries in GL
Answer Question Select Best Answer
P_conc_request_id parameter utility
What is the utility of p_conc_request_id parameter? For what purpose is p_conc_request_id used?
Hi,
P_conc_request_id capture the concurrent program id in srs window . after run the program successfully completed we will get the output from srs window.
Oracle receivables flexfields
How many flexfields are there in Oracle receivables? What are they?
Two key flexfield in receivable 1. Location flexfield 2. Territory flexfield I.Location flexfield : sales tax is dependent on the ship to location of the customer so It is MANDATORY flexfield f...
What is data migration and what is conversion?Whats the difference between both?
See..Conversion means moving data from one apps system into another apps system.But data migration means moving from non apps system to apps system(Like Upgrading).
Data Migration is the one off PROCESS of moving data from one system to another, whether that be an upgrade or from legacy.Data Conversion is a step in the data migration process that involves a some ...
What is meant by erp?
ERP is used to maintain organization requirement like purchasing,sales,inventory,ap,ar,fa etc.,
ERP is best way to planning our business requirement.
ERP Stands for Enterprise Resource Planning . it is a customized s/w whcih is develop as per requirement of organization.
What is an API & what is the sequence of events that happens after calling API ?
API means we can directly insert data into base tables with standard validations through calling API.
But Interface means we have to load data into interface tables.After that we have to run Import program.
API is nothing but application program interface.when we call an API first of all it will check the validations for the data(validations u can see in the API) that u are inserted through API, if the validations are successful the n it will insert data into the base tables.
Second parameter should depend on first parameter
When I am running my report in Apps I have to pass two parameters second parameter should be depend on first parameter. And in first parameter it consist two list of valuesex:1. Approve 2. In process when I pass approve in first parameter then second parameter should be enable and when I pass in process...
:$FLEX$.Value_ Set_Name
In this senario we unable to disable the parameter for that what you can do like this In the 2nd parameter value set you have to hardcore in the where caluse like &...
Retrieve one particular row
Suppose if there are 100 rows and you need to retrieve one particular row without using where clause?
Code
SELECT * FROM AP_SUPPLIERS START WITH VENDOR_ID =10000 CONNECT BY PRIOR VENDOR_ID =SEGMENT1
(OR)
SELECT * FROM AP_SUPPLIERS CONNECT BY LEVEL<=1
Select rownum=1 from table;
Answer Question Select Best Answer
Lot and serial controlled
Asked By: sandeep24410 | Asked On: Jul 6th, 2012 2 answers
What is meant by lot and serial controlled item?
Answered by: Manivasagam on: Jul 9th, 2014
Lot contains multiple Items,so that particular lot have some details.
Serial number means every item in a lot have serial number details.
Answered by: priya on: Sep 25th, 2012
Serial controlled means a serial number is associated to each piece of the item.Attribue1 in table mtl_system_items defines if the item is serial controlled.
Answer Question Select Best Answer
Child field is placed in parent frame
Asked By: syedrafi123 | Asked On: Jan 19th, 2012 3 answers
There is parent frame and for that parent frame there is child frame, suppose child field is placed in parent frame what message you will get.
Answered by: venu on: Jun 27th, 2014
Frequency below group/abouve group
Answered by: Ramesh.maldakal on: May 30th, 2014
Filed doesnt exists under the parent
Answer Question Select Best Answer
What is the difference between cross-validation rules and security-rules?
Asked By: Interview Candidate | Asked On: Aug 15th, 2005 5 answers
Answered by: prasad on: Jun 2nd, 2014
Cross Validation Rule:Rules that define valid combinations of segment values a user can enter in an account. Cross-validation rules restrict users from entering invalid combinations of account segment...
Answered by: audiresri on: Feb 25th, 2009
Security rules is nothing but restrict the user to enter invalid accounting values means we are restricting the to enter manually. If dynamic insert is on is checked then we can define the security r...
Answer Question Select Best Answer
1.How to create concurrent program with out system administrator responsibility from front end.?2.How to call one concurrent program from another concurrent program?
Asked By: manasa | Asked On: Apr 23rd, 2007 5 answers
Answered by: Prateek on: May 30th, 2014
FND_PROGRAM.SUBMIT_REQUEST
Answered by: Prateek on: May 30th, 2014
Use FND_PROGRAM.REGISTER
Answer Question Select Best Answer
Master organization doesn’t have any child organizations
Asked By: sandeep24410 | Asked On: Jul 6th, 2012 1 answer
If master organization doesn’t have any child organizations, this will be stored in mtl_parameters or not?
Answered by: DINESH on: Apr 10th, 2014
Yes.. It will be created as master
Answer Question Select Best Answer
Can anybody suggest me how can the multi org. Be set up?
Asked By: Debajyoti | Asked On: Dec 19th, 2005 10 answers
Answered by: sridevikoduru on: Mar 14th, 2014
I am Sridevi Koduru, Oracle Apps Techno Functional Faculty with 5+ Years Training Experience on Oracle Apps Technical, Oracle Apps Functional, SQL, PL/SQL and D2K including 3+ Years of Real Time Exper...
Answered by: bala koti reddy on: Feb 21st, 2013
In R12
begin
mo_global.set_policy_context(s,orgid);
end;
Answer Question Select Best Answer
Manadatory parameters in Oracle Apps reports
Asked By: anishajain | Asked On: Mar 6th, 2008 7 answers
What are the manadatory parameters in Oracle Apps reports?
Answered by: shatagni on: Mar 6th, 2014
P_conc_request_id, p_flexval
Answered by: GURU on: Jan 25th, 2014
Parameters not mandatory for reports
Answer Question Select Best Answer
What is the function of token in concurrent program window?
Asked By: Adithya | Asked On: Nov 27th, 2006 6 answers
Answered by: Rohit Gupta on: Jan 26th, 2014
Token is the linking between concurrent program and report builder.Tokens are case sensitive.So,it should be in same case as given in report builder. We can also change the sequence in which paramete...
Answered by: venkateshei on: Feb 26th, 2007
Token is nothing but a interface between report builder parameters and concurrent program parameter.Report bulider parameters are not in sequence. that is why we combine with token .
Answer Question Select Best Answer
What is set of books ? What are the four conditions when you change your sobs?
Asked By: Interview Candidate | Asked On: Aug 31st, 2005 6 answers
Answered by: manohar reddy on: Jan 7th, 2014
Calender
Answered by: balakotireddy on: Apr 26th, 2013
In R12 setbooks are called as ledgers
setofbook contain 3c->currency,calendar,chartofaccounts.
ledgers contain 4c->currency,calendar,chartofaccounts,conversion methods
Answer Question Select Best Answer
Allow dynamic inserts
Asked By: oraclehrmsab60 | Asked On: May 23rd, 2013 1 answer
Why we enable allow dynamic inserts and what is the purpose?
Answered by: murari on: Oct 11th, 2013
If you allow dynamic inserts when you set up your key flexfield, a user can enter a new combination of segment values using the flexfield window from a foreign key form
