Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Wednesday, 6 July 2016

Create Oracle Form Wizard

Open the Form Builder and select Data Blocks click on create button as shown bellow
Create new data block  by selected "Use data block wizard" and click on "OK" as shown below

Click on "Next" on following screen

Select the type of data block clicking on radio button "Table or View" and click on "Next" as shown below

Enter the "Table or View" Name Click on Refresh , it will ask for database username and password and click on connect on following screen
 It will show all the column which is available in table and you can select by clicking on arrow marks what columns are required  as shown bellow and click on “Next”

Enter the Data block Name and click on “Next” as shown below

Now Data Block Creation part completed and let us start create Layout of  form 
Select "Create Data Block, then call the Layout Wizard" radio button  and click on "Finish" as shown bellow

Let start Layout creation part 
Click on "Next" following screen 
 As per Business requirement you can select one of canvas on list of values
 Canvas Types:
                        Vertical Tool Bar
                        Horizontal Tool Bar
Note: Default Canvas is "Content"

Create Canvas as shown below screen click on "Next"

Now It will show available item whatever we have select on creating of data block
as show below screenshot 

By using arrow marks  you can select what field are need to be display on form as shown below and Click on “Next”
 On following screen you can change prompt field name and width and height as shown bellow and click on "Next"

You can select layout of report either Form or Tabular and click on "Next"

On following screen you can give details of  Frame Title ,Records Display and Distance between records and click on “Next” and "Finish"

Now your form ready to use 
Share this article :


  1. Hello There,

    Jeez oh man, while I applaud for your writing , it’s just so damn straight to the point Create Oracle Form Wizard.

    I have a number of table spaces based over a 4-year period and would like a script which when executed drops the oldest table space and data files after a period of 30 days / 60 days / 90 days etc - which will be executed via corn once per month
    Does anyone have a script where they can upload and I can test

    But great job man, do keep posted with the new updates.

    Kind Regards,

  2. Selamat Petang,

    The challenge however, is we don’t yet know how it will be used making to hard to assess their value proposition and consequently value.

    how to apply refcursor in package with multiple insted of multple cursors in oracle?

    Give one example.

    Thank you very much and will look for more postings from you.


  3. Hi There,

    Seems like I won the lottery here….This is a treasure box of blogs and your folks are like leprechauns! Phenomenal read on Create Oracle Form Wizard !

    I'd like to be able to log all constraint errors when users are running an application having Oracle as the back-end. That means inserting a record into an Errors Log table in Oracle.

    Is that even possible? In an exception clause, I could do that; however, when a constraint fails, I don't know where I'd be able to run such code to do the insert.

    Is this even possible?

    Thanks for any help you can give.


    Appreciate your effort for making such useful blogs and helping the community.


  4. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check

  5. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

  6. You can't alter this area which gives connects to the Terms of Administration and Report Misuse pages. Wikipedia writers for hire

  7. Things happen for a reason is something I believe in. I also believe that I am the person I am because of my life experiences. Billdu invoice generator online

  8. online payment form Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info.

  9. Your Accountants in Wigan. MTA Accountants are a rapidly growing Wigan based accountancy practice with different approach. polski ksiegowy