In this tutorial, I demonstrate the complete process of creating bills in Oracle APEX — starting from customer creation, then agreement creation, and finally generating bills with built-in duplicate check and skip logic.
You’ll learn how to:
----------------
Create customers and agreements in Oracle APEX
Set up page items, date fields, and save button actions
Write PL/SQL code to insert bills into the bill table
Add validation to skip agreements that already have bills for the same month
Show success messages with counts of created and skipped bills
Test the process with real data step-by-step
Source Code:
https://github.com/benqmamun/property-management/blob/main/Tutorial-9
