Install Weblogic 10.3.6 64Bit using JDK 7, Configure Forms & Reports 11gR2 on Windows 8 64Bit


A wonderful article about setting up Weblogic Server 10.3.6 64Bit using JDK 7 is available here(Install Weblogic Server 10.3.6 64bit)

Once you installed the product, installing forms and reports 11g should be as easy as installing any software bundle on Windows platform.

However, one of the nasty errors we came across multiple times were related to JAVA

While the forms & reports 11gR2 reaches 19% installation, it stops and java errors are thrown in the log file, without giving any prompts over the GUI. If the installation stops @ 19% for a long time, cancel the installation and restart. That deals with the java error

Once you completed the forms and reports installation, you can invoke the configuration as described with our earlier post

and you should be online within 20-25 minutes!

Try and post us your experiences

for Windows7bugs


Uninstall Weblogic Server 10.3.6 & Forms, reports 11g


Quite a times, uninstalling Oracle products from a development machine could be quite troublesome, many times with errors difficult to understand. One of the most common errors

One of the most common errors as below


Oracle Universal Installer


The Java RunTime Environment was not found at C:\DOCUME~1\v859971\LOCALS~1\Temp\OraInstall2013-09-05_01-10-08PM\jre\bin\javaw.exe. Hence, the Oracle Universal Installer cannot be run.

Please visit and install JRE version 1.3.1 or higher and try again.

A Discussion about the same here:

Here is a quick workaround to address such situations

Copy the latest jre installation to a path without spaces


to, eg: C:\jre6

Switch to the folder where you have the “setup.exe”


D:\>cd D:\WebLogic\Middleware\oracle_common\oui\bin

Check what are the switches supported by the “setup.exe”

D:\WebLogic\Middleware\oracle_common\oui\bin>setup.exe -jreLoc C:\jre6 –help

Now, start uninstall process by starting the “setup.exe” with required switches

D:\WebLogic\Middleware\oracle_common\oui\bin>setup.exe -jreLoc C:\jre6 –deinstall

The setup GUI should start without throwing further errors now!

Once the components are uninstalled, you can uninstall weblogic server from “Oracle Weblogic” context menu, and the operation(s) should be smooth!


for Windows7bugs


Upgrade your 11g Forms/Reports [32 Bit] Version to

Upgrading Forms & Reports developer 11g could be equally confusing & interesting, as there are not many documents explaining a how to. Recently we were closely following up an “issue” raised by one of the visitors and opted to “upgrade” the development machine to check the feasibility of Forms & Reports 11g over Windows 8.1 64Bit

We were able to complete the upgrade process without much issues and the steps followed were described as below

Download the required software


As we were on 32Bit environment for the Weblogic, we downloaded the 32Bit packages for the upgrade. The total download should be roughly around 1.8GB

Once the downloaded archives are extracted, you can start with the upgrade process.

Prior the upgrade process, please make sure you stopped both Weblogic Admin server service & Weblogic Node manager service to avoid any kind of failures with the process.




You can kick start the upgrade process by executing the “setup.exe”



You should “Skip” the software update, as usual :)


Select “Install software – do not configure”

There could be multiple warnings about incompatible setups, you can “Safely” ignore and continue with the installation. We warn you, you shouldn’t install uncertified Oracle products on any OS, in case if you are going to use such setups for Production purposes

Setup should automatically pickup the “Middleware Home & Oracle Home Directory”


Going ahead will produce an error stating another installation is available in the selected location, ignore and continue


Unless you have a valid Oracle support contract, uncheck “I wish to receive…” and continue with the upgrade process



We got an error at 19%, all about certain java components. If you are familiar with LINUX, most of the times you could monitor a log file, as it is being updated using “tail” command. With latest versions of Windows OS you can use powershell to monitor the log file online.

Open up powershell and copy the installation log name like following

get-content “C:\Program Files (x86)\Oracle\Inventory\logs\install2014-02-24_12-59-08PM.log” –wait

It does the job and if errors are found, go ahead and cancel the installation and start over, which should deal with the java related errors. The total installation will be stuck unless.








You may save the setup steps and try out your upgraded forms & reports now. The only one element what we have noticed as “created” new as part of the installation was


Start Forms designer and check the about window and you must having the following information.

Forms [32 Bit] Version (Production)
Oracle Toolkit Version (Production)
PL/SQL Version (Production)
Oracle Procedure Builder V11. – Production
PL/SQL Editor (c) WinMain Software (, v1.0 (Production)
Oracle Query Builder – Production
Oracle Virtual Graphics System Version (Production)
Oracle Tools GUI Utilities Version (Production)
Oracle Multimedia Version (Production)
Oracle Tools Integration Version (Production)
Oracle Tools Common Area Version
Oracle CORE Production

That’s it folks. Give it a try and post us your issues, success notes.

for Windows7bugs


Posting Source Code with your free blog


If you are using Windows, the best free desktop offline blog publisher should be “Windows Live Writer”. With dozens of plug-ins, this blog publisher could be handy while you want to take breaks and continue at later stages.

You may follow the following link to learn few workarounds, which the code snippet plug-ins fail to provide you while you want to insert code into your posts

Alternatively you may add the code snippets to your post like following

Switch to “Source” view


and paste your code within [code] [/code] blocks


Read the link provided above to learn, programming languages supported for syntax highlighting, gutter (left side line numbers) disabling etc


[code language=”sql”] Select "windows7bugs" blogname from dual; [/code]


[code language=”sql” gutter=”false”] Select "windows7bugs" blogname from dual; [/code]

Unfortunately, the Windows live writer doesn’t parse the [code][/code] block with the previewer. Hence you must publish it to view the final results.

We hope you enjoyed another quality post from us

for Windows7bugs


Oracle – a simple function to format numbers for display

We have requirements to produce Payment Requests through Oracle E-Business suite custom interface, where the users are allowed to select different currencies based on the payment.

Different currencies means different precisions, US $ 2, Indian Rupees 2, while Kuwait, Bahrain have 3 precisions to maintain…

So the amounts displayed on reports needed to be formatted properly and we were doing some hardcoded formatting like

Now we have more currencies to deal with, hence came up with following simple function, which accepts the amount, precisions as inputs and returns a VARCHAR2 string as formatted number!


[code language=”sql” gutter=”false”]
frm_1 VARCHAR2 (30) := ‘fm999999999990.’;
new_num VARCHAR2 (30);
RPAD (frm_1, 15 + P_DEC_PREC, ‘90000000000000000’))
INTO new_num

RETURN (new_num);


You can check the function like following

[code language=”sql” gutter=”false”]

l_new_num VARCHAR2 (30);

l_new_num := xx_format_number(.009,3);


Check it out, and let us know whether it worked for you!

for Windows7bugs


Windows | re-lock BitLocker unlocked drive

Updated on 31st July 2020

Download & install the below from git, which is easier and cleaner for less tech savvy users.

Updated on 12th October 2016

The below hack is applicable to Windows 10 also, however, after the RedStone update, the registry hack entry “might” get removed and if you still prefer to right click and lock the drive without restarting, you will have to import the registry once again.

Start registry editor (double click to merge is NOT anymore supported), from the “File menu” Select import and point to the lock-bde.reg or whatever name you have given to the registry file that was manually created.

End of update //12/October/2016

The major difference between Windows 8.x Professional and Windows 7 Professional? Well you have free Bitlocker encryption for your 8.x Windows box(professional onwards), while the same is limited to Ultimate and Enterprise editions for Windows 7

Enabling Bitlocker on a drive is pretty easy, right click and go on.


Obviously we will not recommend you to bitlock your root drive. If you do, you are on your own :)

Now we have a problem, to unlock you must enter a password or other bitlocker supported authentication methods, which is fine. The concern is the unlocked drive remains unlocked for any user logs into the same computer until a restart.

For me this is a clear concern. I have some stuff which is not appropriate for my 7 years old daughter, or for a friend who just wants to “check his emails” during a visit.

After loads of searches, I found some nice leads which helped me to re-lock a drive by right clicking the bitlocker enabled drive in the explorer window.

Below listed were the actual links, which helped me to achieve the objective on my Windows 8.1 boxes (Office laptop & Home PC)

spreadbytes solution had one problem, I am using the boxes without UAC, thus while the .vbs script fires, nothing happens and the drive remains unlocked

Technet thread had the exact requirement addressed & all I needed to do was, alter the scripts a bit here and there to achieve my target

Open notepad or notepad++ and copy the below text and save it as lock-bde.reg

Windows Registry Editor Version 5.00
"AppliesTo"="(System.Volume.BitLockerProtection:=1 OR System.Volume.BitLockerProtection:=3 OR System.Volume.BitLockerProtection:=5)"
@="Relock drive..."

The hex values mentioned over here creates an entry like following


Once the value created, you can change the text as you desire to suite your situation (for Example, my development machine was not reading the PATH information properly, hence I was forced to add C:\Windows\system32 in front of the command

Open notepad or notepad++ and copy the following text into it.  Then save as “manage-bde-lock.vbs”, and copy to c:\windows\system32

Args = ""
Last = Wscript.Arguments.Count - 1
For i = 0 To Last
Args = Args & " " & Wscript.Arguments.Item(i)
Args = Replace(Args,"\","")
CreateObject("Shell.Application").ShellExecute "manage-bde.exe", "-lock -forcedismount " & Args, "", "runas", 1

That’s it. You should get “Relock Driver…” context menu by right clicking on the bitlocker enabled driver from now onwards


Hope this helps few out there.

for Windows7bugs


Oracle Applications R12, Re-assign PR/PO stuck in the workflow (awaiting approval)


Handling Purchase Orders stuck in the work flow.

Logon to the instance as “SYSADMIN”


Select “Workflow Administrator Web Applications” and Select the function “Status Monitor”. This opens a jsp page show below.


For the purchase orders stuck in the flow, please locate “PO Approval” workflow using search function. This windows provides multiple choices to limit the amount of data retrieved. Apply it whenever it is possible to reduce the time collecting and producing data.

Image: Finding the correct workflow (for Purchase requests stuck in the workflow)


For Purchase Requests stuck in the work flow, please use the following query

select requisition_header_id, segment1, wf_item_type, wf_item_key, authorization_status, org_id from po_requisition_headers_all where segment1 = ‘1980’ and org_id = 105;

for Purchase order change the table name to PO_HEADERS_ALL

to find the wf_item_key which is referred as “item key” with the JSP form.


Once the desired information derived

Click on “Activity History” button


Now you may use “Reassign” function (Shown within green rectangle) to reassign the Purchase Request for approval by next immediate subordinate.

You may use the “Rewind” button to rewind the workflow to an earlier stage as well

Hope you enjoyed another quality solution from us

for Windows7bugs


Oracle forms developer 10g, setting up initial values issues–a workaround

Update: 04.Feb.2014

Iudith from ittoolbox suggests, instead of WHEN-NEW-FORM-INSTANCE, PRE-FORM should be used for populating values to PARAMETER elements, thus when the focus is set, the initial values will be set for the columns.

The post will be open for more comments. Cheers!


The main advantage of an initial value for a text column is the form status remains NEW, instead of CHANGED & entering the query mode by pressing the F11 key is initiated without throwing errors even if you have mandatory (Required:Yes) property set for one more more columns within the same block.

(Strictly limiting the solution towards custom development for Oracle E-Business Suite, using TEMPLATE.FMB & forms developer 10g)

When a custom module is loaded, 10g run time doesn’t populate values assigned to GLOBAL/PARAMETER variables for the first record. Iudith explains this is default nature of forms load. However, the consequent records are getting the initial values from the GLOBAL/PARAMETER elements.

This time we are providing a workaround solution towards this dreaded situation, which should make a developer’s life bit easier.


Do not assign “First Navigation Block”, instead keep it as <Null>


Open “WHEN-NEW-FORM-INSTANCE” and programmatically send the focus to your first block (in which text columns are assigned with GLOBAL/PARAMETER values as initial values)


Somehow, this method populates the initial values for text columns when the forms is initiated. We believe, such a navigation to the block enforces a WHEN-NEW-RECORD-INSTANCE indirectly and populates all the referred elements.

If you have a better explanation, please forward the same to us.

Hoping to hear from Oracle forms developer guys, we remain

for Windows7bugs