FormsLauncher.cLass not found

Hi Guys

Many times we connect to   our company’s application instance  using our personal laptops. Most companies only permit connections  to their  network using a VPN conncetion. I had never faced any problem in the past. However  with my latest client I was not able to access the forms ,even though I was able to acess all the html applications  like iReceivables / Collections HTML Manager  etc. The error I received was  that Formslauncher. class not found.

I had referred to the metalink and seen the  problem / Howto pages on this. All of them   did not  solve my problem. Ultimately  I found a solution myself after some trial and error. I removed  all the JRE /JDK from my system.  Then I made a connection to the URL  using the VPN. It then downloaded the JRE and it worked fine.

I spent a couple of  hours on this. So guys you save your time  using this post. Pl note that this is  for accessing the application using a VPN connection.

Thanks

Kumar

Oracle Applications Opens the exported file with a notepad.

Hi

Many times users compain that Oracle applications opens the exported data with notepad instead of Excel.  Important point to note here is that it is  the Windows which opens the file with notepad instead of Excel. Oracle Exports the data as a  tab separated value file (with .tsv extension) which is very useful format. However windows does not  associate this type of file with an excel  application. So you need to set up the  file association for this to work correctly.

My previous post addresses this issue.  I made this into two different posts because for some users the file export  does not work and for others  the export  works, but the file is opened by a notepad/wordpad.  Both the issues are addressed in my previous post.

THanks

Kumar

Unable to Export from Oracle Applications

Hi

Many times  your application users come with a request  that they are not able to export data from Oracle applications. They complain that it does nothing or sometimes a window opened and did something ,but they do not know where the file is saved to.

For many business users it is essential to export the data into and amnipulate it in Excel. So  this is a much needed functionality. There are a couple of things we need to see. The doc explains every thing.

Hope this is useful

Kumar

unable-to-export-from-oracle-applications

Oracle Financials Release 12 Installation on Netbooks

Hi Guys

I was able to install Oracle Financials Release 12 on Netbooks. However I made a few configuration changes to get the most out of my system.

I will describe the steps here. I purchased an  ASUS eePc Netbooks for 349$ with a 5 hr battery back up time. This has Windows Xp on it.It has  a 160 GB hard disk and 1 GB ram which I definitely wanted to upgrade. So  I purchased a 2GB Ram and a 320 GB internal hard drive.

Used Norton Ghost to create  a back up disk  of my 160 gb disk. So my 320 gb disk became a back  up disk for my original 160 gb disk.

I slipped this 320 gb disk and 2gb ram into my netbook. I also purchased a 8gb SDHC card  f or under 15 $.  I  made this as swap memory for  my netbook.

Installed VC++ 6 ( yes it works  with this also ) and Cygwin. Downloaded the software from Edelivery website and staged it onto 160 gb disk (which is an external disk now).

In the localhosts file I added an entry like localhost.OracleApps.com  and gave an IP address of 127.0.0.1

Then  I ran the  rapidwiz wizard from the external disk. From this point it took about  two and half hours to complete the installation.

So guys you can also use these steps to install Release 12 on netbooks or any other system that you want to use for your release12 usage.

Thanks

Kumar

Oracle Payables Escheatment Process Howto

Hi

If you are working  with Oracle Payables you might come across on questions related to Escheatment process.  The payables user guide does not have much info on this. Let me explain what  it is and how to go about it. Many a times Some vendors forget to cash their check for various reasons. Believe me it happens in real world for whatever reason it is . We had over  200k (dollar amount)  in uncashed checks. The US law requires that  you remind the suppliers about the uncashed checks . If  those checks remain uncashed after enough efforts you are required to   cancel the checks and remit the amount to the State  as the amount is not yours but it belongs to the suppliers who did not cash it.

In India  Companies are  required to remit the amount  to the Comapny Law board. How do you go about it.

It is very simple. As this happens with Checks run the query to identify  the checks, suplliers etc. I  have given a date of  01-Jan-2008 to identify the checks mailed in the years prior to 2008. Based on the results  you send out letters to the suppliers identified by the query.  Some suppliers might encash it or request for a new check, if they have lost the check (Void and reissue in such cases). Or ellse cancel the checks and remit the amount to the state after some time.

The query is as follows. You may have to modify it based on your AP department’s requirement.

select vendor_name,vendor_site_code, amount,check_date,check_number,
checkrun_name from ap_checks_all
where  1=1
and status_lookup_code=’NEGOTIABLE’
and check_date <’01-JAN-2008′

Thanks

Kumar

Make Concurrent Programs Incompatible Howto

Many a times you have to make certain Concurrent Programs incompatible with itself or other programs.Oracle has defined many incompatiblity rules for you. But sometimes you may have to define additional incompatibility rules  to meet your business requirement.

In this case we found that AP Invoice validation and Taxware (third party tax software in the US) have some issues in our instance. So we defined an incompatibility  rule to solve the issue.

The same solution was used by me to fix some payment batch set issues.We had defined different pay groups like Special handling(tax related payments), Vendor, Small Business etc. We created a batch set with all these paygroups and one catch all batch with no pay group  to run the batch for  all the other suppliers. Due to a bug Special handling  paygroup checks are created in its batch as well as the catch all pay group.To prevent this from happening  we defined an incompatibility rule  for Invoice selection. This served our purpose.We retained the payment batch sets  and run them now. It initially kicks off the selection program which would run one after the other.  Rest of the  programs like build, format and confirm would run simultaneously.

This helped us in a big way as we did not want to apply a patch to fix the bug at the year end.  This simple solution gave us the breather to carry on with our work at the year end.

So it is our ability to apply simple solutions that makes us happy at the end of the day.

Kumar

Make Concurrent Programs Incompatible Howto