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
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
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
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 220.127.116.11.0 (Production) Oracle Toolkit Version 18.104.22.168.0 (Production) PL/SQL Version 22.214.171.124.0 (Production) Oracle Procedure Builder V126.96.36.199.0 – Production PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production) Oracle Query Builder 188.8.131.52.0 – Production Oracle Virtual Graphics System Version 184.108.40.206.0 (Production) Oracle Tools GUI Utilities Version 220.127.116.11.0 (Production) Oracle Multimedia Version 18.104.22.168.0 (Production) Oracle Tools Integration Version 22.214.171.124.0 (Production) Oracle Tools Common Area Version 126.96.36.199.0 Oracle CORE 188.8.131.52.0 Production
That’s it folks. Give it a try and post us your issues, success notes.
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
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”]
CREATE OR REPLACE FUNCTION xx_format_number (P_AMOUNT IN NUMBER,
P_DEC_PREC IN NUMBER)
frm_1 VARCHAR2 (30) := ‘fm999999999990.’;
new_num VARCHAR2 (30);
SELECT TO_CHAR (P_AMOUNT,
RPAD (frm_1, 15 + P_DEC_PREC, ‘90000000000000000’))
You can check the function like following
[code language=”sql” gutter=”false”]
SET SERVEROUTPUT ON;
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!
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)"
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
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
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