D2K Interview Questions

Always first "key_next_item" firs first and then "when_validate_item" fire,this is applicable for all levels .i.e form level,block level and item level

key-next-item
when-validate-item

If still couldnt see the scroll bar, just look at the x and y coordination of the scroll bar. Change the values of hose two according to the size of the window. You will see the scroll bar on the canvas.

You can add whatever scroll bar to your form. Normally we add scroll bars to the data block. Therefore no matter whether the canvas is content or stack or tab one. Simply you can add a scroll bar to y...

we can call report from form directly from object navigator of form

By Using the key word RUN_PRODUCT

Create a view on multiple tables and after then
Create a data block on that view

Use Post_Query Trigger on the Block Level.Remember in this Trigger if you are getting the data from the base table (your Data Block Source), then you dont need any coding.If you want to query another ...

call_form(file namw with path,no_hide,do_replace,no_query_only);

Code
HIDE_WINDOW('WINDOW1');
CALL_FORM('this u r file save path',NO_hide,no_replace,no_Query_only);
SHOW_WINDOW('WINDOW1');

Dear All, Basically when we write null on on error then at that time, no error will display. At the backend when we want to search the on which packages are firing then write down ON_ERROR...

Nothing Happens... the on-error trigger wont be handled in case a NULL is written in the trigger

we can install two instance of oracle on a stand alone machine in two different directories and distinguish them by there different home names as orcl1,orcl2 we can work with both instances........

Yes, we can maintain two oracle databses in a single machine.
For this we need to install two Operating systems in your machine, one is Windows and another one is Unix.
After you that you should install the databases in the two Operating systems.

1) On-Check-Delete-Master Fires when Oracle Forms attempts to delete a record in a block that is Master block in a master-detail relation 2)On-Clear-Details Fires when Oracle Forms needs to clear rec...

1) Which trigger are created when master -detail rela?1) master delete property *  NON-ISOLATED (default) a) on check delete masterb) on clear detailsc) on populate details  *...

Hi Mr. Subrat, very good but when i set system parameters as destype=file and desformat=spreadsheet it is just showing on browser that "Successfully run" and nothing where as if i give destype=c...

set system parameters

destype=file

and

desformat=spreadsheet
(100% tested) and secure

Flex means to store the data for feature purpose.
Bind variable means it returns single column..
Lexical means it return multiple columns..

The main diff betn lexical and bind variable  as followsBind reference will substitute a single value in PL/SQL whereas lexical variables are used to substitute multiple value.  Bind va...

In 1992, Oracle version 7 was released with support for integrity constraints, stored procedures and triggers. In 1997, Oracle version 8 was released with support for object-oriented development a...

In 6i -> Report6i program units, layout modules, anchors, conflex and flex modes, frames and repeated frames.

By using FND_STANDARD.SET_WHO in PRE_INSERT and PRE_UPDATE trigger, 5 who columns can be populated. But this work in Oracle Application form customization. 

In pre-insert trigger by using 'fnd_standard.who' package we can insert data into these two columns in Oracle forms.

The property used to define the relative position of one field with another is Anchor

In properties -> Record -> Distance Between Records (Default value is 0).

Irrespective of number of records, between pages trigger will fire n-1 times.

Mittal,  You are wrong.  Page between trigger  Fire only 4 times. If there is  5 pages in a report.



C.K.Ravi
3i-infotech

Opening new form and going to dept.deptno --pre-logon (form level) –post-logon (form level) –pre-form (form level) –pre-block (block level) –pre-record (block level) –pre...

 Pre-form
When-new-form
 Pre-block
 When-validate-item
 Post-block

A trigger is PL/SQL function which will fire whenever a corresponding event occures. The sequence of the triggers as follows

A trigger is PL/SQL block which will fire whenever a corresponding event occures. The sequence of the triggers are Key-Next-Item, When_validate_item, Post_item and when-new-item-instance.

Thanks,
Rahgu.

The return type for Oracle Apps report trigger is Boolean ie TRUE Or FALSE

That Will be Boolean like True or false

Oracle Forms for Microsoft Windows supports Dynamic Data Exchange(DDE), a mechanism by which applications can communicate and exchange data. DDE client support is a procedural extension to Oracle Form...

Sir can you tell me

any sites name where i can getproject in D2K

ajay singh

This trigger fires forces the cursor to be taken to the next available item or data block. 

Key-Next-item trigger will fire whenver the user try to move the control(i.e., cursor) from one item to another item in the form by pressing return key or tab key.