D2K Interview Questions

Place Holder Column Is A Empty Container, It Holds The Value At Run Time. Place Holder Column Should Be Source From Formula Column And Before Report Trigger And Also With After Parameter Form Also.....

place holder is nothing but empty column it contains empty data at compilation time,after run the report it can hold the data

FND Stands for Foundation in Application Object Library Module.

Most of the tables in AOL module starts with fnd_XXXX .

The meaning of FND in Oracle Apps or in AOL(Application Object Library) is system name of core application object library and now it is renamed to Application Technology. The application has $FND_TOP which has all the apps related product files

Regards

Utpal Nayak

The Difference is Program units are only to the corresponding form or report.
If, you have written that code in attached library, you can use that code in multiple forms or reports - means reusability, where as you cannot reuse a program unit in multiple forms.

Answer to the first Question is :CALL_FORM to run forms in modal mode. The calling form remains inactive till the called form is exited.NEW_FORM to close the calling form, and then invoke the called f...

Hi,

There are two types..

1. Folder Forms

2. Normal Forms

Why should we copy .fmb and why not .fmx. .fmx is the executable file so we should copy that.

we will copy new custorm form to custom_top/forms.

Extension of that file is .fmb

A flexfield, is a flexible data field that your organization can customize to your business needs without programming. It is made up of sub–fields, or segments. There are 2 types of flexfields ...

Client can customize Descriptive Flex Fields.

Posting is an event that writes insert update and delete in the form but not commiting these transaction to the data base.
Commit is an event that attempts to make the data in the database identical to data in the form.

Q:1) totally there r 9 layouts available in reports,in that 8 are predefined another 1 is manual layout.1.tabular2.form like3.form letter4.group left5.group above6.mailing lable7.matrix8.matrix with g...

1.Web and Paper layout
2.Web layout
3.Paper layout

Please see the question b4 u r going to answer

SRW.RUN_REPORT('MonthlyCostsheet.rep PARAMFORM=NO P_BATCH='||''''||:batch_no||''''||' P_COMPANY_CODE ='||''''||:P_COMPANY_CODE||'...

SRW IS A PACKAGE WHICH IS USE IN REPORTS .HERE IS FOLLOWING PROCEDURES WHICH USE WITH SRW PACKAGE.SRW.ADD_DEFINITIONSRW.APPLY_DEFINTIONSRW.BREAKSRW.CONTEXT_FAILURESRW.DO_SQLSRW.DO_SQL_FAILURESRW.GETTE...

step(1): download the report(.rdf)
step(2): open the report in report builder
step(3): do the modifiacation whatever you want.
step(4): save the report and compile.
step(5): place the .rdf into the respctive folder
step(6): run the report as well

Lexical parameters are used to substitute multiple values at runtime. It can be used in FROM TABLE NAME and in WHERE clause. Usually the lexical parameters are defined in After Parameter Report or in...

Lexical Parameter is denoted by a symbol &(Amphersend) and is used in WHERE_CLAUSE.
with the help of this parameter we can pass strings.

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

Anchor is used to make fix distance between two objects in Reports Layout.

After parameter Trigger: It will fire after the parameter form is displayed.here we can do validation on parameter values
Before Report Trigger: It will fire before the report is execured and after the query is parsed and date is fetched.

Query which has to be run by the report is parsed at the end of AFTER PARAMATER TRIGGER. Hence values that need to be provided for the bind and lexical variables should be assigned in or before this t...

Placeholder column is a global variable for which we can set data type and data value.Format Trigger is a PL/SQL function. This trigger is going to fire before an object is printed in report output.it...

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

Creating Oracle Forms Developer applications using Wizards Working with the enhanced user interface Ensuring consistency across applications Representing data within your application Understanding Ora...

When-validate-item,key-next-item ,on-error,on-message etc are the common triggers shared by form , block as well as items

when new_ form _instance, when new_ block _instance, when new_ item_ instance are most used common trigger

hiwe an do ways1)creating independent valueset and based on this we can create dependent valueset .1st can select independent  then only we can chosse dependent value set 2) By usi...

create one value set. This value set will get first parameter. while creating second Value set use ":$FLEX$.<first value set name>" in the condition. for example, I m cr...

we have the following USER EXITS

1.FND SRWINIT

2.FND SRWEXIT

3.FND FLEXIDVAL

4.FND FORMAT_CURRENCY

5.FND FLEXSQL

User exits are used to set profile options and are actually usedto pass the control from 4gl to 3 gl language to do complexcalculations for ex from Oracle reports to outside and return backto reports....

using SRW.Message

u can make .exe file for ur project..i've given a solution for this in this forum..u can check it out and try it...

thanx..

vikram sagar

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