Monday, 6 August 2012

JDE INTERVIEW QUESTIONS PART 12

1.How many numbers detail sections possible in a report template?
A)Multiple. But the physical page size of report template should not exceed 45 inches in length and width. Report template that exceeds this limit might faces problems at runtime…

2.How many detail sections can be added in a report template using report director?
A)Using the Director, only one detail section can be inserted in the report template. Later RDA can be used to enhance the report template and add extra detail sections

3.How many numbers (max) of Page Header/Page Footer sections possible in a report template?
A) Only one

4.How many numbers (max) of Report Header/Report Footer sections possible in a report template?
A)Only one

5.Can a business view be attached to a Page header section?
A)No. Business views can be attached to details sections only

6.what is the default font used to generate PDF reports in E1?
A)Arial

7.Is it possible to print the attachments that are inserted in the report?
A)No. They are just useful to explain the functionality of the report, any special logic used, documenting the changes etc.,

8.The properties and format of report headers and footers and of page headers and footers are similar to which detail section?
A)Group section

9.Report Templates Vs Batch Versions
A)Report templates are master specifications of the report. It defines the data used, how the data is
Selected , sorted, displayed, and formatted etc.
Batch versions read the master specifications from the associated report template and over ride one or more specification of the report template like:
• Section layout
• Section data selection
• Section event rules
• Section database output
• Section sort sequence
This concept allows creating requirement specific reports (versions) without touching the Master (i.e Report Template). Basically you create one report template and create multiple version by overriding the specifications.
Report Power points:
·      Report template is a Master specification
·      Batch version is a child i.e business need based customization of the Master

Thursday, 2 August 2012

JDE INTERVIEW QUESTIONS PART 11

1.How to create a null column in a table with out using the table copy?
a) include column in a table and generate  index operation we can create a null column in a table


2. in a table conversion does the data sequencing is used?
a)yes, it causes to a data changed event


3. whats written in format fetched event?
a)this event is used to convert the text files with different formats to data base tables


4. what different type of reports?
a)columnar , group,and tabular


5.what are events in columnar section?
a)say the events in a columnar section,initialize section,advance section,before level break,init level break header section,do section, after lost object printed,init break section,end break section,end section,suspend section.


6.can we copy a business function?
a) no we can't copy business function the copy button in omw window is disabled


7.in a header less detail form if we want to populate the grid on opening the form what should we do?
a)automatically find on entry check box property of grid should be checked


8.what is the use of different versions in applications?
a) to set the different criteria using different fields on applications with out changing the application


9what we can modify for versions in reports?
a)data sequencing,data selection,over ride the printer,event rules etc.....


10. how can we display errors for the grid columns?
a) set control error system functions


11. how can we attach data items for text box?
a)using the data dictionary item


12.if we change the description for data item can we get immediate reflection on our client machine?
a)the data dictionary changes are reflected centralized location to update the tam specs remove the dddict.ddb,dddict.xdb from the spec directory in a local path and relogin into JDE the dd items changed values reflected.


13.does the business function specs come from local are central?
a) local, if we want to get the changed specs of bf we should build it








Friday, 16 March 2012

jde interview questions_part10

1.What is an Object in JDE? Define Some…
Traditionally a One World Object was defined as any object created in Object Librarian.
Ex: Applications, Business Functions,Business Views, UBEs, Data Structures, Tables, Media Objects


2. How do JDE Stores Objects?

Central Objects Provides a central location for managing all One World objects. Only used for Development &  Software deployment.
Never used at run time


3. What is System code & Product Code? Mention Some…

Ans: – System code refers to the module object belong to. Product Code refers to the module for which object is reporting. e.g. 01, 41, 42, 03B, 55-59 etc


4. For What objects JDE maintains .h files?

Ans :- Tables and Business Functions

5. For What objects JDE maintains .h files?

Ans :- Tables and Business Functions


6.What is the Naming Convention of objects followed by JDE?
Ans :-
Batch applications RXXXXYYY
Business functions BXXXXYYY
Named event rules NXXXXYYY
Business views VXXXXYYY
Data structures DXXXXYYY
Processing options TXXXXYYY
Interactive applications PXXXXYYY
Media objects GTXXXXYYY
Tables FXXXXYYY
 
7. What is a Smart Field & what are its advantages?

A Data Dictionary item with an attached Business Function.
You don’t have to know how to write a Business Function. You don’t have to know how to pass values. They don’t have to be created every time you need the same functionality – they are reusable.


 8.What facility does JDE provide to achieve this purpose?
Interoperability

9. What are the JD Edwards EnterpriseOne components (Servers  & tools etc)
  • Databases
  • Deployment server
  • Enterprise (business logic) server
  • Web application server
  • Portal Server
  • Integration Serve
 10.explain about event rule debugger?
event rule debugger is state of the program at any point of execution
will debug the report application,and table conversation
will debugger we have 5 windows
1.object browse window
2.application window
3.brake point window
4.variables window
5.event rules window
we have 2types of  buttons 


f5:break point to break point
f10:step by step process


11.what is udc?
a valid value for data items we using the udc user will defining the list of values
the udc is made up 2 parts 1.code 2.description


12.what is udc type?
is made up of code type which is 2 character name
ex:search type
phone type


each udc type is associated with product code
use define code type table(f0004)(product code type)
use defined code table (f0005)(code description)








Tuesday, 6 March 2012

jde interview questions_part9

1.what is interactive application?
an interactive application is the interface between the a user and a data base  table (using the business view )a user uses an interactive application to add ,modify or view data using a form


2.what is application?


application is the collection of one or more forms


3.what is form?


interface between the a user and a table

4.what are the form types?
8 types of forms
a.find & browse
b.fix inspect
c.header detail
d.header less detail
e.search&select
f.parent/child
g.message
h.power forms

5.what is find & browse?
a.is the entry point to an application,which form has to be  initially first activated
b.is also called inquiry form
c.we have one grid control in this form
d.you can attach only one business view in this form
e.use this form  
search,view and select multiple records in a grid,
delete records,
exit to another form to add,update, or view table record

6.what is fix&inspect?
a.add or update single record  at the time
b.we can enter single record at the time
c.this form attach only one business view
d.there is no grid control in this form
e.this form include OK and cancel buttons
f.when you click the OK button updates or additions are written to the table
g.click cancel button any changes you have made are lost  no database changes are made


7.what is header detail?
a.updating and existing record to the two table  at the time
b.you can attach two business views in the form
c.we have one grid control in this from,in this grid control include input capable grid ,is nothing but enter the records in the grid
d.updates the multiple records at the time
e.include two buttons in this form OK and cancel,
click OK button add or update to the both the table
click cancel button any changes are lost and no database changes are made

8.what is header less detail form?
a.update the multiple records to the one table
b.attach single business view in this form
c.we have one grid control ,this is also input capable grid
d.use in this form display the multiple records in a grid,and view ,add change,and delete records


9.what is search and select form?
a.use to find out the records
b.use this form to locate a value and return in to the calling field
c.is called visual assist,or hyper control,or torch symbols
d.attach one grid control
e.in that grid there is no input capable
f.finding to the record and increasing performance


10.what is parent child form?
a.this form represent the parent/child relationships in an applications
b.omw is the exact example of the parent child
c.right portion of the detail view
d.left portion of the tree view


11.what is message form?
a.display the messages  are request action form the user
b.you can add only static text and push buttons
c.there is no business view in this form
d.allow standard push buttons including OK,cancel,yes and no buttons.
e.example are you sure you want delete this record

12.what is power form?
a.is collection of multiple forms
b.functionality of every form
c.collections of sub forms is called power form
d.sub form we attach single business view
e.sub form we can attach single grid control
f.power form attach multiple grid control
g.power form attach multiple tab control
h.attach the multiple business view
i.two types of sub forms embedded sub forms,reusable sub forms

 









 







 

jde interview questions_part8

1.what is ERP ?
enterprise resource planing it is a business management system .which includes many diver set of modules which are interrelated


2.what is modules?


is a set of applications .that perform a specific set of tasks on a specific data in the database


3.what is erp advantage?
 higher management easily understand to take the decision making with a point of time 


4.advantages of JDE?


a.easy for business management system
b.time saving
c.cast repetition
d.efficiency is more
e.user friendly
f.it can be worked on multiple platform
g.they said good profits from the business

5.features of JDE?

A.Configurable network computing
b.Multi plat form
c.accent supply chain
d.interoperability
e.adaptability
f.user friendly


6.how many types of modules?

 2 types of modules a.functional , b.technical
functional modules are
a.finance 
b.distribution
c.manufacturing
d.hr module
e.transpiration module
f.real estate management
g.customer relationship management  
h.groaner management
i.approach management

technical modules are

a.fundamentals
b.application design
c.event rules
d.business function
e.catching
f.additional features
g.messaging
h.debugging

7.what is mean by object?
 is a reusable entity that is based on software application created by one world tools 

8.project life cycle?

project is collection of objects

a.create a new project
b.add user/owner to the project
c.add object to the project
d.check object out and in
e.advance project
f.complete project

9.JDE environments?
a.development  
b.testing
c.production
d.pristine
e.protect

10.what is table?
table is collection of data in rows and columns ,data item becomes field in the table

11.what is table generation?
 after you have selected data items and assigned indices   for your table .you are ready to configure ,the table for a specific data source .if u have not established an index your generation will fail
you must generate a table to create the physical table you cannot  add or update the table until it is generated
table generation also creates a .h files  .that is used for compiling in business functions and table event rules
you must regenerate a table if u modify it for example if you delete or add data items
you use generate to generate a newly modified table the existing data in the table will be lost




  

 













Saturday, 3 March 2012

jde interview questions_part7

1.what is event?

events are activities the occur in a form
ex: add,save,submit these are all events

2.what is a control?
a  control is reusable object that appears on a form,example,include push buttons,edit fields,and grids.
every control having the event rules in that event rules have multiple events

3.what is event rules?

event rules are logic  statement that we can create and attached to the events

4.what is types of event rules?

1.if else conditional statement
2.while loop
3.assignment operator
4.call business functions
5.call system function
6.table i/o
7.form inter connection
8.report inter connection

5.what is form processing?

form processing refers to the business logic associated with the each form .by default each type of one world form automatically include  basic processing for various events .then using event rule design you can build a additional logic.form processing depends on the occurrence of specific events .such as initializing a form change the value of a field

6.what is business function event rules?

business function event rules encapsulated reusable business logic created using event rules rather than 'c' programing .they are store as object and are compiled ,business functions event rules are some times called named event rules.

7.what is embedded event rules?

embedded event rules are specific to a particular table.interactive application or batch application.they are not reusable .embedded event rules can be application event rules or table event rules they can be compiled or UN compiled

8.what is applications event rules?

you can add business logic that is specific to a particular application interactive application,connect event rules via form design batch applications are report design

9.what is table event rules?

you can create database triggers or rules that are attached to a table through table design event rules

10.how many types of variables?

1.business column
2.grid column
3.grid buffer
4.form control
5.form inter connection
6.processing option
7.query by example
8.event rule variable
9.system variable
10.table column
11.text variable
12.report variable
13.report constant
14.input column and  out put column
15.previous business view column


     

Thursday, 1 March 2012

jde interview questions_part6

1.what is table conversion?

 is a type of batch process that enables you to rapidly manipulate the data in tables

2.what type of conversions you can do in TC

data conversions,data copy,data copy with table input ,batch delete


data conversions:  enables you to transfer or copy data from an input table  or business view into output tables using to logic.this is necessary to perform the transfer .you can also use data conversion to update records in a table or business view
data copy :  enables you to copy tables from one data source or environment to another source or environment .when the tables are identical
data copy with table input: enables you to copy tables based on information from an input table .for example the input table provide information about which tables are copied when they are copied and so on
batch delete: enables you to delete records from a table or business view

3.what is table conversion process flow?

data copy : the conversion type does not include input and out put tables.all actions are accomplished through the process begin event.

data copy with table input: the conversion type does not include output table .all actions are accomplished through the process begin,process end and row fetched event


batch delete: as with the data copy with table input type. the conversion type does not include output table .all actions are accomplished through the process begin,process end and row fetched event


4.how many inputs a TC can have?


one


5.what is foreign table?


Non - JDE  table are called foreign table not defined by one world


6.what is difference between fetch single and select, fetch next?


fetch single retrieves only a single row(based on primary index)and select fetch next retrieves more than one record

7.how many out puts can be attached in a batch delete?

none

8.what is flow of events in TC?
process begin,data changed,row fetched,format fetched,and process end

9.what is difference between user insert row and   TC insert row?


a user insert row can defined  anywhere but TC insert has to be defined at the end of the event


10.what is a processing option and where do you attach it in a TC?

 it is a run time user input and you attach po in the external data of the navigation window

11.What is table conversion system functions?

Tc insert row
User insert row
Set selection append flag
Set user selection
Stop conversion processing
Stop event processing
copy table data source
Copy table data invironment