how to send output of concurrent program through email
With R12.1.3, we can configure delivery option while submitting concurrent request.Delivery options could be the mail of the user which submitted the request. So user will get notified on completion of request
Following need to be set to enable delivery option
Set the profile options “FND:SMTP Host” and “FND:SMTP Port” by providing the right values
a. Log into System Administrator responsibility.
b. Navigate to Profile – System.
c. Query up the %SMTP% profiles.
d. Set the following profile values to the defined host and port:FND:SMTP Host
FND:SMTP Host = mail..com
FND:SMTP Port = 25
Mechanism used to send the Delivery Option
The concurrent request on completion connect with OPP(Output Post Processor) for sending the mail to the user.So we must increase the processes in OPP if your organisation is going to use the delivery option widely
Concurrent Manager Queries :This article contains awesome top 30 Concurrent Manager Queries for Concurrent Manager troubleshooting ,resolution ,run time, details
ORA-01427 :Check out this for the solution on ORA-01427: single-row subquery returns more than one row error ,how to resolve it when it happens with Concurrent Manager
request set in oracle apps : Request set gives the capability to submit the same set of requests regularly using a single transaction.
Concurrent Manager Interview questions ::Check out 24 Concurrent Manager Interview questions to help you in EBS interview. This consists of all sort of question on standard manager,service manager
Parallel Concurrent Processing :What is PCP, How to setup it, how to define internal monitor
Oracle Concurrent Manager :How an E-Business Suite Concurrent Manager Process Works,Oracle Concurrent Manager,What is internal monitor,What is service manager and troubleshooting
Output post Processor :Post on Output post Processor(OPP) of Oracle apps. How it works and what are the parameter and what general issues are faced
The following are some of the recommended course you can buy if you want to get a step further
Given below are the links of some of the courses
Oracle DBA 11g/12c – Database Administration for Junior DBA : This course is good for the people who are starting as Junior DBA or aspire to be Oracle DBA. This will provide good understanding on backup & recovery and General administration tasks
Oracle Database Administration Workshop ( 12c and Higher) : This course covers installation, Creating PDB, queries on Architecture.This is good course for Oracle DBA beginners and a good startup for Multi tenancy with Oracle 12c
AWS RDS for DBAs : This course covers basics of Cloud computing, Basics of Oracle Database Cloud, AWS RDS, AWS RDS Administration. You must take if you plan to work on AWS
Oracle Database: Oracle 12C R2 RAC Administration : This course covers installation, administration of Oracle RAC. A good course for Oracle DBA who want to upgrade his skills for Oracle RAC
Oracle Data Guard: Database Administration for Oracle 12C R2 :This course covers installation, administration of Oracle Dataguard. A good course for Oracle DBA who want to upgrade his skills for Oracle Dataguard