Oracle Reports.

Step1: Start Connecting.

• Open the Oracle Reports Builder, go to File Menu and press Connect or execute the command Ctrl+J.
• On the second step, you need to enter the user name, password and the database name.

Step2: Create Report Wizard in Oracle Reports.

Click on Reports and the press the button Create. An alert "Create a new report" with two option will appear, and here you choose: Use the Report Wizard.

Step3: Choose The Type of Layout and Style Reports in Oracle 11g.

• Select the type of layout you would like to generate:

We have three options here.

1.  Create both Web and Paper Layout,
2.  Create Web Layout only, 
3.  Create paper Layout only.

• Next step is  to  choose the report style and give a title name for your report. 

         The report style option are: Tabular, Group Left, Group Above, Matrix, Matrix with Group.

Step 4: Selecting a Data Source and Select Sql Query Builder for Reports in Oracle.

• In this step you have to choose a Data Source for your report. The Data Source can be from JDBC Query, SQL Query, Text Query, XML Query.
• In the next window you can write the query manually or else you can use Query Builder or Import Builder.

Example Query with Explanation:

SELECT * FROM MTL_SYSTEM_ITEMS_B WHERE SEGMENT1 =:P_SEGMENT1

In the above query: p_segment1 is called as bind parameter/variable.

Note: There are two types of parameters that we use in reports. Lexical Parameter and Bind Parameter

Bind Parameter: This is used to pass the values dynamically at run time.

Examples: 1) If you want to see only one item from your inventory and you want to select that item at the time of running report. 2) If you want select only particular department employees and you want to select that department at runtime.

Lexical Parameter: This parameter is used to build the query dynamically.

Examples: If you have two users A, B will be running the report and if use A want to see only columns 1, 2, 3 where as User B want to see columns 2, 3, 4 in that case we build the query dynamically using lexical parameters

• Select the fields that you would like to display in your report. You can move one item or all items to target from Available Fields in Displayed Fields.
• Select the fields that you would like to calculate totals in your report. Also you can choose to calculate: sum, count, minimum, maximum, average.
• In the Next screen here you can modify the labels of the fields and also the width for each field.
• Next Step is to select the template for your report. You have multiple options: Predefined Template, Template File or No Template

Now you are done with describing report.

Step 5:Run Module Report Editor Paper Design.

• Select the template for your report. You have multiple options: Predefined Template, Template File or No Template.

Forms.

Creation of sample 'form' step by step.

Step 1:Connecting forms 11g to database 11g.

• Copy the file 'tnsnames.ora' from database folder to config folder in Oracle Middleware.
• Go to the Oracle Form Builder, go to File Menu and press Connect or just execute the command Ctrl+J.
• Finally you need to enter the user name, password and the database name.

Step 2: Changing Module Name in Oracle Forms.

In the object navigator select 'Modules' under forms and then click right button and select 'Property Pallet'. In the 'property palle't select name and enter your modulename'.

Step 3:Create New Data Block Wizard in Oracle Forms 11g.

• Select  'Data Blocks' in the list and the press the button Create. Another window with two option will appear, and here you select ->Use the Data Block Wizard.
• Another window with title 'Welcome to the Data Block Wizard!' - Click Next to begin creating your data block.

• Select the type of Data Block: Table/View or Stored Procedure.
• Click Browse button and will appear a small window with more choices: Tables, Views, Current user, Synonyms, Other users.

• Once you select the table name, oracle forms will show all Available Columns from the table. Here you can bring all columns from the table in your form or you can select just a few or required columns.
• After selecting the columns you can move the items to right panel and press Next.
• It will ask for Name then Enter a name for your Data Block. Ex: Employee.
• Now we are done with describing you data block. Now we will have two options: 
   1.Continue with: Call the Layout Wizard 
  2.Stop: Just create the data block(this is recommended when you use multiple data block on the same canvas)

Step 4:Create Layout Wizard Oracle Forms 11g.

• Go to Layout wizard ->This wizard helps to easily layout the items of a data block.This wizard helps to display items in frame on a canvas and lay them in different styles.
• Here we have to choose the canvas name(can be a new one or an existing canvas) and the type of canvas. 
  Below are the Types of canvas: 
  - Content 
  - Stacked 
  - Vertical Toolbar 
  - Horizontal Toolbar 
  - Tab.

Step 5 : How to Display available items.

• After selecting the canvas type the next window will show the list of items to be displayed in canvas. select the required items and move them to 'Display items list'.
• The next window  prompt for width and the height for each item. enter the desired dimensions.
• Next step is to select the Layout Style for your frame.

            1.Form

            2.Tabular

           select 'Form' and click next.

• Next step is  to choose the Frame Title, you can insert how many records to be displayed in the field 'Records Displayed', also Distance Between Records and Display Scroll bar.
• You are done with creating layout frame.
• Now go to 'Form'->Datablocks->Employee-> the tree will be displayed with list of items and on the right hand side newly created form will be displayed with list of items.

Procure to Pay Process...

Use of FNDLOAD.

Some of the examples in this FNDLOAD article include:-

1. FNDLOAD to transfer Request Groups
2. FNDLOAD for moving Concurrent Programs
3. FNDLOAD to download and upload Forms Personalizations ( or Personalisations depending on where you are located ).

Use FNDLOAD for transferring value set definitions.
Please note that when transferring Key Flex Fields and Descriptive flex fields the respective value sets against each segment will be extracted and loaded automatically.

Also, FNDLOAD can be used to migrate Key FlexFields, Descriptive Flexfields, Responsibilities and almost every other FND entity.

Technical Course Covers the following topics.

• Workflows, 
• Forms&Reports.
• Web Services,
• XML, 
• Database Internals, 
• PL/SQL, 
• Framework, 
• SOA, 
• XML Publisher etc.

The pre-requisite for this technology is Oracle ( SQL and PL/SQL ) , basics of oracle forms and reports.