JD Edwards Q&A
Fundamentals
Q1. What is OMW?
The Object Management Workbench (OMW) is the Change
Management System for One World development. It helps organize a lot number of
development activities and helps prevent problems such as intermixing
components from different releases and simultaneous changes to any object by
multiple developers.
Q2. What are the Object Librarian Objects?
Batch Applications and versions, Business Functions,
Business views, Data Structures, Interactive Applications, Media Objects and
Tables.
Q3. What are the Non-Object Librarian
Objects?
Data Dictionary Items, User Defined Code Items, Work flow
Items and Menus
Q4. What is the meaning of Project Status
Code 21?
Project is under development (programming) phase.
Q5. What is the use of Next Numbering Table
(F0002)?
Next Numbering Table provides the facility for automatic
numbering of items such as Account Numbers, Voucher Numbers and Address
Numbers.
Q6. Is there any limitation on number of
tables used in a Business View?
One World limits the number of tables to five if all joins
are simple joins or to three tables if any of the joins is an outer join or if
there is a union.
Q7. What is the limitation on maximum
number of columns in a Business View?
256.
Q8. How do you eliminate duplicate rows in
a Business View?
Using Select Distinct feature.
Q9. What are the types of joins available
in Business View Design?
Simple, Left Outer and Right Outer joins.
Q10.
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.
Q11.
What
are the system generated Data Structures?
Form and Report Data Structures.
Q12.
What
are the user defined Data Structures?
Media Object Data Structures, Processing Option Data
Structures and Business Function Data Structures.
Q13.
What
is the use of Processing Options?
Processing Options are used to pass parameters to
Applications. They control how interactive and batch applications process data.
You can create several versions of the same set of processing options.
Q14.
How
do you find information about Object usage in One World?
Using the Cross Reference Facility.
Q15. 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.
Q16. What table contains the details of OMW
Project?
F98222 – OMW Project Objects
OMWCHS - Check out Status
0 - Checked-in
1 - Checked-in and holds token
2 - Checked-out
OMWOST - Object Management Object Status
01 - Just Added
02 - Checked-in
03 - Checked-out
04 - To be deleted
05 - Obsolete
Q17.
What are the required fields when adding an Object?
Object Name, Description, and Product Code
Q18. How do you move
batch version specifications to an enterprise server?
Check in the version.
Q19. You have just checked your batch version on your machine,
when the machine crashes. You need to immediately run that version. You go over
to your friend's machine and log in to OneWorld as yourself.
Referring
to the above scenario, which one of the following is the better solution?
Erase the existing checkout, then checkout and run from the
friend’s machine
Q20. You have the batch
application "R55001." The parent section is not visible and you want
the aggregate fields to be listed in one row with headings.
Referring
to the above scenario, what type of section layout do you select for your level
break footer?
Tabular
Q21.You have the report (Employee commission Report)
"R55100" printing the following columns:
Employee Code
Employee Name
Department Code
Project Code
Commission Amount
If the logged in user is a manager, the commission amount
column should be displayed, otherwise it should be hidden.
Referring
to the above scenario, which one of the following properties is changed?
Section properties
Q22.What is the
path of the print Queue in One World?
It is always B7333SYS/PRINTQUEUE
To change the PrintQueue path locally on your
PC/machine, you can change your JDE.INI setting. You would need to go inside
you INI file and:
1. Look for [NETWORK QUEUE SETTINGS]
2. Change OutputDirectory=C:\B7 to some other
path like OutputDirectory=S:\B7
Q23.I can't
advance my project to the next status?
If you can't advance the status,
check the following conditions:
All objects must be checked in.
This also includes objects on projects that are inheriting tokens.
Have you filled all the required
fields in SAR on JDEC.
Q24. I am not the
owner on the project. How can I add myself as an owner to it?
Go to the Advance Search. Enter the project name in the
QBE line and press the find button. Select the project and it will be displayed
on your workbench. Now you can use the Search tab to add yourself as an owner.
Q25.I want to
inherit the token but the option is disabled. Why?
The SAR that has the token is at a different status. In
order to inherit the token the SARs must be at the same status. Once the token
is inherited the SARs will move together at the same status. This means that if
you advance the status for one of the SARs, the status for the other SAR will
also change.
Q26.I've
inherited the token but I can't check out the object. Why not?
The object is already checked out by another project that
also has the token. You cannot check out the object until the other project
checks it in. This prevents overwriting changes when token is inherited.
Q27.I keep
getting the Release Search and Select form when I try to add an object to my
project?
The object has already been added to the project. Do a
find to see it displayed under the object node. The Release Search and Select
form is displayed whenever you try to add an object to a project more than once
because OMW thinks you are trying to do modifications in multiple releases.
Q28.The
programmer makes a fix to an object then wants to run it to assure the fix
works, how is this done in OMW?
Go into ‘Design’; click the 'Run' button on the 'Design
Tools' tab.
Q29.If you add an
object to your 'Default Project' and check the object out, then decide to move
the object to another project and you 'Drag and Drop' the object to another
project, does the token go with the object to the new project?
Yes, the token does go with the object to the new
project.
Q30.
What
is a token?
It is a reference to an object used to determine the
ownership of that object and to prevent non-owners from checking the object out
in OMW.
Q31.
How
do you find information about Object usage in One World?
Using the Cross Reference Facility.
Q32.
What
is Employee Work Center?
It is a central location for sending and receiving all
OneWorld messages (system and user generated) regardless of the originating
application and user.
Q33.
What
is the use of JDE.ini file?
It provides the runtime settings required for OneWorld
initialization.
Q34.
What
is a Data Source?
A data source is the specific location of data or
distributed processing. One World data source can be:
Ø An entire database in a specific
location, regardless of the type of the database, such as a MS Access database
located in a specific directory or a library in DB2/400.
Ø A specific machine in an enterprise
that processes logic.
Q35.
What
is an OCM?
The Object Configuration Manager (OCM) is a tool that
configures distributed processing and distributed data at run time without
requiring programming. Using the Object Map table, the Object Configuration
Manager points to the correct data, batch process or business function for a
given environment and user. The Object Configuration Manager is the control
center for the run time architecture. One World always uses the Object
Configuration Manager to locate the data and platform needed to execute the
distributed logic.
Q36.
What
is a JDEBASE?
It is JD Edwards proprietary database middleware, that
provides platform independent APIs for multiple database access.
Q37.
What
is JDENET?
It is JD Edwards proprietary messaging software package.
Q38.
What
is Just in time installation?
It is OneWorld’s method of dynamically replicating objects
from the central object location to workstation.
Q39.
What
is a Package?
OneWorld objects are installed to workstations in packages
from deployment server. It is a point-in-time “snap shot” of the central
objects on the deployment server.
Q40.
What
a Path Code?
It is a pointer to a specific set of objects. A path code is
used to locate Central and Replicated objects.
Q41.
What
OneWorld tables does OMW use?
S.No.
|
Table
|
Description
|
-
|
F98210 – Logging Header
|
Contains Header information including the Project, Object Type,
Object Name, Time Stamps, Path Codes, Data Sources, Locations and Action
Type.
|
-
|
F98211 – Logging Detail
|
Contains detailed information on the Errors and Error Codes for
the Projects and Objects included in the F98210.
|
-
|
F98220 – Project Master
|
Detailed information on all newly created projects and all
default projects.
|
-
|
F98221 – Project Users
|
Includes information on all the Users in OneWorld, the projects
they are added to and the Role numbers they are assigned with.
|
-
|
F98222 – Project Objects
|
This log details all OneWorld Objects that are added to Object
Management Workbench Projects. It
includes the object name and type, the Path Code and Project Name.
|
-
|
F98223 – Allowed Actions
|
All the Allowed Actions assigned to User Roles in the Object
Management Configuration are detailed in this table.
|
-
|
F98224 – Status Activity Rules
|
Details all Project Status Activity Rules.
|
-
|
F98225 – Transfer Activity Rules
|
Details all the Object Transfer Activity Rules.
|
-
|
F98230 – System Settings
|
Contains all OMC information other than Activity Rules and
Notification subscriptions.
|
-
|
F9829 – Notification Subscriptions
|
All added Notification Subscriptions are detailed here.
|
Q42.
What
are the different delete options available when you delete an object?
When you delete an object from OMW, there is a list of
delete options available.
The Delete Object
from Server check box, will delete the Object Specifications from the
Server depending on the Object Transfer Activity Rules for the Project Status
you are in. The Delete Object Locally
check box, will delete the Object Specifications from the local TAM
specifications on the workstation upon pressing the OK button.
The Delete Object from the SAVE Location,
will delete the Object from the SAVE LOCATION from whatever Path Code is
represented by the Project Status you are in.
The Mark Object To Be Deleted From Transfer Locations, will place a
flag on the Object. As the Object passes through each Path Code throughout the
Promotion Path, the object will be automatically deleted from that path code.
For Example, if you wanted to remove an object from One World, you could create
a project and advance it from 11 to 21 – Programming. In 21, add the object to
your Project, then highlight the object and press the DELETE button. If the
Delete button is not available, then you are not on the project with a Role
that has an Allowed Action of Delete for the object type you are trying to
delete. When the Delete screen comes up, select the Mark Object To Be Deleted
so that the object will be flagged to be deleted. You will also need to select
the Delete Object from Server to delete the object from the current Development
Path Code. Then advance the project from 21, to 26, to 28, to 38. The object
will be deleted from the Prototype and Production Path Code.
The Remove Object From ALL Locations,
will delete the object from the Server depending on the Object Transfer
Activity Rules for the Project status you are in, it will delete the specs
locally, it will delete the object from the SAVE location, and it will mark the
object to be deleted from the Transfer Locations which will delete the object
as the project is advanced.
Q43.
What
are the differences between the Get button on the center toolbar and the Get
option that is a Row Exit in OMW?
The "Get" button on the Center Toolbar retrieves
the specifications for an object from Central Objects to the local workstation
path code based on the activity rules specified for the Get function for the
project's status. For example, if you have a project at a status of 21, the
activity rules will be defined for a "Get" to retrieve the
specifications of an object from the development path code (DV7333). The "Get"
button provides a way to look at the current specs of an object from the server
without requiring the object to be checked-out. The "Get" option
available as a row exit in Object Management Workbench is used to get the
specifications of an object from any path code or data source. When you
highlight an object and select the "Get" button from the row exit,
for Object Librarian objects, a list of path codes is displayed to select the
desired path code and for non-Object Librarian objects a list of data sources
is displayed. This "Get" function can be used to select the desired
path code and is independent of the project status.
Q44.
How
can you assign a numeric field to a string field or visa versa?
When performing assignments, business function calls, etc.
within the event rule design, the available objects that display are required
to be the same type as the left operand selected in an assignment or the data
item within the parameter list for a business function, form interconnect, or
Table IO mapping. The event rule editor requires that the data items be the
same type.
Business Functions can be used to convert a field from a
math numeric to a string or from a string to a math numeric. The business
functions B0000580 - Convert String to Math Numeric and B0000045 - Math Numeric
to String, Convert are examples of available business functions that can be
used to convert a value from one data type to another.
Q45. What are the different ways to get UDC
Description?
User Defined Code (UDC) values and descriptions are stored
in the F0005 - User Defined Codes table. The User Defined Code value is stored
in the DRKY column. This is a 10-character column, however the length of the
values that are stored in this column are based on the definition of the length
of the User Defined Code values for the specified UDC table. These are defined
in the UDC Code Types application. Frequently these values are less then ten in
length and the value is then stored as right justified within the DRKY field in
the F0005 table. This makes Table I/O difficult when attempting to retrieve a
UDC description.
There are a couple recommended methods for retrieving a
UDC Description.
- Whenever
possible, use the Associate Description feature available within both
Report Design Aid and Form Design Aid. This feature will automatically
return a UDC description for a data item when that data item is associated
with a UDC table in the Data Dictionary.
- Use
a business function to retrieve the UDC description. There are two
business functions available and documented that will return a UDC
description. These are the business functions X0005 Get UDC and B4002070
Get/Update UDC Description.
Q46. How can you use SUBSTR text function in event rules?
The SUBSTR (sub string) text function is available within
the Expression Manager. This function allows the user to selectively extract
any part of a string variable. The SUBSTR function expects three parameters.
The first parameter is the name of the string variable that you wish to extract
characters from. The second parameter is the starting point within the string
for extracting characters. Keep in mind that the counting of characters in a
string begins at 0, not at 1. The third parameter is the number of characters
to extract.
Q47. How can you convert a Date stored in
either a Numeric Format or String Format into a JDE Julian Date Format?
There are numerous Date Business Functions available
within the J.D. Edwards software that can be used to convert dates into a JDE
Julian Date Format. Some of the available functions include B0800013 - Convert
String to Date, B41B0470 - Format Date from DMY, B910001 - Convert Julian Date
to JDE Date and B9800210 - Convert Julian to Date.
Q48.
What
Occurs when you perform a checkout of a Batch Version and where do the
Specifications come from?
When checking out a Batch Version the environment you are
logged into in OneWorld supercedes the activity rules specified in Object
Management Configuration. The batch version will check-out of the path code for
the environment you are logged into. For example, if you are logged in a
production environment, when performing a check-out on a batch version, the
specifications of the version are checked out of the PD7333 central objects
irregardless of the status of the project and activity rules associated with the
check-out function for that project status. This is only the case for batch
versions, not other objects and only during check- out.
Q49.
What
Occurs when you perform a Check-in of a Batch Version and What Path Code Gets
Updated with the Specifications?
When you check-in a batch version, whether you check it in
from Object Management Workbench or from Batch Versions, the version will be
checked into both the path code for the environment you are logged into in
OneWorld as well as the path code that is defined in the activity rules in
Object Management Configuration for the check-in action for your project
status. If you are logged into a prototype environment and check-in a version,
if the project that the version belongs to is at a status of 21, the version
will check into the prototype path code, based on the environment you are
logged into, as well as the development path code. The development path code is
updated because the standard transfer activity rules for a project status of 21
have the check-in action defined to check- in the information from the local
workstation to the development path code.
Data Dictionary
Q1. What is Data Dictionary?
A central repository containing data item definitions and
attributes, just like a dictionary contains word definitions. The data item
definition defines how the item is used and includes information such as the
type of item and its length. The Data Dictionary is active, i.e. a change is
effective immediately.
Q2. What are the
Data Item Attributes for?
- Determines how a data item appears
on forms and reports (i.e. number of decimals and default value).
- Validates data entry within an
application.
- Assigns column and row
descriptions on forms and reports.
- Provides glossary text for
field-level help (i.e. on a form control, press the F1 key or use the Help
“What's This" menu item)
- Defines how data is stored in a
table.
Q3. Where is the Data Dictionary stored?
The
Master Data Dictionary is stored in relational tables on the enterprise server:
a.
F9200
- Data Item Master
b.
F9202
- Data Field Display Text
c.
F9203
- Data Item Alpha Description/Glossary Overrides Information
d.
F9207
- Error/Workflow Message Information
e.
F9210
- Data Field Specifications
f.
F9212
- Smart Fields
g.
F00165
- Data Item Glossary Text
Q4. What are the Types of
Data Item Glossary Groups?
D -
Primary Data Elements
S -
Secondary Data Elements
Ø No different from a D glossary group
data item.
Ø Assigned by the Data Dictionary
application when creating a group of Data Items.
C -
Data Item Class
Ø A way to create a class that is then
used to group several data items that share the same attribute such as display
decimals, i.e. QTYINV, CURRENCY
K -
Smart Field
Ø Special Data Items used for specific
application report templates in Report Design Aid.
E -
Error Messages
Ø Used for error messages within OneWorld
applications.
Y -
Workflow Messages
H -
Processing Option Glossary
NOTE:
Only Glossary Groups D and S data items can be used as attributes of a table.
Q5. What is the Difference between File Decimals and Display Decimals?
The
difference between file decimals and display decimals
Ø Has to do with the way the data is
stored in the database.
Ø You have to use one or the other and
cannot use both.
File
Decimals
Ø Defines the number of decimals that are
stored to the right of the decimal of the data item within the table.
Ø Must never be changed for existing JDE
data items.
Example:
File Decimals = 2
Displayed by OneWorld as 1.23 Stored in Database as 1.23
Display
Decimals
Ø Designates the number of decimals to
display for a data item
Ø Display decimals are for display
purposes and are not stored in the database tables.
Ø Changes to the display decimals on a
data item do not convert any existing data already in the tables.
Example:
Display Decimals = 2
Displayed by OneWorld as
1.23 Stored in Database as
123
Q6. What are the Packed and Zoned for
Numeric Data Items on the AS/400?
Packed and Zoned are data item storage
types for the AS/400. Zoned is readable (numeric unpacked) and Packed is
encrypted when using the AS/400 command DSPPFM to display the contents of a
table.
When a Numeric data item with a length
greater than five is used as a table column on the AS/400, the table column is
created in Packed format; otherwise it is created in Zoned format. This occurs
by default and cannot be changed by the user.
Q7. Where is the Data Dictionary Item
Glossary stored?
The Data Dictionary Item Glossary is stored in the F00165
Media Object Table. This table exists in its own Data Dictionary data source
generally named Data Dictionary - B7333. The glossary information is stored
using the Media Object data structure GT92002. This data structure is mapped to
the Data Dictionary data source via Object Configuration Manager (OCM).
Q8. How can you find out, which Data Items
have been modified in Data Dictionary?
Run report R920022 - Print All Data Dictionary Adds and
Changes. The report displays the following fields from the F9200 - Data
Item Master: Date Updated, DD Alias, User ID, Program ID, Workstation ID and
Time Updated.
Q9. How do you print a list of Data
Dictionary Items?
R92400 prints Full Detail for a Data Dictionary item, with
Processing Option to Print Glossary Text. R92401 prints Specifications of
Error/Workflow messages i.e. Error Level & Data Structure Templates.
Q10. How do you compare the Values of Data
Items in both the Data Dictionary Master and Data Dictionary Spec Tables?
Add
the entry below in the OneWorld Client JDE.INI:
[Interactive
Runtime]
TAMMenus=Show
In
Fast Path, key in UTB for the Universal Table Browser:
Ø
Click File|Open Table to find and view the Data
Dictionary master tables. Key in the Data Dictionary Alias in the QBE column
FRDTAI.
Ø Click File|Open Local TAM to view the
list of Spec tables, double click on DDDICT.DDB or DDTEXT.DDB, key in the Data
Dictionary Alias in the QBE column szDict.
JD Edwards Best Practices
1. Use of
Handles
Handles allow the users to perform several operations that
can not be done using regular non-handle table I/O operations.
· You can use
handles to concurrently open multiple instances of a single table or business
view.
· You can use
handles to open a table or business view in an environment other than the
environment you are logged into.
· You can
pass handles into a form, named event rule or business function so that you do
not need to open a table or business view more than once.
2. Use a
Single-table or multiple-table business view?
When an application needs to access data from multiple
database tables, you can accomplish this in two ways:
· Use a
multiple table business view to access all the related data fields.
· Use a
single table business view to access the data fields from the primary table and
use a business function or table I/O to access the data fields from secondary
tables.
The best choice is not always obvious, but you can usually
decide by looking at the resulting number of database I/O operations that will
be performed. A joined business view that uses cross data source joins causes
slower performance.
If the secondary tables are master files, the first option
is usually preferable because it makes best use of database caching. For
example, suppose the primary table contains a company number and the related
company name is store in a secondary company master file. If, in practice, it
is likely that the same company master record will be retrieved for several
records in the primary table, then it is usually preferable to fetch the
company name explicitly using a business function or table I/O.
3. Restrict the
number of fields in a business view
Create new business views with only the desired fields.
Minimizing the number of fields in a business improves the runtime performance.
4. Table Design
considerations
· Try to use
existing indices for a table. Adding an additional index will almost always
improve the performance when selecting and fetching data from database.
However, each additional index adds maintenance overhead when records are
added, updated or deleted in the database. The decision about adding a new
index should balance these two factors.
· Use a
partial key only for fetch next.
5. Balance
Table Open and Closes
Be sure to match each jdbOpen with a corresponding jdbClose
within the same business function. Serious performance problems can arise from
unbalanced table opens and closes.
6. Restrict the
number of fields in a Data Structure
Minimizing the number of fields in a data structure improves
the runtime performance. This is particularly required when the data structure
is passed between work station and
Server.
7. Data
Sequencing in Reports
Selecting indexed columns in data sequencing improves the
runtime performance of the report.
8. Setting
Level Breaks
If the sort definition for a report section is KCOO, DOCO,
DCTO, LNID and you want to have a level break on DOCO, the level break
indicator must be set for all four fields. This will improve the run time
performance.
9. Use of
Caching
Use JDECACHE functions to access XREF tables instead of
regular table I/O. This improves the runtime performance by minimizing the
number of database I/O operations.
10. Handling
Large Files
Copy the large files into temporary JDE tables and use them
instead of directly accessing the large files. This improves the run time
performance by making use of table indexes.
Table Conversion
Utility (TCU)
Q11. What is a processing option and where
do you attach it in a TC?
It a
run time user input and you attach the PO in the “External Data” of the
navigation window.
Q12. What is difference between User Insert
Row and TC Insert Row?
A User
Insert row can be defined anywhere but TC Insert has to be defined at the end
of the event.
Q13. What is a business view?
Business
view is a link between application and data. Business view is generated on one
or more tables.
Q14. What is the flow of Events in a TC?
Process
begin, Data Changed, Row fetched, Format Fetched and Process End.
Q15. What type of Conversion you can do in a
TC?
Data
Conversion, Data Copy, Data Copy with Input Table and Batch delete.
Q16. Why is User defined format used?
It is
used to deal with fixed-width or Character separated value (CSV) in a table or
a text file.
Q17. When is the data changed event invoked?
Each
time the value in the column defined in the sequencing changes, the event is
invoked.
Q18. What is use of a handle?
It is
used to create multiple instances of a table in the same TC. To safe guard the table, it is advisable to
use handles or business view.
Q19. How many output can be attached in a
Batch delete?
None.
Q20. 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 1 record.
Q21. What is foreign table?
Non-JDE
table are called foreign table not defined by One World.
Q22. How many inputs a TC can have?
One.
Report Design
Q1. What are the various types of detail
sections available with Report Design?
Columnar,
Group and Tabular
Q2. What are the features of a Group
Section?
They
are characterized by free-form layout and are not restricted to standard row
and column layout. This section is most flexible and users can place the fields
anywhere in the group section.
Q3. What is the main difference between
Tabular and Columnar section?
Although
they look similar, Tabular section has built-in spread sheet functionality.
This makes tabular sections suitable for presenting numerical data that has to
be summarized with sub-totals and grand totals.
Q4. In an existing report, what happens if
a column is removed from Level Break?
It
will cause unpredictable results.
Q5. What is the standard horizontal spacing
for CSV report output?
52
pixels
Q6. What is a 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 smart field template,
which is based on a particular business view. Its glossary, type is K
Q7. What happens if the business view
attached to a detail section is not same as the business view required by the
smart field template?
The
report section will not function properly.
Q8. 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.
Q9. What is a Subsection Join?
A join
that is established by joining two sections in a report (parent and child)
using common fields that exist in two different business views is called as
Subsection Join.
Q10. What is the use of Text Variables in
reports?
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.
Q11. What is the use Custom Sections in
reports?
Custom
Sections allow you to control, through event rules, the information that prints
on a report. We can use Custom Sections to print additional information
depending on certain criteria.
Q12. How do you invoke Custom Sections?
Using
the system function DO_CUSTOM_SECTION.
Q13. How do you print text attachments in a
report?
Using
Media Object System functions.
Q14. Is it 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/SeqFromASection.
Q15. Is
it possible to do transaction processing from reports? How?
Yes,
using the transaction processing functions Begin, Commit and Rollback
Transaction business functions.
Q16. When
does the Advance Section Event occur in a report?
Occurs
when each time you do a fetch from the database.
Q17. When
does the AfterLastObjectPrinted Event occur in a report?
Occurs
after a row is printed to an output file. It is used to process information
after a row has been output.
Q18. Is
it possible to change printers at runtime (while a report is running)? How?
Yes,
using system function K2DoInitPrinter.
Q19. Is
it possible to print Bar Codes from OneWorld reports?
Yes, but the printers must support PostScript and PCL
printer definition languages.
Q20. What
is the use of Report Data Structures?
Report Data Structures are used to pass the parameters to
the report when it is called from another report/UBE.
Q21. How
can you use Event Rules to print Media Object Text attachments on a report?
The Media Object system functions allow you to select the
appropriate Media Object Data Structure, map the appropriate keys for this data
structure and perform a "GetText" function to retrieve a text media
object and return the information to a report variable to print on the report.
Q22.
If one want to make changes to a version of a
report layout, what should one do ?
Override the Version Specification
You
have a Purchase Order (PO) report with the fields: PO Number, Line Number,
Description, Amount. One PO will have multiple line numbers. PO number should
be displayed only once. This means every time a PO changes, the number should
be printed only on the first line.
Referring
to the above scenario, how is this accomplished?
Properties -> Advanced Tab
Q23. Which one of the following do you select to get the JDE data
source while submitting the report?
Override location
Q24. How many business views can be
selected for a given section?
One business view
Q25. Which one of the following Edit Codes
do you choose for "Zero Suppress?"
Z
Q26. You have created a favorite sub-folder.
Referring
to the above scenario, who is the owner?
Parent
Q27. How many business views can you attach
to a favorite folder?
Five
Q28. Which one of the
following section types has a "free-form" capability?
Group
Q29. How do you get the
logging/tracing enabled for a version run in spite of logging being disabled in
the JDE.INI file?
Right-click the version and choose view system log.
Q30. You are designing
the report "R55500." "T55500" (Processing Option) is
attached to the report. At the end of the development, you select
"Preview" option to view the contents of the report.
Referring
to the scenario above, while running the Preview option for the given UBE, how
are the processing option values passed to the UBE?
The values are picked up from the version you have selected.
Q31. You have two
reports: "R55100" and "R55200" You want to adopt sequencing
specifications of one of the sections from "R55200" into
"R55100."
Referring
to the above scenario, which one of the following system functions do you
choose?
Use data selection/sequencing from a section.
Q32. How do you write a
description for a business view that is already attached to a sub-folder?
No description can be attached to a sub-folder.
Q33. Which one of the
following UBE logging levels do you choose to obtain log error messages,
informative messages, section level messages, object level messages, ER level
messages, and SQL statements?
Five
Q34. In a tabular
section, which one of the following events is used to process the data after
each record is fetched?
Column Inclusion
Q35. When you check out
a version on your machine, a confirmation box appears asking if you would like
to overwrite local specifications
Referring
to the above scenario, why does the confirmation box appears?
This box always appears by default.
Forms
Q1. Name the different types of forms
available in JDE?
Find/Browse,
Fix/Inspect, Header Detail, Headerless Detail, Parent/Child, Search and Select,
and Message
Q2. What is the difference between an
Application and a form?
An
application can have more than one form.
Q3. Which type of form is the entry point
to an Application?
A Find
browse form
Q4. If you want to view multiple records
from one table, which form should you use?
Find
Browse
Q5. Can we attach more than one view to a
Find Browse form?
No
Q6. What is the basic difference between a
Fix inspect and Header detail form.
A fix
inspect form can use only one business view and can update only one table.
Where was a header detail form uses two business views.
Q7. How do we use a search and Select form?
A
search and select form is always used to locate a value and return the same to
the calling field. The search and select form is called using a visual assist.
Q8. Can we attach multiple views to a
search and select form?
No
Q9. What kind of form gets displayed in 'Employee
work center'?
Parent
child
Q10. What is the difference between a
database item and dictionary item pertaining to forms?
Database
items are used to store and update database. But a dictionary item’s use is
limited to event rules only.
Q11. Does it always requires to associate an
edit control with a dictionary or database item? If yes why?
Yes,
an edit control field does not have a text attached. Its takes the text of data
item associated to it.
Q12. In a find browse form how should be the
grid sequencing/sort order, which will not affect he performance?
The
sort order should partially or completely match with the table index.
Q13. What is a parent/child form?
It is
a type of form that presents parent/child relationships in an application on
one form. The left portion of the form presents a tree view that displays a
visual representation of a parent/child relationship. The right portion of the
form displays a detail area in browse mode.
Q14. What is a Modal window?
It is
a window that restricts a user’s interaction with other windows unless it is
closed.
Q15. How do you set and clear an error on a
control in an Interactive Application?
System functions are available to set and clear errors on
a control. Under the Control system functions the system functions Set Control
Error and Clear Control Error are available. Under the Grid system functions
the system functions Set Grid Cell Error and Clear Grid Cell Error are
available. The system functions to set an error require that a Data Dictionary
Error Message be sent to the system function in order for an appropriate error
message to display within the application.
Q16. How can you determine what tables are
updated by a specific form?
In order to determine what tables are updated by a
specific form, you must determine the business view being used by the form. In
order to do this, double click on the form within Form Design Aid. The
description of the business view will display on the section properties form.
Then within Object Management Workbench, you can search for the business view
based on its description. Once you locate the business view, add it to a
project and select design. Then select the option for the Business View Design
Aid. Within Business View Design Aid you can determine the table(s) that are
included in the business view. This shows what tables will be updated by the
form using that business view.
Q17. How do you use a Combo Box?
The Combo Box has limited functionality within the
software. It was originally designed for web use only, but can be used on a
Window's client also. To use a combo box, it needs to be associated to a data
dictionary item that points to a User Defined Code table. Then the combo box
will display a list of the User Define Code values in the pull down window. The
steps to accomplish this within Form Design Aid are:
Ø Add a combo box to the form
Ø Highlight the combo box and under the
Edit pull down menu, select the option for Associate.
Ø Associate the combo box to an
appropriate data dictionary or business view variable.
Ø
Run
the application. The User Define Code values for the associated data item will
appear in the drop down box.
To pre-populate a value into the combo box, use the
"Select Item" system function under the Combo Box Functions.
Q18. How do you make Radio Buttons mutually
exclusive?
Associating two or more Radio Buttons to the same
data dictionary or database item makes the Radio Buttons mutually exclusive.
Q19. What determines the value that is
returned from a Search and Select Form?
The value that is returned from a Search and Select Form
is based on the data structure that is assigned to that form. Generally the
data structure associated with a Search and Select Form should only contain one
item in the data structure and that is the value that you wish to return from
the form.
Q20. Can you modify a version of an
Interactive Application within Form Design Aid?
No. Versions of interactive applications do not have
specifications. All design changes to an interactive application must be made
at the template level. Multiple versions of Interactive Applications are used
only to establish different processing option values for the application.
Q21. How does a form that allows for adds
and updates determine whether it is in Add mode or Update mode?
Upon initially opening a form, a SQL select occurs based on
the key values of the form. If a record is retrieved from that select
statement, then the form is in Update mode. This generally occurs when data is
passed to the form within the form interconnect. If no record is retrieved,
then the form is in Add mode. This generally occurs when calling the form
without passing data into the form interconnect.
If a corrupt record exists in the table with all
blanks/nulls in the key fields, the application will select it upon initially
opening the form and put the form into update mode. It will not go into add
mode unless no record is found when doing the select. Removing the corrupt
record will resolve this potential issue.
Q22. How do you indicate that a field is a
required field on a form and have an error result if the field is left blank?
Within the Control Options for a field, there is a check
box for "Required Entry Field". Selecting this check box indicates
that a field is required and will provide an automatic error at runtime if the
field is left blank. This option is accessed by selecting the Options button
within the Control properties.
Q23. How do you define a grid within a form
in an application to work with Multiple Select?
The steps to setup a grid to allow for multiple select are
to mark the Multiple Select grid property for the grid and select the
"Repeat for Grid" setting under the Options pull down within the
event rules defined for the menu/toolbar exit. Multiple select will only work
when the interconnect is not defined as modeless.
Q24. How do you add a Bitmap to a Row or
Form Exit?
A bitmap strip can be assigned to the beginning
category of menu/toolbar exits. Then all exits within that category will have
the bitmap strip available and individual bitmaps can be selected for each
exit.
Q25. Is there a way to prevent a Header
Detail form from exiting upon pressing the OK button?
If the interconnect that is used to call the Header Detail
is defined as a modeless interconnect, the form will not exit upon pressing the
OK button. If the Header Detail has been defined as the entry point, there is
currently no way to prevent the form from exiting when the OK button is
pressed.
Q26. How do you get a Header Detail to
automatically load the grid with the appropriate information when the form is
opened through a Form Interconnect?
Create the appropriate key fields as filter fields in the
header portion of the Header Detail form. Select the grid property option of
"Automatically Find on Entry" to preload the grid upon entry into the
form based on the key values populated in the header through the form
interconnect.
Q27.
How
can you modify a standard J.D. Edwards application to add new fields to the
form grid?
Many of the large transaction entry applications within
the J.D. Edwards software use Master Business Functions to add and update
records to the tables rather then using the business view. The forms are
defined to update using these Master Business Functions rather then using the
business view, so adding a new business view field will not update the table.
In order to update the table, the new field must be passed to the appropriate
parameter within the data structure of the Master Business Function (assuming
the field is available within this data structure). This is true of numerous
standard J.D. Edwards applications including Purchase Order Entry (P4310),
Sales Order Entry (P4210), Voucher Entry (P0411), Invoice Entry (P03B11) and
Journal Entries (P0911).
Q28.
How
can you debug problems associated with form adds, updates and deletes?
Turning on logging within the jde.ini will produce logging
messages in the jdedebug.log that
will show the SQL statements that are a result of pressing the Find button or
performing an Add or Update within a form. These SQL statements will show what
data and tables the system is attempting to update. Reviewing these SQL
statements can provide important information as to why an update is not
successful.
Find/Browse
Form
Find/Browse is the entry point to an applivation. It contains an optional query by example (QBE) line so you can search on any database field in the grid. QBE columns that are grayed out do not have QBE capability (for example, sold To Name in the example above)
Fix/Inspect
The Fix/Inspect form allows you to add a new record to a table or to update an existing record. The Fix/Inspect form includes OK and Cancel buttons. When you click OK, updates ot additions are written to the Table. When you click Cancel, any changes you have made are lost and no database changes are made because the Fix/Inspect form only allows you to add or update one record at a time, the form does not contain a Grid.
Header Details Form
The Header Detail form allows you to work with data from two separate tables. You can use this form to add or update a single header record. You can also add, update or delete multiple detail records from the same from.
The Header Detail form includes an input-capable grid so you can add or update Detail Records. Click OK to perform updates or adds to both tables on the Form. When you click Cancel, any changes are lost and no database changes are made.
Because the Header Detail form allows you to update or add records from two different tables, you can attach two business views to a Header Detail form. Attach one business view to the grid and the other to the form, updating both tables from a single form. You can use the Header Detail form for one to many relationships.
Search and Select Form
Message Form
Headerless Detail Forms
Parent/Child Form
Business Functions
Q1. What is a Business Function?
An
encapsulated set of business rules and logic that can normally be reused by
multiple applications. Business functions can be combined with other business
functions, forms, event rules and other components to make up an application.
Business functions can be created through event rules or C language.
Q2. What is the use of MATH_NUMERIC?
The
MATH_NUMERIC data type is used exclusively represent all numeric values in one
world. The values of all numeric fields on a form or a batch process are
communicated to business functions in the form of pointers to MATH_NUMERIC data
structures.
Q3. What is the use of header files in
business functions?
Header
files are necessary to help the compiler properly create the business function.
Functions are defined in various header files you include at the beginning of a
business function. With out header files, the compiler does not recognize the
functions and may return error messages.
Q4. What is a Named Event Rule (NER)?
It is
a Business Function created using Event Rules scripting language.
Q5. How do you create a custom DLL?
By
creating an object in OMW with the type Business
Function Library.
Q6. What is the use of Business Function
Builder?
It is
used to build business function code into a DLL.
Q7. What is the use of JDECallObject?
It is
an API used by C business functions
to call other business functions.
Interoperability
Q1. What is Interoperability?
The
ability of different computer systems, networks, operating systems and
applications to work together and share information.
Q2. What are the types of interoperability
supported by JD Edwards?
Batch – EDI (Electronic Data Interchange), Interoperability
interface tables, Table Conversion
Interactive – Native One World APIs, COM and DCOM, JAVA,
CORBA, XML, MQ Series, SAP ALE, IDoc.
Q3. What
Q4. are the different processing modes
available in One World to handle transactions?
Synchronous – User establishes a connection to One World
and make real time calls to One World APIs and business functions. Results are
immediately available upon completion of the call. This method is typically
used for interactive applications requiring immediate user feedback.
Asynchronous – It allows an application to submit
transactions or requests to another application one at a time, but the requests
are queued up and processed in the background with out being directly connected
to the calling program. This allows an application to submit a request and
immediately continue processing without waiting for a result. Results are
returned through a separate process when the transaction is complete. This
method is typically used when real time feedback is not required, although fast
transaction response is still important.
Batch – It allows the users to save transactions over a
period of time and then run a periodic process that processes the entire group
of transactions at once. This method is typically used for large group of
transactions that must be transferred from one system to another on a periodic basis.
Q5. What is EDI and how it works?
Electronic Data Interchange is the paperless
computer-to-computer exchange of business transactions such as purchase orders
and invoices, in a standard format with standard content.
When computers exchange data using EDI, the data is
transmitted in EDI standard format so it is recognizable by other systems using
the same EDI standard format. Companies who use EDI must have translator
software to convert the data from EDI standard format to their computer
system’s format.
Q6. Is it advisable to load data coming
from external systems into JDE directly?
No,
due to data integrity
Q7. What facility does JDE provide to
achieve this purpose?
Interoperability
Q8. What is an interoperability table
commonly called?
Z-
file
Q9. What is a Store and Forward
transaction?
It is
a transaction method that allows the client applications to perform work (store
it in Z files) and at a later time, complete that work (update JDE tables using
master business functions) by connecting to the server.
Q10. Can we call a Z-file as a JDE table? If
No why?
No, as a Z file has no relation to JDE business
logic. The data residing in z-files becomes obsolete once it’s moved
successfully into related JDE tables.
Work Center
Messages
Q1. How are Work Center Messages stored?
If the message is an
active message, the message will be in the F01131 Message Control Table, F01133
Message Detail Table and F01131T Message Attachment Tag File and the records
will all have the same SERK or Key Value Serial Number.
If the message is a
multi-level message, the way they are displayed in the Work Center and
ultimately how they get deleted with the purge program is done with a
parent/child type of relationship. These type of multi-level messages are
stored in the F01131M Multi Level Message Table. The first F01131M record that
is written will have the same SERK number as the parent F01131 record. That
same record has an additional SERK number in the same F01131M record. This
second SERK number is the "child" and points to the next F01131M
parent. It is this recursive relationship that makes it possible to have one
F01131 record and many F01131M records. We use this same recursive relationship
for deciding which F01131M records get deleted when running the purge process.
For example:
A UBE has an error and it creates a F01131 record with the number 100 as its
SERK number.
Table F01131
Record 1 = SERK 100
Multiple F01131M records can be produced for detailing what that error was:
Table F01131M
Record 1 = Parent SERK 100 Child SERK 200
Record 2 = Parent SERK 200 Child SERK 300
Record 3 = Parent SERK 300 Child SERK 400
Record 4 = Parent SERK 400 Child SERK 500
Record 5 = Parent SERK 500 Child SERK 600
Each additional parent SERK (records 2, 3, 4, and 5) that is created has a
record in the F00165 Media object table that displays text just like a F01131
record, but these records do not exist in the F01131 table because they are not
needed. So although there are five parent SERK numbers in the F01131M there is
only one true parent in the F01131 used for the starting point.
The actual text of the message is encoded and stored in the
F00165 media object table using the GT01131 data structure with GDTXKY as the
key. For example, if there is a record in the F01131 with ZZSERK = 32526, the
actual text of the message is in the F00165 where GDOBNM=GT01131 and GDTXKY =
32526.
Q2. How do you purge Work Center messages?
The batch process R01131P - Purge Completed Tasks can be
used to purge messages in the Work Center.
Q3. Why do Work Center Messages Need to be
purged?
Many processes within OneWorld send messages to
the Work Center including workflow processes and UBE completion messages. The
message tables get large quickly. Messages in the work center need to be purged
regularly. This will improve performance. Also sometimes orphaned records can
appear in the F01131M and cause problems. Purging the message fixes the problem
most of the time. Setting up the R01131P purge program within the scheduler is
one way to schedule the process to run on a regular basis. If the table already
has orphaned records, you have to use SQL to clear them.
Q4. How can OneWorld be Set Up to Send
Messages to External Mail rather then to the Work Center?
By adding the appropriate jde.ini setting in the
[JDEMAIL] section of the client and server jde.ini and also defining the
appropriate e-mail preference and e-mail address for address book records
within OneWorld, work center messages can be sent to an external mail system
such as Outlook and Lotus Notes.
Q5. Are Multi-Level Error Messages Sent to
External Mail?
Multi-level drill down messages created by certain Batch
Applications within OneWorld are always sent to the Work Center. Currently the
functionality does not exist to send this type of drill down messages externally.
If the user's e-mail preference is external, they will receive a message that
the UBE process completed with errors, however the specifics of the error
messages will need to be viewed through the work center.
Q6. Can the UBE Completion Messages be Disabled?
There is not a way at the system level to
disable the completion messages sent whenever a UBE report completes. There is
an available API that can be used in a business function that is called within
an individual report to disable the UBE messages. The API is "BOOL
ubeReport_DisableSendMessage(LPBHVRCOM lpBhvrCom)". A business function
calling this API can be hooked up on any event in a report and this would
disable the job completion messages for this specific UBE report.
Q7. Is it possible to view the messages of
another user through Work Center?
There are a couple different methods available
to allow a user to view another user's Work Center messages. Security can be
defined within the Queue Security application (P01135) to allow a user access to
another user's messages within specific queues. An administrator can use the
Employee Queue Manager Application (P012501) to view all queues and all
messages for a user.
General JD Edwards Questions
Q1: What are User Defined Codes?
A: J.D. Edwards software lets you create
user defined code values (UDCs). User defined codes use table values to define
the allowed values for an input-capable field without having to make program
changes. Some examples of user defined code fields include: State and province
codes, Spending account codes, Unit of measure codes, Search Type, Language
Preference etc.
Each system has its own user defined
code types. When a J.D. Edwards program encounters a user defined code field,
it checks the data that the user has entered against the table of valid values.
If no match is found, the program issues an error message.
Q2a What are Category Codes?
A: Use category codes to define additional
codes that describe or categorize items for management reporting,
consolidation, totaling, and characteristic identification. A category code is
a user defined code for which you define the code title and the valid values.
E.g. Branch, Account representative etc.
Q2b: How
Are Category Codes Defined?
A: The user
defines how the code will be used. For example: Category code 1 = Branch
Category code 2 = Account Representative. The user also defines the valid values of
the code. For example: Branch: DEN = Denver Branch, Salesperson: ROD = Rod
McLind
Q3: Mention the two identifiers used to define
an UDC?
A: Each
User Defined Code field corresponds to a system code and a user defined code
type.
You need to know these identifiers
when you assign values to data. E.g. 01/ST Address book / Search type
Q4: How many category codes does Address Book
contain?
A: 30 Codes
Q5: What is the difference between users
defined codes and category codes?
A: UDC's are individual values you create
and define. Examples are Search Type and State.
Only the valid values are user
defined. With category codes, you define both their use (title) and the valid
values
Q6: Mention the list of status attached to a
JOB.
A: ACTIVE, OUTQ, DSC, JOBQ, TRFOBJ,
TTRFRBCH, FIN, END, EOJ, MSGW,SCD JOBLOG PENDING.
Q7: How to review a processed report?
A: On Work with Submitted Jobs, Enter
8 in front of your completed job (Work
with
Spooled Files)
Q8: What is the Master Directory?
A: The Master Directory lists the main
product groups that J.D. Edwards offers. The Master Directory is a menu of
menus; every selection from the Master Directory accesses the main menu for
that system.
Q9: Mention the major technical files in Data
dictionary
A: Master F9200 Data
Field Specs F9201
Data Field Display Text F9202 Alpha Desc F9203
Data Item Aliases F9204 Error
Msg Prog to Call F9205
Glossary Text F9816 Glossary
Text Key F98163
Q10: Mention the major technical files in Dream
writer
A: Definition
F98301 Values
and Ranges F9831
Extended Params/Titles F98311 Processing Opt Text F98302
Values for Process Opt F98303 Printer File Overrides F98312
Q11: Mention the major technical files in menu
A: Menu Master (Header) F0082 Selection Detail F00821
Menu Selection Text F0083 Menu Selection History
F0083H
Q12: Mention the major technical files in UDC
A; Valid
Code Types F0004 Valid
Values for Code Types F0005
Q13: Mention the major technical files in VO
A: Vocabulary
Overrides F9220
Q14: Mention
the major technical files in Function Key Translation
A; Master
File F9601 Detail
File F9611
Function
Key Security F9612
Q15: Mention the major technical files in Cursor
Sensitive Help
A Master
File F9620 Detail
File F9621
Q16: Mention the major technical files in
software version repository
A: Master
File F9801 Detail
File F9802
Q17: Mention the major technical files in user
control
A: User
Library List Control F0092 User Library
List Member F0093
Library List Master F0094 User Display Preferences
F00921
Q18: Mention the major technical file in
pre-open of files
A: Pre-Open
File F0095
Q19: Mention generic messages/rates file
A; Types
F0019 Records F00191 Detail F00192
Q20: Mention generic text file
A: Generic
Text F0016 Window
Definition F00161 Key Definition
F00162
Q21: How to sign off the system?
A: To sign
off, enter one of the following four values into the Selection line of any
menu:
·
Two periods (..)
·
90-this is the Hidden Selection for signing off.
·
The command Signoff if the system allows IBM Command
Entry.
·
30-used with J.D. Edward's Multi-Library List Function
J98INITA
Q22. Explain the
LODRUN Process
A: The
following is an overview of the LODRUN process:
Submit the LODRUN command. This is an
IBM command that installs the libraries needed for the remainder of the
process.
The LODRUN procedure puts the
following new libraries onto your machine:
JDEINSTAL - installation programs
JDFINS - upgrade planner
LODRUN also creates the user profile
JDEINSTAL.
After the libraries have been added to
the system, LODRUN sends a message to sign on as JDEINSTAL. After you sign on,
the Software Upgrades Menu displays. You can then create your install plan.
Q23: Explain Creation of an Install Plan
A: After the LODRUN process, create a
plan. The plan details the release level
you are installing as well as all the systems sent on the tape. After the plan is complete, the next step is
to restore the software.
Q24: Explain the Main Software Installation
Process
A: The
installation tapes you receive from J.D. Edwards contain the following
libraries:
·
JDFINS - objects used to plan installs and upgrades
·
JDEINSTAL - objects that drive the installation
process
·
COMFILE - common files
·
#JDFDxx - test
data files
·
#JDFOxx -
execution objects
·
#JDFSxx -
source objects where xx is the system
code, such as 01 (Address Book)
Restoring the software fills JDFDATA
with J.D. Edwards pristine data files. J.D.
Edwards recommends that you keep
JDFDATA on your system as a test environment and as a model on which you base
your production libraries. The J.D. Edwards response line often uses JDFDATA in
problem determination.
The restore process creates these user
profiles:
·
JDE - for the J.D. Edwards data library (JDFDATA)
·
JDEPROD - for your data library
Q25: What Libraries Does J.D. Edwards Install?
After the software restore, the
following three libraries exist. They are:
The Source Library (JDFSRC).
The source library contains source
code.
Within the JDFSRC library, J.D.Edwards
has three multi-member source files.
JDESRC contains Source code for:
·
RPG Programs
·
Printer files
·
Display files
·
CL Programs
·
DDS for Logical Files
·
DDS for Physical Files
JDECPY contains Source code for:
·
Common Subroutines
·
Action Code
·
Date Routines
F98CRTCMD (P01051 P04301)
Pre-compiler commands Used to compile
J.D. Edwards programs
J.D. Edwards specifies the source
library (JDFSRC) with a library type of SRC.
The Object Library (JDFOBJ)
The object library that contains
executable objects for your J.D. Edwards software. ( RPG programs CL programs
Display files Reports J.D.
Edwards specifies an object library with a library type of OBJ.)
The Data Library (JDFDATA)
The data library that contains test
data files for your J.D. Edwards software.
J.D. Edwards specifies a data library with a library type of DTA.
Q26: Explain the Post Installation Process
A: The post
installation process includes the following:
·
Install a cumulative update library if necessary
·
Build join logical in JDFDATA
·
Build Field Reference Files and J.D. Edwards Message
File
·
Create new production files
·
Perform special application jobs
Q27: Explain Library Environments in JDE
A: After installation of the software is
complete, you must create an environment for the software. An environment is a
named collection of libraries that contain files, programs, forms, and reports,
all under a specific software release level.
An environment also includes all
attributes that determine how that environment is set up, such as printer
overrides and J.D. Edwards users. The
library types are:
Production Library
A library you create to contain your
live J.D. Edwards data files. A special J.D. Edwards program facilitates this
process by creating all of the necessary data files that belong in your
production library. J.D. Edwards specifies a production library with a valid
value of library type DTA.
This library is created during the post-install
process.
Common Library
A library you create to contain your
live J.D. Edwards data files that are common to more than one environment.
These are data files such as your Data
Dictionary or help files. By maintaining
these types of files in one location, you facilitate standardization and
conserve on disk space.
A special J.D. Edwards program
facilitates this process by creating all the necessary data files that belong
in your common library. J.D. Edwards specifies a common library with library
type COM. This library is created during the post-install process.
Security Library
A library you create to contain your
live J.D. Edwards user profile files: F0092, F00921, F0093, F0094. and F0095.
Sharing the user profiles between
environments can minimize user profile maintenance. If you are setting up
multiple environments that have separate object libraries you must have
separate sets of security libraries. For example: if you have two versions of
J.D. Edwards software such as A7.3 and A6.1 you will probably need more than
one security library. J.D. Edwards specifies a security library with library
type SEC. Depending upon your install plan, the security library is
automatically created during the post-install process.
How many environments, production, or
common libraries you choose to maintain depends on your database and company
·
Never use JDFDATA in a production library list. When you upgrade, the J.D.Edwards software
would delete JDFDATA from your production library.
·
Never put custom code in the JDFOBJ or JDFSRC libraries
or your own data in the JDFDATA library. Upgrades of J.D. Edwards software
remove and replace objects and data from these libraries, which could cause you
to lose customized software or data.
·
Do not put objects in the JDFINS library, which is
replaced when you upgrade to future releases. Your custom upgrade plans in the
JDFINS library are preserved.
Q28: What are Model Plans?
A: J.D.
Edwards provides you with model plans when you first install, including:
ZJDE - Simple Production Environment
Plan
ZJDE_ALT - Alternate Environment Plan
For new installations, J.D. Edwards
recommends that you use the ZJDE model plan. Setting up plans with the Upgrade
Planner are discussed in detail in the install workbooks
Q29: Give Examples of Library Lists for
Environments?
A: Various
examples are as follows:
Production Environment - No Custom Code
QTEMP IBM Temporary
Library
JDFOBJ JDE Object
Library
CLTCOM Client's Common
Library
CLTDTA Client's Data
Library
CLTSEC Security Library
JDFSRC JDE Source
Library (Optional)
QGPL IBM General
Purpose Library
Production Environment - With Custom Code
QTEMP IBM Temporary
Library
CLTOBJ Client's Custom
Object Library
JDFOBJ JDE Object
Library
CLTCOM Client's Common
Library
CLTDTA Client's Data Library
CLTSEC Security Library
CLTSRC Client's Custom
Source Library
JDFSRC JDE Source
Library (Optional)
QGPL IBM General
Purpose Library
Development Environment
QTEMP IBM Temporary
Library
DEVOBJ Client's Custom
Objects in Development
TSTOBJ Test Objects
CLTOBJ Client's Custom
Object Library
JDFOBJ JDE Object
Library
DEVCOM Client's Common
Library for development
DEVDTA Client's Data
Library for development
CLTSEC Security Library
DEVSRC Client's Custom
Source in Development
CLTSRC Client's Custom
Source Library
JDFSRC JDE Source
Library (Optional)
QGPL IBM General
Purpose Library
Test Environment
QTEMP IBM Temporary
Library
TSTOBJ Test Objects
CLTOBJ Client's Custom
Object Library
DEVCOM Client's Common
Library for development
JDFOBJ JDE Object Library
DEVDTA Client's Data
Library for testing
CLTSEC Security Library
QGPL IBM General
Purpose Library