Wednesday 7 May 2014


 Part 1

  1. What is an Object in JDE? Define Some…
    Traditionally a OneWorld 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 OneWorld objects. Only used for Development &  Software deployment.
    Never used at runtime.
  3. What are Replicated Objects?
    Replicated Objects are stored in a directory on every workstation and logic server that will run OneWorld
    Built from Central Objects, Deployed via packages (‘point-in-time’ snapshot of selected objects)
    Stored in runtime (TAM vs. RDB) format
  4. What are Control Objects?
    Control objects are like buttons on the Form as Control obj. Fields on the Form are also control objects.
    We set control errors on the form design so that it stops the processing of error is set on the control.
  5. What are tokens?
    A Token has a One-to-One relationship with the following objects:
    Applications, Business Functions, Business Views, UBEs, Data Structures, Tables, Media Objects and Batch Versions
    The Token is used to minimize the possibility of one user overriding another user’s changes to an object.
    When an  object is checked out and is not already checked out by another user The project receives a Token.
    A Token can be released, switched or inherited.
    The Token is released by the project when the project reaches the status designated by the administrator for release.
    A Token is not released by the project when the object is checked back in.
  6. What is OMW?
    As a OneWorld developer I sometimes long for the simple days before XE.  I could check out objects from any environment and check them back into any environment. I could more easily view if an object was checked out and to who and which environment.  I could easily see what objects I personally still had checked out locally. I could also transfer objects from one environment to another with a few mouse clicks. 
The OMW was designed to replace the old tools we were used to using such as the Object Librarian, Promotion Manager, and Object Transfer.  I believe that the OMW is a great tool when it comes to developing for new projects.  I like the fact that I can group up all of the objects I am working on into a project so I never forget the objects I created or modified for the new module I am creating.  In the old days you would have to keep track of objects in a separate file to give to the CNC guy once it was ready to deploy. Using the old method, how many times do you remember leaving off 1 or 2 objects because you forgot to write them down?
  • Promotion Manager
  • Object Transfer
  • Object Librarian
  • Object Librarian Check-in Log
  • To Hide Object Management Tasks
  • To Provide Better Control of OneWorld Objects
  • To Unify all Development into One Interface
  • To Automate Change Management Process
  • To Provide Detail Logging of Objects
  1. What is Check In & Check Out?
    Check In – We send the updated specs to the server. It will replace the specs on the server with the specs which we are doing check in. User will not lose the Token.
    Check Out – It will override the local specs of the object which we are trying to check out. We will get the latest specs from the server. User will get the token
  2. What is the difference between GET & Check Out?
    Checking out an object allows you to modify the object and check it back in to Central Objects.  Performing a Get copies the latest specifications to your workstation but does not allow you to check in.  This is similar to erasing a check out for those familiar with previous releases of OneWorld.
  3. What are the Object Librarian and Non-Object Librarian Objects?
    Only Object Librarian objects have tokens and Non Object Librarian Objects do not have token.
    non-Object Librarian objects  are based on data source rather than path code.
    One World objects include the following non-Object Librarian objects: 
    • Data dictionary items
    • User defined code items
    • Workflow items
    • Menus
  4. What are the required fields when adding an Object?
    Object Name, Description, Product Code, System Code, Object Use

 Part 2


  1. 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
  2. How do you find information about Object usage in One World?
    Ans: – Use Cross Reference Xref which will give all the information about the object used in how many other objects. For log – Focus on the Object and choose Row, Logging to view log details.
  3. What is the difference between One World and One World Xe?
    Ans: – One World Xe needed JAS server cause all the objects we running on FAT client. And for web we required to have a JAS server. In One World we have all objects running on web only. We can make the applications to run on fat if required.
  4. What is Software Development Life Cycle
    Ans: – This is quality process. It starts from Scope definition, Estimation, Development, Testing and Rework, Deliver and close.
  5. What is JITI? How JDE Stores Specs.
    Ans: – Just In Time Installation. It stores on the local system.
  6. What is TAM?
    Ans: – Table Access Management (TAM) The JD Edwards EnterpriseOne component that handles the storage and retrieval of use-defined data. TAM stores information, such as data dictionary definitions; application and report specifications; event rules; table definitions; business function input parameters and library information; and data structure definitions for running applications, reports, and business functions.
  7. What are Global Tables?
    Ans: – global table files: dddict.*, ddtext.* and gbltbl.* (6 files)
  8. Name the Tools Provided by JDE for developing diff objects.
    Ans: – FDA – Form Design Aid RDA – Report Design Aid TDA – Table Design Aid VDA – View Design Aid
  9. What are the different project statuses? Brief them…
    Ans: – 21 = Development; 26 = Testing; 38 = Production
  10. What is default project?
    Ans: The first time a developer uses OMW a Default Project is created. The Default Project is named after the user’s ID. All development done outside of OMW is stored in the Default Project. Default Projects can not be advanced to another status code.

 Part 3

For What objects JDE maintains .h files?
Ans :- Tables and Business Functions
What are different Roles?
Ans :- Initiator, Developer, Lead, Manager, Administrator, QA
What is the significance of project Advancement?
Ans :- To advance the projects within different environments.
Like From Development to Testing, Testing to Production, Testing to Rework, Rework to Development. The purpose of having different environments is to have individual objects & data for each set of people, like developers, who would make and break objects or programs. Another set of functional people who make and break data. Neither of this should affect the Production data/objects, which should stay and work fine.
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

What is the meaning of Project Status Code 21?
Ans :- According to JDE std codes the project is in Development.
What is a Data Structure and what are the System generated and User Defined Data Structures?
Ans :- Used to pass parameter.
System Generated Data Structures
Form Data Structures
Report Data Structures
User Generated Data Structures
Media Object Data Structures
Processing Options Data Structures
Business Function Data Structures

 Part 4

  1. What changes must be made in jde.ini to view local TAM.
    Add line
     “TamMenus=Show” in [INTERACTIVE RUNTIME] section.
  2. Tables containing BLOBS and Generic Text are suitable for replication – True or  False.
    False.
  3. In Work with Server application, you can terminate a job with status =  W (waiting) – True or False.
    False. Only jobs with status P (processing) can be terminated.
  4. How many types of Data Structures are there? Name them.
    5. BSFN Data Structure : Processing Option Data Structure : Media Object Data Structure : Form Interconnect Data Structure : Report Interconnect Data
    Structure.
  5. Packages contain a set of Central Objects in a runtime format. – True or False.
    False. Packages contain a set of Replicated Objects in a runtime format.
  6. Handles (Table I/O) can be used to open a table or business view in only the environment you are logged into. – True or False.
    False. Handles (Table I/O) can be used to open a table or business view in an environment other than the environment you are logged into.
  7. Rita is a part of the accounting group profile. The accounting group has access to the G09 menu. Rita’s profile gives her access to the G00 menu.  
    Which menu will Rita see when she signs on to OneWorld?
    Only The G00 – Foundation menu, individual user settings override group settings.
  8. 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.
  9. What glossary group does a Smart Field Data Dictionary item belong to?
    Glossary Group K
  10. What are three types of User Generated Data Structures?
    Media Object Data Structures, Business Function Data Structures,Processing Option Data Structures

 Part 5

  1. What are smart field?
    Smart fields are the fields, which provide the ability to add complex and reusable calculations to the report.
    Smart field are grouped by smart field template, which is based on a particular Business view.
    Smart field glossary type is K
  2. Where are smart fields used?
    Smart fields are mainly used in tabular reports and financial reports.
    They can also be used in Group and columnar sections, but on level break footers only.
  3. What all steps needed in creation of smart fields?
    Create a DD item of glossary type K,
    Create a DSTR for the BSFN associated with smart field.
    Create Named mapping for the Data structure.
    Create a BSFN.
    Attach this BSFN at DD level  in the smart field row exit.
    Create a Smart field template through P91420 Application.
    Use this Template in Report template.
  4. What type of conversion you can do in a TC (Table conversion)?
    Data Conversion, Data Copy , Data Copy with Input table and Batch delete.
  5. How many inputs  TC can have in a Data conversion?
    One
  6. Is it Advisable to load data coming from external systems into JDE directly?
    No, due to data integrity
  7. What facility does JDE provide to achieve this purpose?
    Interoperability
  8. What is the standard horizontal spacing for CSV report output?
    52 Pixels
  9. How do you print text attachments in a report?
    Using Media object system functions
  10. Is it possible to print bar codes from one world reports?
    Yes , but the printers must support PostScript and PCL printer definition languages.

  Part 6

  1. Do Interactive Versions need to be checked in?
    NO. You don’t need to check in an interactive version. All that an interactive version has is processing options. There are no specs like the batch version has (ER overrides, selection, seq, layout overrides etc.)
  2. Are Path Codes and Environments Same?
    No, they are different.
    A path code is a set of objects and versions. In a typical system, you will have Pristine, Development, Prototype, and Production. Each of those is a path code with its own set of objects and versions. If you take any object as an example, it exists multiple times.
    For e.g. P4210 is Sales Order Entry and in a standard system, P4210 exists in 4 path codes, or 4 sets of objects.
    An Environment is made up of a path code + Mappings. Mappings determine which Data Source to use and where to run the business logic i.e. BSFN, UBE’s etc. So in effect Environment determines which objects can use which set of data, and where it executes. So if you have an Envt – say PD900 it uses Objects from Production, and the data-source say Business Data – PD.
  3. Do the Security Changes for a user take effect immediately?
    No. The user has to sign off, and then sign in again for security changes to be in force.
    When a user signs into EnterpriseOne, certain table records are inserted into memory for quick and easy access. One of those sets of records is security. The F00950 table is read and records from the *PUBLIC, your user profile, and/or the group or user roles attached to your profile, are written into memory. These are stored for your profile to use quickly.
  4. I did a User Override in an application in PD; will it be visible in my PY environment?
    User Overrides are dependent on the Path Codes. If both your PD and PY envts use the same path code, the overrides will be visible. Else not. Additionally, Overrides are also dependent on the version, so one Object1|Version1 might have one override, while Object1|Version2 can have another.


  1. What are the JD Edwards EnterpriseOne components (Servers  & tools etc)
    • Databases
    • Deployment server
    • Enterprise (business logic) server
    • Web application server
    • Portal Server
    • Integration Server
    • Transaction Server
    • Performance Monitor
    • JD Edwards EnterpriseOne tools and administration applications
    • Third-party tools
  2. Do server log files need to be secure?
    Yes. Log files may contain sensitive  user information (e.g. TIN/SSN, contact info), location of DB, and other specifics. There’s a catch though -  Server Manager will not be able to display the logs if security is implemented on log files.
    Also the print queue folder should be secured.
  3. What is preferable when it comes to User input for Data selection – Processing Options or Override Data selection (run-time)?
    Processing Options: because, you can limit the fields on which data selection can be done. If you give away the security for override data selection to users, they may put additional data selection, or modify the existing criterion, rendering the Report/UBE unusable.
  4. What are Vocabulary Overrides?
    Vocabulary Overrides (VO) are known as soft coding because changes can be made to individual texts/videos and reports without changing values in the Data Dictionary or having to use Screen Design Aid or Report Design Aid. They exist at the following location - Menus:13/G90, 8/G92. Fast Path: VO. Reports: 5/G9131
  5. How to preserve Vocabulary Overrides during an ESU or Upgrade ?
    • Go to GH9011/Specification Merge Selection (P98401)
    • QBE Search for appl and
    • Verify following for Location=<Deployment Server>
    • Mod Flag=C (Changed)
    • Mod Flag is updated to C when the Appl is checked in or after clicking OK in Vocabulary Overrides Application. If it is not equal to C, go back to Vocabulary Overrides Application and click OK again.
  6. Mrg Opt=1 (Merge), provided Mod Flag = C
    • Mrg Opt (merge option) is defaulted from the Merge Option column if set up in Pathcode Master, otherwise use row exit- Enable to set Mrg Opt=1
  7. Important: Mod Flag must be C and Mrg Opt must be 1 in order to preserve the VO Changes
  8. How can I  reset Vocabulary Overrides for a specific data item?
    • From Data Dictionary-Work with Data Items (P92001), there are 2 row exits – Reset FDA (UBE:R9225,Ver:XJDE0001) and Reset RDA (UBE:R9226,Ver:XJDE0001).
    • These 2 UBEs will reset the Vocabulary Overrides to the Data Dictionary Row Description & Column Title of the Selected Data Dictionary Item in all APPLs/UBEs for the Central Objects Specs specified in the Processing Option (PO).
    • Revise the Processing Option values and Data Selection for the XJDE0001 version of the UBEs before submitting them through the row exits since it does not prompt for the PO values and the DD application is hard-coded to submit version XJDE0001.
    • Run the UBEs in Proof Mode first to list all APPLs/UBEs that will be affected, then in Final mode to update the Central Object Specs. Note: The UBE must be submitted from the row exit in P92001.
    • Deploy Data Dictionary Change throughout PeopleSoft EnterpriseOne before deploying the VO changes .
    • An update package must be built for all the APPLs/UBEs listed in the 2 reports (R9225 & R9226) so as to deploy the changes.


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
  1.  
F98210 – Logging Header
Contains Header information including the Project, Object Type, Object Name, Time Stamps, Path Codes, Data Sources, Locations and Action Type.
  1.  
F98211 – Logging Detail
Contains detailed information on the Errors and Error Codes for the Projects and Objects included in the F98210.
  1.  
F98220 – Project Master
Detailed information on all newly created projects and all default projects.
  1.  
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.
  1.  
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.
  1.  
F98223 – Allowed Actions
All the Allowed Actions assigned to User Roles in the Object Management Configuration are detailed in this table.
  1.  
F98224 – Status Activity Rules
Details all Project Status Activity Rules.
  1.  
F98225 – Transfer Activity Rules
Details all the Object Transfer Activity Rules.
  1.  
F98230 – System Settings
Contains all OMC information other than Activity Rules and Notification subscriptions.
  1.  
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.

  1. 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.
  1. 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