EBS Customizations (MOSC)

MOSC Banner

How to decrypt encrypted password?


Customer have a requirement where in we are reading email attchment from Inbox present on the IMAP server.
In order to connect IMAP store, I need to pass server name , user name and password as given below.
store.connect(SERVER_NAME,USER_NAME,PASSWORD);

I am trying to get Mail Server password from database using below mentioned queries:

SQL> select parameter_id,parameter_name
 2 from apps.fnd_svc_comp_params_b
 3 where parameter_name=<PARAM_NAME>

SQL> select PARAMETER_VALUE from apps.fnd_svc_comp_param_vals
 2 where PARAMETER_ID=<ID_VALUE>;

PARAMETER_VALUE
--------------------------------------------------------------------------------
Encrypted_Password

But its output gives me encrypted password like above.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center