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

https://windows7bugs.wordpress.com/2013/04/06/install-configure-oracle-weblogic-server-10-3-6-forms-reports-11g-on-windows8windows-2008-r2/

and you should be online within 20-25 minutes!

Try and post us your experiences

for Windows7bugs

rajesh

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

Thread: https://community.oracle.com/thread/2578042?start=0&tstart=0
—————————

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 http://www.javasoft.com and install JRE version 1.3.1 or higher and try again.

A Discussion about the same here:

http://stackoverflow.com/questions/17282283/oracle-setup-exe-space-sensitivity-when-specifying-jre-absolute-path

Here is a quick workaround to address such situations

Copy the latest jre installation to a path without spaces

image

to, eg: C:\jre6

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

C:\WINDOWS\system32>d:

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

rajesh

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

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

http://www.oracle.com/technetwork/developer-tools/forms/downloads/index.html?ssSourceSiteId=null

image

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.

 

image

image

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

start

1

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

2

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”

6

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

7

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

8

9

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.

image

10

11

12

 

13

14

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

image

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

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

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

for Windows7bugs

rajesh

Posting Source Code with your free wordpress.com 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

http://en.support.wordpress.com/code/posting-source-code/

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

Switch to “Source” view

image

and paste your code within

 

blocks

image

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

 

 Select "windows7bugs" blogname from dual; 

 

 Select "windows7bugs" blogname from dual; 

Unfortunately, the Windows live writer doesn’t parse the 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

Admin

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!

Function

CREATE OR REPLACE FUNCTION xx_format_number (P_AMOUNT IN NUMBER,
P_DEC_PREC IN NUMBER)
RETURN VARCHAR2
IS
frm_1 VARCHAR2 (30) := 'fm999999999990.';
new_num VARCHAR2 (30);
BEGIN
SELECT TO_CHAR (P_AMOUNT,
RPAD (frm_1, 15 + P_DEC_PREC, '90000000000000000'))
INTO new_num
FROM DUAL;

RETURN (new_num);

END;

You can check the function like following

SET SERVEROUTPUT ON;

DECLARE
l_new_num VARCHAR2 (30);
BEGIN

l_new_num := xx_format_number(.009,3);

DBMS_OUTPUT.PUT_LINE (l_new_num);
END;

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

for Windows7bugs

admin

Windows 8.1 re-lock Bitlocker unlocked drive

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.

image

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)

http://social.technet.microsoft.com/Forums/windows/en-US/41607938-7452-440d-8253-67fe8657bc0f/how-to-relock-a-drive-with-bitlocker?forum=w7itprosecurity

http://spreadbytes.blogspot.com/2012/01/how-to-lock-bitlocker-encrypted-drive.html

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

[HKEY_CLASSES_ROOT\Drive\shell\relock-bde]
"AppliesTo"="(System.Volume.BitLockerProtection:=1 OR System.Volume.BitLockerProtection:=3 OR System.Volume.BitLockerProtection:=5)"
@="Relock drive..."
"HasLUAShield"=""
"MultiSelectModel"="Single"

[HKEY_CLASSES_ROOT\Drive\shell\relock-bde\command]
@=hex(2):77,00,73,00,63,00,72,00,69,00,70,00,74,00,2e,00,65,00,78,00,65,00,20,\
00,6d,00,61,00,6e,00,61,00,67,00,65,00,2d,00,62,00,64,00,65,00,2d,00,6c,00,\
6f,00,63,00,6b,00,2e,00,76,00,62,00,73,00,20,00,25,00,31,00,00,00

The hex values mentioned over here creates an entry like following

image

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)
Next
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

image

Hope this helps few out there.

for Windows7bugs

rajesh

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”

1

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

2

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)

3

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.

4

Once the desired information derived

Click on “Activity History” button

5

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

rajesh