DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, October 16, 2019

Oracle Critical Patch Update for October 2019



Oracle has released the Critical Patch Update for October 2019. Please refer to below link . DB and EBS Patch do available.

 

Tuesday, October 15, 2019

Open Ebiz R12 in Google Chrome

Scenario:

In order to open oracle e-business in google chrome, there is an option of installing the IE Tab Extension in chrome.


Installation of IE Tab Extension for Google Chrome.

Step 1 : Open Google Chrome Browser.
Step 2 : Check IE Extension is present .
Step 3 : Download IE Tab Extension.
Step 4 : Install the IE Tab Extension in google chrome.
Step 5 : Allow the url in IE Tab extensions using settings.
Step 6 : Now verify Oracle is working in IE Tab in Chrome.

1.  Open Google Chrome Browser.





1 2.       Check IE Extension is present .
-          Navigate to Settings - > Extension . By default it wont be there.



3.       Download IE Tab Extension.

-          Type in IE Tab for Chrome from the Chrome Browser, or copy and paste the following URL in the browser.
-          You will be navigated to the following page where we can see Add to chrome Tab as highlighted.

-          Click on Add Extension

4.       Install the IE Tab Extension in google chrome.
 If required  for first time run the installer. Once done close the Chrome browser and open a new window, You will find the tab for IE like below 



5.       Allow the url in IE Tab extensions using settings.
-          Navigate to setting -> Extensions

-          By default the below mentioned 2 options will be disabled, Just enable as shown below.

6.       Now verify Oracle is working in IE Tab in Chrome.

-          Now Open new Chrome browser and enter the oracle url 





WF Mailer Not able to start with the following error : FRAMEWORK_USER=Unable to make a connection with the user and responsibility

Scenario:

I was trying to restart the WF Container using the following Navigation in 12.1.3

Oracle Application Manager -> Workflow ->Service Components ->Workflow Notification Mailer

When we go inside the container and restarts it failed and shows the following error when we click on the Workflow Notification Mailer.


Error :

Could not handle the control event -> oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not start component; performing rollback -> oracle.apps.fnd.cp.gsc.SvcComponentException: Validation failed for the following parameters -> {FRAMEWORK_USER=Unable to make a connection with the user and responsibility}. Parameters were -> {RESET_NLS=N, FROM=Workflow Mailer Production, INBOUND_MAX_RET_EMAIL_SIZE=100, CANCELED=WFMAIL:CANCELED, SEND_UNSOLICITED_WARNING

Solution:

The Error indicates connectivity problem, and the notification mailer will attempt to make a connection as SYSADMIN with the system administrator responsibility. So verify the following:
1. SYSADMIN userid is active and the responsibility System Administrator is Active.
2. Also check whether sysadmin has the default value by :

select * from fnd_user_a  where USER_ID='0' order by 1 desc;

In my case SYSADMIN user was end dated by mistake. Because of that it fails to start the WF mailer. So we removed the enddate and tried restarting and it worked.


Reference:

Workflow Mailer Is Not Coming Up And Agent Listeners In Unavailable State FRAMEWORK_USER=Unable to make a connection with the user and responsibility (Doc ID 2448179.1)

Friday, October 11, 2019

Oracle Open World 2019 presentations are now available for download


Team,

Using below link , you can download Oracle Open World 2019 presentations. Please make use of them and share with your team/friends/colleagues.


 


Cheers,
Narasimharao Karanam
#OOW19 #Oracle #oraclecloud #openworld #presentations

Wednesday, October 9, 2019

How to deploy Oracle EBS Cloud Manager from Market Place?


The Main agenda for this post is to demonstrate basic steps to deploy Oracle EBS Cloud Manager from Market Place.

Pre-requirement:  Have Oracle Cloud account login, and Have basic understanding of oracle cloud networking and compartment.

  1. Login to oracle cloud account.
  2. Through Navigator Menu,  Select Market Place.
  3. Select the  version of Cloud Manager, select the compartment, review and agree to the terms and restrictions , and finally click on launch instance.
  4.  Page will get directed to page to create compute instance. provide required instance name and ssh key 
  5. it will get provisioned in Oracle cloud infrastructure , click on "View Usage Instructions".