Workflow mailer configuration 11i/R12

It works on 11i and R12.

ABDUL Mailler Config

Hexaware Apps DBA Interview Questions (2+ exprienced) Part -1

What is Symbolic Links?

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

A symbolic link is a special file type which points to another file. The
contents of this special file is the name of the file that it points to.
Symbolic links are created by the ln -s command.

Once a file which is pointed to by a symbolic link is deleted, the link still
points to it, leaving a hanging link.

You can use the find command to locate symbolic links:

find ./* -type l -ls

Examples:
---------
Consider a file 'example' to which there is a hard link 'hlink' and a symbolic
link 'slink'.

Check the contents of the directory for the file 'example':

% ls -li
427222 -rw-r--r-- 2 osupport dba 50 Oct 23 11:35 example

-----------------------------------------------------------------------
what is FRM-3000 ?

When it will come ?

How to overcome this FRM-3000 ?
----------

Take the following steps to help you troubleshoot REP-3000 errors:

1. First, test the integrity of DISPLAY by issuing "xclock" command.
- Login to the machine where Reports Server is installed.
- From the UNIX command prompt, set the DISPLAY to a valid
X Windows session:
setenv DISPLAY :0.0
- Ensure that DISPLAY was set correctly:
echo $DISPLAY
- Type command "xclock"
If you see a clock come up, then the DISPLAY is set correctly.
If you do not see the clock, then DISPLAY is not set to an active Xterm.

You must have xclock working before running any reports.

Another way to test whether an X server is running on given machine
and you have permissions to connect to it, you can use the following command:

xterm -display :0.0

If you do not have permissions to access the display or if there is no
such display running on the given machine, an error similar to the
following is displayed:

Xlib: connection to ":0.0" refused by server
Xlib: Client is not authorized to connect to Server
xterm Xt error: Can't open display: :0.0

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

2. If the error occurs when running report on the Web, then you need
to first test it using Reports Runtime on the machine where your Reports
Server is running. Steps:
- Set DISPLAY to a valid X Windows session
- Run report using sample syntax:
rwrun60 report=test.rdf userid=username/password@db destype=file desname=test.html desformat=html batch=yes

If rwrun60 works, go to step 3.
If rwrun60 does not work, then:
- Re-check your DISPLAY environment variable
- Go back to step 1 and test the integrity of DISPLAY
- Review Section VI (below) to see if any of the scenarios
match your situation.
- If nothing else works, then try to relink Oracle Reports executables.
See Note:154512.1 for details.
----------------------------------------------

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

How to check the Concurrent request's ?
From which table we can find the concurrent request informations ?

FND_NODES

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


FND_CONCURRENT_REQUESTS
This table contains a complete history of all concurrent requests.

FND_RUN_REQUESTS
When a user submits a report set, this table stores information about the reports in the report set and the parameter values for each report.

FND_CONC_REQUEST_ARGUMENTS
This table records arguments passed by the concurrent manager to each program it starts running.

FND_DUAL
This table records when requests do not update database tables.

FND_CONCURRENT_PROCESSES
This table records information about Oracle Applications and operating system processes.

FND_CONC_STAT_LIST
This table collects runtime performance statistics for concurrent requests.

FND_CONC_STAT_SUMMARY
This table contains the concurrent program performance statistics generated by the Purge Concurrent Request and/or Manager Data program.
The Purge Concurrent Request and/or Manager Data program uses the data in FND_CONC_STAT_LIST to compute these statistics.


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

What is Single Sign-On Server (SSO) ?

As name says Single-Sign On Server is set of services (Software) which enables login to Application once which will allow you to login to partner
Applications with no need to login again. Lets assume I have configured single SSO Server for Portal , E-Business Suite,
Collaboration Suite plus some other other applications, Now if I login to any one of them & after that if I wish to login to other applications
I should be able to login without supplying passwords again.



*** Refered from various Blogs and Sites ****

Exporting PATH setting

We have lot of confusion while we patching for upgradation process.

here i am giving some examples which i faced in my forms upgradation patchset19..

This is the normal path of $ORACLE_HOME in 11i
echo $ORACLE_HOME
/ebiz/testappl/testora/8.0.6


as per the need of upgradation we have to set this path to iAS server..

export ORACLE_HOME=/ebiz/testappl/testora/iAS/6iserver

Now you can check the exported path using Echo command.

echo $ORACLE_HOME
/ebiz/testappl/testora/iAS/6iserver


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

Like wise if we have to add iAS path in $PATH

echo $PATH
/ebiz/testappl/testora/iAS/Apache/perl/bin:/ebiz/testappl/testora/8.0.6/bin:
/ebiz/testappl/testappl/fnd/11.5.0/bin:/ebiz/testappl/testappl/ad/11.5.0/bin:
/ebiz/testappl/testcomn/util/java/1.4/j2sdk1.4.2_04/bin:
/ebiz/testappl/testcomn/util/unzip/unzip/unzip-5.50::
/ebiz/testappl/testora/8.0.6/bin:/usr/bin:/usr/ccs/bin:
/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:
/usr/X11R6/bin:/ebiz/testappl/bin

export PATH=$PATH:/ebiz/testappl/testora/iAS/6iserver/bin

echo $PATH
/ebiz/testappl/testora/iAS/Apache/perl/bin:/ebiz/testappl/testora/8.0.6/bin:
/ebiz/testappl/testappl/fnd/11.5.0/bin:/ebiz/testappl/testappl/ad/11.5.0/bin:
/ebiz/testappl/testcomn/util/java/1.4/j2sdk1.4.2_04/bin:
/ebiz/testappl/testcomn/util/unzip/unzip/unzip-5.50::
/ebiz/testappl/testora/8.0.6/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:
/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:
/ebiz/testappl/bin:/ebiz/testappl/testora/iAS/6iserver/bin


**in the above echo we can see the exported path

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

echo $LD_LIBRARY_PATH
/ebiz/testappl/testora/8.0.6/network/jre11/lib/i686/native_threads:
/ebiz/testappl/testora/8.0.6/network/jre11/lib/linux/native_threads:
/ebiz/testappl/testappl/cz/11.5.0/bin:/ebiz/testappl/testora/8.0.6/lib:
/usr/X11R6/lib:/usr/openwin/lib


export

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/ebiz/testappl/testora/iAS/6iserver

/lib


echo $LD_LIBRARY_PATH
/ebiz/testappl/testora/8.0.6/network/jre11/lib/i686/native_threads:
/ebiz/testappl/testora/8.0.6/network/jre11/lib/linux/native_threads:
/ebiz/testappl/testappl/cz/11.5.0/bin:/ebiz/testappl/testora/8.0.6/lib:
/usr/X11R6/lib:/usr/openwin/lib:[testappl@vmware:
/ebiz/testappl/testora/iAS/6iserver/lib



**in the above echo we can see the exported path


-----------------------------------------------------
Very important note is :

* This Export wont reflect in any other section
** Its just like a temporary setting if you use this in Putty.
*** After export we have to continue our task in the same window.

OBIEE 11g

Dear Friends this is my three months old Document for OBIEE 11g.
Installation Document of OBIEE 11g for Scriber

Custom Top - 2

Custom Top in Oracle Application - Creation & Registering

Kindly follow the previous post

STEP 11

Register your Oracle Schema

Login to Applications with System Administrator responsibility
Navigate to
Application–>Register

STEP 12

Register Oracle User

Naviate to
Security-->Oracle-->Register

STEP 13

Add Application to a Data Group
Navigate to
Security-->Oracle-->DataGroup

STEP 14

Create custom request group
This will act as a placeholder for any custom reports we wish to make available for the Custom Responsibility (which is defined at a later stage)
Navigate to

Security-->responsbility-->Request

STEP 15

Create custom menu
This will act as a placeholder for any menu items we wish to make available for the Custom Responsibility (which is defined at a later stage) We will create two menus, one for Core Applications and one for Self Service.
Navigate to

Application-->Menu

STEP 16

This is the CUSTOM_TOP we created in the above 15 steps.







All the best Flocks...

Custom Top - 1

Custom Top in Oracle Application - Creation & Registering

STEP 1

Created the directory structure for your custom application files under $APPL_TOP/abdul

$cd $APPL_TOP

$ mkdir abdul

$ mkdir abdul/11.5.0

$ mkdir abdul/11.5.0/admin

$ mkdir abdul/11.5.0/admin/sql

$ mkdir abdul/11.5.0/admin/odf

$ mkdir abdul/11.5.0/sql

$ mkdir abdul/11.5.0/bin

$ mkdir abdul/11.5.0/reports

$ mkdir abdul/11.5.0/reports/US

$ mkdir abdul/11.5.0/forms

$ mkdir abdul/11.5.0/forms/US

$ mkdir abdul/11.5.0/log

$ mkdir abdul/11.5.0/out

$ mkdir abdul/11.5.0/$APPLLIB

$ mkdir abdul/11.5.0/$APPLOUT

STEP 2

Added entry ABDUL_TOP=/ebiz/testappl/testappl/abdul in Enviornment file custom_TEST_vmware.env

ABDUL_TOP=/ebiz/testappl/testappl/abdul

export ABDUL_TOP

STEP 3

Then Run "custom_TEST_vmware.env",

./custom_TEST_vmware.env

STEP 4

Then Run "APPSORA.env"

./APPSORA.env

STEP 5

Finally Run the Oracle Manager's bash profile,

.bash_profile

STEP 6

Now Check for "ABDUL" top

$cd $ABDUL_TOP

$pwd

/ebiz/testappl/testappl/abdul

STEP 7

Create datafile (.dbf) from the new customized top in database

Connect to database manager

connect into sys user.

create tablespace and datafile for ABDUL_TOP

STEP 8

SQL> create tablespace abdul datafile '/ebiz/testora/testdata/abduldbf' size 10M;

Tablespace created.

STEP 9

Create Schema (USER) and Grant connect,resource to the USER.

SQL> create user abdul identified by abdul default tablespace abdul temporary tablespace temp quota unlimited on abdul;

User created.

STEP 10

SQL> grant connect,resource to abdul;

Grant succeeded.