Wednesday 29 February 2012

jde interview questions_part5

1.explain in report event flow?
a.initializing section :  occurs when a batch process encounters  a section for the first time,use this event to do processing immediately before a section begins.this event is useful for working with global variables

b.advance section :  occurs when each time you perform a fetch from the data base use this event if u need processing on objects before the fetch


c.do section :  occurs following an advance section, after values have been assigned to print out to a printer or an output file


d.after lost object printed : occurs after a row is printed an output file  it is used to process information after a row has been  output


e.end section : occurs after a batch process has been completed processing the last set of section values .use this event to do processing immediately after a section ends


2.what is set  selection append flag and set user selection?
set selection append flag : enables you to add, append or overwrite data selection and data sequencing for a selection


set user selection : enables you to define data selection and data sequencing for a selection


3. what is report?


a report is nothing but batch application used to represent the data in useful format or user defined format

4.what are the various types of detail sections available  with report design?


columnar, group, tabular
a. columnar section: is a fixed format we cont change the format  this is least flexible section


b. group section : is free form design capability .it is the most flexible section we cont change the format .we can drag and drop any ware variable and constant in section 

c.tabular section: it is same like columnar section and additional features are 1.drill down future 2.automatic totaling 3. subtotaling    and it is balance sheet


5.what is level break ,level break header and level break footer?
 level break:  will be occur when data will be changed and difference between the data


level break header: will be occur beginning of the header it show the information with in the detailed section 

level break footer : it will be occur in after the level break this is use in field the accumulate the total 


6.what is an aggregate object?


an aggregate object is an object that holds the result of a calculation on the values in other fields.for example the calculation could be a sum of values an average of values or a count of records


7.how do you invoke custom sections?


using the system function do_custom_section


8.how do you print text attachments in a report?

using media object system functions

9.it is possible to adapt the data selection and data sequencing from another section in the same report? if yes how?  


yes using the system function use data sel/seq from a section


10.it is possible to  do transaction processing from reports?how?


yes using the transaction processing functions begin,commit and rollback transaction business functions

11.some report system function?

Set selection append flag
Set sequence append flag
Set ube error
Set user selection
Stop batch processing
Stop event processing
Use data selection from section
Use data sequence from sequence










Tuesday 28 February 2012

jde interview questions_part4

1.what is meant by scope of a variable?
an event rule variable associate with a data dictionary item.but it does not reside of data dictionary.once it created it can only be used  a specific interactive applications,batch applications,or business functions event rule
 in that scope we have 3 options
1.report: enables you to use the event rule variable in any event in any section of the report.upon completion of the variable .the system adds a prefix of  report to the variable name
2.section: enables you to use the event rule variable in multiple-events of the selected sections . upon completion of the variable .the system adds a prefix of  section to the variable name
3.event: enables you to use the event rule variable in the event where it was created. upon completion of the variable .the system adds a prefix of  event to the variable name

2.what is solution explorer ?
the solution explorer is an interface that has been created to replace the one world explorer.starting with release erp9.0.solution explorer is automatically installed as a part of any one world xe or erp8.0 installation (light blub icon)including standalone

3.what is smart field?
smart fields are the fields which provide the ability to add complex and reusable calculations to the report,smart fields are grouped by a field template,which is based on a particular business view it is glossary type is k

4.what is the us e of text variables in report?

text variables are used to store strings,which can be attached to the reports,using event rules they are used as alternative to hard coding text strings in assignments

5.what is the  us of custom sections in reports?
custom sections allow you to control through event rules the in formations that prints on a report ,we can use custom section to print additional information,depending on certain criteria

6.what is the use of data structure/
this is used pass the parameters to the report,when it is called from another report

7.what is subsection join?
]a link established between the two sections in a report by using the common fields,that exist between the different business view.these to sections are called parent and child sections

8.explain report event flow?
a.initialize section
b.advance section
c.before level break
d.level break header section
e.do section
f.after lost object printed
g.end break section
h.end section









jde interview questions_part3

1.dd item attributes?
a.determine how a data item appears on forms and reports(number of decimals and default values)
b.validates data entry with an application
c.assign columns and row descriptions on forms and reports
d.define how data is stored in a table


2.what is an environment?
environment= Ocm + Path codes
IT IS ACOLLECTIONS OF POINTERS INDICATING LOCATION OF DATA AND ONE WORLD OBJECTS
OCM : object configuration manager is a tool that configures distributed processing and distributed data at run time without requiring programing
Path code: it is a pointer to specific set of objects .a path  code  is used to locate central and replicated objects


3.some features of data dictionary?
dynamic,when you change a data item the changes are immediately occurs through out one world

4.explain what is check in and check out?
checkout: to getting the objects specifications from server to workstations is called checkout
check in: taking the objects specifications from workstations to server is called check in


5.what are the business view?and why do u need the business view?
business view is a link between applications and data,business view is generated one one or more tables
it defines the data items from one or more tables that an applications uses.with business view you can select only the columns needed for an application which increases your system performance due to less data moving over the network

6.what are the different form types?
find/browse,search,select,header detail,parent child,message form


7.how do u submit a report from an application?
through report interconnection


8.what are media objects?
media objects are images which allows to attach information to one world forms and applications

9.what is ube?what different uses of ube?
universal batch engine,printing reports,batch applications,and table conversions

10.what are versions?
versions are user defined specifications attached through processing option

11.what is the difference between interactive and batch versions ?
interactive are not necessary to check in .where as batch versions to be check in ,because batch versions have local specifications






jde interview questions_part2

1. what is a data structure?

a data structure is a list of parameters,that is used to pass data between applications and tables  or forms

2.what are the types of data structures?

a.system generated data structures
b.user defined data structures

3.what are the system generated data structures?

a.form data structures
b.report data structures

4.what are the user defined data structures?

a.media object data structures
b.processing option data structure
c.business function data structure

5.what is the use of processing options?


processing options are used  pass parameters to applications.they control how interactive and batch applications process data

6.how do you find information about object usage in one world?

 using the cross reference facility

7.what is the difference between one world and one world xe?

one world doesn't have omw and token concept.it only has object librarian

8.what are the required field when adding an object?

a.object name

b.description
c.product code

9.what is a token ?

 a token is  reference to an object used to determine the ownership of  the object and prevent non owners 
from  checking the object out in omw

10.what is a data dictionary?

a data dictionary is a central repository containing data item definitions and attributes.just like a dictionary contains word definitions





jde interview questions_part1

1.what is omw?
: the object management work bench is the change management system for one world development.it helps organize a lot number of development activities and helps prevent problems.such as inter mixing components from different releases and simultaneous changes to any object by multiple developers


2.What is Object Librarian objects?


a,Batch applications and versions
b.Business functions
c.Business-view
d.Data structure
5.Interactive applications
6.Tables
7.Media Objects

3.What are the non object librarian objects?

a.User defined codes
b.Data dictionary items
c.Workflow items and menu


4.What is the meaning of project status code 21?

it is the project under development phase


5.what is the use of next numbering table(f0002)


the next numbering table provides the facility for automatic numbering of items such as account numbers , overture numbers address numbers

6.is there any limitation of number of tables used in business view?

simple inner join add 5 tables 
left and right outer join add 3 tables

7.what is the limitation of maximum number of columns used in business view?
  256

8.how do u eliminate duplicate rows in business view?

using select distinct future

9.what are the types of joins available in business view ?
a. simple inner join
b.left outer join
c.right outer join