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.
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
try to give some information about BI Publisher.
ReplyDeleteThanks