Wednesday 7 May 2014


1).What is an environment
 ENVIRONMENT=PATHCODES+OCM MAPPINGS.
It is a collection of pointers indicating location of Data and One  World Objects. It answers the following questions,
(1)what is my data 
(2)what machine will process my logic
(3)what directory contains the object being processed. 
OneWorld has the following types of environments:
Distributed data and logic environments where data resides and where application process.

2).Why is a data dictionary required  ?
Applications access the data dictionary at run time and immediately reflect modifications to the data item attributes. It is a central repository that  contains data item definitions and attributes.
Data dictionary is required to create,view,update  attributes for data items.

3).Explain some features of Data Dictionary.
Data Dictionary is a central repository that contains data item  definitions and attributes, Dynamic,when you change a data item the  changes are immediately occurs throughout one world.

The data dict. does not verify whether a data item is used by an application when you delete it. Data Dictionary resides on Enterprise server.

4).What are next numbers ?
It is the facility controls the automatic numbering for such items as new general ledger account numbers, voucher numbers and address numbers. It gives you the method of automatically incrementing numbers  to reduce transposition and keying errors. The combination of the system code and index defines how the next number will be assigned. After you set next numbers, do not change it. If you change ,system  performance is impacted. Next number ties with the data dict.G00 is the fast path code.

5).What are UDCs. What does UDC stand for
UDC stands for user defined codes, UDC are valid values that  are assigned to a fields. This allows to tailor JD Edwards software to our business needs,with out any negative consequences during upgrade process. UDC are customized codes that defines to order the information in address book useful for our business needs. (Valid set of data specific to our business needs)-
(1)Valid values for data items
(2)Uniform description for each valid values 
(3)An easy way to customize valid values. 
UDC fields include (1)state and province code(2) unit of measure  (3) category codes.


6).What are business functions. What are the different ways to  create a business function
Business functions are group of business logics. Business functions should perform a specific task. Journal Entry Transactions, Calculating Depreciation, and Sales Order Transactions are examples of cohesive business functions.  You can create business functions using one of the following methods:

The event rules scripting language
Business functions created using the event rules scripting language  are referred to as Business Function Event Rules (also called Named  Event Rules). You should try to use Business Function Event rules for your business functions if possible. There may be some instances, however, where C business functions may better suit your needs.
C programming code
Business functions designed using C are not generated by One World. C Business Functions are used mainly for caching. They can also be used for:
Batch error level messaging
Changing the OR properties of a Where clause Large functions Complex Select statements

C business functions work better for large functions. If you have a large function, you can break the code up into smaller individual functions and call them from the larger function. After creating business functions we can attach them to Oneworld applications to provide additional power,flexibility,and control.


7).Explain what is Check In/Checkout
when you checkout an object, all object specifications and records are replicated from server to work station. When ever we create an object it will reside only on our work station, if you want to this object avalible to other user it must be placed in server, Placing object into server is called checkin,checkout is viceversa.

8).How do you debug an Interactive application, a UBE, and  a business function
we can debug by using Event rule debugger,Debugging is used to 8 determine the state of the program at any point of execution.It is  used to help solve problems and to tets and confirm program execution. We can use a debug to stop execution so we can see status of program  at a specific point. This allows you to view values of input parameters ,output parameters,and variables at specified point.

9).Explain what is meant by BLOB, TAM.
BLOB-is a binary large object,which can store large text as well as images(media objects). Which can not be included in business views.
TAM-Table access management/Method,The replicated object specifications are stored in a JDE format called TAM.Only TAM specifications that we can delete on a client workstation are DDDICT,DDTEXT and GLBLTBL.
DDDICT-----F9200           Header Information For DD items.
DDTEXT----F9200,F9202,F9203,F9207,F9210    Detail Information For DD items.
GLBLTBL-----N/A    cache of JITI spec for items from the DD and table definitions.

10).How are the applications stored and retrieved?
An application is a collection of computer programs that performs a specific task. An application retrieves and updates data within a database table. In One world there are three types of applications:
Interactive ,Batch,Web applications. An application is a collection of objects that performs a specific task. 
J.D. Edwards uses the OneWorld Tools to build its standard groups of related applications:
1)Architecture, engineering, and construction,   2)Distribution Energy and chemical systems
3)Financial   4)Human resources  5)Manufacturing 6)Technical
These applications share a common user interface because they are all generated through OneWorld Tools. Applications refer to both interactive and batch applications. For example, all of the following are applications:
Address Book Revisions ,Sales Order Entry General Ledger Post,Trial Balance Report

11).What are the different modules in JDE ?
1)Architecture, engineering, and construction  2)Distribution 3)Energy and chemical systems 4)Financial
5)Human resources 6)Manufacturing 7)Technical

12).What are business views and Why do we need business views ?
 Business views are the link between applications and data. It defines   the data items from one are more tables that an application uses. With business views , you can select only the columns needed for your application,which increases your system performance due to less data moving over the network.

13).Is it mandatory to have a key when a table is defined?
yes. If you do not established an index,your generation will fail. You Must generate your table to create your physical table. You can't add  or update until it is generated. Table generation will else create a  .h file used for compiling in BF and TER.

14).What are join business views
Join business views are business views which are designed from two are  more tables for any relevant applications.

15).What are data structures. What are different uses of data structures
Data structures are list of parameters used to pass data between  tables and applications or forms,between applications and business  functions. Data structures are used to create processing options,Media objects, and Business functions.

16).What is the difference between a Deployment and an Enterprise server
Deployment server is the one where One World is initially installed. This is the location where the deployment plan is entered to describe the architecture to be utilized.It is also the location where clients attach to load client packages.

Enterprise server is the one where the database server and application server functions resides. It may also act as a UBE server. It represents a more host-centric design approach.

Database Server This machine runs the Database Management System (DBMS), holds the  transactional data and services data related requests.

Application Server An Application Server is used to handle business logic requests for one or more end users. These servers offer part of the scalability of the design since more of them can be added as the number of users goes up. A large installation may have many application servers.

UBE (Universal Batch Engine) Server The UBE Server handles requests for reports and batch updates. In many designs, the UBE Server is the same machine as the database server. This makes good sense since the data needed for the reports and batch updates is located there. If scalability becomes an issue, the UBE Server may be
separated from the database server.

Enterprise Server A OneWorld Enterprise Server is a machine were the database server and application server functions reside. It may also act as the UBE server. It represents a more Host-Centric design approach.

Workgroup Server A Workgroup Server is a localized data server holding non-volatile data for a set group of users. This server is often in a remote location (separated by a WAN) from the database server. It is normally on the same LAN as the clients it is serving. Its main function is to reduce WAN traffic and improve performance for remote users.

17).What are the different steps involved in implementing One World ?
The phases usually include 1) CNC 2)Basic Training 3) Conversion Of The Data From current system 4)Analyzing the client requirement 5)Conference room pilot 6)Technical development solutions.7)Testing 8)Advanced training 9)Going live 10) Upgrade strategies.

18).What is Brows ER
It is an application used to view Event rules and design layouts for  Interactive &Batch applications you can enable or disable one or more  event rules with out extensive work on the design tools. This is useful  for debugging specific event rules.

19).If a user checks out an application, checks it back into the server and the server some how loses the object, can the user recover his lost object----
Yes. User can recover his object by OCM.

20).Explain Vocabulary Overrides used to override the data dictionary properties. Technical development solutions ---
A feature you can use to override field, row or column title text on forms and reports.
A user override changes only the appearance of an application.

21).What are the different form types
Find /Browse,Fix/Inspect,Search and select, Header detail, Header less detail, Parent/Child and Message form

22).What is Entry point. Where is it normally found
In an applications there will be different types of forms to initiate  the business process. While running application Entry point defines  which form has to be initially activated. Normally this will be  selected by checking entry point in form properties. JD Edwards defined  by default Find/Browse is the entry point for an application,We must  only one entry point in an application.

23).How do you submit a report from an application--
Through  Report Interconnection

24).Explain the process of retrieving Processing options in an application
From System admin tools (G9011),choose interactive versions application .
 On the work with interactive versions form enter the application ID ,press find button. Select  one of the versions and select processing options from ROW menu bar.(OR )Choose an application and select Prompt for values from the edit menu.(OR)right click on application in the oneworld explorer and choose for values in the prompt for from the  pull down menu.

25).What are the impacts of modifying a JDE application
improves efficiency and provides distinct advantages, such as the ability to do the following:
  • Export grid records to other applications, such as a Microsoft Excel spreadsheet
  • Re sequence a grid on a different column
  • Change grid fonts and colors
  • Control major functionality using processing options

26).What are upgrades and what precautions should one take during an upgrade
Upgrades are custom modifications,
“Preserve” means that during an upgrade, oneworld automatically merges your modifications with the new J.D. Edwards applications shipped with the upgrade, and you do not lose your modifications. If there is a direct
conflict between your specifications and J.D. Edwards specifications, the upgrade process uses yours. When there is no direct conflict between the two, then the upgrade process merges the two specifications.
“Replace” means the upgrade does not merge those types of modifications and, therefore, J.D. Edwards replaces your modifications. You will need to do them again after the upgrade completes.

  • The following general modification rules apply to all OneWorld objects: When adding new objects, use system codes 55-59. OneWorld uses reserved system codes that enable it to categorize different applications and vertical groups. By using system codes 55-59 for your custom usage, OneWorld does not overlay your modifications with J.D. Edwards applications.
  • Do not create custom or new version names that begin with ZJDE or XJDE. These are reserved prefixes for standard version templates that J.D. Edwards sends out for you to copy, to create new templates or versions. Using these prefixes does not preserve your custom versions in case of a naming conflict.
  • For upgrades, you should build a package from the last modified central objects set and perform backups of your development server, central objects, and Object Librarian data sources so you can access those specifications for comparison or for troubleshooting purposes. See the OneWorld Upgrade Guide for information.

27).How do you attach a description to a Address Number field--
Through Associate Description.


28).How do you align the fields on a form
By selecting fields to be aligned(the Anchor field will be the last) and from layout ,we can align.

29).What is the difference between a Header Detail and a Headerless Detail form.
Header Detail form includes an input-capable grid so you can add or update detail records. It is used to add  or update a single header record. you can also add,update or delete multiple detail records from the same form and  allows to work with data from two tables, it has two business views. Headerless/Detail form is used to display multiple records from a  single table it has one business view

30).What is Cache. What is the main use of Caching
virtual memory used to save while committing or rollback.

31).Explain Handles.
In OneWorld, the table I/O term handle refers to a type of file pointer. This file pointer connects the OneWorld application or UBE with the middleware used to communicate with the database manager. Handles are references to an address within the middleware that point to a database table. Unlike regular file pointers, handles allow you some control over when and how they are used Handles allow you to perform several operations that you cannot do using 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. This is particularly helpful whenever there is an upgrade to OneWorld or when you need to convert data from another system into OneWorld. 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.
* Handles cannot be used in transaction processing.
If you pass a handle to a form or a named event rule, the data structure for the form or named event rule must contain a member that is a handle data item. In the form interconnect or business function call, you
must assign a handle value from your event rules to the handle data structure member. You can use this handle in the form or named event rule that is receiving the handle just like any other handle.
You must explicitly open and close handles, unlike other table I/O operations where you can use implicit open and close statements. You must open a handle before it can be used for any other operations. All of the operations except Open work the same for handles as they do for tables or business views. When you are finished using a handle, you must explicitly close it. You close the handle the same way that you would close a table or business view except that you choose a handle instead of a table or business view.

32).What are event rules. Explain five most commonly used event rules with examples
Event rules are business logic statements that are attached to events,Events are activities that are occurs in an application. Perform mathematical calculation,connecting two forms or applications,Attach a business function. Evaluate if/while and else commands,Assign a value to a field and passing data from source field to target field.

33).What are the different objects used in a Table I/O.
Table,Business view and Handles are objects used in Table/IO.

34).What are filter fields
Filter fields are controls on the form ,which was not selected in the grid on the same form. It is used to build a where clause of an SQL SELECT statement.

35).What is meant by visual assist. How do you attach visual assist to a field in a form.
Visual assists are search code types with flashlight. They are used to access supplemental tools available on forms. These tools automate the process of inputting information into calling field.


36).What are media objects
Media objects are images,which allows to attach information to one world forms and applications.(either to rows in a grid or to a form)OLE allows to create link between different programs.

37).What is PO, GC, GB, FC denote before a variable
PO=A Value from processing options of the application
GC=A column in the grid for this form
GB=(Grid buffer column)GC is one row of data space independent of the lines being read from the data base and written into the grid.
FC=A control on this form,such as a push button.

38).How do you check the mode of an application (add/change). How do you check the status of a file after a table I/O
In Form properties,,Status check---SV File_IO_Status is equal to CO SUCCESS

39).Explain the process of writing a new application to view, select, and delete records from a table F4211.
Designing an Application ,consists  a Find/Browse form,it should have Select and Delete button,so that you can View,select and delete the records from table F4211.

UBE

40).What is a UBE. What are the different uses of a UBE
Universal Batch engine,printing Reports, Batch applications,and Table conversions

41).Explain Level breaks
In a report, a set of records that all have the same value for one of their fields are said to be in the same level. For example, in a report that is sorted by telephone numbers, all records having the same area code would be in the same level. When the value in that field changes, a level break occurs. Level breaks are useful because you can add processing when they occur. Two special report section types make it easy to add processing to level breaks: they are the level-break header and level-break footer sections.

42).What are versions. If a version is modified, does it affect the base
 Versions are user defined specifications attached through processing options. NO.

43).What is the difference between Interactive and Batch versions
IV's are not necessary to check in,where as BV's are to be checked in, because BV's have local specifications

44).Can we use system functions for data selection
yes (general objects) Set_User_data_selection.

45).A UBE requires dynamic data selection based on the processing options.
How would you achieve this. As an example consider an UBE to have 4 processing options A, B, C, and D. If the user enters values in A and C then the data selection should be (A=x and C=y). If the user enters values in A, C, and D then the data selection should be (A=x and C=y and D=z)
If  PO=this value--- Set User selection  else----not to do

46).How do you skip to a new page.------  
level break & page break


47).What is meant by scope of a variable
An event rule variable is associated with a data dictionary item, but it does not reside in the data dictionary. Once created, it can only be used in a specific interactive application, batch application, or business function event rule.
The event rule variable is automatically initialized at runtime because you define how the event rule variable is used when you create it.
Use event rule variables instead of hidden fields. Event rule variables use fewer system resources at runtime.
The scope of an event rule variable determines how it can be used. For example, you can: Reference a report variable anywhere in the report Reference an event variable only within the event where it was created
Different scope options are available for interactive and batch applications.

Interactive event rule variables are available at the following levels:
Form level----Grid level----Event level--Form-Level

Form-level variables are available at all events for all controls within the form. They are initialized when the form is initialized and retain values until the form is closed.

Grid-level variables are subtypes of form variables, and are available on any form with a grid. They are available from all events on the form. They apply to the current row. Every new row added to the grid has
the same set of variables. These variables are reinitialized each time a new row is added to the grid. You can use these variables as temporary work fields for the grid. If possible, you should use variables instead of hidden work fields for better performance. Using variables instead of hidden work fields enhances the performance of OneWorld forms during initialization and saves time because variables are not formatted. Although grid variables are available in all event rule line types, you should only use them with events that are associated with grid rows.

An event-level variable is available only within the event for the form control where it was added. The variable is reinitialized each time the event is processed for the form control.

Batch event rule variables are available at the following levels:
Report--------Section-------Event


48).What are Z tables/reports(Inter Operability tables)
For store and forward(network disconnected) user,one world store and forward applications performs edits on static data and other critical information that must be valid to process an order.After initial edits are complete,one world stores  the transaction in work tables on the work station.these work tables are called Z

 tables.When network connection  is established,Z files are uploaded to the enterprise server and transactions are edited again by a master business function.

49).Can different versions have different Data Selection criteria------
yes

50).Is it possible to attach different printers to different versions of the same report.   How?-----
yes

51).Versions are never checked into the server, only objects are checked in. (True/False)
False, IV's are not necessary to check in,where as BV's are to be checked in,because BV's have local
 specifications.

52).Two users cannot submit the same version of the UBE. They always have to use separate versions. (True/False) -------- 
true

53).Event rules are never validated for UBEs. The event rules are only validated for APPL? (True/False)     false

54).What is the difference between Columnar and Group sections
The layout of a columnar  section consists of column headings with the associated column values listed under the headings. Each data field is a column, and each record is a row. The column heading is linked to its column data, and the two cannot be disconnected in the report. If one is deleted, the other is deleted also. Because you cannot change the column format, the columnar section is the least flexible detail section.

Group sections, characterized by their free-form layout, are not restricted to standard column and row layout. This section type is the most flexible because you can place data fields anywhere in the group section. Data fields in group sections are called controls. Controls are composed of a constant component and a variable component. Initially, the constant and variable of the control are linked; however, you can disconnect the constant and variable to meet your reporting needs. Because of the free-form layout, group sections are almost always used for levelbreak header and footer sections.

55).What are edit codes. What are the edit codes used for.
Edit codes are control formatting characteristics such as whether to include commas with  amounts and the negative amount notation to use. edit codes used by One World to determine how to display or format a particular value  for a report.The default edit codes that pertain to reporting require paricular  attention because they account for a substantial amount of information.

Functional

56).What is a Sales Order Cycle
Print pick slips,shipment confirmation,invoice printing,and G/Lposting.

57).What is an order activity rule used for
To control process of SO cycle,by using Linetype and ordertype with status codes.

58).Name a few JDE table names and their usage
F4201-Sales Order Header File,F4211—Sales Order Detail File,F0101—Address Book,
F0301—Customer master,F4101—Item Master,F0002—Next Number

F0005—UDC values,F9860-OL Master table,F4942—Shipment detail

69).Name at least one JDE partner involved in Front office automation, B2B consulting, and ASP.
Deleton Tools,Arista Soft,M&D,Earnest and Young(E&D).

60).Identify how you can set up the line type for an item to be Z.
From Distribution & Logistic by selecting Sales Order Management ( G2 ) then to Sales Order Management Set Up (G 4241 ) select Order Line Types (P40205).
On the Order Line Types ( Work With Line Types ) screen Choose LnTy  EC  (Container Deposit/Refund ) Which has to be Associated with your new  line type 'Z', then press copy . On the Order Line types ( Line Type Constants Revisions) screen enter Line type 'Z'  and required description ,then press OK .From Inventory Management ( G41), then to  Daily Processing (G4110) ,  then to Item Revisions (G4112) Select Basic Item Master Data ( P4101).On Work With Item Master Browse Screen  Press Find to get the complete  Item Numbers in the Enterprise.Select required Item number Which has  to be assigned with line type 'Z'.
On Item Master Revisions  screen select Basic item data tab. On the left pane at the Line Type enter 'Z' and press OK.
The required item number will be assigned to line type to 'Z'.

61). Identify how you can set up the item flash message to 'EC'( pending engineering changes).What are the mandatory steps to do this set up.
You should have UDC types FL for flash messages in Product code 40.If not create UDC type FL and codes for different messages as per your business requirement.
Type UDC from the fast path,  On the work with user defined codes, enter product code 40 &  Udc type FL, then click FIND. If Enterprise requires any Flash messages it can be added here by selecting ADD.
From Inventory Management ( G41), then to  Daily Processing (G4110) ,  then to Item Revisions (G4112) Select Basic Item Master Data ( P4101).
On Work With Item Master Browse Screen  Press Find to get the complete  Item Numbers in the Enterprise.Select required Item number Which has  to be assinged with flash message 'EC' (Pending for Engineering Changes).
On Item Master Revisions  screen select Basic item data tab. On the Right pane at the Item Flash Message enter EC  from the visual aid.
The required item number will be assigned to Flash Message to 'EC'.

62).Where do you see the hold codes associated with a Branch/plant. How do you set up passwords to release them
Form the Sales Order Management Setup (G4241), Select order Hold Information (P42090).
On the work with hold order constants press FIND to get Hold Codes  for Branch Plants.
By selecting required hold codes , which password to be changed can be changed on the order hold information screen.

63).Identify how you can set up the supplier for a branch/plant
By selecting Supplier Item Information (P43090),on work with supplier item  relationship , you can set up supplier for any branch/plant or vice versa.
This application navigation as follows :
distribution/logistics (G4 ),
Procurement (G43),
Daliy Processing (G4310),
Stock Based Purchaing (G43A),
Purchase Order Processing (G43A11),
Supplier Management ( G43A16),
Supplier Item Information (P43090).

64). How do you assign a branch/plant to the customer or vendor or employee..etc.
From Foundation Systems, Address Book ( G010), Daily Processing ( G01) select
Address Book revisions (P01012).
On work with Address  screen enter required search type viz C,E,V<  etc click Find button
Select address number to be assigned to branch/plant in the grid.
You will be navigated to Address Book revision. On the Address book tab Enter required branch/plant in the
Business unit field  by overiding the  default value 1 ( Finance & Distribution company.)

65).How do you define a branch/plant for an address book
From work with User defined codes, enter 01 in product code and ST in the user defined codes then click ADD.
Then on the user defined codes Screen enter new value for the code to be representing Branch /Plant.( say BP)
and press OK. On work with Address book enter the search type BP and press ADD.
you will be getting Address book Revisions Screen. In this enter the  values in required fields and press OK.
it will be defined Address book for the branch/plant.

66).Which form can use two business views-------
Header detail

67). Give an example of n to n relationship
    A department has multiple employee at the same time an employee can work for different departments

68).  What is custom section

    Custom sections allow you to control, through event rules, the information that prints on a report. You can use custom sections  to force a page break by creating a custom section with no objects, then activating Page Break After Print in that section's  Section Properties. You can use custom sections to print variable text. Custom Sections can also be used for sections that present  the same information, but are formatted differently. You can call a custom section from any event rule except INIT_Section. If  you try to call a custom section using INIT_Section, your report will not process.

69).Which report type uses custom report-------
 All Group,columnar and Tabular,

70). Advantages of using Group section
    Group sections, characterized by their free-form layout, are not restricted to standard column and row layout. This section type is the most flexible because you can place data fields anywhere in the group  section.

71). How can you set any specific form as an entry point to the  application
    Two ways:   1)In design time we can set that form as an Entry point 
                        2) Else while designing the menu we can set the Form name also

72). What type of form Sales order entry uses---------
Header detail


73). What is the Sales Order entry program name........
           P4210

74).Have you written/changed any business functions-------   
Yes, using NER - Named event rules

75).What are the advantages of using C business functions ------- 
Can access more system values

76).Advantages of using NERs---------   
Flexible, easily maintenance

77).what is DLL
    Routines that can be invoked from Executables at the runtime,  these  are not linked to the executable applications

78).What is normalization   -------   
State of database where there is no data redundancy and records can by  accessed by a key

79).what does jde.log have--------   
All information from OneWorld system start to the end for that  particular workstation

80).Why do we use Indexes----------
To improve performance

81).Brief Sales order processing flow
Order Entry Prepayment,PrintPickslip,shipmentonfirmation,Shippping,information, Invoice printing,UpdateGL

82).What are processing options used for
    Processing options control how interactive and batch applications process data. Processing options are used to create an "input property sheet." A parameter list is used to pass processing options to an

 application.  For controlling runtime attributes  processing options that control the format, page breaks, report totaling, and how the report processes data.

83).What are versions used for
    A version is a user-defined set of specifications. These specifications control how applications and reports run.You use versions     to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions     are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
Section layout,,Section data selection,,Section event rules,,Section database output,,Section sort sequence

84).What are the differences between where and having class in SQL
    where applies to the whole database(on each row column), Having applies to the group functions

85).What is left outer join
    Type of table join in SQL - selects all the records from the left table and  the corresponding common records from the right table

86).Brief about Find/browse
    A type of form used to: Search, view, and select multiple records in a detail area.

87).How do you invoke one form another application
    Form interconnection. Allows one form to access and pass data to another form.

88).What does OMW do
     The Object Management Workbench (OMW) is the change management system for OneWorld development. A change Management system is vital to a productive development environment because it helps organize a myriad of development activities and helps prevent problems such as intermixing components from different releases and simultaneous changes to an   object by multiple developers.
     The purpose of the OMW is to automate many of these change management activities.The three OMW systems are:
     Graphical User Interface(GUI)---Unifies all development under an intuitive interface
     Configuration System Controls all development from a central location
     Logging System Automatically tracks all program changes Provides check-out and checkin capabilities for developers, retains  token info
     Object Management Workbench concepts include the following items:
     Projects,  Default project,  User roles,  Allowed actions,  Tokens

89).What is OCM
     One World's Object Request Broker

90).About system codes
     Each group of Software is called a System and has assigned a system code.A group of system define a Comprehensive business solution.System codes are a numerical representation of J.D. Edwards and customer systems. e.g. Address book is 01

91).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.

92).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.

93).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 willalso change. 

94).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.

95).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 objects 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.

96).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.

97).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.

98).What are UDC?
A user defined code (UDC) is one value in a set of values that you have assigned as valid for a field.
 Most OneWorld forms contain fields. Some fields allow you to enter any value,
and some require you to choose from a list of valid values.

99). What is Object Management Workbench? 
Object Management Workbench (OMW) is a complete Change Management System for OneWorld®  development. OMW replaces Object Librarian, Promotion Manager, Object Transfer, and the Object  Librarian Check-in Log. Object Management Workbench is the single entry point for development of all OneWorld® objects. OMW simplifies development for the user while providing the administrator with complete control of changes to OneWorld® Path Codes and Data Sources. For an overview on Object Management Workbench and information on how OMW differs from Object Librarian, refer to the document Object Management Workbench Overview.

100). Understanding Project Statuses
Since Object Management Workbench (OMW) is an object management system, the user no longer has the ability to decide from what path code he/she wants the object to be checked-out from or what path code the object is checked-in to.  These types of decisions are made by the system administrator using the Object Management Configuration application.  Each project can be moved through different statuses.  The project may start in development, then go into Q&A in a prototype path code, and then into production or any number of other paths that the system administrator determines.  For a standard install, with no changes, a project will start at a status of an 11.  This is usually where the project is reviewed and people are assigned to the project.   From that stage the project goes to a status of 21.  A project status of 21 indicates that the project is in development which is where objects will be checked- in, checked-out, and modified.  When a project is at a status of  21, it does not matter which environment the user is logged into, the path code that the object is checked in and out of is determined by the activity rules and allowed actions  set up in Object Management Configuration for the project status 21.  The environment the user is logged into is irrelevant because everything is determined by the configuration defined in Object Management Configuration.  For more information on Object Management Configuration, refer to the document Object Management Configuration Overview.  For more information on project statuses, refer to the document Project Statuses in Object Management Workbench

101).Understanding Roles
Object Management Workbench (OMW) uses User Roles to determine what actions a user can perform. The roles determine which buttons appear in the middle of the OMW screen such as Check-In, Check-Out, Get, Advance Status, Release Token, and Erase Check-Out. The role of the user is given certain permissions in Object Management Configuration to be able to perform certain actions such as the ones mentioned above. Roles and project statuses work together. A role is given certain rights to perform certain actions at certain
statuses.That same role can have different allowed actions at a different project status. For example, a user with the role of a developer that has the authority to check-in and check-out objects at a project status of 21 will not have the same authority and allowed actions at a project status of 26. Refer to the document Understanding User Roles in Object Management Workbench for additional information on roles.

102).Checking-in an Object
The check-in process has the same result as it did in earlier releases of OneWorld®. Once you have the object checked-out and made the required modifications, you can check-in the object. As discussed above, Object Management Workbench does not allow a user to select which path code to check-in the object to. The project status and the activity rules behind the project, as defined in the Object Management Configuration application, determine the destination of the object at check-in time. The check-in process takes the specifications of the object from your local workstation and checks them into the central objects on the server. For example, at a project status of 21 with the role of a developer assigned, the object would be checked into the development path code central objects.

103).How Do I Do a Fake Check-Out and then a Fake Check-In?
Fake check-outs were done for a variety of reasons in OneWorld releases prior to Xe.  Clients did fake check-outs to go into design of the local specifications, or to restore the specifications in the check-in location, etc.  The new functionality of Object Management Workbench eliminates some of the old reasons to do a fake check-out.  If you bring an object over to your project and go into design without checking the object out, any changes made to that project are done to your local specs.  If you wanted to get the specs from your workstation to the server, then the process has a few more steps.  For example, if you wanted to put the specs on your production machine into the production environment, you would need to do the following.  First, you
would need to create a project and get it approved and advanced to the Production project status – 40.  The OneWorld administrator would need to put you on the project with a Role that gives you the Allowed Actions
to Check Out, In, Save, Restore, all in the project status 40.  In the project status 40, you would add the object to your project, but do not check it out.  Then click the Save Action button in Object Management Workbench. This will save the object to the Save Location the Administrator has defined in the Object Management Workbench.  Check out the object in your project, this will overwrite your local specs with the unwanted specs from the server, and it will give you the token.  Then click on the Restore button in Object Management Workbench, this will bring the specs back from the Save Location which are the desired specifications formally from your workstation.  Now, in your project, you have the object checked out to your project, hold the token and you have the specs restored on your machine.  You can now check the object back in and this will put the desired specifications into the check-in location.

104).How do I Object Transfer from Pristine?
New Projects are started at a Status 11 - New Project Pending Review.  OneWorld is delivered to allow a Project to be advanced from a status 11 to a status 45 – Pristine Get.  There are no Object Transfer Activity Rules for the Status change from 11 to 45, so objects will not move between data sources or path codes with this project status change.  Once the project is in a status 45 – Pristine Get, the user will then add the Object(s) that they desire from Pristine, to the project.  You can then do a check-out or a Get to bring the Pristine specifications down to the local machine

105).How do I Delete a Project?
In OneWorld Xe, a project is considered an ‘Object’ just as any other OneWorld object such as an Interactive Application.  Therefore to delete a project in Object Management Workbench, you will need to be assigned to the project with a Role that has the Allowed Action to Delete objects of type Project.

106).What OneWorld Tables does Object Management Workbench Use?
The Object Management Workbench tables are kept in the System – B7333 Datasource.
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.


107).How do I Object Transfer from Pristine?
New Projects are started at a Status 11 - New Project Pending Review.  OneWorld is delivered to allow a Project to be advanced from a status 11 to a status 45 – Pristine Get.  There are no Object Transfer Activity Rules for the Status change from 11 to 45, so objects will not move between data sources or path codes with this project status change.  Once the project is in a status 45 – Pristine Get, the user will then add the Object(s) that they desire from Pristine, to the project.  You can then do a check-out or a Get to bring the Pristine specifications down to the local machine


108).What Object Management Workbench Changes are Cached in OneWorld?
The Object Management Workbench Setting for a users Default Project are cached by OneWorld.  After making changes to Activity Rules or Allowed Actions for an existing User Role on a Default Project, you will need to exit OneWorld and then restart it.

109).How do I get a change made to a Menu, UDC, or Interactive Version in my Prototype Environment back to my Development  Environment?
OneWorld is designed with a Change Management System that assumes a development lifecycle that promotes objects from Development to Prototype to Production.  Occasionally clients will need to promote objects in the reverse direction using some sort of tool.  Before OneWorld Xe, this was done through the Record Copy application.  However, the Record Copy application no longer exists in OneWorld Xe because of the risk of compromising the goals of an integrated Change Management System.  Therefore this type of object promotion must be done through Object Management Workbench, and more specifically, through the advancement of a project from one status to the next.  Because OneWorld is not delivered with a promotion path that moves objects from Prototype to Development, one must be created.  An example of a possible promotion path may be from the starting projects status of 11 moving to a new status like 27 – Prototype to Development, which then moves to the status 21 – Programming.  Instructions on setting up this type of promotion path can be seen in the Knowledge Document “Configuring Object Management Workbench with Custom or Additional Path Codes” (see link below)  and Question 9 above, “How Do I Create my own Object Promotion Paths?”.

110).What are the Different Delete Options Available when you Delete a Project?
Answer: 
When deleting an object in the Object Management Workbench, there is now a list of different 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 OneWorld, 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.

111).Why do I Receive an Error when Clicking on an Interactive Version? 
When working with Interactive Versions in Object Management Workbench  and highlighting the Interactive Version in a project, a OneWorld error of "Error Code Does Not Exist" is given.  This issue has been reported on SAR 4717404 and a fix is available in an ESU and in OneWorld Xe Update 1

112).How do I Delete a Project and the Objects in the Project Once the Project has been Moved to an 01 Status?
When a project is moved to a status of 01 - completed, Object Management Workbench is hard coded to not allow the ability to delete the project if there are objects in that project.  Set up a new status to go from 01 to 99 which is also completed.  Then create an allowed action for one of the user roles to have the ability to delete the project at a status of 99.  This will delete the project, remove all objects from the project, erase all the check-outs, and release the tokens of that object.  

113).When Attempting to Advance a Project with an Interactive Application, Why am I Getting Errors on my User Overrides and the Status Change is Failing?
Transfer Activity Rules for User Overrides that were sent our with the GA release of Xe are incorrect.  The Transfer Activity Rules for User Overrides incorrectly point to Control Tables Data Sources.  These objects should point to Central Objects Data Sources.  Use the Universal Table Browser and search the F98225 table where TROMWOT = UO to find all Status Activity Rules that have associated User Override Transfer Activity Rules.  For each UO Activity Rule found, use the Object Management Configuration Application (P98230) to change all Transfer Activity Rules for object type UO from Control Tables Data Sources to Central Objects Data Sources.  

114).When a User Creates and Checks-in a Version in Batch Versions, How do I Get the Token Released Automatically so Other Users can Check-Out the Version?
When users are in Batch Versions and do not have access to Object Management Workbench, they create versions and check them in, but other users can not check them out because the original user has the token in their default project.  This issue is reported on SAR 4945378 and has been corrected.  Now on a check-in of a version, if Batch Versions was not called by Object Management Workbench (but instead accessed from a menu) and the Project Name is equal to the User ID, the token will be released automatically at check-in of the version.  The fix is available to download in an ESU.  

115).No Owners Display on Any of My Projects in Object Management Workbench?  (AS/400 Platform Specific)
The issue can be seen in Object Management Workbench because no owners exist under any projects and an owner cannot be added to a project.  This issue is specific to the AS/400 and relates to journaling issues on the AS/400 after installing OneWorld® Xe and SP 13.  Refer to the Knowledge Document oti-00-0167 for additional information on how to correct this issue. 

116).I Can Successfully Check- in Most Applications, but when Checking in Certain Applications (such as P0911) I am getting a "General Error in Method - Check-In"?
There are certain known issues that will cause Object Management Workbench to error. Certain existing One
World applications contain what is now considered duplicate keys for a check-in to RDB. There have also been some cases where RDB has an extra record that causes TAM add failures for duplicate keys.   These issues have been reported and corrected on SAR 4673499.  This SAR is included in OneWorld Service Pack 15.

117).When Accessing Object Management Workbench through a Citrix Connection, How can I Stop the Application from Flickering?
The problem has to do with Citrix and the TSE setup. Many things play into this such as TSE and client resolution, number of colors, bitmap caching, speed of machines, speed of connection, video cards, etc.  The most common fix seems to be, making sure the resolution on the client and TSE matches (such as 800x600) and that the colors are set to 256.  Another option that has worked for some customers is updating the
module.ini file on their workstation.  To modify this file, search for the file: module.ini on your workstation and open it. Then in the section [thinwire 3.0] about two thirds of the way down, add the following line "SkipRedrawPerPaletteChange=ON".   Then save the file and close. After logging back into Object Management Workbench, the screen no longer flickered.

118).Why am I not able to Check-Out Any Objects, but I am not Getting any Errors in the Logging?
When performing an action such as a check-out, if the Transfer Activity Rules have been inactivated, the program is not returning an error to say that no Activity Rules exist.  Instead the check-out does not occur, but no errors are given on the form or in the Logging.  This issue has been reported on SAR 4950716 which will be included in OneWorld® SP 15.1.  Creating active Transfer Activity Rules will resolve this issue

119).When my Project is at a Status of 11 and I Attempt to do a Check-Out,  It Appears that Object Management Workbench has Checked-out the Object, but when I Re-Inquire, the Object is not Checked-out?
When a user is assigned the role of PVC Administrator (super user), all the Object Management Workbench (OMW) buttons display on the toolbar even when the project is at a status of 11. It appears that actions can be performed such as check-outs.  When doing a check-out, it seems that OMW has checked-out the object as it gives the object a checkmark and updates the status tab.  However, when you do another find or log out and back into OMW, the object is not checked-out and the status tab is not updated. When a project is at a status of '11', a check-out is not an allowed action and activity rules do not exist for a check-out.  Therefore, OMW will not allow a check-out.  However, OMW should give an error that activity rules do not exist rather then appearing to check-out the item.  This issue is corrected in SP 15.1.  In order to check-out the object, advance the project to a status such as '21' that has activity rules defined for a check-out and then check-out the object.

120).What Happens When I Have Multiple Objects in a Project and the Advance of the Project Fails?
When you have a project with multiple objects in the project, when you advance the project it will promote the objects one by one.  If some of the objects succeed and some fail, then the project status will not advance.  However, the objects that were successful did transfer to the new location, based on the Transfer Activity Rules.  When the project is advanced again, Object Management Workbench (OMW) will not promote all the objects again.  It will promote only those objects in the project that failed the first time.  When objects are transferred the dates in the F9861 records are compared.  If the dates are the same, OMW will not transfer the specs for a second time because the specs have already been transferred.  If you look at the OMW log, it will show for the second transfer that the objects that succeeded the first time will not transfer (and will fail) the second time, but the project status will advance because all of the specs for all objects in the project have been transferred successfully

121).In the Object Management Configuration Setup Application, what is the Allowed Action "Install" Used For?
The Allowed Action "Install"  is supposed to have the same functionality as an Install of an object in Object Librarian.  However, the functionality does not exist yet in Xe.  This functionality will be available in a later release of OneWorld

122).When Adding a New Project in Object Management Workbench, I am Attempting to give the Project a New Type Code.  This Code has been Set up in the H92/PT UDC Table, however, I am Still Getting an Error of only Bug or Enhancement Types Allowed?
Object Management Workbench is currently hard coded to only accept new OMW projects with a type of 01 Bug or 02 Enhancement.  This was due to an internal interface requirement.  Even though new project types
have been added to the UDC table H92/PT, the program is hard coded to only accept the values of 01 or 02.  This has been reported on SAR 5109355.     

123).When Trying to Check-Out a Table or Business Function, I am Getting an Error of File Cannot be Copied.  The Error Refers to the Corresponding '.h' or '.c' File for the Table or Business Function.
This error can be caused for a variety of reasons.  One of the first tests to try would be to map a network drive to your Deployment Server in Windows Explorer and try a manual copy of a '.h' or '.c' file from the include or source directory on the deployment server to that same directory on the local workstation.  This test will verify that a network connection can be made and a copy done without security errors.  If this test is successful, check the Server Share Path in the Path Code Master application (P980042).  The server share path for Xe is generally set to a value of B7333.  An incorrect share path (such as B733 instead of B7333) will cause this error on a check-out of a table or business function.

124).How Do I Clean Up Projects and Check-Outs of Objects for Users or Machines that No Longer Exist in my Environment?
The following steps can be done to clean up projects and check-out records on objects for users or machines that no longer exist.  You will not be able to retrieve the spec record information, but you can clean up the tables that show these objects as being checked-out.
Do a Find in OMW for all projects.
Add yourself to the projects you need to clean-up with a role of PVC Administrator.
For the Default Projects, remove the objects from the project (using the right arrow on the center toolbar)
For non-Default Projects you should be able to delete the project and it will release the token, erase the check-out, remove the objects from the project and delete the project.  

125).When Advancing a Project in OMW, the Status on my Project is Changing Indicating that the Transfer was Successful, however, the Objects are not being Transferred?
Prior to doing a transfer of an object, Object Management Workbench (OMW) verifies that the project that the object is being advanced in is the last project to modify the object.  If this is not the case, then OMW will not transfer the object.  There is an issue in OMW that although the object is not transferred, the project status is still being advanced.  This issue has been reported on SAR 4972309 and is corrected in SP 16.  In order to get the objects to transfer successfully, change the status back to the prior status, check-out and then check-in the objects that did not transfer.  This will update the objects to have the appropriate project listed as the last project that updated the object.  Then attempt the transfer again.

126).When my Project is Advanced to a Status that Releases the Token, if another User is in the Token Queue to Receive the Token, the Transfer will Fail if there is a Problem Sending a Message to the User who Should Receive the Token.
If no other errors are encountered, all the objects in the project will transfer successfully, however, OMW will fail on the project status change due to an error sending an e-mail message to the user who is in the Token Queue to receive the token.  This issue has been reported on SAR 5209698 and OMW will be changed to not fail on a project status update in this situation.  As a workaround, verify that the e-mail setup is correct for the user who should be receiving an e-mail when the token is released on the project.    

127).When Updating Information such as Processing Option Values or the Version Title on a Version in the Prototype Path Code and then Checking-In the Version, this Information is Not Being Updated to the Version Record in the Development Path Code?
When you create a new version in the prototype path code and check the version in, the information will be checked into both the prototype and development path codes assuming your project is at a status '21' and the activity rules are setup to check into development at that status.  All information is reflect in both path codes.  However, if you log into the prototype path code and make a change to the version such as changing processing option values, data selection or the version title, when you check in the version, it will again check into both the prototype and development path codes.  Any changes that were made that affected the specs of the version (such as data selection changes) will be updated in the development path code.  However, any changes that were made that only affect the F983051 Versions List Table record (such as processing option values or version title) will not be reflected in the development path code.  If the F983051 record already exists
for a version in the development path code, when changes are made to that record in the prototype path code and checked-in,  the F983051 record is not being updated upon check-in in the development path code.  This issue has been reported on SAR 5245912

128).The Report has data,but there are no Smart Field Column headings
This occurs when the company has a Fiscal Date Pattern code that is not set up in the column headings table for the report.The demo data is only shipped with a value of R.
Set up at Gh9141—p83110(column Headings)
SMART FIELD TEMPLATES

Financial Report(S09001):
 1).FINRPTAB(Account Balance)--The account balance as of the specified period and fiscal year.
 2).FINRPTBA(Approved Budget)--The approved budget amount.
 3).FINRPTBO(Final Budget)--The final budget amount
 4).FINRPTBR(Requested Budget)--The requested budget amount
 5).FINRPTIC(Inception To Date Through Current Period)--The account balance inception to date to the
                       current period
 6).FINRPTIY(Inception To Date Year End)--The account balance inception to date to the end of the
                                        fiscal year. Includes the balance forward for all types of accounts.
 7).FINRPTJE(Create Journal Entry)--For creation of journal entries through the application report writer.
 8).FINRPTPA(Period Activity)--The net postings for the requested period and fiscal year.
 9).FINRPTPB(Prior Year End Balance Forward)--The balance forward for one year prior to the current
                                                                            year.
10).FINRPTPC(Prior Year’s Account Balance )--The account balance as of the specified period for one 
                              year prior to the current fiscal year. For P&L accounts the balance
                              forward is not included, for balancesheet accounts the balance forward is included.
11).FINRPTPR(Prior Year’s  YTD To Current Period)--The net postings to the current period for one year
                         prior to the current period.The balance forward is not included for any type of account.
 12).FINRPTPS(Prior Semester To Date)--The net postings to the current period for one year prior to the
                                            current period.The balance forward is not included for any type of account.
13).FINRPTPY(Prior Year End Net Postings)Prior Year Net Postings.
14).FINRPTQ1(First Quarter)--The net postings for the first three periods of the fiscal year.
15).FINRPTQ2(Second Quarter)--The net postings for periods four through six for a given fiscal year.
16).FINRPTQ3(Third Quarter)--The net postings for periods seven through nine for a given fiscal year
17).FINRPTQ4(Fourth Quarter)--The net postings for periods ten through twelve for a given fiscal year
18).FINRPTSC(Current Semester)— The net postings for the current semester year to date to the
                                          current period.
19).FINRPTYC(YTD Through Current Period)— The net postings for the requested fiscal year through
                                                    the current period.
29).FINRPTYY(YTD Through  Year End)— The net postings for the requested fiscal year to the end of
                                               the year.
52Period Accounting(S09002)
WKRPTAB(52Period Reporting Account Balance)-- The account balance from the 52 Period Balance
                                                                               table as of the period and fiscal year specified.
WKRPTPA(52Period Reporting Period Activity)-- The net postings from the 52 Period Balances table for
                                                                           the period and year specified

Section data selection lets you define the criteria by which records are included in your report. The Section Data Selection form filters the data for one detail section only. If it includes only one detail section, your report will display only the records that match the criteria entered on this form. If you add additional detail sections in Report Design, you must define data selection for each new section.

Financial Reports template includes Company and Business Unit as default sequencing and level breaking.
OneWorld data fields are stored in tables. Through section data sequencing, you determine the order in which the records of the business view are read from the database and displayed on your report.
Because OneWorld can sequence the records in the report by any column in the record (regardless of whether you choose to display the column in the report), the data sequencing columns you select in this task do not need to match the business view columns selected on Section Layout.After you choose data fields to use for section data sequencing, you can define sort properties for those data fields. These properties determine whether the rows are sorted in ascending or descending order, whether a level break should occur, and whether the level break should produce a page break.
Smart fields are data  dictionary items (glossary group K) designed to retrieve and manipulate specific OneWorld table data. For example, by adding the smart field FINRPTAB - Account Balance to your report, you create a column that calculates the account balance as of the specified financial period and fiscal year. Smart fields call business functions or named event rules.

If you chose Undefined, a percent column is created without a calculation. You can define the percent calculation for the column after completing the steps of the Director and after rows have been created.   AAI Subtotaling              This property inserts additional accounting lines that include running totals of the accounts, depending on the object account value. A final net income or loss is totaled for the business unit or company.

When you create a report using a tabular section, the Description column is  automatically included. When the report prints, the data in this column is based on fields designated as level-break fields. If the system cannot retrieve a description for the field (the field must have a data dictionary trigger), the

 key for the field is printed instead. For example, if the level-break field is company 00001, the description Financial  reporting Company will print if a trigger exists. Otherwise, the key 00001 will print.
Except as noted below, at the lowest level break of a tabular section, this column becomes the row  description. At higher level breaks, the Description column becomes level-break header or footer text.

A simple income statement tracks revenues and expenses and the net income or loss for a specific period of time. To print a simple income statement, all your profit and loss accounts must be grouped together in your chart of accounts and cannot be interrupted by any balance sheet accounts. Some examples of special interim totals for this report follow:
  • Gross Margin
  • Net Profit Before Taxes
  • Net Income (Loss)

For a business unit report The data sequence should be:
  • Business Unit
  • Object Account
  • Subsidiary
For a business unit consolidation report          The data sequence should be:
  • Company
  • Object Account
  • Subsidiary
For a company consolidation report                  The data sequence should be:
  • Object
  • Subsidiary
If you do not use company as your first sequence, the system uses the information for company 00000 to determine the financial reporting date. You must always use a sequence by object account and subsidiary to

 protect the integrity of your data and ensure that the level of detail subtotals are accurate. To print a report across many business units or companies, use a sequence by object account and subsidiary only.
A simple balance sheet tracks assets, liabilities, and equity by business unit or company. To print a simple balance sheet, all your balance sheet accounts must be grouped in your chart of accounts and cannot be interrupted by any profit and loss accounts.
You can use a balance sheet to track financial information for the following items:

  • Current period
  • Prior period end
  • Prior year end
  • Net change for the period and year

1 comment:

  1. try to give some information about BI Publisher.

    Thanks

    ReplyDelete