CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.




Get it now !!
Send your Resume to 6000 Companies
AOL Interview Questions & Answers - Learning Mode
COOLINTERVIEW.COM ORACLE APPS INTERVIEW QUESTIONS AOL INTERVIEW QUESTIONS QUESTIONS & ANSWERS - LEARNING MODE

AOL Interview Questions & Answers - Learning Mode

The Oracle Applications AOL/J Setup Test Suite, used to trouble-shoot the Self-Service framework, can be exploited to remotely retrieve sensitive configuration and host information without application authentication.

Try AOL Interview Questions & Answers - Exam Mode

1 2 Next

Sort By : Latest First | Oldest First | By Rating

AOL Interview Questions & Answers - Learning Mode
Try AOL Interview Questions & Answers - Exam Mode
Question: How cam i changes in custom.pll? After changes how can i send on the server and what's effect in this condition?

Answer: 1. FTP the Custom.pll from $AU_TOP/resource

2. Open the Custom.pll in Forms6i

3. Include the following code for your Form logic :

begin

Form_Name varchar2(50) := name_in('system.current_form');

If Form_Name = 'YOUR CUSTOM FORM" then

begin

include your logic

end;

end;

4. Once changes over , using the following command to generate the CUSTOM.plx

f60gen module=CUSTOM.pll userid= Source: CoolInterview.com
Question: What is '$flex$ and '$profile$, Waht is the use of '$flex$'?



Answer: $Flex$ is used when we need to return the Flex value contained by any AOL Vlauset or AOL object .

For Ex . $Flex$.<Valueset name> would return the value held by that valueset .

$profiles$. are used to get the values of environment variables like org_id or mfg_Organization_id etc which are related to the current apps environment.

Ex. $profiles$.org_id would return the operating unit which is active at that time for the user. Source: CoolInterview.com
Question: I have applied a patch. at the time of applying he update a table and suddenly he gives the error that table is lock. Now what i do?

Answer: one case could be multiple upgrade scripts in the patch are there, and ad workers are running them parally , so when the first worker was upading the table and second one also gone for the update at the same time, in this case locking error will come.

To resolve this kind of issues patch should not contain different upgrade scripts for a single table ,all the upgrades should happen in the same file. Source: CoolInterview.com
Question: How do I check if Multi-org is installed?



Answer: SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS

If MULTI_ORG_FLAG is set to 'Y', Then its Multi Org.
Source: CoolInterview.com
Question: What do I do if I am missing an executable from my APPL_TOP?



Answer: Simply display the error(request status ERROR) , object name and path in the logfile.

NOTE : Before submitting any request(s), required executable(s) to be trasfered(FTP) in their corresponding TOPs thru UNIX.

Source: CoolInterview.com
Question: How can i implementing and managing the custom schema?
please give me quick reply.


Answer: Basically a schema is collection of objects(tables, views, indexes,sequences) belonging to particular user, here in case of Oracle apps every module is implemented as a user for example Order Management is implemented as a user ONT, so to create a custom schema, we need to create a user and register the user with AOL.

check this link for step by step process to create a custom module(Application) and register with oracle AOL. Source: CoolInterview.com
Question: How do I submit a concurrent request from PL/SQL?



Answer: begin

v_request_id := fnd_request.submit_request(applicationshortname,concurrentprogramshortname,description,paramers)

commit;

if v_request_id > 0 then

dbms_output.put_line('Successfully submitted')

else

dbms_output.put_line('Not Submitted');

end;

Source: CoolInterview.com
Question: How do I generate a message file (usaeng.msb)?



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) Source: CoolInterview.com
Question: What is AUTO Accounting what are the steps for setting up auto accounting



Answer: Auto Accounting is a mechnism for generating defualt accounting flexfields for revenue , receivables, frieght and tax based on the other parameters associated with the invoice you are entering.. since auto accounting looks at the following tables to get the data so please set/define the following depending upon your requirement.

1.Salesrep.

2.Transaction Types.

3.Standard Lines.

4.Taxes.

5.Customer bill-to-site

Source: CoolInterview.com
Question: What is Auto Invoicing? Explain?



Answer: Auto invoicing is used to import the AR invoices direclty into the AR module Source: CoolInterview.com
Question: What are Different types of transactions in AR?



Answer: I know 6 of them in total

1) Charge back

2) Credit memo

3) Debit memo

4) Invoice

5) Guarantee

6) Deposit
Source: CoolInterview.com
Question: What are the standard concurent programs for auto invoice interface and customer interfaces



Answer: Autoinvoice Import Program -- for auto invoice program Customer Interface Master Conc Program --> for Customer Interface Source: CoolInterview.com
Question: What are the logfile and output file naming conventions?



Answer: Log file get following name by default: lRequest_id.req

and Output file get following name by default : oRequest_id.out

Output files are stored at $APPLCSF/$APPLOUT

and Log files are stored at $APPLCSF/log

These paths may vary depending on the setups that sys admins perform at the time of Oracle Apps installation
Source: CoolInterview.com
Question: Where do concurrent request logfiles and output files go?



Answer: The solutions provided are very informative and crisp . HIghly for beginners and for experts . Source: CoolInterview.com
Question: What are the interface tables used for ar invoices, customers, receipts for conversion process



Answer: Following are the Validation for Autoinvoice:



? AR Transaction Type Validation : Check if the Transaction type provided in data file is defined in AR transaction types(RA_CUST_TRX_TYPES_ALL)

? Transaction Batch Source Validation: Check if the source provided in data file is defined in AR transaction Batch source (RA_BATCH_SOURCES_ALL).

? Invoice Currency Validation: Check if the currency provided in data file is defined in AR Currency (FND_CU Source: CoolInterview.com
Question: What so you mean by Hierarchical and non Hierarchical security type in value set?



Answer: You define a security rule element by specifying a value range that includes both a low and high value for your segment. A security rule element applies to all segment values included in the value range you specify.

You identify each security rule element as either Include or Exclude, where Include includes all values in the specified range, and Exclude excludes all values in the specified range. Every rule must have at least one Include rule element, since a rule automatically excludes Source: CoolInterview.com
Question: What is quick code? why is it called a quick code?
What is steps of defining a quick code?



Answer: Quick code is that where we can hurry up the process of getting services and extended warranties quickly.

Source: CoolInterview.com
Question: What is the use of lockboxes?



Answer: Auto lock box is used create receipts automatically and match against the invoices, customers.

Steps for lock box are :

The first step involves reading and formatting data from your bank file into AutoLockbox tables.

The second step involves submitting the validation program which checks data in the AutoLockbox tables for compatibility with Receivables. Once data is validated, it is transferred into QuickCash tables. At this point, you can optionally query your receipts Source: CoolInterview.com
Question: How do i recover the responsibility in apps if it is disabled?



Answer: Here is the API script which add the System Administrator responsibility through which you add the other responsibility.

DECLARE
CURSOR c1_cur IS SELECT u.user_name
,u.user_id,u.end_date,u.start_date,u.description
FROM fnd_user u
WHERE u.user_name IN ('subbarab')
AND (u.end_date IS NULL OR u.end_date = TO_DATE('31-dec-4712','dd-mon-yyyy'))
ORDER BY u.user_name;

BEGIN
FOR c1 IN c1_cur LOOP
B Source: CoolInterview.com
Question: I have run a request but it is not completed. His status is (running normal) and those requests are giving after this he will be completed.So,now what steps i have follow for the unning request?

Answer: You might have submitted the request when network traffice is peak.

So try to submitt the request when network traffice less, Suggested to submit at night time Source: CoolInterview.com

1 2 Next



India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.045898 Seconds