Skip to main content
Question

SSL communication between DB and MWS

  • August 3, 2021
  • 6 replies
  • 160 views

Forum|alt.badge.img+6

Hi,

 

In IFS APPs 10, the communication between the DB and MWS is not encrypted. The encrypted traffic only for the communication between MWS and end users through a SSL certificate. Please confirm.

 

Thank you.

This topic has been closed for replies.

6 replies

Forum|alt.badge.img+14

Forum|alt.badge.img+6
  • Author
  • Do Gooder (Partner)
  • August 3, 2021

Thank you Chamath. In simple terms, the communication between the DB and MWS is encrypted right?

 

 


Forum|alt.badge.img+14

Hi @PlaSandaM,

 

APPS10 UPD4 or older versions/APPS MWS → DB communication was done by PLSQL Access Provider. So for that we can put SSL as mentioned in above informed link. But if you are looking for later version I cannot guarantee that because latest versions use “JMS/AQ (Oracle Advance Queue)” for communications between MWS→ DB.

Thank You,

 


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Partner)
  • August 3, 2021

Thank you Chamath. So we don’t know that the traffic between the DB and MWS is encrypted or not after UPD4?

 


durette
Superhero (Customer)
Forum|alt.badge.img+19
  • Superhero (Customer)
  • August 3, 2021

Hi @PlaSandaM,

 

APPS10 UPD4 or older versions/APPS MWS → DB communication was done by PLSQL Access Provider.

 

I can only speak from my experience with Apps 9.

The PL/SQL Access Provider reaches upward, from the database to the application, to make web service calls originating from the database code. This gets encrypted via HTTPS if the application is set up that way. An Oracle wallet will need to be properly set up on the database so the database can trust the application.

The usual method of communication is talking downward, from the application to the database, via Oracle SQL*Net. Oracle supports encryption over this protocol, but I’ve never done this. I do know it’s configured in SQLNET.ORA.


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Partner)
  • August 3, 2021

Hi Durette, Thank you very much for your response.