ISSUE RESOLVED. THANKS TO EVERYONE THAT CONTRIBUTED.
Here is what I found, learned and ultimately what resolved the issue.
1. On the Oracle side, there are specific settings for them to use IKEv1 or IKEv2.
2. On the Checkpoint side, the settings are: Prefer IKEv2, support IKEv1, IKEv2 only, or IKEv1 for IPv4, IKEv2 for IPv6.
3. When the checkpoint side is set to IKEv1, checkpoint, from what we saw on my system, offers the Private IP of the CP firewall as the IKE ID. When the CP side is set to IKEv2, the CP side offers the Link Selection IP, which by default is usually the externally facing IP for the site unless you've changed it. When the CP side is set to Prefer IKEv2, Support IKEv1, the CP side offers both the Private IP and the Link selection IP as available IKE IDs to Oracle.
4. AWS does not seem to care what you send them as the IKE ID as long as all of the other information matches up, but ORACLE does restrict what IKE it accepts.
5. We tried IKEv2, support IKEv1 and Oracle was establishing and terminating the VPN Tunnels because their side does not have a 2 IKE ID...either or solution. They failed to tell me they were only looking at IKEv2. I changed my system to IKEv2 only, which should have forced the CP Firewall to only use the Link selection ID.
6. Working with CP TAC, CP said that I stumbled upon a software bug in R81.20 Jumbo HF 41. One of the issues of the bug was that, even when set to IKEv2, it still let the CP FW present both IKEv1 and IKEv2 as IKE IDs to Oracle, which caused Oracle to terminate the tunnel.
7. THE FIX....I upgraded the mgmt server, log server, all of the remote and HA on premise Firewalls to Jumbo Hotfix 43. Then we verified that all the tunnels were set to IKEv2. Oracle changed/verified that their side was using IKEv2 and receiving the Link Selection IP as the only IKE ID, which in our case was set to the externally facing IP address. We've been up and running with this configuration for over a week now and have not had a single issue with VPN Tunnels dropping since making the upgrade to HF43.
Hope this helps folks and thank you to everyone that chimed in. Kind of a weird one.