I had to use oracle UTL_HTTP to access HTTPS site. The site uses diacritical letters (öäüõ) in certificate organization name. This site was https://ariregister.rik.ee/ where subject was CN = *.rik.ee O = Registrite ja infosüsteemide Keskus L = Tallinn C = EE Typically I have added all certificates in path as trusted root certs into oracle wallet. In this case, there were three certificates on path: So I exported those as: *.rik.ee to arireg1.cer DigiCert SHA2 High Assurance Server CA to arireg2.cer DigiCert High Assurance EV Root CA to arireg3.cer And imported them to oracle wallet: orapki wallet add -wallet /u01/app/oracle/admin/MYSID/xdb_wallet/ -trusted_cert -cert "/tmp/arireg1.cer" -pwd XXXXXX orapki wallet add -wallet /u01/app/oracle/admin/MYSID/xdb_wallet/ -trusted_cert -cert "/tmp/arireg2.cer" -pwd XXXXXX orapki wallet add -wallet /u01/app/oracle/admin/MYSID/xdb_wallet/ -trusted_cert -cert "/tmp/arireg3.cer" -pwd XXXXXX Usi
I have two APEX applications (102 and 105) that use the same layout and design. Currently each application has its own theme and templates, which needed to be updated in parallel. Today I needed to create a third application with the same design. Therefore I studied how to make my theme and templates reusable. At first, it struck me that there is option to create Workspace Theme. So I created one, based on my application 102 theme. Intentionally set the Subscribe Theme to NO because I wanted to switch both of my applications to use the workspace theme. After that I discovered that it is impossible to edit Workspace theme templates directly ( need to create application using the workspace theme to edit templates ). Secondly I decided to create Master Theme Application that holds the shared theme templates. Copied theme from existing application 102. And created Workspace Theme based on Master Theme application theme with Subscribe Theme set to YES. It all went smoothly until I