Thursday, 26 November 2015

Interview Questions


1. How many sections can be placed in a report for Maximum?
Ans. We can add multiple sections but physical size should not exceed 45 inches in length and width

2. Can we call forms from Reports?
Ans. No

3. Can we call reports from Forms?
Ans. Yes, using Report interconnect.

4. Can we call Reports from table Conversions?
Ans.  Yes, using Report interconnect.

5.Is it possible to adopt data selection and data sequence from another section in the same Report?
Ans. Yes, using System Function - Use data selection / Sequence from a section

6. What are the version Overrides that can be done in a Report. 
Ans. Section Layout, Data selection, Event Rules, Data Base Output, Sort sequence.

7.What are the options that are available in Group and Columnar but not in Tabular.
Ans. Tabular cannot be conditional and cannot have level breaks. Level Break information is printed automatically within a tabular section and controlled by items marked as level breaks in Data sequencing. Sub section join is not available in tabular section.

8. What are the types of log files in JDE?
Ans. JDE Log and JDE Debug log

9.What are filter fields?
Ans. filter fields are controls on the form which are not selected into grid on the same form. It builds where clause in SQL Select statement .


Thursday, 17 April 2014

Forms(Interactive Applications)

Interactive Applications

  •          After entering into OMW Window select the project to which you want to add the aqpplication and then click on ADD. Now select Interactive Application and select OK.
  •          Fill all the fields like Object Name, Description, Product code and System Code. The namming Convension of Forms is Pxxxxyy. Click OK.

  •          Select the object and click on Design then go to Design Tools and select “Start Form Design Aid”.
  •       After Entering into Form Design Aid Click on Form, Create and then Select the form which you want to Create.
  • After adding the Form Click on Edit and attach a Business View
 The Form that is added first will be automatically selected as Entry Point   In this we have Grid Properties and Form Properties separately.   To add Columns to Grid Select the Grid then select the column to be added and click on Insert Column.

  • We will have Grid Properties, Form Properties and Column Properties separately.
  •          In this we have Grid Properties and Form Properties separately.
  •          To add Columns to Grid Select the Grid then select the column to be added and click on Insert Column.
  •          To change the Column Properties Right Click on the Columns Added and go to Properties.

  •          By entering into Grid Properties we change the alignment of the added columns.
  •          To Select Multiple Records at a time go to advanced and Select “Multiple Select” Option.
  •  And also we have many other options in this Advanced Tab.
  •   By clicking on Advanced or Options Tabs Change the properties based on the Requirement.  Fix Inspect Form will not have Grid. 
  • Remaining all Forms will have Grid.

Wednesday, 16 April 2014

Reports

Reports: Reports are used for representing the data in a useful format.

Report Components: The report components are
  • Report Introduction: A report exists as a set of specifications that are read by JDE batch engine for processing. We can create variations of a single report using versions.
  • Report Objects: JDE is object based. Each report template is considered as batch application. When you add report object the system creates a header record in OL Manager Table(F9860).
  • Report Sections: Report sections are basically components of a report. Selection types include:
  1. Report header and Report Footer Section: Report Header section appears once at the beginning of the report. Report Footer appears once at the end of the report.
  2. Page Header and Page Footer: Page Header section appears at the beginning of every page. Page Footer appears at the end of every page.
  3. Detail Sections: These presents the information that the report is designed to convey. The types of sections are Columnar, Group and Tabular. The data for these sections is populated from a business view. In addition to Business View fields we can define and add data fields to detail report section such as data dictionary fields, constants and variables.Within this detail section we can 
  • Attach a business view.
  • Sequence data using business view fields.
  • define level break using data sequencing fields.
  • Filter data based on designated criteria.
  • Present totals.
  • Attach Event Rules.
The guide lines for the size of a report template is not the number of sections but the physical size. A report design should not exceed a size of 45 inches in length and width.

Table Conversion

Table Conversion: It is used for converting data from Table to Table, Table to Text File, Text File to Text File and Text File to Table.

Types of table conversions:
  • Data Conversion: Data from records in the input is inserted into records in the output through mapping defined by you. Data Conversion is used to update records in a Table or Business view.

  • Data Copy: It consists of one or more tables which are copied exactly from one environment or data source to another environment.

  • Data copy with table input: It is similar to data copy except that is also allows information for the process to come from an input table.

  • Batch Delete: It allows you to delete a range of records from input tables.
The Environments in Table Conversion are 3. They are
  1. Logging Environment
  2. Input Environment
  3. Output Environment
Procedure for Table Conversion:

  • After entering into OMW window Click on 'ADD' button and select Batch Applications and click OK.
  • Fill all the fields like Object Name, Description, Product code, System code and select Table Conversion Check box then click OK. Now Table Conversion Object will be added to the project.
  •  Click on Design Tools Tab and select Table Conversion Design Aid and click OK.
  • In the Table Design Aid We have the Options like Data Conversion, Data Copy, Data Copy with Input and Batch Delete. From that select any one option and click 'Next'.
  • If you want to add a Processing Option add it otherwise click Next.
  • Select the Input and Output Environments and click Next.
  • Select input i.e., Table, Business View,Text file and Foreign Table select any one and then click Next.
  • If required add Data Sequencing, then click Next.
  • If required define your Data Selection, then click Next.
  • Select Output i.e., Table, Foreign Table and Text File Select any one option and click Next.
  • Do mapping for the data items from input tables to Output Tables, then click Next.
  • Create the version for that batch application save the created version and run the created version.
  • We can check the output based on the output selected that is table or text file or foreign table.
  1. If you want to convert the data from Text File to Text File then save the Text File in CSV format and upload the Text File in both Input and Out put also. In the user defined formats select the format type as Delimited and in that select 'Tab' option and add data items needed and finish it. In the output click User Defined Formats and select the format type as Delimited and in that select 'Tab' option and add data items needed and finish it. Then only complete data populates from one Text File to another.
  2. If you want to convert the data from Table to Text File select the table as input. In the output also upload the Text File and in the User Defined Formats select the format type as Delimited and in that select 'Tab' option and add data items needed and finish it. Then only complete data populates from Table to Text File.
  3. If you want to convert the data from Table to Table select the input and output tables. There is no need of changing user defined formats.
  4.  If you want to convert the data from Text File to Table, upload the Text File saved in CSV Format and select the User Defined Format type as Delimited and in that select 'Coma' option and add data items needed and finish it. In the output select the Table.There is no need of changing user defined formats. Then complete data populates from Text File to Table.

Data Structures

Data Structures:

Data Structures is a list of parameters that passes data between applications and tables.

The types of data structures are:
  1. System defined data structures
  2. User defined data structures
System defined data structures: The system defined data structures are form data structure and report data structure.

     Form Data Structure: Each form with an attached business view has a default data structure.This is used to receive or send parameters to other forms.
     
    Report Data Structure: A report is a batch application. Batch application can receive parameters from or send parameters to data structures.

User defined data structures: The user defined data structures are 
  1. Media Object Data Structure: It is used to add images or media files.
To create media object data structure:

  • After entering into OMW window click on 'Add' button and select media object data structure and click 'OK' button.
  • A window will pop up with the fields like object name, Description, Product code, System code. Fill all the fields and click OK button. Media object data structure will be created.
Naming Convention: GTXXXXYYA
GT is media object
XXXX is the file name
YY is next number

      2. Business function data structure: This business function uses source languages as C or NER.

To create a business function data structure:
  • After entering into OMW window click on 'Add' button and select  Business function data structure and click OK button.
  • A window will pop up with the fields like object name, Description, Product code, System code and source language( C or NER ). Fill all the fields and click OK button. Business function data structure will be created.
The naming convention is DXXXXYYYY
      
       3. Data structure: 

To create a data structure:
  • After entering into OMW window click on add button and select Data Structure and click OK button.
  • A window will pop up with the fields like object name, Description, Product code, System code and type( Regular data structure or Processing option template). Fill all the fields and click OK button. Data structure will be created.
     Processing option Data structure: A parameter list is used to pass processing options to an application. 
Naming convention of processing option data structure is TXXXXYYYY.
Naming convention of Regular Data Structure is DXXXXYYYY

BusinessView

Business View: A business view is a selection of data items from one or more tables.

Table Joins: A table join combines data from individual rows of joined tables. Types of joins are:

  1. Simple Join: This includes only rows that match both the primary and secondary tables.
  2. Right Outer Join: This includes rows common to both the tables and unmatched rows from secondary table.
  3. Left Outer Join: This includes rows common to both the tables and unmatched rows from primary table.
  4. Sql 92 left outer join: This includes rows common to both the tables and unmatched rows form primary and null values in the secondary tables.
Adding a business view: 
  1. On OMW click 'ADD'.
  2. On Add One world object to project, choose business view option and then click OK.
  3. On Add object complete all the fields like Object name, Description, Product code, System code, Object use and click OK.
Naming convention: the naming convention is VZZZZZZZZA.

V is business view name.
ZZZZZZZZ is character of primary table.
A is letter to generate view.

Working with business view: It has 4 windows
  • Table Join: It defines the tables over which you create the business view.
  • Available Tables: It locates tables for selecting and moving to the table joins view.
  • Selects columns: It lists the data items from your tables that are included in your business view.
  • Properties: we can get all the properties of the object.
To launch Business View Design Aid:
  • After entering into OMW window click on existing business view and click the "Design" button in the center column.
  • Click on design tool tab and then click start the "Business View Design Aid".
Choosing table and data items for a business view:
  • Search the tables and add them to table joins view by drag and drop.
  • If we add more than one table to a joins view then the first table is automatically indicated as primary table. If we want we can change it by double clicking on the title bar of desired table. A primary table denoted by a crown symbol in the upper left corner.
  • To delete the table from a business view choose it and choose delete from table menu.
  • Select the data items highlighted in the table joins window. As you select each item is added to the select column window.
  • You cannot join unlike items.
Creating table join:
  • Click and draw a line that links a column in the primary table to a column in the related table. You can create joins between the same data items only.
  • To delete a join choose it and choose delete from the join menu.
  • From the join menu choose types and choose one of the join types: Simple join, Left outer join, Right outer join.
  • Click the selected columns view to sequence columns.