Interesting Metalink Note IDs

For training webcasts from Oracle Please refer
Advisor Webcasts: Current Schedule and Archived recordings [ID 740966.1]
E-Business Suite Applications Technology Group (ATG) Advisor Webcasts [ID 1186338.1]
Oracle Fusion Middleware (FMW) SOA 11g Infrastructure Database: Installation, Maintenance and Administration Guide [ID 1384379.1]

R12 Features: Concurrent output Delivery Options

Oracle EBS Version : R12.1.3

There is a new functionality that is introduced in R12 concurrent program submission. ( "Delivery Opts" )
When we submit concurrent requests we can choose to send the output of the program upon completion to a specified user. Other features include IPP Printer(Internet Printing Protocol) , Fax , FTP.
These new features enable to avoid additional coding or writing interfaces by developers to achieve the most common functionalities of ftping the output of concurrent programs to banks or sending the output to a targeted user directly into the inbox of the users etc...

The screenshots below show the usage of Email functionality. Interesting point to note is in the From Field even if we submit an email that is not present in the apps it will still send mail as that users. Example for th case below dummyR12@myspace.com does not exist in the env.

Email received : 

 

The required configurations for this mail to be sent are:

1. Ensure that SMTP server setup is done properly in "Workflow Notification Mailer" configuration

2. Ensure that Notification mailer and background engines are running properly

3. Ensure that the profile options "FND: SMTP Host" & "FND: SMTP Port" are set as per the SMTP configuration done in "Workflow Notification Mailer" Configuration step.

General Clone Issues in 11i

ERP version: Oracle R11i (11.5.10.2)

Issue:  Reports execution fails for non-standard tops / Custom tops
Symptoms:
1. Concurrent program log file shows error similar to the one shown below:

Routine FDPREP cannot read the file /oraapps/iprodappl/roi/1.0.0/reports/US/KNSINVARPIA.rep.

Check if the file exists under correct product directory.

Check if the person who started the Concurrent Manager has read privileges on the direc

Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 53810962


2. The path is pointing to a location that does not exist in the current env
3.  The files exist but at different location

Solution:
Check the adovars.env for path specified for the custom top.
It will point to the top location pointed in the error above.

Now correct the path in the file & bounce the concurrent manager if they are already running.
This will fix the issue.

Fresh Install OEM12C on Linux X86-64 (OEL 6.2)

Fresh Install OEM12C on Linux X86-64 (OEL 6.2)

12C OMS Certification Matrix

 12C OMS Certification Matrix

 Requirements:

http://docs.oracle.com/cd/E24628_01/install.121/e22624/preinstall_req_packages.htm#CHDEHHCA

Pre-Installation Tasks

1. Do not install Weblogic before installing in OEM12C. For OEM11g this is PRE-REQ.

However from OEM12C the weblogic binaries are bundled along with the installer and the installation automatically installs from the binaries.

If you install weblogic before the installation you will get the below error:

WLSTException: "Error occured while performing nmConnect : Cannot connect to Node Manager.Access to domain '<domain name>' for user 'weblogic' denied Use dumpStack() to view the full stacktrace"

The node manager port 7403 will be busy causing this error. Workaround would be to stop the existing instance of weblogic or reconfigure the existing weblogic to use a different set of ports.

2. Install database & examples

 DB Home Installation:

DB Examples installation: 

Creating Database:

Creating listener

3. Perform Post DB Install steps.

    a. remove the db console using 

emca -deconfig dbcontrol db -repos drop -SYS_PWD <sys password> -SYSMAN_PWD <sysman password>

     b. Ensure the Processes are 300 or above

Alter system set processes=300 scope=SPFILE;

     c. Ensure the session_cached_cursors parameter is 200 or above

alter system set session_cached_cursors=200 scope=SPFILE;

     d. Set the below db parameters

alter system set SGA_TARGET=2G scope=SPFILE;

alter system set shared_pool_size=600m scope=SPFILE;

alter system set pga_aggregate_target=1G scope=SPFILE;

alter system set job_queue_processes=20 scope=SPFILE;

OEM Istallation

   Install OEM application 

Ignore the warning for glibc i386 (This looks like a bug in installer.)

 Post installation steps
  1. Login and add hosts

  2. Perform Agent Installation

  3. Create startup and shutdown scripts

Startup Script

#!/bin/bash
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export OMS_HOME=/u01/app/oracle/Middleware/oms
export AGENT_HOME=/u01/app/oracle/Middleware/agent/core/12.1.0.1.0

# Start everything
$ORACLE_HOME/bin/dbstart $ORACLE_HOME

$OMS_HOME/bin/emctl start oms

$AGENT_HOME/bin/emctl start agent

Stop Script

#!/bin/bash
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export OMS_HOME=/u01/app/oracle/Middleware/oms
export AGENT_HOME=/u01/app/oracle/Middleware/agent/core/12.1.0.1.0

# Stop everything
$OMS_HOME/bin/emctl stop oms -all

$AGENT_HOME/bin/emctl stop agent

$ORACLE_HOME/bin/dbshut $ORACLE_HOME