OAuth 2.0 workflow setup

 Oracle Note: 

Configuring Oracle Workflow for OAuth 2.0 in Oracle E-Business Suite Release 12.2 and Release 12.1.3 (Doc ID 2884072.1)

Java api patch - 31042881	cd $FMW_HOME/utils/bsu/cache_dir/ cp -rp /applprd/software/OAuth/p31042881_1036_Generic.zip . unzip -o p31042881_1036_Generic.zip . Archive:  p31042881_1036_Generic.zip   inflating: README.txt   inflating: patch-catalog_27104.xml   inflating: 7BIA.jar cd $FMW_HOME/utils/bsu ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir/ -patchlist=7BIA -prod_dir=$FMW_HOME/wlserver_10.3 -verbose
OAuth2.0 - 34423621	time adop phase=apply patches=34423621 wait_on_failed_job=yes patchtop=/applprd/software/OAuth apply_mode=downtime
OAuth2.0 - 34565205	time adop phase=apply patches=34565205 wait_on_failed_job=yes patchtop=/applprd/software/OAuth apply_mode=downtime
JDK Upgrade

Selfsign certificate created at our end server level

 

keytool -genkeypair -alias ms -keyalg "RSA" -keysize "2048" -dname "cn=app1.domain.com, ou=OH, o=Oihotels, c=US" -storetype "PKCS12" -keystore ms.p12 -storepass "password" -validity 1095

keytool -exportcert -alias ms -keystore ms.p12 -storepass "password" -file ms.cer -storetype "PKCS12"

Send Certificate details to Azure team to register.

Azure team, they will register and provide us following details for workflow configuration

Clientid

Tenant id

Access token

 

 

Once we get confirmation from Azure Team,

We need to configure workflow with certificate details.

once you configure the workflow, to validate the configuration details

execute the following command

$AFJVAPRG -classpath .:$AF_CLASSPATH OAuthIMAPTest
<user> <inboundOAuthClientID> <inboundOAuthAccessTokenURL>
<inboundOAuthScope> <privateKeyFileID> <publicKeyFileID> <privateKeyPwd>
<dbc_file> MicrosoftOffice365ExchangeOnline > /tmp/OAuth_Imap.out

To get privatekey and publickey details

col FILE_ID for 00000000

col FILE_NAME for a15

select file_id,file_name,upload_date  from fnd_lobs where file_name like 'ms%';

 FILE_ID FILE_NAME       UPLOAD_DATE

--------- --------------- ------------------

 0100036 ms.cer          11-DEC-22   === Public

 0100035 ms.p12          11-DEC-22  ===Private