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
D2K Interview Questions & Answers - Learning Mode
COOLINTERVIEW.COM ORACLE APPS INTERVIEW QUESTIONS D2K INTERVIEW QUESTIONS QUESTIONS & ANSWERS - LEARNING MODE

D2K Interview Questions & Answers - Learning Mode

D2K has revolutionized the ETL market by offering data extraction and transformation as a service as well as custom software solutions. D2K. Data to Knowledge (data mining application). It's the Oracle Developer Suite, mainly consisting of Oracle Forms and Oracle Reports.

Try D2K Interview Questions & Answers - Exam Mode

1 2 Next

Sort By : Latest First | Oldest First | By Rating

D2K Interview Questions & Answers - Learning Mode
Try D2K Interview Questions & Answers - Exam Mode
Question: How I can use SRW.RUN_REPORT in Reports6i?



Answer: u can use srw.run_report as followssrw.run_report('module=modulename.rdf destype=screen paramform=yes'); Source: CoolInterview.com
Question: Are you familiar with internet architecture of Oracle Apps 11i



Answer: There are 3 tier of Internet Architechture of Oracle Application 11i.

1. Desktop Tier
2. Database Tier
3. Application Tier.

Source: CoolInterview.com
Question: Which Oracle Apps version you are very confident in.



Answer: As we basically use 11.5.9 version hence its better to tell that only.

Source: CoolInterview.com
Question: What is use of object libraries.



Answer: 1) To create ,store,and maintain and distrubate standard and reusable objects.

2)Rapidly create application by dragging and droping predefined objects on to form.
Source: CoolInterview.com
Question: Have you used lexical parameters in reports



Answer: There is no need of using Lexical parameter in reports Deveoper.Instead We can use bind Variables as a parameter. Source: CoolInterview.com
Question: Any work done in Oracle Workflow builder. Did you customize or build a new workflow.



Answer: Yes, I customized the Work Flow For Credit Memo Request approval in AR through Workflow Builder. Source: CoolInterview.com
Question: How do you run ms_batch file in forms?
what could be the value :system.mode?




Answer: host('c:myFile.bat'); Source: CoolInterview.com
Question: Which directory will you copy your new custom form, what would be its extension ( .fmb or .fmx )



Answer: Directory Name:-

Move the fmb file into :-

cust_top/forms/US

Keep the new form (renamed) in au_top/forms/US

Source: CoolInterview.com
Question: Which Oracle applications PL/SQL standard APIs you are familiar, have you used most of them.



Answer: 1. Fnd_File - PL/SQL I/O
2. Fnd_program - Concurrent Program Loaders
3. Fnd_set - Request Set Creation
4. Fnd_request - Concurrent Request Submission
5. Fnd_Submit - Request set Submission
6. Fnd_Request - Info

and so on...

Source: CoolInterview.com
Question: What is the Page Protect in Reports?




Answer: It indicates that whether you want to keep a object and its entire contents on the same logical page. Setting its property to 'yes' if the object and its entire contents cannot fit in the page it will be moved to next logical page. Source: CoolInterview.com
Question: How many different layouts are available in Reports6i? What are they?
in which sequence , form level trigger will fire? in which sequence, report trigger will fire?
how many types of canvas are there in form? what r they?
what are bind variables and lexical reference in oracle reports?
how many types of colums are there in Reports6i? what are they?
what is the purpose of placeHolder column in Report?
can u have a form with out a canvas?
what is confine mode and flex mode in reports?
how do u register report in oracleApps?




Answer: There are eight different layout formats :

1. Tabular

2. Form Like

3. Mailing Label

4. Form Letter

5. Group Left

6. Group Above

7. Matrix

8. Matrix with group
Source: CoolInterview.com
Question: How to make the project as .exe file in oracle forms & reports(d2k)



Answer: Developer/2000 doesn't make exe files. Think of your Dev 2k project
like an access database, you develop the forms and reports and then

when you deploy them you also install the Forms & Reports Runtimes

on the clients machine. Forms, when compiled have the *.fmx

extension as opposed to the normal *.fmb extension.

Source: CoolInterview.com
Question: What is the Placeholder Column?
What is the Format Trigger?




Answer: A placeholder column is used to hold the value of certain calculation or a variable that is being carried out in a formula column. A place holder can be defined as anumber, character or date type, depending upon the type of value which will be stored into it.

A format trigger is used when we want to display a particular field, if certain conditions are met.
Source: CoolInterview.com
Question: Do you know table based value sets



Answer: yes i know.

Nav=>application-->validation-->set

we will give set name.

select type as table,"edit information" button will hilight,click that

give application name-->table name(for which u want to make table value set)-->column name-->give name of the column-->where/order by(give the condition or order either asc/desc)-->save it and use in "parameters" window in concurrent program creation.


Source: CoolInterview.com
Question: How should i get a image from database to report?

Answer: Hi,
Open the Report using Report Builder, then connect to the instance.
In Layout Model file-->Import--> Its asking the Path where your image is located . Give the Appropriate Location then image is loaded from database into layout model. Source: CoolInterview.com
Question: What is the Anchoring in Reports?
What is the difference between Frame and Repeating Frame?




Answer: Anchors are used to determine the vertical and horizontal positioning of a child object relative to its parent. The end of the anchor with a symbol on it is attached to the parent object.

Since the size of some layout objects may change when the report runs (and data is actually fetched), we need anchors to define where we want objects to appear relative to one another. An anchor defines the relative position of an object to the object to which it is anchored. Positioning is based on t Source: CoolInterview.com
Question: Do you know what are User Profiles in Apps. Any examples you can give.



Answer: User Profile : It is a set of changeable options through which your application runs.User profile can be defined at various levels. They are

1.System

2.Application

3. Responsibility

4. User
Source: CoolInterview.com
Question: Which directory will you copy your new reports, what would be its extension ( .rdf or .rex )



Answer: THe extension of the Oracle report will be *.rdf (Report Definition File).

You place the Oracle report on the corresponding application top in the reports folder.

Eg: $XAP_TOP/../reports
Source: CoolInterview.com
Question: Have you good knowledge on Java.



Answer: Can anybody give the meaning of this question.

i think answer is: i know java
Source: CoolInterview.com
Question: Were you involved in any data conversion, which one




Answer: Ya..We have done data conversion for1.Suppliers2.AP Invoices3.Customers4.AR Invoices 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.15625 Seconds