Oracle APEX on AWS Oracle RDS requires the APEX HTTP Listener to be installed on an EC2 Instance. It also requires the that the Oracle RDS instance is setup to run APEX. This is done by adding an APEX XMLDB option group to the Oracle RDS Instance. Details can be found here:
Currently, AWS Oracle RDS supports APEX 4.11.