Customize Master–Detail Form – Oracle APEX

  1. Objective 

To define the process for creating and customizing a Master–Detail Form in Oracle APEX, including manual handling of parent–child relationships and primary key mapping using custom processes. 

2. Scope 

This SOP applies to all APEX applications where: 

  • A custom Master–Detail relationship is required  

  • Default APEX processing is overridden  

  • Manual handling of Primary Key and Foreign Key mapping is implemented  

  • Editable detail regions (Interactive Grid/Form) are used  

3. Prerequisites 

3.1 Oracle APEX Requirements 

  • Access to Oracle APEX (Developer role)  

  • Basic knowledge of Page Designer  

  • Understanding of Master–Detail architecture  

3.2 Database Requirements 

Parent Table (Master) 

Column Name 

Description 

MASTER_ID (PK) 

Primary Key 

Other columns 

Business data 

Child Table (Detail) 

Column Name 

Description 

CHILD_ID (PK) 

Primary Key 

MASTER_ID (FK) 

Foreign Key reference 

Other columns 

Business data 

 


4. Procedure 

Step 1: Create Parent Table 

  • Create a Master table with Primary Key  

  • Example: MASTER_ID  

Step 2: Create Child Table 

  • Create a Detail table  

  • Include:  

  • Primary Key (CHILD_ID)  

  • Foreign Key (MASTER_ID) 

Step3: Map Static Id =Primary key of child table


Step4: Create Process for Primary Key mapping 

Process 1:

 


Step5: Select editable region in page designer 


 


 

Process 2: 


 


 

 

Comments

Popular posts from this blog

Implementing Authentication and Authorization in Oracle APEX

Mastering Shared Components in Oracle APEX

Designing a Scalable Database Architecture for Oracle APEX Applications