Deloitte Interview Questions for vishal and sedhu

1.HAVE YOU DEVELOPED ANY CUSTOM FORM?

Yes i have developed more than 10 custom forms for ti cycles using form builder 6i.

2.HOW DO YOU CREATE A CUSTOM FORM?

1. Download the template.fmb from resource folder.
2. Delete the data block,canvas,windows.
3. save the fmb.
4. In that form module property we have the changed first navigation block.
5. move the fmb into au top.

3.FORM REGISTRATION STEPS

1. compile the fmb using syntax:
frmcmp_batch module=form_name.fmb module_type=FORM userid=apps/apps output_file=oracle/appl/po/form_name.fmx
batch=yes compile_all=yes
2. Register the form into Oracle Apps.Application developer.
-> create a form.
-> create a function for form.
-> create a menu for form.
3. finally we can see the form in our Purchasing responsibility.

4.WHAT IS THE FIRING ORDER OF THE TRIGGERS IN FORMS?
form lever --> block lever --> item lever.

5.WHAT ARE THE TYPES OF RELATION IN MASTER-DETAIL FORM RELATIONSHIP?
1.Cascading.
2.Isolated.
3.Non isolated.

6.LET US CONSIDER THERE IS A DATABLOCK CONTAINS A NON-DATABASE ITEM AND A BUTTON.
WHEN THE BUTTON IS PRESSED HOW WOULD YOU BRING THE DATA TO THE FIELD?

Using when_button_pressed trigger we should mention the specified block name.non_database_item_field name.

7.DIFFERENCE BETWEEN KEYNEXTVAL AND WHEN-VALIDATE-ITEM?

1. Keynextval fires before the when_valildate_item.
2. Keynextval fire everytime when u move the next item.
3. Validate_fires when to make changes to text item after the execution of validate item.


8.XML REPORT REGISTRATION STEPS?



9.DIFFERENCE BETWEEN FUNCTION AND PROCEDURE.

--> A function should return a value.

--> A procedure may or may not return a value.

10.WHAT IS MEAN MY AUTONOMOUS_TRANSACTION?


It is a independent transaction. It is used by pl/sql block within the sql statements committing transactions.


11.DIFFERENCE BETWEEN TRUNC AND DELETE.

1. We can use where clause with delete but not with trunc.
2. delete we have to use the trigger. Trunc we cannt use the trigger.
3. Delete is dml command. Trunc is ddl command.
4. cannot rollback the truncate, can rollback the delete datas.
5. Truncate is faster then delete.


12.WHAT ARE THE MODULES YOU HAVE WORKED?

PO,ONT,AP,AR,HRMS,GL.

13.WHAT ARE THE TRANSACTIONS YOU KNOW IN AR MODULE?

credit memo,Invoice

14.WHAT IS MEAN BY CREDIT MEMO?

15.IN A REPORT,I WANT TO PRINT ONLY 5 RECORDS PER PAGE.

In repeating frame property we have the option maximum records per page.

16.TYPES OF DATABASE TRIGGERS.

before,after,insert,update,delete,before row level,after row level.





vishal questions:
-----------------
1) WHAT ARE THE PROBLEMS FACED BY YOU DURING REPORT MIGRATION.

2) WHAT ARE THE DIFFERENT TYPE OF DATA BLOCKS .

1.DATA block 2.control block

3) WHAT ARE THE DIFFERENT BUTTON TRIGGERS AVALIABLE?
4) WHAT ARE THE DIFFERENT REPORT TRIGGER AVAILABLE.
5) WHAT ARE THE DIFFERENT FLOWS AVALABLE IN AR.
6) WHAT ARE THE TABLES AVAILABLE IN AR.
7) HOW TO CREATE A CREDIT MEMO.
8) HAVE YOU DONE GL INTERFACE
9) WHAT ARE THE TRIGGERS IN FORM PERSONALIZATION.
10) DIFFERENCE BETWEEN PRE TEXT ITEM AND POST TEXT ITEM.
11) HOW TO CREATE AN INVOICE IN AP AND POST IT TO GL.
12) WHAT ARE THE DIFFERENT TYPES OF INVOICES IN AR AND HOW TO CREATE
THEM.