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.

Make a Comment

Leave a Reply Cancel reply

Enter your comment here...

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

Email (required) (Address never made public)

Name (required)

Website

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

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

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

Cancel

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

sheeraz Khan
April 7, 2009

Where's The Comment Form?