Oracle R12 Reports are failing with Rep 3000 error on IBM AIX

Posted on March 24, 2009. Filed under: Uncategorized |

Issue :
In R12 on IBM AIX Reports are failing with Rep 3000 error

Description:
We all know that there is no concept of Display for generating reports in R12, there is…..:) but only on IBM AIX.
We need to set the display in IBM AIX for R12 to generate the reports output without error.

Solution ;

a) Go to CM(Admin) Node
b) Login in as Application User
c) Find the display from CONTEXT_FILE

Ex :
-bash-3.2$ grep -i display $CONTEXT_FILE
oratestdev:0.0

Here the display is 0.0

d) export DISPLAY=localhost:0.0
e) /usr/lpp/X11/bin/xinit /usr/lpp/X11/bin/mwm — :0 -vfb -force -x abx -x dbe -x GLX &
f) xhost +
g) Login as root
h) export DISPLAY=localhost:0.0
i) xhost +

Thanks,
Sam.

Advertisements

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

One Response to “Oracle R12 Reports are failing with Rep 3000 error on IBM AIX”

RSS Feed for OraclePitStop – Lets share some knowledge Comments RSS Feed

Thanks Sam
You did a terrific job putting this in blog. It did help and solved the AIX report display error REP- 3000. Earlier I had display setting but not configured properly.

Thanks again


Where's The Comment Form?

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: