Sunday, July 29, 2007

Accessing Custom Forms after Upgrading To R12

I was checking customization upgrade subject since we faced it and I found this interesting note (451934.1)

The note is talking about how to make custom forms that where created and working fine on 11i to work the on R12.
And according to the note
"All custom forms that were build and working fine on releases 11i are designed and compiled using the Form Builder 6i, while the developer version for R12 is 10G.So you need to open the custom forms in Form Builder release 10G and compile them and save then upload them again."

I did not try the solution yet but thought of sharing it since many were asking bout this subject lately.
Also i found the (Custom forms does not work after upgrade to 12i) forum helpful

Sunday, July 22, 2007

How we solved a (ORA-02049 Timeout: Distributed Transaction Waiting for Lock) on our Apps Customized module

We have a customized Point of Sale module that is integrated with our Apps standard CRM and financial modules; we faced a serious issue on this customized module that is when users are trying to sale through this module they receive an ORA-02049 Timeout: Distributed Transaction Waiting for Lock, which require them to keep trying until they make the sale. This error used to show on daily basis on the peak hours only but we could not tell what the cause of it, simple search of the error on metalink return note 1018919.102 that advices that we should increases the distributed_lock_timeout value in the INIT.ORA file the default value was 60 seconds so we increased it to 300 seconds even though we don’t have any distributed transactions on the system all the transactions were local. We restart the issue and the problem became worse because now the end users have to wait for 5 minutes (300 seconds) before they receive the error message (ORA-02049) and because of that we had to set the value back to 60 seconds.

After that we tried to trace the error using different event trace levels but with no luck we were not able to determine what is causing the error.

We thought that it’s a database bug and oracle advised us to upgrade the database from to we did that but still the issue is there.

After a month of investigation/tracing and snapshot of when the problem is happing we managed to find out what was causing the problem. It was a bitmap index that was built on the table we were trying to insert data on.

When an end user was trying to sale without committing his transaction for some reason and at the same time another end user tries to sale he will receive the error message and a lock on the table happened and the error pops-up.

We solved the issue by dropping the bitmap index and creating a normal b-tree index even though the column has only three distinct values.

Monday, July 16, 2007

ATG Rollup 4 and my Custom schema

After Appling ATG Rollup 4 patch no. (4676589) on our HP-UX server successfully we start to receive the following error only on our customized schema but not on the standard schemas.
The error was showing when we try to run any procedure from this customized schema we keep getting the following even though it used to work fine before the patch
ORA-00942: table or view does not existORA-06512: at "APPS.FND_CORE_LOG", line 23ORA-06512: at "APPS.FND_CORE_LOG", line 158ORA-06512: at "APPS.FND_PROFILE", line 2468ORA-06512: at "APPS.XX_PACKAGE_PA", line 682ORA-06512: at line 4

After checking on metalink we got a hint from note 370000.1 the note dose not apply for the same case but it did gave us the hint and the solution was as follow


Support is my customized schema Custom
Have an error free day ;-)


Sunday, July 08, 2007

Issues while installing oracle redhat linux

Before a couple of days me and my friend ghassan who is also a certified apps 11i dba was doing an installation at my new p.c and while installing oracle linux on the new Intel 965 motherboard the installer freezes at " PCI: Probing PCI hardware (bus 00)" stage after checking redhat forums we found out that we need to start the installation using the following command from the command line to over come this issue
linux all-generic-ide pci=nommconf
of course that solved our issue after the installation finished and the system reboot we had to do the following the grub screen

at the grub menu. Select the kernel we want to edit, and press (e) to edit. Then move the cursor down to the "kernel" line and press (e) to edit that line. And add the all-generic-ide pci=nommconf at the kernel line.
Then press ENTER to accept the changes. And then press (b) to boot.

When the server boot successfully we had to add the all-generic-ide pci=nommconf at the /boot/grub/grub.conf file.

I guess that this issue in not only related to oracle linux but general to all redhat with this Intel motherboard (from what we saw at the redhat forums), anyway after that we did the installation for vision database and the installation went successfully but with one small issue (RW-50004) at step 2 of 5
At the log it shows (ORA-01031: insufficient privileges) this error was a typo of the oracle user group the group was ordba instated of oradba so we fixed that and the installation went successfully

Hope that helped and thank you guz for your help
P.S I got the redhat issue resolved mostly from the and some other forums

Wednesday, July 04, 2007

Thank you apps community

Today is my first day at work after the EPI-LASIK Surgery and my sight is facing haze, glare, ghosts and halos it will need more time before it become stable, I would like to take the chance to thank all apps community who wished me luck during my eye surgery, special thanks goes to hussine sawwan (hsawwan) for his phone call from Kuwait to check on me, and big thanks goes to Steven Chan for taking time to leave comment wishing me luck during the surgery. I would like also to thank marwan shantir, moh'd abu saif and adam shaug for their concerns. During my off days the most I missed was the oracle forums and the oracle blogs, I will need time to keep up with them.