Release 12 installation on Windows XP FRM-92101: There was a failure in the Forms Server during startup

Hi

If you received the above error on Windows XP after installation of R12 do the following.

Go to windows services Control Panel> Administrative Tools > Services > Double click on the Oracle Process Manager > Log ON tab Check Allow Service to Interact with Desktop Check box.

Shut down and restart. The problem should  not occur anymore.

Flexible Invoice Payment Terms

Hi

Many consultants have questions on Flexible payment terms in AP.  One such requirement is that Invoices dated any time between 1st to 15 of the month  should be paid  on 5th of the next month and other invoices  received from 16 th to the end of the month should be paid on 20th of the  next month.

Cut off day and Months ahead  does not give a  good solution for this.

Use AP special Calendar to achieve this. Define  a  special Clendar with  24 periods  and check the Payment Terms radio check box. Your special calendar should look like this

No of periods 24

Period1  

Inv From date  1-Jan-2009 Inv To date  15 Jan-2009 Pmt Date  05-Feb-2009

Period2

Inv From date  16-Jan-2009 Inv To date  31 Jan-2009 Pmt Date  20-Feb-2009

Define the next 22 payment terms.

Use this Special calendar in Payment terms.

Thanks

Kumar

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

BAI2 file format

Hi Guys

Many of us  working in the Cash Management and treasury  applications work with BAI2 files.These files   contain details  of Cash management and treasury payments and receipts information.  Often times  manay people ask what is the difference betwen cash management and treasury modules. While Oracle Cash management  deals with AP and AR payments and  receipts ( be it checks, ACH, Lockbox, automatic clearing) treasury deals with other sources of funding or investing activities like Money Market, Bonds, Equities, Forex operations ,swaps/options/swaptions,FRAs etc.

Cash management deals mainly with AP and AR whereas treasury deals with other products as mentioned above.

Your bank sends  files (payments/receipts)  in BAI2 format. Understanding the   statement format is critical for a treasury analyst. I am uploading a pdf document  for  your ready refernce.

I want to mention here that Money Market  in US is equivalent to Overnight Money or call money in APAC region. In APAC region Banks are the biggest players in the  Call money market.

Thanks

Kumar

BAI2 File Format

Oracle iReceivables Howto

oracle-ireceivables1

Hi guys

Here is a document that explains what  does Oracle iReceivables do ?

How to customize the application?

How to hide the  buttons in iReceivables Pages ?

How to configure the module ?

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

Target Queue /Node unavailable

Hi Guys

This is a document  for the above problem. I have gathered all the useful info on the above issue. There could be more than one cause for the problem. So I  have given below all the solutions for the above issue.

I have been able to resolve my issue with  one or more of the solutions  described here.

Thanks

Kumar

target-node-queue-unavailable

Oracle FSGs Howto

Hi Guys

I will be covering FSGs in the next few days. I now started with a simple one to explain how the FSGs work. I will cover  on Modifying FSGs and building FSGs from scratch in the next few days.

Thanks

Kumar

Oracle FSG – Howto

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