.

.

Create Child Block

Repeat the process of creating the database block using block wizard based on

test_child_table. Beside the other screens you will have to create join at following screen

Click on create relationship button and you will see following screen.

Click ok and you will see following screen the details of the join between two database blocks.

Click Next and complete the process of the creation of block and items through layout Wizard.

Open the layout editor for the canvas and you will see following screen.

Following relation will get created between database blocks.

Check the properties of the created relation

Compile the form and register it in oracle applications. You can see the following screen

when you open the form in oracle applications.

Frequently Asked Questions

1. How do you compile a form on unix box?

2. Is it necessary to compile the form in $AU_TOP/forms/US?

3. Is it necessary to use apps user id while compiling the forms?

4. What is the prerequisite to create master-detail block?

5. What is the significance of the delete record behavior in the relation?

First Page: Creation of Master Detail Block in Oracle Apps 11i