Wednesday, February 28, 2007

What a mess

Today when the purchasing consultant tried to enter employees through the Purchasing Setup the following error occurs
Error message is APP-PAY-06041, you cannot enter person form because HR is fully installed.

I felt like reinstallation is coming on the way, as far as I know you cannot do unlicensed a registered products (please leave comment if you know a way to do that).
Any way after searching on metalink I found note 360552.1 and the note says that to solve this issue I have to 2 options
-we should use Human resource to enter employee not purchasing.
Or (this is the first time I like or ;-)
- using sql

update FND_PRODUCT_INSTALLATIONSset STATUS ='S' where application_id= 800;


Now every is working fine enjoy consultants

Saturday, February 24, 2007

R12 Vision is available now online

I received the following from solution beacon

"Solution beacon has installed R12 Vision instance which is now available on their website.
Check it out at

Please note that there are some steps to install the desktop plug-in differently from Release 11i. Please also note that Release 12 requires a user to enable ActiveX and download the Sun JRE instead of the JInitiator the first time the Applications are accessed."

Thank you Solution Beacon Team


Sunday, February 18, 2007

Upgrade journey to R12

Well at the beginning I though it will be a difficult task but when you get in to it, you will find out that it's kind of clear task so far ;-)

My plan was to clone my production system to a new server just for the upgrade purpose so I had to do a cloning from multi-node to single node based on note 233428.1 and of course with a great help from sam's post (Multi Node to Single Node Cloning) thank you sam.

After that I started the upgrade journey to R12 I just finished the Database upgrade path acutely I am running the utlrp.sql script while I am writing this post, every thing is clear so far.
I will keep you posted in case of any issue and incase I reach the R12 successfully or not (I hope I will).

I need to major the time needed to do the upgrade and to know if there any issues, my next step will be the upgrade to R12 on my Test servers.


Wednesday, February 14, 2007

Apps 11i with Windows vista

(just an update, As a workaround for IE on Vista issue, Apps 11.5.10 works fine on Vista with firefox)
Our network department has a plan to go with windows vista and they asked me to open a TAR with oracle to get their official response.
Below is oracle response

Summarize customer's question here. One question per heading.
Unable to connect from MS-Vista Client on e-Business suite 11.5.10
Steven's Blog
Currently Jinitiator is not certified on MS-VistaDevelepemt is working on it but we don't have any ETA for it So, please don't upgrade to MS-Vista Sorry for that
Platform / Port Specific? = Not certified for the moment

Thursday, February 08, 2007

Cloning after Appling Patch 4676589 ATG_PF.RUP 4

If you applied the ATG_PF.RUP 4 patch you will face the following error when running the perl command
perl dbTier or appsTier

Global symbol "$resultclone" requires explicit package name at
line 525.
syntax error at line 527, near "$resultclone !"
syntax error at line 530, near "}"
Execution of aborted due to compilation errors

There are 2 solutions to this error:
-applying one of the patches (5132155,5225940,5235401).
- You can make the following changes in the file 115.49, replace the following and retest the issue.

$resultclone = system "$syscmd";
# added for bug #4448838
if($resultclone ! = 0 )


my $resultclone = system "$syscmd";
# added for bug #4448838
if($resultclone != 0 )

enjoy cloning

Sunday, February 04, 2007

Journey of a Thousand Miles

I was reading Steven's article Journey of a Thousand Miles, I liked the article and I am quoting from it the following:-

"In the blogosphere, it's not uncommon to see blogs die after a few postings. That's unsurprising. Writing meaningless blather is easy, but writing well is hard. No one's going to expend valuable time in blogging without feedback, and I'm no exception. So, your comments will be vital in keeping this blog fresh and alive. I look forward to hearing from you."

And I would like to tell you the same; I look forward to hear form you, so please leave your comments.

Finally, Oracle is not Magic, it just takes years of experience ;-)

Thursday, February 01, 2007

1Z1-233 Beta Exam 11i Install Patch and Maintain Oracle Applications Ed 5.1

Two days ago I applied the 11i Install Patch and Maintain Oracle Applications Ed 5.1 beta exam, the exam had 153 questions within 3 hours time, some of the questions was an easy going and a little of them were mid/difficult but in general it was an easy going exam, I think I will pass, I will know the results after 10 weeks and I will update you, the exam cover every thing from rapiwiz, cloning, adadmin, admerg, logs, autoconfig, xml file, CM …etc every thing really. But I liked the exam I will prepare for the sysadmin production exam soon.

i think all apps dba should apply it when they have some time (when they are not appling patchs;-)

Have fun with oracle exams