#OracleAPEX #JavaScript #ERP #APEX #oracleace #oracleapex
In this video, I’ll show you how to create a Payment Form for the Property Management System using Oracle APEX — step by step.
You’ll learn how to make the form fully dynamic, user-friendly, and automated with triggers, LOVs, and dynamic actions.
What You’ll Learn:
---------------------------------------
Creating a new Payment Form in Oracle APEX
Auto-generating Payment ID using a database trigger
Setting up Customer & Agreement relationship with popup LOV
Displaying Agreement Amount automatically on selection
Conditional visibility for fields (e.g., Payment Reference for non-cash payments)
Adding default values for Payment Method and Currency
Making the form more intuitive and professional
Source Code
-------------------------
https://github.com/benqmamun/property-management/blob/main/Tutorial-12