0% found this document useful (0 votes)

24 views179 pages

Order 2 Cash

The document is a supplemental guide for the 11i Order to Cash Fundamentals course by Oracle Corporation, detailing various practices and solutions for managing inventory, customer accounts, orders, pricing, shipping, invoicing, and tax processes. It includes a table of contents with specific practices and solutions for each topic, along with instructor preparation and prerequisites for the course. The document is proprietary and protected by copyright, with restrictions on use and distribution.

Uploaded by

aqeel

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

24 views179 pages

Order 2 Cash

Uploaded by

aqeel

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

t e d

h ibi
ro
e P
11i Order to Cash
a l
-s
Fundamentals Supplemental
e
Practices
r R
o
Additional Materials
y
o p
- C
i on
a t
o r
rp
C o
c le
a
Or
D16440GC10
Edition 1.0

This documentation contains proprietary information of Oracle Corporation. It is provided under a license agreement containing
restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software is prohibited. If this
documentation is delivered to a U.S. Government Agency of the Department of Defense, then it is delivered with Restricted Rights
and the following legend is applicable:

Restricted Rights Legend

Use, duplication or disclosure by the Government is subject to restrictions for commercial computer software and shall be deemed
to be Restricted Rights software under Federal law, as set forth in subparagraph (c)(1)(ii) of DFARS 252.227-7013, Rights in
Technical Data and Computer Software (October 1988).

This material or any portion of it may not be copied in any form or by any means without the express prior written permission of the
Education Products group of Oracle Corporation. Any other copying is a violation of copyright law and may result in civil and/or
criminal penalties.

If this documentation is delivered to a U.S. Government Agency not within the Department of Defense, then it is delivered with

d
“Restricted Rights,” as defined in FAR 52.227-14, Rights in Data-General, including Alternate III (June 1987).

t e
bi
The information in this document is subject to change without notice. If you find any problems in the documentation, please report
them in writing to Worldwide Education Services, Oracle Corporation, 500 Oracle Parkway, Box SB-6, Redwood Shores, CA 94065.
Oracle Corporation does not warrant that this document is error-free.

h i
Oracle and all references to Oracle Products are trademarks or registered trademarks of Oracle Corporation.

r o
P
All other products or company names are used for identification purposes only, and may be trademarks of their respective owners.

e
Author a l
Terri North e -s
r R
Technical Contributors and Reviewers
y o
This book was published using: oracletutor
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©
Table of Contents
11i Order to Cash Fundamentals Supplemental Practices ............................................................................. 1-2
Objective....................................................................................................................................................... 1-3
Practice - Instructor Preparation................................................................................................................ 1-4
Inventory Organizations................................................................................................................................ 1-5
Practice - Create a User............................................................................................................................. 1-6
Solution - Create a User ............................................................................................................................ 1-8
Practice - Create a Unit of Measure .......................................................................................................... 1-9
Solution - Create a Unit of Measure.......................................................................................................... 1-10
Practice - Create a Location ...................................................................................................................... 1-11
Solution - Create a Location...................................................................................................................... 1-12
Practice - Create an Inventory Organization ............................................................................................. 1-13
Solution - Create an Inventory Organization............................................................................................. 1-15

t e d
bi
Practice - Create a Subinventory ............................................................................................................... 1-17
Solution - Create a Subinventory .............................................................................................................. 1-18
Practice - Define Shipping Parameters...................................................................................................... 1-19
h i
Solution - Define Shipping Parameters ..................................................................................................... 1-21
r o
Enter Items .................................................................................................................................................... 1-22
P
Practice - Create an Item ........................................................................................................................... 1-23
e
a l
Solution - Create an Item .......................................................................................................................... 1-24
Practice - Create a Material Transaction ................................................................................................... 1-25

e -s
Solution - Create a Material Transaction .................................................................................................. 1-27
Practice - Add an Item to a Price List ....................................................................................................... 1-29

r R
Solution - Add an Item to a Price List....................................................................................................... 1-30
Manage Parties and Customer Accounts ....................................................................................................... 1-31

y o
Practice - Create a Customer Profile Class................................................................................................ 1-32
Solution - Create a Customer Profile Class ............................................................................................... 1-34

o p
Practice - Create a Customer using the Standard Data Entry Form........................................................... 1-35
Solution - Create a Customer using the Standard Data Entry Form .......................................................... 1-38

- C
Practice - Create a Customer using the Quick Data Entry Form ............................................................... 1-41
Solution - Create a Customer using the Quick Data Entry Form............................................................... 1-42

i o n
Practice - Create a Customer Account Relationship.................................................................................. 1-43

a t
Solution - Create a Customer Account Relationship ................................................................................. 1-44
Enter Orders .................................................................................................................................................. 1-46

o r
Practice - Create a Sales Order Header ..................................................................................................... 1-47

r p
Solution - Create a Sales Order Header..................................................................................................... 1-49
Practice - Create a Sales Order Line ......................................................................................................... 1-50

C o
Solution - Create a Sales Order Line......................................................................................................... 1-51
Practice - Create a Split Line and Ship Set................................................................................................ 1-52

c le
Solution - Create a Split Line and Ship Set ............................................................................................... 1-54
Practice - Schedule an Order..................................................................................................................... 1-56
a
Or
Solution - Schedule an Order .................................................................................................................... 1-58
Practice - Book an Order........................................................................................................................... 1-60
Solution - Book an Order .......................................................................................................................... 1-62
© Practice - Copy a Sales Order ................................................................................................................... 1-64
Solution - Copy a Sales Order................................................................................................................... 1-66
Managing Orders........................................................................................................................................... 1-69
Practice - Work with the Order Organizer ................................................................................................ 1-70
Solution - Work with the Order Organizer................................................................................................ 1-72
Practice - Update a Sales Order ................................................................................................................ 1-74
Solution - Update a Sales Order................................................................................................................ 1-75
Practice - Perform a Mass Price Change ................................................................................................... 1-76
Solution - Perform a Mass Price Change .................................................................................................. 1-77

Copyright \'a9 Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices Table of Contents

i
Practice - Create a Hold Name.................................................................................................................. 1-78
Solution - Create a Hold Name ................................................................................................................. 1-79
Practice - Apply a Hold............................................................................................................................. 1-80
Solution - Apply a Hold ............................................................................................................................ 1-81
Practice - Release a Hold .......................................................................................................................... 1-82
Solution - Release a Hold.......................................................................................................................... 1-83
Practice - Cancel an Order Line ................................................................................................................ 1-84
Solution - Cancel an Order Line................................................................................................................ 1-85
Basic Pricing ................................................................................................................................................. 1-87
Practice - Create a Price List..................................................................................................................... 1-88
Solution - Create a Price List .................................................................................................................... 1-92
Practice - Copy a Price List....................................................................................................................... 1-96
Solution - Copy a Price List ...................................................................................................................... 1-97
Practice - Update a Price List Manually.................................................................................................... 1-98
Solution - Update a Price List Manually ................................................................................................... 1-100
Practice - Adjust a Price List..................................................................................................................... 1-102
t e d
bi
Solution - Adjust a Price List .................................................................................................................... 1-103
Practice - Add Items to a Price List........................................................................................................... 1-104
Solution - Add Items to a Price List .......................................................................................................... 1-106
h i
r
Practice - Create an Agreement Price List................................................................................................. 1-107
o
P
Solution - Create an Agreement Price List ................................................................................................ 1-110
Practice - Create a Discount Modifier List................................................................................................ 1-112
e
a l
Solution - Create a Discount Modifier List ............................................................................................... 1-116
Shipping ........................................................................................................................................................ 1-120

e -s
Practice - Grant Access to your User for Your Role ................................................................................. 1-121
Solution - Grant Access to your User for Your Role................................................................................. 1-122

r R
Practice - Pick Release Sales Orders......................................................................................................... 1-123
Solution - Pick Release Sales Orders ........................................................................................................ 1-125

y o
Practice - Ship Confirm a Delivery ........................................................................................................... 1-127
Solution - Ship Confirm a Delivery........................................................................................................... 1-129

o p
Practice - Define a Pick Slip Grouping Rule............................................................................................. 1-131

- C
Solution - Define a Pick Slip Grouping Rule ............................................................................................ 1-132
Practice - Define a Release Sequence Rule ............................................................................................... 1-133
Solution - Define a Release Sequence Rule .............................................................................................. 1-134

o n
Practice - Define a Release Rule ............................................................................................................... 1-135
i
t
Solution - Define a Release Rule............................................................................................................... 1-136
a
o r
Practice - Define a Shipping Role ............................................................................................................. 1-137
Solution - Define a Shipping Role............................................................................................................. 1-139

r p
Practice - Grant Access to a Role.............................................................................................................. 1-140

C o
Solution - Grant Access to a Role ............................................................................................................. 1-141
Process Invoices............................................................................................................................................ 1-143
Practice - Create an Invoice ...................................................................................................................... 1-144
le
Solution - Create an Invoice...................................................................................................................... 1-145
c
a
Practice - Copy an Invoice ........................................................................................................................ 1-146

Or
Solution - Copy an Invoice........................................................................................................................ 1-147
Practice - Create a Credit Memo ............................................................................................................... 1-148
Solution - Create a Credit Memo .............................................................................................................. 1-149
© Practice - Print a Transaction .................................................................................................................... 1-150
Solution - Print a Transaction.................................................................................................................... 1-151
Process Invoices Using Autoinvoice ............................................................................................................. 1-152
Practice - Process Invoices using AutoInvoice.......................................................................................... 1-153
Solution - Process Invoices using AutoInvoice ......................................................................................... 1-154
Manual Receipts............................................................................................................................................ 1-155
Practice - Enter a Manual Receipt............................................................................................................. 1-156
Solution - Enter a Manual Receipt ............................................................................................................ 1-157

Copyright \'a9 Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices Table of Contents

ii
Practice - Apply a Receipt......................................................................................................................... 1-158
Solution - Apply a Receipt ........................................................................................................................ 1-159
Practice - Use Mass Apply ........................................................................................................................ 1-160
Solution - Use Mass Apply ....................................................................................................................... 1-161
Implement Receipts....................................................................................................................................... 1-162
Practice - Define a Bank ........................................................................................................................... 1-163
Solution - Define a Bank........................................................................................................................... 1-164
Tax Accounting Process................................................................................................................................ 1-166
Practice - Define a Tax Code .................................................................................................................... 1-167
Solution - Define a Tax Code.................................................................................................................... 1-168

t e d
h i bi
r o
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright \'a9 Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices Table of Contents

iii
t e d
h ibi
ro
e P
a l
e-s
r R
y o
o p
- C
i on
a t
o r
rp
C o
c le
a
Or
©
Preface
Profile
Before You Begin This Course

Prerequisites

• Navigating Oracle Applications Release 11i

How This Course Is Organized

This is an instructor-led course featuring lecture and hands-on exercises. Online demonstrations
t e d
and written practice sessions reinforce the concepts and skills introduced.

h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright \'a9 Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices Table of Contents

v
Related Publications
Oracle Publications

Additional Publications

• System release bulletins

• Installation and user’s guides

• Read-me files

• International Oracle User’s Group (IOUG) articles

t e d
• Oracle Magazine
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright \'a9 Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices Table of Contents

vi
Typographic Conventions
Typographic Conventions in Text
Convention Element Example
Bold italic Glossary term (if The algorithm inserts the new key.
there is a glossary)
Caps and Buttons, Click the Executable button.
lowercase check boxes, Select the Can’t Delete Card check box.
triggers, Assign a When-Validate-Item trigger to the ORD block.
windows Open the Master Schedule window.
Courier new,
case sensitive
Code output,
directory names,
Code output: debug.set (‘I”, 300);
Directory: bin (DOS), $FMHOME (UNIX)
t e d
(default is
lowercase)
filenames,
passwords,
Filename: Locate the init.ora file.
Password: User tiger as your password.
h ibi
pathnames,
URLs,
Pathname: Open c:\my_docs\projects
ro
user input,
URL: Go to http://www.oracle.com
User input: Enter 300
e P
usernames Username: Log on as scott
a l
-s
Initial cap Graphics labels Customer address (but Oracle Payables)
(unless the term is a
proper noun)
R e
Italic Emphasized words
and phrases, r
Do not save changes to the database.
o
For further information, see Oracle7 Server SQL Language
titles of books and Reference Manual.
p y
courses,
variables
C
name of the user.o
Enter [email protected], where user_id is the

Quotation
marks
Interface elements
with long names -
Select “Include a reusable module component” and click Finish.

n
that have only
t i o This subject is covered in Unit II, Lesson 3, “Working with
initial caps;
r a Objects.”

p o
lesson and chapter
titles in cross-

o r
references
Uppercase
C
SQL column Use the SELECT command to view information stored in the

le
names, commands, LAST_NAME

a c functions, schemas,
table names
column of the EMP table.

Or
Arrow
Brackets
Menu paths
Key names
Select File > Save.
Press [Enter].
© Commas Key sequences Press and release keys one at a time:
[Alternate], [F], [D]
Plus signs Key combinations Press and hold these keys simultaneously: [Ctrl]+[Alt]+[Del]

Copyright \'a9 Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices Table of Contents

vii
Typographic Conventions in Code
Convention Element Example
Caps and Oracle Forms When-Validate-Item
lowercase triggers
Lowercase Column names, SELECT last_name
table names FROM s_emp;

Passwords DROP USER scott

IDENTIFIED BY tiger;
PL/SQL objects OG_ACTIVATE_LAYER
(OG_GET_LAYER (‘prod_pie_layer’))

Lowercase Syntax variables CREATE ROLE role

t e d
bi
italic
Uppercase SQL commands and
functions
SELECT userid
FROM emp;
h i
ro
Typographic Conventions in Oracle Application Navigation Paths
e P
a l
-s
This course uses simplified navigation paths, such as the following example, to direct you
through Oracle Applications.

R e
(N) Invoice > Entry > Invoice Batches Summary (M) Query > Find (B) Approve
o r
This simplified path translates to the following:
p y
1. o
(N) From the Navigator window, select Invoice then Entry then Invoice Batches
C
Summary.

n -
2.
i o
(M) From the menu, select Query then Find.
t
3. r
(B) Click the Approve button. a
p o
Notations:
o r
C
(N) = Navigator

c le
a
(M) = Menu

Or (T) = Tab
© (B) = Button

(I) = Icon

(H) = Hyperlink

(ST) = Sub Tab

Copyright \'a9 Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices Table of Contents

viii
Typographical Conventions in Oracle Application Help System Paths
This course uses a “navigation path” convention to represent actions you perform to find
pertinent information in the Oracle Applications Help System.

The following help navigation path, for example—

(Help) General Ledger > Journals > Enter Journals

—represents the following sequence of actions:

1. In the navigation frame of the help system window, expand the General Ledger entry.

2. Under the General Ledger entry, expand Journals.

t e d
3. Under Journals, select Enter Journals.
h ibi
4. Review the Enter Journals topic that appears in the document frame of the help system
ro
window.
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright \'a9 Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices Table of Contents

ix
t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright \'a9 Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices Table of Contents

x
t e d
h ibi
ro
e P
11i Order to Cash
a l
Fundamentals Supplemental
e -s
Practices
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 1
11i Order to Cash Fundamentals Supplemental Practices

11i Order to Cash Fundamentals t e d

Supplemental Practices
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 2
Objective

Objective

These Practices have been compiled to allow the

learner to apply their knowledge of Oracle Order
to Cash by completing exercises that build upon
one another.
t e d
In performing these practices, the learner will be
h ibi
able to obtain an understanding of the flow of
ro
transactions and the implications of system
e P
implementation decisions.
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 3
Practice - Instructor Preparation
Tasks
Verify that accounting periods in Accounts Receivable for Vision Operations and the Inventory
Organization - Seattle Manufacturing are open. The current month should correspond to the
current calendar period.

1. AR Periods

• Responsibility: Receivables Manager

• (N) Control > Accounting > Open/Close Periods

t e d
2. INV Periods
h ibi
• Responsibility: Inventory Super User, Vision Operations (USA) ro
e P
• (N) Accounting Close Cycle > Inventory Account Periods
a l
− Select appropriate Inventory Organization
e -s
3. De-select the Automatic Site Numbering for Customers.
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 4
Inventory Organizations

Inventory Organizations t e d
h ibi
ro
Supplemental Practices
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 5
Practice - Create a User
Overview
In this practice you will create a new user.

Assumptions
• If you are not attending training at an Oracle University or Authorized Partner
Education Center, you must have access to an Oracle Application Vision database or
comparable training test instance on which to complete this Practice.

i o n
• t
(N) Security > User > Define
a
r
− Name: your name [example: TNORTH]
o
p
− Password: Oracle [will need to enter twice for verification]
r
2.
C o
Assign responsibilities according to the following table:

c le
a
Or
Responsibility
Order Management Super User, Vision Operations (USA)
© Inventory, Vision Operations (USA)
Receivables Manager
System Administrator

Sign in as new user

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 6
3. From main sign-on screen, enter new user name and password

4. Change password to Welcome

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 7
Solution - Create a User
Log on to the System
− User Name = operations
− Password = welcome

Create new user

Responsibility = System Administrator

1. Navigate to the Users window

• (N) Security > User > Define

t e d
− Name: your name [example: TNORTH]
− Password: Oracle [will need to enter twice for verification]
h ibi
ro
2. (T) Responsibilities

e P
3. Assign responsibilities according to the following table:
a l
e -s
Responsibility
r R
Order Management Super User, Vision Operations (USA)
y o
Inventory, Vision Operations (USA)
o p
Receivables Manager
System Administrator - C
i o n
a t
4. (I) Save
o r
r p
o
Sign in as new user
C
5.
le
From main sign-on screen, enter new user name and password
c
a
Or
6. Change password to Welcome

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 8
Practice - Create a Unit of Measure
Overview
In this practice you will create a unit of measure.

i o n
2.
t
Create a new unit of measure class with the following information
a
− Name: XX-Quant
o r
− Description: XX Quantity
r p
− Base Unit: XX Each
o
− UOM: XXE
C
c le
Create a Unit of Measure
a
Or
3. Create a new unit of measure with the following information
− Name: XX Case
© − UOM: XXC
− Description: XX Case

Create a Unit of Measure Conversion

4. Create a new unit of measure conversion. XX Case has 15 XX Each.

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 9
Solution - Create a Unit of Measure
Create a Unit of Measure Class

Responsibility = Inventory, Vision Operations (USA)

1. Navigate to the Units of Measure Classes window

• (N) Setup > Units of Measure > Classes

If prompted, select V1: Vision Operations as the inventory organization

2. (I) New Record

t e d
bi
− Name: XX-Quant
− Description: XX Quantity
− Base Unit: XX Each h i
− UOM: XXE ro
e P
3. (I) Save
a l
Create a Unit of Measure
e -s
4. (B) Units of Measure
r R
5. (I) New Record y o
− Name: XX Case
o p
− UOM: XXC
− Description: XX Case - C
i o n
6.
t
(I) Save, close window to return to Unit of Measure Class window
a
o r
Create a Unit of Measure Conversion
r p
7.
o
(B) Conversions
C
8.
le
(I) New Record
c − Unit: XX Case
a
Or
− Conversion: 15

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 10
Practice - Create a Location
Overview
In this practice you will create a location.

ra
Address 13400 West Ocean Air Drive

O City San Diego

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 11
Solution - Create a Location
Create Location

Responsibility = Inventory, Vision Operations (USA)

1. Navigate to the Locations window

• (N) Setup > Organizations > Locations

− Name: XX-Location
− Global: Checked

2. (T) Address Details

t e d
− Address Style: United States
− Enter address information according to the following table:
h ibi
ro
e P
Field Value

a l
-s
Address 13400 West Ocean Air Drive
City San Diego
R e
State
Zip
CA
92130 o r
County San Diego p y
C o
n -
3. (B) OK
− Leave all defaults t i o
ra
4. (I) Save
p o
o r
C
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 12
Practice - Create an Inventory Organization
Overview
In this practice you will create a new inventory organization.

o
exercise to the inventory organization.
i n
t
− Organization Classification Name: Inventory Organization
a
− Enabled: Checked
o r
r p
3.
o
Specify the following inventory parameters
− Organization Code: XX1
C
− Item Master Organization: Vision Operations
c le Note: This will have defaulted as the new organization you must change the value
a
Or
to Vision Operations.
− Calendar: Vision01

© 4. Specify the following costing information

− Costing Method: Average
− Rates Cost Type: Current
− Transfer to GL: Summary
− Valuation: Accounts:

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 13
Account Type Account
Material 01-000-1410-0000-000
Outside Processing 01-000-1450-0000-000
Material Overhead 01-000-1420-0000-000
Overhead 01-000-1430-0000-000
Resource 01-000-1440-0000-000
Expense 01-000-2225-0000-000

5. Specify the following receiving information

t e d
bi
− Receiving: Accounts:

h i
Account Type Account ro
e P
Invoice Price Variance 01-540-5220-0000-000

a l
-s
Inventory AP Accrual 01-000-2215-0000-000

R e
− Receiving: Accounts:
o r
p y
Account Type Account
C o
Sales
-
01-540-4160-0000-000

n
Cost of Goods Sold

t i o
01-540-5110-0000-00

r a
o
− Cost Variance Account:
p
o r
C
cle
Account Type Account
Cost Variance Account 01-540-5220-0000-000

O ra
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 14
Solution - Create an Inventory Organization
Create Inventory Organization

Responsibility = Inventory, Vision Operations (USA)

1. Navigate to the Organizations window

• (N) Setup > Organization > Organization

2. (B) New
− Name: XX-IO
− Location: XX-Location
t e d
3. (I) Save
− Organization Classification Name: Inventory Organization h ibi
− Enabled: Checked ro
e P
4. (I) Save
a l
5. (B) Others > Inventory Information
e -s
6. (T) Inventory Parameters
r R
− Organization Code: XX1
− Item Master Organization: Vision Operations y o
o p
Note: This will have defaulted as the new organization you must change the value
to Vision Operations.
− Calendar: Vision01 - C
i o n
7. (T) Costing Information
a t
o r
− Costing Method: Average
− Rates Cost Type: Current
r p
− Transfer to GL: Summary

C o
− Valuation: Accounts:

c le
a
Or
Account Type Account
Material 01-000-1410-0000-000
© Outside Processing 01-000-1450-0000-000
Material Overhead 01-000-1420-0000-000
Overhead 01-000-1430-0000-000
Resource 01-000-1440-0000-000
Expense 01-000-2225-0000-000

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 15
8. (T) Other Accounts
− Receiving: Accounts:

Account Type Account

Invoice Price Variance 01-540-5220-0000-000
Inventory AP Accrual 01-000-2215-0000-000

− Receiving: Accounts:

t e d
Account Type Account
h ibi
Sales 01-540-4160-0000-000
ro
Cost of Goods Sold 01-540-5110-0000-00
e P
a l
− Cost Variance Account: e -s
r R
Account Type Account
y o
Cost Variance Account
o p
01-540-5220-0000-000

9. (I) Save - C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 16
Practice - Create a Subinventory
Overview
In this practice you will create a subinventory.

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 17
Solution - Create a Subinventory
Create Subinventory

Responsibility = Inventory, Vision Operations (USA)

1. Navigate to the Organizations window

• (N) Change Organization

2. Choose your organization (XX-IO) from the list

3. (N) Setup > Organizations > Subinventories

t e d
4. (B) New
− Name: XX-Stores h ibi
− Location: Stores ro
Note the values that have defaulted in (T) Main have come from the inventory
e P
organization definition
a l
5. (T) Accounts
e -s
organization definition
r R
Note the values that have defaulted in (T) Main have come from the inventory

6. (I) Save y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 18
Practice - Define Shipping Parameters
Overview
In this practice you will define shipping parameters.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Define Shipping Parameters
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Shipping Parameters window
y o
• (N) Shipping > Setup > Shipping Parameters o p
C
− When prompted, select your inventory organization, XX1
-
2.
o n
Specify the following general shipping parameters
i
t
− Weight UOM Class: Weight
a
r
− Volume UOM Class: Volume
o
p
− Percent Fill Basis: Weight (should default)
r
3.
C o
Specify the following pick/release parameters
− Release Sequence Rule: Departure Date
c le
− Default Pick Slip Grouping Rule: Order Number
a
Or
− Print Pick Slip: At End
− Default Stage Subinventory: XX-Stores
© − Auto Allocate: Checked
− Autocreate Deliveries: Checked
− Leave all other defaults

4. Specify the following shipping transaction parameters

− Weight/Volume Calculation: Manual
− Container Inventory Control: Optional

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 19
− Goods Dispatched Account: 01-000-1410-0000-000

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 20
Solution - Define Shipping Parameters
Define Shipping Parameters

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Shipping Parameters window

• (N) Shipping > Setup > Shipping Parameters

− When prompted, select your inventory organization, XX1

2. (T) General
− Weight UOM Class: Weight
t e d
− Volume UOM Class: Volume
− Percent Fill Basis: Weight (should default)
h ibi
ro
3. (T) Pick Release
− Release Sequence Rule: Departure Date
e P
− Default Pick Slip Grouping Rule: Order Number
a l
− Print Pick Slip: At End
− Default Stage Subinventory: XX-Stores e -s
− Auto Allocate: Checked
r R
− Autocreate Deliveries: Checked
− Leave all other defaults y o
o p
4. (T) Shipping Transaction
− Weight/Volume Calculation: Manual
- C
i o n
− Container Inventory Control: Optional

t
− Goods Dispatched Account: 01-000-1410-0000-000
a
5. (I) Save
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 21
Enter Items

Enter Items t e d
h ibi
ro
Supplemental Practices
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 22
Practice - Create an Item
Overview
In this practice you will create an item.

3.
c le
Specify a list price of 2.00
a
Or
4. Enable the item in the M1-Seattle Manufacturing and the XX1 inventory organizations

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 23
Solution - Create an Item
Define an Item

Responsibility = Inventory, Vision Operations (USA)

1. Navigate to the Master Items window

• (N) Items > Master Items

If prompted, select V1: Vision Operations

− Organization: V1 (should default)
− Item: XX-Mousepad
t e d
− Description: XX Mousepad
− Unit of Measure: XX Each
h ibi
ro
2. (M) Tools > Copy From…
− Template: Finished Good
e P
a l
3. (B) Apply
e -s
4. (B) Done
r R
5. (I) Save
y o
6. (T) Purchasing
o p
− List Price: 2.00
- C
7. (I) Save
i o n
a t
8.
r
(M) Tools > Organization Assignment
o
If grayed out, you haven’t saved.
r p
− Query and enable the following organizations: M1-Seattle Manufacturing and XX1-
o
your inventory organization
C
9.
le
(I) Save
c
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 24
Practice - Create a Material Transaction
Overview
In this practice you will create a material transaction.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Enter quantities for M1-Seattle Manufacturing
e -s
Responsibility = Inventory, Vision Operations (USA)
r R
1. Navigate to the Organizations window
y o
• (N) Change Organization o p
− Select M1: Seattle Manufacturing
- C
2.
o n
Enter a miscellaneous transaction using the following information:
i
− Date: Leave as default
a t
r
− Type: Miscellaneous Receipt
o
p
− Account: 01-580-7740-0000-000 (or use Miscellaneous Account Alias)
r
C o
3. The miscellaneous transaction should accomplish the following for your XX-Mousepad
item:
c le
− The Stores subinventory quantity should be incremented 10000
a
Or
Open current period for your inventory organization

5. (N) Accounting Close Cycle > Inventory Accounting Periods

− Select Line with current period displayed

6. Change the status to open the period

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 25
Enter quantities for your XX-IO inventory organization

7. (N) Transactions > Miscellaneous Transactions

− Date: Leave as default
− Type: Miscellaneous Receipt
− Account: 01-580-7740-0000-000 (or use Miscellaneous Account Alias)

8. The miscellaneous transaction should accomplish the following for your XX-Mousepad
item:
− The Stores subinventory quantity should be incremented 10000

9. (I) Save

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 26
Solution - Create a Material Transaction
Enter quantities for M1-Seattle Manufacturing

Responsibility = Inventory, Vision Operations (USA)

1. Navigate to the Organizations window

• (N) Change Organization

− Select M1: Seattle Manufacturing

2. (N) Transactions > Miscellaneous Transactions

− Date: Leave as default
t e d
− Type: Miscellaneous Receipt
− Account: 01-580-7740-0000-000 (or use Miscellaneous Account Alias)
h ibi
ro
3. (B) Transaction Lines
− Item: XX-Mousepad
e P
− Subinventory: Stores
a l
− UOM: leave default
− Quantity: 10000 e -s
r R
4. (I) Save, return to Navigator

y o
Open current period for your inventory organization
o p
5. (N) Change Organization
- C
6.
o
Select XX1 (your inventory organization)
i n
a t
7.
r
(N) Accounting Close Cycle > Inventory Accounting Periods
o
− Select Line with current period displayed
r p
8. o
(B) Change Status
C
9.
le
(B) OK
c
a
Or
10. Return to Navigator

© Enter quantities for your XX-IO

11. (N) Transactions > Miscellaneous Transactions

− Date: Leave as default
− Type: Miscellaneous Receipt
− Account: 01-580-7740-0000-000 (or use Miscellaneous Account Alias)

12. (B) Transaction Lines

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 27
− Item: XX-Mousepad
− Subinventory: XX-Stores
− UOM: leave default
− Quantity: 10000

13. (I) Save

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 28
Practice - Add an Item to a Price List
Overview
In this practice you will create a price list.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Add item to Corporate price list
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Price Lists window
y o
• (N) Pricing > Price Lists > Price List Setup o p
2. - C
Add your item to the Corporate price list using the following information:
− Product Context: Item
i o n
t
− Product Attribute: Item Number
a
r
− Product Value: XX-Mousepad
o
− Value: 7.50
r p
o
− Leave all other defaults
C
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 29
Solution - Add an Item to a Price List
Add item to Corporate price list

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Price Lists window

• (N) Pricing > Price Lists > Price List Setup

2. Query Corporate Price List

3. (T) List Lines

t e d
4. (I) New Record
− Product Context: Item h ibi
− Product Attribute: Item Number ro
− Product Value: XX-Mousepad
e P
− Value: 7.50
a l
− Leave all other defaults
e -s
5. (I) Save
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 30
Manage Parties and Customer Accounts

Manage Parties and Customer Accounts t e d

h ibi
ro
Supplemental Practices
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 31
Practice - Create a Customer Profile Class
Overview
In this practice you will create a customer profile class

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Create a new customer profile class: XX-New
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Profile Classes window
y o
• (N) Customers > Profile Classes o p
− Name: XX-New
-
− Description (unnamed field): XX New
C
i o n
2. t
Use the following information to define your profile class:
a
− Collector: Pat
o r
p
− Payment Terms: 30 Net
r
C o
− Match Receipts By: Transaction Number
− Auto Cash Rule Set: Standard

c le
− Remainder Rule Set: Standard
− Charge Interest : Unchecked
a
Or
− Statement Cycle: Monthly (25th day of every month)
− Tax Printing Method: Itemize and Sum
© − Dunning Letter Set: STANDARD

3. Use the following information to specify limits in USD

− Min Receipt Amount: 15.00
− Min Statement Amount: 100.00
− Min Dunning Amount: 50.00
− Min Dunning Invoice Amount: 50.00

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 32
− Credit Limit: 100,000.00
− Order Credit Limit: 10,000.00

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 33
Solution - Create a Customer Profile Class
Create a new customer profile class: XX-New

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Profile Classes window

• (N) Customers > Profile Classes

− Name: XX-New
− Description (unnamed field): XX New

2. (T) Profile Class

t e d
− Collector: Pat
− Payment Terms: 30 Net
h ibi
− Match Receipts By: Transaction Number
ro
− Auto Cash Rule Set: Standard
− Remainder Rule Set: Standard
e P
− Charge Interest : Unchecked
a l
− Statement Cycle: Monthly (25th day of every month)
− Tax Printing Method: Itemize and Sum e -s
− Dunning Letter Set: STANDARD
r R
3. Leave all other defaults y o
o p
4. (T) Profile Class Amounts
− Currency: USD
- C
− Min Receipt Amount: 15.00
i o n
a t
− Min Statement Amount: 100.00
− Min Dunning Amount: 50.00
o r
− Min Dunning Invoice Amount: 50.00
r p
− Credit Limit: 100,000.00
o
− Order Credit Limit: 10,000.00
C
5.
c le
(I) Save
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 34
Practice - Create a Customer using the Standard Data Entry Form
Overview
In this practice you will create a customer using the standard customer entry form.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Create a new customer: XX-Big City, with two addresses
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Find/Enter Customers window
y o
• (N) Customers > Standard o p
− Name: XX-Big City
- C
2.
o n
Create customer XX-Big City with the following information:
i
− Profile Class: XX-New
a t
r
− Class: High Technology
o
p
− Sales Channel: Commercial
r
o
− Price List: Corporate
C
3.
le
Enter address information according to the following table:
c
a
Or Field Value

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 35
County Cook

4. This address is a non-primary Bill To address:

− Location: IL Chicago

5. This address is the primary Ship To address. Invoices should be sent to the IL Chicago Bill
To location.
− Location: IL Chicago

6. Specify salesperson information:

− Salesperson: Abbott, Ms. Rachel

t e d
7. Specify default order information.
− Order Type: Mixed
h ibi
− Warehouse: Seattle Manufacturing
ro
8. Specify contact information.
e P
− Last Name: Cooley
a l
− First: Peggy
e -s
9. Add a second address entering address information according to the following table:
r R
y o
Field Value
o p
Country United States
- C
Address
n
487 Beverly

i o
City
a t Palo Alto

or
State CA

rp
Postal Code 94301

Co
County San Mateo

c le
a
10. This address is the primary Bill To address.

Or
− Location: CA Palo Alto

12. Specify salesperson information:

− Salesperson: Nelson, Mr. Brian

13. Specify default order information.

− Order Type: Mixed
Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 36
− Warehouse: XX-IO

14. Specify contact information.

− Last Name: Allen
− First: Spencer

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 37
Solution - Create a Customer using the Standard Data Entry Form
Create a new customer: XX-Big City, with two addresses

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Find/Enter Customers window

• (N) Customers > Standard

− Name: XX-Big City

2. (B) Find

t e d
bi
3. (B) New

4. (T) Classification h i
− Profile Class: XX-New ro
− Class: High Technology
e P
− Sales Channel: Commercial
a l
5. (T) Order Management
e -s
− Price List: Corporate

r R
6. (T) Addresses
y o
7. (B) New
o p
8.
- C
Enter address information according to the following table:

i o n
a t
or
Field Value

rp
Country United States

Co
Address 102 N. LaSalle
City Chicago

c le State IL
a
Or
Postal Code 60601
County Cook
©
9. (T) Business Purpose
− Usage: Bill To
− Location: IL Chicago
− Primary: Unchecked

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 38
10. (I) Save

11. (I) New Record

− Usage: Ship To
− Location: IL Chicago
− Bill To Location: IL Chicago
− Primary: Checked

12. (B) Open

13. (T) Details

− Salesperson: Abbott, Ms. Rachel

14. (T) Order Management

t e d
− Order Type: Mixed
− Warehouse: Seattle Manufacturing
h ibi
ro
15. (I) Save, return to Customer Address form.

e P
16. (T) Contacts: Telephones
a l
− Last Name: Cooley
− First: Peggy
e -s
17. (I) Save r R
− Place cursor in Country field at top of form
y o
18. (I) New Record
o p
C
− Enter address information according to the following table:
-
i o n
Field
a t Value
Country
o r United States
p
or
Address 487 Beverly

e C City Palo Alto

cl
State CA

r a Postal Code 94301

O County San Mateo

20. (I) Save

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 39
21. (I) New Record
− Usage: Ship To
− Location: CA Palo Alto
− Bill To Location: CA Palo Alto
− Primary: Unchecked

22. (B) Open

23. (T) Details

− Salesperson: Nelson, Mr. Brian

24. (T) Order Management

− Order Type: Mixed
− Warehouse: XX-IO
t e d
25. (I) Save, return to Customer Address form.
h ibi
ro
26. (T) Contacts: Telephones
− Last Name: Allen
e P
− First: Spencer
a l
27. (I) Save
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 40
Practice - Create a Customer using the Quick Data Entry Form
Overview
In this practice you will create a customer using the quick customer entry form.

C o Country
Address
United States
888 Market

c le City San Francisco

a
Or
State CA
Postal Code 94100
© County San Francisco

3. This site will be both a Bill To and a Ship To site

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 41
Solution - Create a Customer using the Quick Data Entry Form
Create a new customer: XX-Quick

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Find/Enter Customers window

• (N) Customers > Quick

− Name: XX-Quick
− (B) Find
− (B) New [for creating new customer]

t e d
2. (T) Address

h ibi
3. (B) New [for creating new address]
ro
4. Enter address information according to the following table:
e P
a l
Field Value
e -s
Country United States
r R
Address 888 Market
y o
City San Francisco
o p
State
Postal Code
CA
94100 - C
i o n
County

a t San Francisco

o r
r p
5.
o
(T) Business Purpose
C
− Bill To: Checked

c le
− Ship To: Checked

a
Or
6. (I) Save

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 42
Practice - Create a Customer Account Relationship
Overview
In this practice you will create a customer relationship.

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 43
Solution - Create a Customer Account Relationship
Create a relationship between XX-Big City and Business World (1608)

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Find/Enter Customers window

• (N) Customers > Standard

− Name: XX-Big City

2. (B) Find

t e d
bi
3. Select the Customer Account record for Big City

4. (B) Ok h i
ro
5. (T) Relationships
e P
− Name: Business World
− Number: 1608 a l
− Type: Reciprocal
e -s
6. Leave all other defaults
r R
7. (I) Save y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 44
t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 45
Enter Orders

Enter Orders t e d
h ibi
ro
Supplemental Practices
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 46
Practice - Create a Sales Order Header
Overview
In this practice you will create a sales order header.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Create a sales order header
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Sales Orders window
y o
• (N) Orders, Returns > Sales Orders o p
2. - C
Create a sales order for the following customer. Associate purchase order number XX-100
with the sales order.
i o n
− Customer: XX-Big City
a t
o r
3.
p
Note the values that default into the header:
r
− Order Type: Mixed
o
− Price List: Corporate
C
− Ship To Location: IL Chicago
c le
− Salesperson: Abbot, Ms. Rachel
a
Or
− Bill To Location: IL Chicago

© Split sales credit between Rachel Abbot and Timothy Cleary

4. Specify sales credit information according to the following table:

Salesperson Percent
Abbot, Ms. Rachel 75%

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 47
Cleary, Mr. Timothy 25%

5. Note Sales Order Number________________________

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 48
Solution - Create a Sales Order Header
Create a sales order header

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Sales Orders window

• (N) Orders, Returns > Sales Orders

2. (T) Order Information (T) Main

− Customer: XX-Big City
− Customer PO: XX-100
t e d
3. Note the values that default into the header:
− Order Type: Mixed h ibi
− Price List: Corporate ro
− Ship To Location: IL Chicago
e P
− Salesperson: Abbot, Ms. Rachel
a l
− Bill To Location: IL Chicago
e -s
Split sales credit between Rachel Abbot and Timothy Cleary
r R
4. (B) Actions > Sales Credits
y o
5. Change Rachel Abbot’s sales credit to 75% o p
Salesperson: Abbot, Ms. Rachel
- C
− Credit Type: Quota Sales Credit (should default)
− %: 75.000
i o n
a t
6.
r
Add Timothy Cleary’s 25% sales credit
o
− Salesperson: Cleary, Mr. Timothy
r p
− Credit Type: Quota Sales Credit (should default)
o
− %: 25.000
C
7.
c le
(B) Ok
a
Or
8. (I) Save

© 9. Note Sales Order Number________________________

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 49
Practice - Create a Sales Order Line
Overview
In this practice you will create a sales order line.

i o n
3.
t
Create sales order lines according to the following table:
a
o r
p
C
Item
XX-Mousepad or 5
Quantity Request Date
Today’s date

cle
CM13139 30 One week from today

r a
O
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 50
Solution - Create a Sales Order Line
Create a Sales Order Line

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Sales Orders window

• (N) Orders, Returns > Sales Orders

2. If you are not currently in the sales order from the prior practice, query it now.

3. (T) Line Items (T) Main

t e d
bi
− Item: XX-Mousepad
− Qty: 5
− Request Date: today’s date h i
ro
4. (I) Save
e P
a l
-s
5. (I) New Record
− Item: CM13139
− Qty: 30
R e
− Request Date: one week from today
o r
6. (I) Save
p y
C o
n -
t i o
r a
p o
o r
C
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 51
Practice - Create a Split Line and Ship Set
Overview
In this practice you will create a split line and ship set.

Or − Date: Today’s date

− Warehouse: XX1
© 5. (I) New Record
− Qty: 50
− Date: Today’s date +7
− Warehouse: M1
− (B) Split

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 52
6. (I) New Record
− Item: AS92689
− Qty: 5
− Warehouse: M1
− Date: Today’s date +7

Create a ship set including line 1.2 and line 2.1

7. Shift + Left Mouse click, highlight lines 1.2 and 2.1

8. Right Mouse click > Sets > New > Ship Set
− Set Name: XX-SS1

9. (B) Ok
t e d
10. View results of ship set creation
h ibi
11. (T) Shipping ro
e P
12. Note Sales Order Number________________________
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 53
Solution - Create a Split Line and Ship Set
Split an order line into shipments and create a ship set.

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Sales Orders windows

• (N) Orders, Returns > Sales Orders

2. (T) Order Information (T) Main

− Customer: XX-Big City
− Customer PO: XX-200
t e d
3. (T) Line Items (T) Main
− Item: XX-Mousepad h ibi
− Qty: 100 ro
e P
4. (B) Actions > Split Line
a l
− Qty: 50
− Date: Today’s date
e -s
− Warehouse: XX1
r R
5. (I) New Record
y o
− Qty: 50
− Date: Today’s date +7 o p
− Warehouse: M1
- C
− (B) Split
i o n
6. (I) New Record
a t
− Item: AS92689
o r
− Qty: 5
r p
C o
− Warehouse: M1
− Date: Today’s date +7

c le
Create a ship set including line 1.2 and line 2.1
a
Or
7. Shift + Left Mouse click, highlight lines 1.2 and 2.1

9. (B) Ok

10. View results of ship set creation

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 54
11. (T) Shipping

12. Note Sales Order Number________________________

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 55
Practice - Schedule an Order
Overview
In this practice you will schedule an order for shipping.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Create Sales Order referencing purchase order XX-300
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Sales Orders window
y o
• (N) Orders, Returns > Sales Orders o p
2. -
Create a sales order for the following customer:
C
− Customer: XX-Big City
i o n
a t
3.
r
Specify the following sales order information
o
− Item: XX-Mousepad
− Qty: 150r p
o
− Request Date: Today’s Date + 45 days
C
− Line Type: Standard (Header Invoicing)
c le
a
Or
4. Ensure the sales order references purchase order XX-300

Check Availability
© 6. Check availability and if there is quantity available, continue on to scheduling.

Schedule order line

7. (M) Tools > Scheduling > Schedule

8. (B) OK
Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 56
9. Note the scheduling activity has occurred for the request date.

10. (T) Shipping

Reserve order line

11. (M) Tools > Scheduling > Reserve

12. (B) OK

13. Note the Qty Reserved field has been populated

14. (T) Shipping

Use Autoschedule for additional order line

t e d
15. (M) Tools > Autoschedule (make sure this is checked)
h ibi
ro
16. (I) New Record
− Item: AS18947
e P
− Qty: 2
a l
Note: Tab out of the quantity field to see the Availability displayed automatically
e -s
17. (I) Save r R
y o
18. Note the Qty Reserved field has been populated
o p
19. (T) Shipping
- C
20. (I) Save
i o n
a t
r
21. Note Sales Order Number________________________
o
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 57
Solution - Schedule an Order
Create Sales Order referencing purchase order XX-300

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Sales Orders window

• (N) Orders, Returns > Sales Orders

2. (T) Order Information (T) Main

− Customer: XX-Big City
− Customer PO: XX-300
t e d
3. (T) Line Items (T) Main
− Item: XX-Mousepad h ibi
− Qty: 150 ro
− Request Date: Today’s Date + 45 days
e P
− Line Type: Standard (Header Invoicing)
a l
Check Availability
e -s
4. (B) Availability r R
y o
5.
p
If there is quantity available, continue on to scheduling.
o
Schedule order line
- C
6. (M) Tools > Scheduling > Schedule
i o n
a t
7. (B) OK
o r
8.
r p
Note the scheduling activity has occurred for the request date.

9.
C
(T) Shippingo
c le
Reserve order line
a
Or
10. (M) Tools > Scheduling > Reserve

12. Note the Qty Reserved field has been populated

13. (T) Shipping

Use Autoschedule for additional order line

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 58
14. (M) Tools > Autoschedule (make sure this is checked)

15. (I) New Record

− Item: AS18947
− Qty: 2

Note: Tab out of the quantity field to see the Availability displayed automatically

16. (I) Save

17. Note the Qty Reserved field has been populated

18. (T) Shipping

t e d
bi
19. (I) Save

20. Note Sales Order Number________________________

h i
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 59
Practice - Book an Order
Overview
In this practice you will book a sales order.

c le
5.
a
(B) Actions > Book Order

Or
6. (B) Continue
© 7. Note status change of the sales orders

Verify workflow activities for your order (PO number XX-200)

8. Select sales order linked to PO: XX-200

9. View the status in Workflow

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 60
10. (M) Tools > Workflow Status

11. Click on first OM Order Line link

12. (B) View Diagram

Verify line has been entered successfully

13. Double click on Enter - Line activity

Verify scheduling activities have occurred

14. Double click Schedule - Line activity

Verify product will ship from internal (stock) inventory locations

t e d
15. Double click on Create Supply – Line activity
h ibi
ro
Verify Ship activity is current activity for line flow

e P
16. Double click on Ship - Line, Manual activity
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 61
Solution - Book an Order
Book a Sales Order

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Order Organizer window

• (N) Orders, Returns > Order Organizer

2. (I) Find
− Customer Name: XX-Big City

t e d
bi
3. (B) Find

Book your orders h i

ro
4. Using Shift + Click, highlight your sales order
e P
5. (B) Actions > Book Order
a l
6. (B) Continue e -s
r R
7. Note status change of the sales orders
y o
Verify workflow activities for your order (PO number XX-200)
o p
8. Select sales order linked to PO: XX-200
- C
9. View the status in Workflow
i o n
a t
r
10. (M) Tools > Workflow Status
o
r p
11. Click on first OM Order Line link

C o
12. (B) View Diagram

c le
Verify line has been entered successfully
a
Or
13. Double click on Enter - Line activity
© 14. (B) Zoom out

Verify scheduling activities have occurred

15. Double click Schedule - Line activity

16. (B) Zoom out

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 62
Verify product will ship from internal (stock) inventory locations

17. Double click on Create Supply – Line activity

18. (B) Zoom out

Verify Ship activity is current activity for line flow

19. Double click on Ship - Line, Manual activity

20. Close Workflow Diagram window

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 63
Practice - Copy a Sales Order
Overview
In this practice you will copy a sales order.

i o n
Copy sales order
a t
3. (B) Actions > Copy
o r
r p
4. o
(T) Quick Copy
C
5.
le
Accept default option to Create New Order
c− Order Type: Mixed
a
Or Note: a note window will pop, indicating:
© − The Customer PO was referenced by another order
− The copy has succeeded
− The new Order Number

6. Note Sales Order Number________________________

Update Information on copied order

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 64
7. Find, and open your sales order
− Order number: from above

8. Specify the following order information

− Ship To: CA Palo Alto
− Salesperson: Abbott, Ms. Rachel

9. Update the Ship To Address for both lines on the sales order to CA Palo Alto

10. For the second line, update the shipping warehouse to M1, Seattle Manufacturing

Add additional line to new sales order

11. Add a new line using the following information.

t e d
bi
− Item: AS72111
− Qty: 1
− Request Date: Today’s date h i
− Warehouse: M1 ro
e P
12. Book the order
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 65
Solution - Copy a Sales Order
Find sales order referenced by PO: XX-100

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Sales Orders window

• (N) Orders, Returns > Sales Orders

2. (I) Find
− Customer: XX-Big City
− Customer PO: XX-100
t e d
3. (B) Find
h ibi
Copy sales order ro
e P
4. (B) Actions > Copy
a l
5. (T) Quick Copy
e -s
6. Accept default option to Create New Order
r R
− Order Type: Mixed
y o
7. (T) Copy Header
− Accept all defaults o p
- C
8. (T) Copy Line
− Accept all defaults
i o n
a t
9. (T) Pricing Option
o r
p
− Accept all defaults
r
10. (B) Ok
C o
c le
Note: a note window will pop, indicating:
a
Or
− The Customer PO was referenced by another order
− The copy has succeeded
− The new Order Number
©
11. Note Sales Order Number________________________

12. (B) Continue

13. (B) Cancel

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 66
Note: if you select the Ok button again, you will copy the order a second time.

14. Return to Order Organizer

Update Information on copied order

15. (I) Find

− Order number: from above

16. (B) Find

17. (B) Open Order

18. (T) Order Information (T) Main

− Ship To: CA Palo Alto
t e d
− Salesperson: Abbott, Ms. Rachel
h ibi
19. (T) Line Items (T) Addresses
ro
e P
20. Update the Ship To Address for both lines on the sales order
− Ship To: CA Palo Alto
a l
21. For the second line, update the shipping warehouse to M1, Seattle Manufacturing e -s
− Warehouse: M1
r R
22. (I) Save
y o
Add additional line to new sales order o p
- C
23. (I) New Record
− Item: AS72111
i o n
− Qty: 1
a t
r
− Request Date: Today’s date
o
− Warehouse: M1
r p
24. (I) Save
C o
c le
25. (B) Book Order
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 67
t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 68
Managing Orders

Managing Orders t e d
h ibi
ro
Supplemental Practices
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 69
Practice - Work with the Order Organizer
Overview
In this practice you will work with the Order Organizer.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Create Default Summary form
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Order Organizer window
y o
• (N) Orders, Returns > Order Organizer o p
2. Close the Find window - C
i o n
3.
t
Create a new folder according to the following information:
a
o r
− Folder: XX-Summary
− Open as Default: Checked
r p
o
Create a personalized folder
C
4. le
Shrink the status field and change the Customer PO filed to PO.
c
a
Or
5. Move Customer PO field to the right of the Status field

© 6. Save your folder according to the following information:

− Folder: XX-Custom
− Open as Default: Unchecked

Save a Query in the Navigator Tree

7. Query orders for XX-Big City

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 70
8. Save your query in Navigator Tree

9. Select Search Results from Navigator Tree

10. Use Right Mouse click to open pop window

11. Select Save Query

− Name: XX-Big City
− Public: Checked

12. Note your folder’s appearance in the Public Folder of the Navigator Tree

Look at Today’s Orders

t e d
bi
13. Double Click on the “Today’s Orders” folder in Navigator Tree

h i
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 71
Solution - Work with the Order Organizer
Create Default Summary form

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Order Organizer window

• (N) Orders, Returns > Order Organizer

2. Close the Find window

3. (M) Folder > New

t e d
bi
− Folder: XX-Summary
− Open as Default: Checked
h i
4. (B) Ok ro
e P
5. (M) Folder > Save
a l
Create a personalized folder
e -s
Shrink the status field and change the prompt.
r R
6. (I) Folder Tools
y o
7. Place cursor in Status field o p
- C
8. Click the Shrink field icon twice

i o n
9. Scroll to Customer PO field
a t
o r
r
− Prompt: PO p
10. (M) Folder > Change Prompt

11. (B) Ok C o
c le
a
12. Move Customer PO field to the right of the Status field

Or
13. Use your mouse to “drag” the Customer PO field to the left
© 14. (M) Folder > Save As
− Folder: XX-Custom
− Open as Default: Unchecked

15. (B) Ok

Save a Query in the Navigator Tree

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 72
16. Query your customer’s orders

17. (I) Find

− Customer: XX-Big City

18. (B) Find

19. Save your query in Navigator Tree

20. Select Search Results from Navigator Tree

21. Use Right Mouse click to open pop window

22. Select Save Query

− Name: XX-Big City
t e d
− Public: Checked
h ibi
23. (B) Ok
ro
e P
24. Note your folder’s appearance in the Public Folder of the Navigator Tree
a l
Look at Today’s Orders
e -s
25. Double Click on “Today’s Orders” folder in Navigator Tree
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 73
Practice - Update a Sales Order
Overview
In this practice you will update a sales order.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Update your sales order referencing customer PO XX-200
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Order Organizer window
y o
• (N) Orders, Returns > Order Organizer o p
− Customer: XX-Big City
− Customer PO: XX-200 - C
i o n
2. t
Change the sales channel and shipping instructions based on the following information:
a
r
− Sales Channel: Commercial
o
p
− Shipping Instructions: Contact Sales team upon shipment
r
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 74
Solution - Update a Sales Order
Update your sales order referencing customer PO XX-200

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Order Organizer window

• (N) Orders, Returns > Order Organizer

− Customer: XX-Big City
− Customer PO: XX-200

2. (B) Find
t e d
3. Select sales order referencing Customer PO: XX-200
h ibi
4. (B) Open Order ro
e P
5. (T) Order Information (T) Others
− Sales Channel: Commercial a l
e -s
6. (T) Line Items (T) Shipping
r R
7. Select line 2
− Shipping Instructions: Contact Sales team upon shipment y o
o p
8. (I) Save
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 75
Practice - Perform a Mass Price Change
Overview
In this practice you will perform a mass price change.

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 76
Solution - Perform a Mass Price Change
Perform a Mass Line Change

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Order Organizer window

• (N) Orders, Returns > Order Organizer

− Customer: XX-Big City
− Customer PO: XX-300

2. (B) Find
t e d
3. (T) Lines
h ibi
4. Use Control + Click to select the lines 1.1 and 1.2 ro
e P
5. (M) Tools > Mass Change
a l
6. (T) Shipping
− Shipping Priority: High Priority e -s
r R
7. (B) Ok (to initiate mass change)
y o
8. (B) Ok (to acknowledge message regarding mass change)
o p
9. (B) Open Order
- C
10. (T) Line Items (T) Shipping
i o n
a t
r
11. Note update of line information
o
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 77
Practice - Create a Hold Name
Overview
In this practice you will create a hold name.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Create Hold Name
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Holds window
y o
• (N) Setup > Orders > Holds o p
− Name: XX-My Hold
− Type: Order Administration Hold - C
i o n
2. Record Authorizations:
a t
r
− Responsibility: Order Management Super User, Vision Operations (USA)
o
p
− Authorized Action: Apply Hold
r
C o
− Responsibility: Order Management Super User, Vision Operations (USA)
− Authorized Action: Remove Hold

c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 78
Solution - Create a Hold Name
Create Hold Name

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Holds window

• (N) Setup > Orders > Holds

− Name: XX-My Hold
− Type: Order Administration Hold

2. Record Authorizations:
t e d
− Responsibility: Order Management Super User, Vision Operations (USA)
− Authorized Action: Apply Hold
h ibi
− Responsibility: Order Management Super User, Vision Operations (USA)
ro
− Authorized Action: Remove Hold
e P
3. (I) Save
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 79
Practice - Apply a Hold
Overview
In this practice you will apply a hold.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Apply an Order Level Hold to the order referenced by customer PO XX-200
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Order Organizer window
y o
• (N) Orders, Returns > Order Organizer o p
− Customer: XX-Big City
− Customer PO: XX-200 - C
i o n
2. (B) Find
a t
o r
3.
p
Apply the following hold and comments:
r
− Hold Name: XX-My Hold
o
− Comments: add at your discretion
C
c le
View Hold Information
a
Or
4. Use Additional Hold Information to view the hold information associated with the order

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 80
Solution - Apply a Hold
Apply an Order Level Hold to the order referenced by customer PO XX-200

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Order Organizer window

• (N) Orders, Returns > Order Organizer

− Customer: XX-Big City
− Customer PO: XX-200

2. (B) Find
t e d
3. (B) Actions > Apply Holds
− Hold Name: XX-My Hold h ibi
− Comments: add at your discretion ro
e P
4. (B) Apply Holds
a l
5. (B) Ok
e -s
View Hold Information
r R
6. (B) Action > Additional Order Information (T) Holds y o
o p
7. Note your hold information is contained on the form
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 81
Practice - Release a Hold
Overview
In this practice you will release a hold.

C
le
3. Use Additional Order information to view the release reason associated with the hold.

a c
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 82
Solution - Release a Hold
Release an Order Level Hold against order referenced by customer PO XX-200

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Order Organizer window

• (N) Orders, Returns > Order Organizer

− Customer: XX-Big City
− Customer PO: XX-200

2. (B) Find
t e d
3. (B) Actions > Release Holds
− Reason: Approved by Sales Manager h ibi
ro
4. (B) Release
e P
a l
-s
5. (B) Ok

View Hold Information

R e
6. (B) Action > Additional Order Information (T) Holds
o r
p y
7.
o
Note your release is noted on form, including your username.

C
n -
t i o
r a
p o
o r
C
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 83
Practice - Cancel an Order Line
Overview
In this practice you cancel an order line.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Cancel one line of an existing order
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Order Organizer window
y o
• (N) Orders, Returns > Order Organizer o p
− Customer: XX-Big City
− Customer PO: XX-200 - C
i o n
2. t
Cancel line 2.1 and view the status field to see the changed status.
a
r
− Reason: Administrative or procedural error
o
p
− Comments: enter at your discretion
r
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 84
Solution - Cancel an Order Line
Cancel one line of an existing order

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Order Organizer window

• (N) Orders, Returns > Order Organizer

− Customer: XX-Big City
− Customer PO: XX-200

2. (B) Find
t e d
3. (B) Open Order
h ibi
4. (T) Line Items ro
e P
5. Put your cursor on Line 2.1 (AS92689)
a l
6. (B) Action > Cancel
− Reason: Administrative or procedural error e -s
− Comments: enter at your discretion
r R
7. (B) Ok y o
o p
8. (T) Main
- C
9. Note the updated Qty value.
i o n
a t
10. Scroll to Status field to see changed status.

o r
p
11. Scroll to Qty Cancelled field to see updated quantity.
r
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 85
t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 86
Basic Pricing

Basic Pricing t e d
h ibi
ro
Supplemental Practices
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 87
Practice - Create a Price List
Overview
In this practice you will create a price list.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
r o
e P
Tasks
a l
Create Price List Header and Lines
e -s
Responsibility = Order Management Super User, Vision Operation( USA)
r R
1. Navigate to the Advanced Pricing - Price Lists window
y o
• (N) Pricing > Price List > Price List Setup o p
− Name: XX-Base Prices
− Active: Checked - C
o
− Description: Corporate Base Price
i n
− Currency: USD
a t
− Round To: -2
o r
r p
2.
o
Add the following items to the price list. Save after each line.
C
c le
Product Product Product Value Primary Line Application Value
a
Or
Attribute UOM Type Method
Context UOM

Item Item AS54999 Ea Checked Price Unit Price 1700

Number List
Line
Item Item AS18947 Ea Unchecked Price Unit Price 1800

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 88
Number List
Line
Item Item AS72111 DZ Unchecked Price Unit Price 2208
Number List
Line
Item Item XX-Mouse Pad XXE Unchecked Price Unit Price 7.50
Number List
Line
Item Item WR18533 YR Checked Price Percent Price 5
Number List
Line
Item Item
Category
COMPUTER.
NOTEBOOK
Ea Unchecked Price
List
Unit Price 2000

t e d
Line

h ibi
r o
Create Sales Order referencing your price list
e P
a l
3. (N) Orders, Returns > Sales Order (T) Main
− Customer Name: XX-Big City
e -s
− Customer PO: XX-400
− Price List: XX-Base Prices r R
y o
4. Populate any required fields that have not defaulted
o p
Order internal item number: AS18947 with a UOM of DZ
- C
5. Enter line 1 as follows:
i o n
a t
o r
Line Item
r p Quantity UOM
1.1
C o
AS18947 1 DZ

c le
a
Or
6. Change UOM to Ea

© Add additional lines to your sales order

7. Add additional lines to your order and note resulting unit price

Line Item Quantity UOM Unit Price

2.1 AS72111 1 DZ 2,208.00

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 89
3.1 AS54888 1 DZ 18,000.00
4.1 AS92689 1 Ea 2,000.00
5.1 XX-Mouse Pad 12 XXE 90.00

Answer the following questions:

1. Why did the pricing engine allow you to order 1 dozen AS72111?

Answer: Because AS72111 is on your price list with a unit of measure of dozen. Therefore
the engine used that named price for your order.

t e d
bi
2. Why did the pricing engine allow you to order 1 dozen AS54888?

Answer: Because the “Primary UOM” is check for AS54888. Therefore the pricing engine h i
used the inventory unit of measure conversions to determine the unit price. In this example: ro
1500 (Ea unit price) * 12 (12 Ea in a DZ) = 18,000.
e P
3. AS92689 is not on XX-Base Prices, how did the pricing engine determine the unit price? a l
Answer: AS92689 is a part of the inventory category “COMPUTER.NOTEBOOK”, which e -s
is on the price list with a unit price of 2,000.
r R
Purchase an Extended 6 year Service program
y o
8. (I) New Record [as necessary] o p
- C
For Line 6.1
− Item: WR18533
i o n
− Quantity: 1
a t
o r
9. (T) Services
r p
C o
− Service Reference Type: Order
− Service Order Type: Mixed

c le
− Service Ref Order Number: (this order number)
− Service Ref Line Number: 4
a
Or
− Service Ref Shipment Number: 1
− Service Duration: 6
© − Service Period: YR

10. (I) Save

11. Requery the lines on your order

12. Answer the following questions:

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 90
1. Why did line 6.1 change to 4.1…1?

Answer: The fifth line number digit represents a Service. By looking at the line number you
are able to identify that 4.1….1 is a Service which is linked to shipment number 1 of line
number 4.

2. How was the 600.00 Unit Price calculated?

Answer: The warranty sells for 5% of the covered product (2000) per year. Since the customer
ordered 6 years the calculation is as follows: .05 * 2000 * 6 = 600.00.

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 91
Solution - Create a Price List
Create Price List Header and Lines

Responsibility = Order Management Super User, Vision Operation( USA)

1. Navigate to the Advanced Pricing - Price Lists window

• (N) Pricing > Price List > Price List Setup

− Name: XX-Base Prices
− Active: Checked
− Description: Corporate Base Price
− Currency: USD
t e d
− Round To: -2
h ibi
2. Accept all other defaults
r o
3. (T) List Lines
e P
a l
Note: Save after entering each line
e -s
r R
Product
Context
Product
Attribute
Product Value
UOM
y o
Primary
UOM
Line
Type
Application
Method
Value

Item Item AS54888 Ea

o p Checked Price Unit Price 1500
Number
- C List
Line
Item Item
i
AS54999
o n Ea Checked Price Unit Price 1700
Number
a t List

o r Line

p
or
Item Item AS18947 Ea Unchecked Price Unit Price 1800
Number List

e C Line

a
Item
cl Item
Number
AS72111 DZ Unchecked Price
List
Unit Price 2208

O r Line
Item Item XX-Mouse Pad XXE Unchecked Price Unit Price 7.50
© Number List
Line
Item Item WR18533 YR Checked Price Percent Price 5
Number List
Line
Item Item COMPUTER. Ea Unchecked Price Unit Price 2000
Category NOTEBOOK List

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 92
Category NOTEBOOK Line

4. (I) Save

Create Sales Order referencing your price list

5. (N) Orders, Returns > Sales Order (T) Main

− Customer Name: XX-Big City
− Customer PO: XX-400
− Price List: XX-Base Prices

6. Populate any required fields that have not defaulted

t e d
Order internal item number: AS18947 with a UOM of DZ
h ibi
7. (T) Line Items ro
e P
8. Enter line 1 as follows:
a l
e -s
Line Item Quantity UOM

r R
1.1 AS18947 1 DZ

y o
o p
9. Respond to the Note (B) OK
- C
10. Change UOM to Ea
i o n
a t
r
Add additional lines to your sales order
o
r p
11. Add additional lines to your order and note resulting unit price

C o
12. (I) New Record [as necessary]

c le
a
Or Line Item Quantity UOM Unit Price

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 93
Answer the following questions:

1. Why did the pricing engine allow you to order 1 dozen AS72111?

Answer: Because AS72111 is on your price list with a unit of measure of dozen. Therefore
the engine used that named price for your order.

2. Why did the pricing engine allow you to order 1 dozen AS54888?

Answer: Because the “Primary UOM” is check for AS54888. Therefore the pricing engine
used the inventory unit of measure conversions to determine the unit price. In this example:
1500 (Ea unit price) * 12 (12 Ea in a DZ) = 18,000.

3. AS92689 is not on XX-Base Prices, how did the pricing engine determine the unit price?
t e d
Answer: AS92689 is a part of the inventory category “COMPUTER.NOTEBOOK”, which
is on the price list with a unit price of 2,000.
h ibi
ro
Purchase an Extended 6 year Service program
e P
13. (I) New Record [as necessary]
a l
For Line 6.1
e -s
− Item: WR18533
− Quantity: 1 r R
y o
14. (T) Services
− Service Reference Type: Order o p
− Service Order Type: Mixed
- C
i
− Service Ref Line Number: 4 o n
− Service Ref Order Number: (this order number)

a t
− Service Ref Shipment Number: 1
o r
− Service Duration: 6
r p
− Service Period: YR

15. (I) Save C o

c le
16. Requery the lines on your order
a
Or
17. Answer the following questions:
© 1. Why did line 6.1 change to 4.1…1?

Answer: The fifth line number digit represents a Service. By looking at the line number you
are able to identify that 4.1….1 is a Service which is linked to shipment number 1 of line
number 4.

2. How was the 600.00 Unit Price calculated?

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 94
Answer: The warranty sells for 5% of the covered product (2000) per year. Since the
customer ordered 6 years the calculation is as follows: .05 * 2000 * 6 = 600.00.

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 95
Practice - Copy a Price List
Overview
In this practice you will copy a price list.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Copy your price list: XX-Base Prices
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Copy Price List window
y o
• (N) Pricing > Price Lists > Copy Price List o p
− Copy From Price List: Corporate
− Leave all defaults - C
o n
− Copy To Price List: XX-New Corporate
i
t
− Description: Created by copying Corporate Price List
a
o r
2.
p
Verify that the price list has been copied.
r
3.
C o
Query your new price list to see the lines have been added from the Corporate Price List.

c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 96
Solution - Copy a Price List
Copy your price list: XX-Base Prices

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Copy Price List window

• (N) Pricing > Price Lists > Copy Price List

− Copy From Price List: Corporate
− Leave all defaults
− Copy To Price List: XX-New Corporate
− Description: Created by copying Corporate Price List
t e d
2. (B) Submit
h ibi
ro
3. Verify that the price list has been copied.

e P
4. Check the concurrent requests window to determine when the concurrent program has
a l
completed. (M) View > Requests > (B) Find (all requests)
e -s
5.
R
Query your new price list to see the lines have been added from the Corporate Price List.
r
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 97
Practice - Update a Price List Manually
Overview
In this practice you will update a price list.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h i bi
Practice.
r o
e P
Tasks
a l
Update price list XX-Base Prices for item AS18947 preserving the pricing history
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Advanced Pricing - Price Lists window
y o
• (N) Pricing> Price Lists > Price List Setup o p
2. (I) Find - C
− Price List: XX-Base Prices
i o n
a t
3.
r
Find item AS18947 and change to last day of this month.
o
4.
r
Add the following: p
C o
c le
Product Product Primary Line Application Value
a Attribute UOM Type Method

Or
Context Product Value UOM
Item Item AS18947 Ea Checked Price Unit Price 1820
© Number List
Line

5. Effective Dates From: first of next month

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 98
Update price list XX-Base Prices for item AS54888 without preserving the pricing
history

6. Find item AS54888

7. Update the value for the line to 1550

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 99
Solution - Update a Price List Manually
Update price list XX-Base Prices for item AS18947 preserving the pricing history

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Advanced Pricing - Price Lists window

• (N) Pricing> Price Lists > Price List Setup

2. (I) Find
− Price List: XX-Base Prices

t e d
bi
3. (T) List Lines

4. (I) Find h i
− Item: AS18947 r o
− To: last day of this month
e P
a l
-s
5. (I) Save

6. (I) New Record

R e
o r
y
op
Product Product Primary Line Application Value
Attribute UOM Type Method
Context Product Value UOM
Item Item AS18947
- C Ea Checked Price Unit Price 1820
Number
i o n List

a t Line

o r
r p
7.
o
Effective Dates From: first of next month
C
8.
le
(I) Save
c
a
Or
Update price list XX-Base Prices for item AS54888 without preserving the pricing
history

© 9. (T) List Lines

10. (I) Find

− Item: AS54888

11. Update the value for the line

− Value: 1550

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 100
12. (I) Save

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 101
Practice - Adjust a Price List
Overview
In this practice you will adjust a price list.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Adjust price list XX-New Corporate by 5% for all items
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Adjust Price List window
y o
• (N) Pricing > Price Lists > Adjust Price List o p
− Price List: XX-New Corporate
- C
2. Select Adjust By: Percent
i o n
− Value: 5
a t
o r
p
Verify that the price list has been updated.
r
3. o
Check the concurrent requests window to determine when the concurrent program has
C
completed. Then query the price list to see the lines have been increased by 5%.

c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 102
Solution - Adjust a Price List
Adjust price list XX-New Corporate by 5% for all items

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Adjust Price List window

• (N) Pricing > Price Lists > Adjust Price List

− Price List: XX-New Corporate

2. Select Adjust By: Percent

− Value: 5
t e d
3. (B) Submit
h ibi
Verify that the price list has been updated. ro
e P
4. Check the concurrent requests window to determine when the concurrent program has
a l
-s
completed. (M) View > Requests > (B) Find (all requests)

5. Query price list XX-New Corporate to see the lines have been increased in value by 5
R e
percent.
o r
p y
C o
n -
t i o
r a
p o
o r
C
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 103
Practice - Add Items to a Price List
Overview
In this practice you will add items to an existing price list.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Add items from inventory to your price list XX-Base Prices
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Add Items to Price List window
y o
• o
(N) Pricing > Price Lists > Add Items to Price List p
− Price List: XX-Base Prices
− Item Status: Active - C
o n
− Set List Price Equal to Cost From: Checked
i
t
− Inventory Organization: Seattle Manufacturing
a
o r
2. (B) Submit
r p
C o
Verify that the price list has been updated

3.
c le
Check the concurrent requests window to determine when the concurrent program has
a
Or
completed. (M) View > Requests > (B) Find (all requests)

4. Query price list XX-Base Prices to see the lines have been added.
© 5. Answer the following question:

Where did the value for each of the items added come from?

Answer: The cost of the item based upon the inventory organization selected.

Mass Adjust the price for the items added to XX-Base Prices
Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 104
6. (N) Pricing > Price Lists > Adjust Price List
− Price List: XX-Base Prices
− Adjust By: Amount
− Value: 10

7. (B) Submit

Verify that the price list has been updated

8. Check the concurrent requests window to determine when the concurrent program has
completed. (M) View > Requests > (B) Find (all requests)

9. Query price list XX-Base Prices to see the line values have been increased by 10.

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 105
Solution - Add Items to a Price List
Add items from inventory to your price list XX-Base Prices

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Add Items to Price List window

• (N) Pricing > Price Lists > Add Items to Price List
− Price List: XX-Base Prices
− Item Status: Active
− Set List Price Equal to Cost From: Checked
− Inventory Organization: Seattle Manufacturing
t e d
2. (B) Submit
h ibi
ro
Verify that the price list has been updated

e P
3. Check the concurrent requests window to determine when the concurrent program has
a l
completed. (M) View > Requests > (B) Find (all requests)
e -s
4. Query price list XX-Base Prices to see the lines have been added.
r R
5. Answer the following question:
y o
o p
Where did the value for each of the items added come from?

- C
Answer: The cost of the item based upon the inventory organization selected.

i o n
Mass Adjust the price for the items added to XX-Base Prices
a t
6.
o r
(N) Pricing > Price Lists > Adjust Price List
p
− Price List: XX-Base Prices
r
C o
− Adjust By: Amount
− Value: 10

7. c le
(B) Submit
a
Or
Verify that the price list has been updated

© 8. Check the concurrent requests window to determine when the concurrent program has
completed. (M) View > Requests > (B) Find (all requests)

9. Query price list XX-Base Prices to see the line values have been increased by 10.

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 106
Practice - Create an Agreement Price List
Overview
In this practice you will create an agreement price list.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Create an Agreement Price List
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Price Agreements window
y o
• (N) Pricing > Price Agreements o p
2. (T) Agreement - C
i o n
− Agreement Name: XX-Pricing Agreement
− Agreement Number: 1
a t
r
− Customer: XX-Big City
o
p
− Agreement Type: Standard Terms and Conditions
r
3. (T) Pricing
C o
− Price List Type: Agreement Price List
c le
− Price List: XX-AGREEMENT PL
a
Or
− Description: Agreement prices for XX-Big City
− Accept all other defaults
© 4. (T) Payment
− Payment Terms: 2/10, Net 30
− Accounting Rule: IMMEDIATE
− Invoicing: ARREARS INVOICE
− Accept all other defaults

5. (T) Line
Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 107
Product Primary Application
Value UOM Method
UOM Line Type Value
AS54888 Ea Checked Unit Price Price List Line 1450
AS54999 Ea Checked Unit Price Price List Line 1500

6. (I) Save

Create a Sales Order using XX-Agreement

7. (N) Orders, Returns > Sales Orders

t e d
8. (T) Order Information
h i bi
r o
9. Add the Agreement field to the Order Information Tab view, if it is not already displayed

e P
10. Place your cursor in the Total field
a l
11. (I) Folder Tools
e -s
12. (I) Show Fields
r R
13. Select Agreement y o
o p
14. (M) Folder > Save As
− Folder Name: XX Agreement view
- C
i o n
15. (B) OK
− Customer: XX-Big City
a t
o r
− Customer PO: XX-500
r p
− Agreement: XX-Pricing Agreement

C o
16. Note the Price List field has been updated

c le
17. Populate any required fields that have not defaulted
a
Or
18. (T) Line Items
− Ordered Item: AS54888
© − Qty: 1

19. Note the Unit Price Displayed.

20. (T) Pricing

21. Note the price list referenced

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 108
22. (I) Save

t e d
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 109
Solution - Create an Agreement Price List
Create an Agreement Price List

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Price Agreements window

• (N) Pricing > Price Agreements

2. (T) Agreement
− Agreement Name: XX-Pricing Agreement
− Agreement Number: 1
t e d
− Customer: XX-Big City
− Agreement Type: Standard Terms and Conditions
h i bi
r o
3. (T) Pricing
− Price List Type: Agreement Price List
e P
− Price List: XX-AGREEMENT PL
a l
− Description: Agreement prices for XX-Big City
− Accept all other defaults e -s
r R
4. (T) Payment
− Payment Terms: 2/10, Net 30
y o
− Accounting Rule: IMMEDIATE
− Invoicing: ARREARS INVOICE o p
− Accept all other defaults
- C
i o n
5. (T) Line
a t
o r
p
or
Product Primary Application
Value UOM Method

e C UOM Line Type Value

cl
AS54888 Ea Checked Unit Price Price List Line 1450

ra
AS54999 Ea Checked Unit Price Price List Line 1500

O
© 6. (I) Save

Create a Sales Order using XX-Agreement

7. (N) Orders, Returns > Sales Orders

8. (T) Order Information

Copyright © Oracle Corporation, 2002. All rights reserved.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 110
9. Add the Agreement field to the Order Information Tab view, if it is not already displayed

10. Place your cursor in the Total field

11. (I) Folder Tools

12. (I) Show Fields

13. Select Agreement

14. (M) Folder > Save As

− Folder Name: XX Agreement view

15. (B) OK
− Customer: XX-Big City
t e d
− Customer PO: XX-500
− Agreement: XX-Pricing Agreement h ibi
ro
16. Note the Price List field has been updated
e P
17. Populate any required fields that have not defaulted
a l
18. (T) Line Items e -s
− Ordered Item: AS54888
r R
− Qty: 1
y o
19. Note the Unit Price Displayed.
o p
20. (T) Pricing
- C
21. Note the price list referenced
i o n
a t
22. (I) Save
o r
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 111
Practice - Create a Discount Modifier List
Overview
In this practice you will create a discount modifier list.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Create a Discount Modifier list and place a qualifier on the list
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Modifier Setup window
y o
• (N) Pricing> Modifiers > Modifier Setup o p
2. -
Use the following information to set up a modifier
C
− Type: Discount List
i o n
− Number: XX-Mod List
a t
− Active: Checked
o r
p
− Name: XX Modifier List
r
C o
− Automatic: Checked
− Currency: USD

c le
− Description: Discounts and Surcharges for XX-Base Prices price list

a
Or
3. Specify qualifier information according to the following information:
− Grouping Number: 1
© − Qualifier Context: Modifier List
− Qualifier Attribute: Price List
− Operator: =
− Value From: XX-Base Prices

4. Specify Modifier summary information:

− Modifier No.: XX-1

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 112
− Level: Line
− Modifier Type: Discount
− Automatic: Checked (should default)
− Override: Unchecked
− Pricing Phase: 10 – List Line Adjustment

Note - if you enter the number 10, list line adjustment will default in. Otherwise you will
need to select from the list of values

5. Specify the following discounts/charges

− Application Method: Percent
− Value: 10

Create an automatic line level price break modifier for your modifier list
t e d
6. (I) New Record in the same Discount Modifier List
h ibi
− Modifier No.: XX-2
ro
− Level: Line
− Modifier Type: Price Break Header
e P
− Automatic: Checked (should default)
a l
− Override: Unchecked
− Pricing Phase: 10 – List Line Adjustment e -s
r R
need to select from the list of values
y o
Note - if you enter the number 10, list line adjustment will default in. Otherwise you will

− Product Attribute: Item Number

o p
− Attribute Value: AS54999
− Volume Type: Item Quantity - C
− Break Type: Point
i o n
− Operator: BETWEEN
a t
− UOM: Ea
o r
7. (T) Price Breaksr p
o
− Adjustment Type: Discount
C
8. le
(B) Define Details
c
a
Or Application
© From To
Method
Value
1 10 Amount 8
11 20 Amount 12
21 9999999999999 Amount 15

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 113
Create a manual discount line for your modifier list

9. (I) New Record in the same Discount Modifier List

− Modifier No.: XX-3
− Level: Line
− Modifier Type: Surcharge
− Automatic: Unchecked
− Override: Checked
− Pricing Phase: 10 – List Line Adjustment

Note - if you enter the number 10, list line adjustment will default in. Otherwise you will
need to select from the list of values
t e d
10. (T) Discounts/Charges
h ibi
− Application Method: Percent
− Value: 2 ro
e P
Create a sales order to test your modifier
a l
11. (N) Orders, Returns > Sales Order
e -s
12. (T) Order Information (T) Main r R
− Customer: XX-Big City
y o
− Customer PO: XX-600
− Price List: XX-Base Prices o p
-
13. Populate any required fields that do not default.
C
i o n
14. (T) Line Items (M) Main
a t
− Item: AS54888
− Qty: 1 o r
r p
C o
View the addition of your modifier

c le
15. (B) Actions > View Adjustments (T) Adjustments
a
Or
16. Add a manual adjustment line to this order

− Modifier Number: XX-Mod List

Note: Your manual surcharge line from your modifier should default, as there was only one
manually applied discount available. Had there been more than one, you would have to
choose which discount.

18. (B) Apply

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 114
19. (B) OK

20. Notice that the price has now been adjusted with the 10% discount and the 2% surcharge.

21. Close the View Adjustments window.

Add a new line to the sales order

22. (I) New Record

− Item: AS54999
− Qty: 25

23. (I) Save

t e d
bi
View the addition of your modifier

24. (B) Actions > View Adjustments (T) Adjustments

h i
ro
25. Note the adjustment applied to the line.
e P
Note: If you are in a database with only basic pricing installed: You will only see the 15%
a l
Price Break Modifier as it will give the customer a better price than the automatic 10%
discount. e -s
r R
y o
Note: If you are in a database with advanced pricing installed: The pricing engine will apply
both the 10% and 15% discounts because they are both defined as automatically applied
discounts.
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 115
Solution - Create a Discount Modifier List
Create a Discount Modifier list and place a qualifier on the list

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Modifier Setup window

• (N) Pricing> Modifiers > Modifier Setup

2. (M) Main
− Type: Discount List
− Number: XX-Mod List
t e d
− Active: Checked
− Name: XX Modifier List
h ibi
− Automatic: Checked
ro
− Currency: USD
− Description: Discounts and Surcharges for XX-Base Prices price list
e P
a l
3. (B) List Qualifiers
e -s
4. (B) OK, to access the qualifier form
− Grouping Number: 1 r R
− Qualifier Context: Modifier List
y o
− Qualifier Attribute: Price List
− Operator: = o p
− Value From: XX-Base Prices
- C
i o n
5. (B) Ok
a t
6. (T) Modifier Summary
o r
p
− Modifier No.: XX-1
r
C o
− Level: Line
− Modifier Type: Discount

c le
− Automatic: Checked (should default)
− Override: Unchecked
a
Or
− Pricing Phase: 10 – List Line Adjustment

© Note - if you enter the number 10, list line adjustment will default in. Otherwise you will
need to select from the list of values

7. (T) Discounts/Charges
− Application Method: Percent
− Value: 10

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 116
8. (I) Save

Create an automatic line level price break modifier for your modifier list

9. (I) New Record in the same Discount Modifier List

− Modifier No.: XX-2
− Level: Line
− Modifier Type: Price Break Header
− Automatic: Checked (should default)
− Override: Unchecked
− Pricing Phase: 10 – List Line Adjustment

Note - if you enter the number 10, list line adjustment will default in. Otherwise you will
need to select from the list of values
t e d
− Product Attribute: Item Number
− Attribute Value: AS54999
h ibi
− Volume Type: Item Quantity
ro
− Break Type: Point
e P
− Operator: BETWEEN
− UOM: Ea a l
10. (T) Price Breaks e -s
− Adjustment Type: Discount
r R
11. (B) Define Details
y o
o p
-
ApplicationC
From To
i o n Method
Value
1 10
a t Amount 8
11 20
p or Amount 12
21
o r
9999999999999 Amount 15

e C
c l
a
Or
12. (I) Save

Create a manual discount line for your modifier list

© 13. (I) New Record in the same Discount Modifier List
− Modifier No.: XX-3
− Level: Line
− Modifier Type: Surcharge
− Automatic: Unchecked
− Override: Checked

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 117
− Pricing Phase: 10 – List Line Adjustment

Note - if you enter the number 10, list line adjustment will default in. Otherwise you will
need to select from the list of values

14. (T) Discounts/Charges

− Application Method: Percent
− Value: 2

15. (I) Save

Create a sales order to test your modifier

16. (N) Orders, Returns > Sales Order

t e d
17. (T) Order Information (T) Main
− Customer: XX-Big City h ibi
− Customer PO: XX-600 ro
− Price List: XX-Base Prices
e P
a l
-s
18. Populate any required fields that do not default.

19. (T) Line Items (M) Main

R e
− Item: AS54888
− Qty: 1 o r
p y
20. (I) Save
C o
View the addition of your modifier
n -
t i o
21. (B) Actions > View Adjustments (T) Adjustments

r a
p o
22. Add a manual adjustment line to this order

o r
C
23. (I) New Record
− Modifier Number: XX-Mod List
c le
a
Or
Note: Your manual surcharge line from your modifier should default, as there was only one
manually applied discount available. Had there been more than one, you would have to
choose which discount.
© 24. (B) Apply

25. (B) OK

26. Notice that the price has now been adjusted with the 10% discount and the 2% surcharge.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 118
27. Close the View Adjustments window.

Add a new line to the sales order

28. (I) New Record

− Item: AS54999
− Qty: 25

29. (I) Save

View the addition of your modifier

30. (B) Actions > View Adjustments (T) Adjustments

t e d
bi
31. Note the adjustment applied to the line.

Note: If you are in a database with only basic pricing installed: You will only see the 15%
h i
Price Break Modifier as it will give the customer a better price than the automatic 10%
ro
discount.
e P
a
Note: If you are in a database with advanced pricing installed: The pricing engine will apply l
both the 10% and 15% discounts because they are both defined as automatically applied
discounts. e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 119
Shipping

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 120
Practice - Grant Access to your User for Your Role
Overview
In this practice you will grant access to your user for your role.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 121
Solution - Grant Access to your User for Your Role
Grant Access to Your User for Your Role

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Shipping Execution Grants window

• (N) Shipping > Setup > Grants and Roles Definition > Grants
− User: your user
− Role: Upgrade Role
− Accept all other defaults

t e d
2. (I) Save

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 122
Practice - Pick Release Sales Orders
Overview
In this practice you will release your sales order for picking.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Release Your Sales Order
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Release Sales Orders for Picking window
y o
• o p
(N) Shipping > Release Sales Orders > Release Sales Orders
− Document Set: All Pick Release Documents
− Orders: Unreleased - C
o n
− Order Number: your order number using purchase order XX-100
i
− Warehouse: M1
a t
r
− Autocreate Delivery: Yes
o
r p
2.
o
Note your concurrent request ID:___________________
C
le
View Your Concurrent Request and Pick Slip
c
a
Or
3. (M) View > Requests (B) Find All Requests

4. Identify the Batch Number in the parameters listing for your concurrent request
© 5. Note Batch number: _____________________

6. Note the delivery number associated with your pick slip

7. Delivery Number: _____________________________

View Delivery Number on Sales Order Form

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 123
8. Find your sales order either by number or by Customer PO: XX-100

9. In Order Summary Window select (B) Actions > Additional Order Information (T)
Deliveries

10. Verify the Delivery Number matches the value you found earlier on the pick slip.

Note: Only line 1.1 has release why? The other line on your order is scheduled to ship next
week.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 124
Solution - Pick Release Sales Orders
Release Your Sales Order

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Release Sales Orders for Picking window

• (N) Shipping > Release Sales Orders > Release Sales Orders
− Document Set: All Pick Release Documents

2. (T) Order
− Orders: Unreleased
t e d
− Order Number: your order number using purchase order XX-100

h ibi
3. Accept all other defaults
ro
4. (T) Inventory
e P
− Warehouse: M1
a l
5. (T) Shipping
e -s
− Autocreate Delivery: Yes
− (B) Concurrent r R
y o
6. Note your concurrent request ID:___________________
o p
View Your Concurrent Request and Pick Slip
- C
7. n
(M) View > Requests (B) Find All Requests
i o
a t
8.
r
Identify the Batch Number in the parameters listing for your concurrent request
o
9.
r p
Note Batch number: _____________________

C o
10. Place your cursor on the concurrent request referencing your batch number from above

c le
11. (B) View Output
a
Or
12. Note the delivery number associated with your pick slip

View Delivery Number on Sales Order Form

14. (N) Orders, Returns > Order Organizer

15. Find your sales order either by number or by Customer PO: XX-100

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 125
16. (B) Find

17. In Order Summary Window select (B) Actions > Additional Order Information (T)
Deliveries

18. Verify the Delivery Number matches the value you found earlier on the pick slip.

Note: Only line 1.1 has release why? The other line on your order is scheduled to ship next
week.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 126
Practice - Ship Confirm a Delivery
Overview
In this practice you will ship confirm the delivery.

C o
3.
le
Record freight costs
c− Cost Type: Handling
a
Or
− Amount: 10

5. Validate the following:

− Ship Option: Ship Entered Quantities
− Create Delivery for Staged Quantities : Checked
− Set Delivery In Transit: Checked
− Close Trip: Checked

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 127
6. Note your Interface Trip Stop request number:_____________________

View Ship Confirm Documents

7. (M) View > Requests (B) Find All Requests

8. View any desired output file

View Status of Sales Order Line

9. (N) Orders, Returns >Order Organizer

Find your sales order either by number or by Customer PO: XX-100

10. In Order Summary Window select (B) Actions > Additional Order Information (T)
t e d
Deliveries
h ibi
Note: The first line in the will have a delivery number and a status of closed. The second has
ro
been backordered due to your actions during ship confirm. The third is Ready to release due to
the schedule ship date.
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 128
Solution - Ship Confirm a Delivery
Confirm a Delivery

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Query Manager window

• (N) Shipping > Transactions (T) Lines

− Source System: Order Management
− Order Numbers: Your order number referencing Customer PO: XX-100

2. (B) Find
t e d
3. (B) Detail
− Tracking Number: XX-100-01 h ibi
− Shipped: 3 ro
− Backordered: 2
e P
− Staged: 0
a l
4. (I) Save
e -s
5. (B) Done r R
− Actions: Freight Costs
y o
6. (B) Go o p
− Cost Type: Handling
− Amount: 10 - C
i o n
7. (B) Done
a t
8. (T) Delivery o r
r p
− Actions: Ship Confirm

9. (B) Go C o
c le
a
10. Validate the following:

Or − Ship Option: Ship Entered Quantities

11. Note your Interface Trip Stop request number:_____________________

12. (B) OK

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 129
View Ship Confirm Documents

13. (M) View > Requests (B) Find All Requests

14. View any desired output file

View Status of Sales Order Line

15. (N) Orders, Returns >Order Organizer

Find your sales order either by number or by Customer PO: XX-100

16. (B) Find

17. In Order Summary Window select (B) Actions > Additional Order Information (T)
t e d
Deliveries
h ibi
Note: The first line in the will have a delivery number and a status of closed. The second
ro
has been backordered due to your actions during ship confirm. The third is Ready to release
due to the schedule ship date.
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 130
Practice - Define a Pick Slip Grouping Rule
Overview
In this practice you will define a pick slip grouping rule.

2. Define a pick slip grouping rule - C

− Pick Methodology: User Defined
i o n
t
− Rule Name: XX-Subinventory
a
r
− Description: Group picking lines by subinventory
o
p
− Group By: Subinventory
r
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 131
Solution - Define a Pick Slip Grouping Rule
Define a Pick Slip Grouping Rule

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Pick Slip Grouping Rules window

• (N) Shipping > Setup > Picking > Define Pick Slip Grouping Rules
− Pick Methodology: User Defined
− Rule Name: XX-Subinventory
− Description: Group picking lines by subinventory
− Group By: Subinventory
t e d
2. (I) Save
h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 132
Practice - Define a Release Sequence Rule
Overview
In this practice you will define a release sequence rule.

2. Define a release sequence - C

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 133
Solution - Define a Release Sequence Rule
Define a Release Sequence Rule

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Release Sequence Rules window

• (N) Shipping> Setup > Picking > Define Release Sequence Rule
− Rule: XX-Oldest First
− Order: 2, Ascending
− Schedule Date: 1, Ascending

t e d
2. (I) Save

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 134
Practice - Define a Release Rule
Overview
In this practice you will define a release rule.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Define Release Rule
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Release Rules window
y o
• o p
(N) Shipping > Setup > Picking > Define Release Rules
− Rule: XX-Rule
- C
2. (T) Order
i o n
− Orders: All
a t
r
− Scheduled Ship Date To: Today’s Date
o
p
− Requested Dates To: Today’s Date
r
3.
C o
(T) Inventory
− Warehouse: XX1
c le
− Pick Slip Grouping Rule: XX-Subinventory
a
Or
− Auto Allocate: Yes
− Auto Pick: Yes
© 4. (T) Shipping
− Release Sequence Rule: XX-Oldest First
− Autocreate Deliveries: Yes
− Document Set: All Pick Release Documents

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 135
Solution - Define a Release Rule
Define Release Rule

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Release Rules window

• (N) Shipping > Setup > Picking > Define Release Rules
− Rule: XX-Rule

2. (T) Order
− Orders: All
t e d
− Scheduled Ship Date To: Today’s Date
− Requested Dates To: Today’s Date
h ibi
ro
3. (T) Inventory
− Warehouse: XX1
e P
− Pick Slip Grouping Rule: XX-Subinventory
a l
− Auto Allocate: Yes
− Auto Pick: Yes e -s
r R
4. (T) Shipping
− Release Sequence Rule: XX-Oldest First
y o
− Autocreate Deliveries: Yes
− Document Set: All Pick Release Documents o p
- C
5. (I) Save
i o n
a t
o r
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 136
Practice - Define a Shipping Role
Overview
In this practice you will define a shipping role.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Define Shipping Role
e -s
Responsibility = Order Management Super User, Vision Operations (USA)
r R
1. Navigate to the Shipping Execution Role Definition window
y o
• o p
(N) Shipping > Setup > Grants and Role Definitions > Define Roles
− Name: XX-Clerk
− Description: XX Shipping Clerk - C
i o n
2. (T) Trips
a t
o r
3. (B) Disable Actions
r p
4. (T) Stops
C o
5. le
(B) Disable Actions
c
a
Or
6. (T) Deliveries
− Verify
© − Data Action: Edit
− Accept all defaults

7. (T) Lines/LPNs

8. Accept all defaults

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 137
Solution - Define a Shipping Role
Define Shipping Role

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Shipping Execution Role Definition window

• (N) Shipping > Setup > Grants and Role Definitions > Define Roles
− Name: XX-Clerk
− Description: XX Shipping Clerk

2. (T) Trips
t e d
3. (B) Disable Actions
h ibi
4. (T) Stops ro
e P
5. (B) Disable Actions
a l
6. (T) Deliveries
− Verify e -s
− Data Action: Edit
r R
− Accept all defaults
y o
7. (T) Lines/LPNs
o p
8. Accept all defaults
- C
i o n
9. (I) Save
a t
o r
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 138
Practice - Grant Access to a Role
Overview
In this practice you will grant access to a role.

2. Query your user - C

i o n
3. (B) View Role
a t
4.
o r
Note the differences between the role you assigned to your user earlier and the one you have
r p
just created in a prior practice.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 139
Solution - Grant Access to a Role
Verify the shipping access given to your user

Responsibility = Order Management Super User, Vision Operations (USA)

1. Navigate to the Shipping Execution Grants window

• (N) Shipping > Setup > Grants and Roles Definition > Grants

2. Query your user

3. (B) View Role

t e d
4. Note the differences between the role you assigned to your user earlier and the one you have
just created in a prior practice. h ibi
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 141
Process Invoices

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 142
Practice - Create an Invoice
Overview
In this practice you will create a receivables invoice.

cle
1 CS03755 10 1500 Location

r a 2 CS32698 5 1750 Location

4. Note Transaction Number: ____________________________________

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 143
Solution - Create an Invoice
Create an Invoice

Responsibility = Receivables Manager

1. Navigate to the Transactions window

• (N) Transactions > Transactions

− Source: Manual
− Class: Invoice
− Type: Invoice

t e d
2. (T) Main
− Ship To Name: XX-Big City
h ibi
ro
3. (B) Line Items

e P
a l
Line Number Item Number Quantity Unit Price Tax
e -s
1
2
CS03755
CS32698
10
5
1500 Location

r
1750 LocationR
y o
o p
4. (I) Save
- C
5. Close Lines Window
i o n
a t
6. (B) Complete
o r
7.
r p
Note Transaction Number: ____________________________________

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 144
Practice - Copy an Invoice
Overview
In this practice you will create a copy an invoice.

i o n
View the completed copy report
a t
3.
o r
Select your concurrent request for the program Recurring Invoice Program and view it
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 145
Solution - Copy an Invoice
Copy Invoice

Responsibility = Receivables Manager

1. Navigate to the Copy Transactions window

• (N) Transactions > Copy Transactions

2. Query transaction you just created

− 3. Rule: Monthly
− Number of Times: 6
t e d
3. Accept all other defaults
h ibi
4. (I) Save ro
e P
5. Note Transaction Numbers:___________________________________________
a l
View the completed copy report
e -s
6. (M) View > Requests (B) Find
r R
7.
y o
Select your concurrent request for the program Recurring Invoice Program

8. (B) View Output o p

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 146
Practice - Create a Credit Memo
Overview
In this practice you will create a credit memo.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 147
Solution - Create a Credit Memo
Create a credit memo associated with your first transaction

Responsibility = Receivables Manager

1. Navigate to the Credit Transactions window

• (N) Transactions > Credit Transactions

− Specify the first transaction you created

2. (B) Find

t e d
bi
3. Accept all defaults
− Reason: Discount
h i
4. (T) Transaction Amount ro
− Line %: 5
e P
a l
-s
5. (I) Save

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 148
Practice - Print a Transaction
Overview
In this practice you will print a transaction.

C
View printed invoices

c le
4.
a
View your printed invoices.

Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 149
Solution - Print a Transaction
Print invoices

Responsibility = Receivables Manager

1. Navigate to the Standard Request Submission window

• (N) Print Documents > Invoices

2. Single Request (B) OK

− Name: Invoice Print Selected Invoices

t e d
bi
3. Enter Parameters:
− Order By: Transaction Number
− Transaction Number Low: your first transaction number h i
− Transaction Number High: your first transaction number ro
e P
4. (B) OK
a l
5. (B) Submit
e -s
6. Note Request Number: __________________________
r R
7. (B) No y o
o p
View printed invoices
- C
8. (M) View > Requests (B) Find
i o n
9.
a t
Select line indicating the concurrent program Invoice Print Selected Invoices that has a

o r
parent id referencing your request.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 150
Process Invoices Using Autoinvoice

Process Invoices Using Autoinvoice t e d

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 151
Practice - Process Invoices using AutoInvoice
Overview
In this practice you will process invoices using AutoInvoice.

• Replace XX in the Practice with a unique identifier such as your initials or a number.
t e d
(For Instructor Led Training classes, this number will be assigned to you). This is
necessary in order to create unique records within the database when performing the
h ibi
Practice.
ro
e P
Tasks
a l
Run AutoInvoice for orders that are ready for fulfillment
e -s
Responsibility = Receivables Manager
r R
1. Navigate to the Standard Request Submission window
y o
• (N) Interfaces > AutoInvoice o p
2. Enter Parameters: - C
− Import Source: ORDER ENTRY
i o n
t
− Default Date: today’s date
a
o r
p
Note: In our education database this process was automatically kicked off upon completion
r
View invoice C o
of the shipping process (after the running of a Workflow Background Process)

c le
3.
a
(N) Transactions > Transactions

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 152
Solution - Process Invoices using AutoInvoice
Run AutoInvoice for orders that are ready for fulfillment

Responsibility = Receivables Manager

1. Navigate to the Standard Request Submission window

• (N) Interfaces > AutoInvoice

2. Single Request (B) OK

− Name: AutoInvoice Master Program

t e d
bi
3. Enter Parameters:
− Import Source: ORDER ENTRY
− Default Date: today’s date h i
ro
4. (B) OK
e P
a l
-s
5. (B) Submit

R e
Note: In our education database this process was automatically kicked off upon completion
r
of the shipping process (after the running of a Workflow Background Process)
o
View invoice
p y
6. (N) Transactions > Transactions
C o
7. (I) Find
n -
i o
− Sales Order Number: the sales order number you shipped earlier
t
r a
8. (B) Find
p o
o r
C
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 153
Manual Receipts

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 154
Practice - Enter a Manual Receipt
Overview
In this practice you will enter a manual receipt.

i o n
• Enter receipt 1
a t
o r
− Receipt Number: XX-01
− Receipt Type: Cash
r p
− Receipt Amount: $20,946.88

C o
− Payment Method: Check-BofA

•
c le
Enter receipt 2
a − Receipt Number: XX-02
Or − Receipt Type: Cash
− Receipt Amount: $8,035.00
© − Payment Method: Check-BofA

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 155
Solution - Enter a Manual Receipt
Enter a manual receipt

Responsibility = Receivables Manager

1. Navigate to the Receipts window

• (N) Receipts > Receipts

− Receipt Number: XX-01
− Receipt Type: Cash
− Receipt Amount: $20,946.88
− Payment Method: Check-BofA
t e d
2. (T) Customer
h ibi
− Customer Name: XX-Big City
ro
3. (I) Save
e P
a l
4. (I) New Record
− Receipt Number: XX-02
e -s
− Receipt Type: Cash
− Receipt Amount: $8,035.00 r R
− Payment Method: Check-BofA
y o
5. (T) Customer o p
− Customer Name: XX-Big City
- C
6. (I) Save
i o n
a t
o r
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 156
Practice - Apply a Receipt
Overview
In this practice you will apply a receipt.

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 157
Solution - Apply a Receipt
Apply your receipts

Responsibility = Receivables Manager

1. Navigate to the Receipts window

• (N) Receipts > Receipts

2. Query your receipt XX-01

3. (B) Applications
t e d
4. Apply To: your first invoice transaction
h ibi
5. (I) Save
ro
e P
a l
e -s
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 158
Practice - Use Mass Apply
Overview
In this practice you will use Mass Apply.

c le
− The invoice associated with your sales order
a − Place any leftover amount On - Account

Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 159
Solution - Use Mass Apply
Mass apply your receipts

Responsibility = Receivables Manager

1. Navigate to the Receipts window

• (N) Receipts > Receipts

2. Query your receipt XX-02

3. (B) Mass Apply

t e d
4. (B) Preview
h ibi
5. Select the Apply checkbox for:
ro
− Select the transaction from your first invoice
e P
− The invoice associated with your sales order
− Place any leftover amount On - Account a l
e -s
6. (I) Save
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 160
Implement Receipts

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 161
Practice - Define a Bank
Overview
In this practice you will define a bank.

c le
− Currency: USD

a
Or
3. Use the following GL accounts
− Cash: 01-000-1110-0000-000
© − Remitted Receipts: 01-000-1245-0000-000
− Unapplied Receipts: 01-000-1240-0000-000

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 162
Solution - Define a Bank
Define Bank

Responsibility = Receivables Manager

1. Navigate to the Banks window

• (N) Setup > Receipts > Banks

− Bank Name: XX Bank
− Bank Branch Name: XX Branch
− Institution: Bank

t e d
2. (B) Bank Accounts
− Bank Account Name: XX Checking
h ibi
− Account Use: Internal
ro
− Number: XX-12345
− Currency: USD
e P
a l
3. (T) GL Accounts
− Cash: 01-000-1110-0000-000 e -s
r R
4. (T) Receivables Options
− Remitted Receipts: 01-000-1245-0000-000
y o
5. (T) More Receivables Options o p
− Unapplied Receipts: 01-000-1240-0000-000
- C
6. (I) Save
i o n
a t
o r
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 164
Tax Accounting Process

Tax Accounting Process t e d

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 165
Practice - Define a Tax Code
Overview
In this practice you will define a tax code.

c le
− Tax Account: 01-000-2520-0000-000

a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 166
Solution - Define a Tax Code
Define a Tax Code

Responsibility = Receivables Manager

1. Navigate to the Tax Codes and Rates window

• (N) Setup > Tax > Codes (T) Rates

− Tax Code: XXTAX
− Tax Type: Sales Tax
− Taxable Basis: After Discount
− Tax Rate %: 10
t e d
− Sign: Credit
h ibi
2. (T) Control
ro
− Tax Class: Output
e P
3. (T) More
a l
− Tax Account: 01-000-2520-0000-000
e -s
4. (I) Save
r R
y o
o p
- C
i o n
a t
o r
r p
C o
c le
a
Or
©

11i Order to Cash Fundamentals Supplemental Practices

Chapter 1- Page 167

11i Order To Cash Fundamentals: D11435GC30 Edition 3.0 November 2005 D22442
No ratings yet
11i Order To Cash Fundamentals: D11435GC30 Edition 3.0 November 2005 D22442
4 pages
Order Management For End Users
No ratings yet
Order Management For End Users
286 pages
11i Implement Treasury Management: D17501GC10 Edition 1.0 May, 2005 D21790
No ratings yet
11i Implement Treasury Management: D17501GC10 Edition 1.0 May, 2005 D21790
8 pages
OM User Guide
No ratings yet
OM User Guide
888 pages
Oracle Database 11g: Performance: Student Guide
No ratings yet
Oracle Database 11g: Performance: Student Guide
66 pages
Oracle Database 10g: Administration Workshop II: Student Guide
No ratings yet
Oracle Database 10g: Administration Workshop II: Student Guide
2 pages
Introduction To Oracle9i: SQL: Additional Practices - Volume 3
No ratings yet
Introduction To Oracle9i: SQL: Additional Practices - Volume 3
2 pages
Om User Guide
No ratings yet
Om User Guide
928 pages
Oracle Forms Developer 10g: Build Internet Applications: Electronic Presentation
No ratings yet
Oracle Forms Developer 10g: Build Internet Applications: Electronic Presentation
2 pages
CSG 3
No ratings yet
CSG 3
2 pages
Oracle Database 11g: Administration Workshop I: Electronic Presentation
No ratings yet
Oracle Database 11g: Administration Workshop I: Electronic Presentation
2 pages
Oracle Database 11g: Administration Workshop I: D50102GC20 Edition 2.0 September 2009
No ratings yet
Oracle Database 11g: Administration Workshop I: D50102GC20 Edition 2.0 September 2009
2 pages
Oracle EB TAX - Activity Guide
No ratings yet
Oracle EB TAX - Activity Guide
290 pages
Ep Cover
No ratings yet
Ep Cover
2 pages
Cash Management
No ratings yet
Cash Management
112 pages
CSG 1
No ratings yet
CSG 1
2 pages
Oracle Database 10g: SQL Fundamentals II: D17111GC10 Edition 1.0 March 2004 D39193
No ratings yet
Oracle Database 10g: SQL Fundamentals II: D17111GC10 Edition 1.0 March 2004 D39193
2 pages
Ep Cover
No ratings yet
Ep Cover
2 pages
Oracle Forms Developer 10g: Build Internet Applications: D17251GC10 Edition 1.0 June 2004 D39560
No ratings yet
Oracle Forms Developer 10g: Build Internet Applications: D17251GC10 Edition 1.0 June 2004 D39560
2 pages
WMS Guide
No ratings yet
WMS Guide
300 pages
Oracle Database 10g: SQL Fundamentals I: D17108GC10 Production 1.1 March 2004 D39191
No ratings yet
Oracle Database 10g: SQL Fundamentals I: D17108GC10 Production 1.1 March 2004 D39191
2 pages
Maintenance Procedures
No ratings yet
Maintenance Procedures
144 pages
Oracle Forms Developer 10g: Build Internet Applications: D17251GC10 Edition 1.0 June 2004 D39558
No ratings yet
Oracle Forms Developer 10g: Build Internet Applications: D17251GC10 Edition 1.0 June 2004 D39558
2 pages
Ep JFV
No ratings yet
Ep JFV
2 pages
Oracle Database 11g: Administration Workshop I: D50102GC20 Edition 2.0 September 2009 DXXXX
No ratings yet
Oracle Database 11g: Administration Workshop I: D50102GC20 Edition 2.0 September 2009 DXXXX
2 pages
EP Cover
No ratings yet
EP Cover
2 pages
CSG 1
No ratings yet
CSG 1
2 pages
Using Oracle XML Publisher Student Guide
No ratings yet
Using Oracle XML Publisher Student Guide
174 pages
Oracle 10g Application Developers Guide Fundamentals
No ratings yet
Oracle 10g Application Developers Guide Fundamentals
582 pages
D60119GC10 Ig1
No ratings yet
D60119GC10 Ig1
404 pages
Oracle Database 10g: Administration Workshop I: D17090GC30 Edition 3.0 November 2005 D22683
No ratings yet
Oracle Database 10g: Administration Workshop I: D17090GC30 Edition 3.0 November 2005 D22683
2 pages
R 115102 Ug
No ratings yet
R 115102 Ug
268 pages
Oracle Database 10g: SQL Fundamentals I: D17108GC10 Edition 1.0 March 2004 D39190
No ratings yet
Oracle Database 10g: SQL Fundamentals I: D17108GC10 Edition 1.0 March 2004 D39190
2 pages
Use Only: R12 Oracle Financials Functional Migration Fundamentals
No ratings yet
Use Only: R12 Oracle Financials Functional Migration Fundamentals
320 pages
Oracle Receivables Doc Update: January 2002
No ratings yet
Oracle Receivables Doc Update: January 2002
31 pages
CSG 1
No ratings yet
CSG 1
2 pages
Oracle Database 10g: Administration Workshop I: D17090GC30 Edition 3.0 November 2005 D22682
No ratings yet
Oracle Database 10g: Administration Workshop I: D17090GC30 Edition 3.0 November 2005 D22682
2 pages
Euro As Functional Currency
No ratings yet
Euro As Functional Currency
394 pages
Oracle Database 10g: Administration Workshop I: D17090GC30 Edition 3.0 November 2005 D22680
No ratings yet
Oracle Database 10g: Administration Workshop I: D17090GC30 Edition 3.0 November 2005 D22680
2 pages
Oracle® Database: 2 Day + Data Warehousing Guide 11g Release 2 (11.2)
No ratings yet
Oracle® Database: 2 Day + Data Warehousing Guide 11g Release 2 (11.2)
130 pages
Use Only: 11i Oracle XML Publisher Fundamentals
No ratings yet
Use Only: 11i Oracle XML Publisher Fundamentals
400 pages
Oracle® E-Business Tax: Implementation Guide Release 12
No ratings yet
Oracle® E-Business Tax: Implementation Guide Release 12
102 pages
A96524 Dbconcepts 92
No ratings yet
A96524 Dbconcepts 92
734 pages
R12 Financials 1
No ratings yet
R12 Financials 1
474 pages
NLD Intercompany Issue
No ratings yet
NLD Intercompany Issue
6 pages
AR - Reconcile Receipt
No ratings yet
AR - Reconcile Receipt
1 page
Advanced Global Intercompany (AGIS)
No ratings yet
Advanced Global Intercompany (AGIS)
11 pages
Oracle EBTax Setup Document BR100
No ratings yet
Oracle EBTax Setup Document BR100
35 pages
Overview of Spring Framework Modules
No ratings yet
Overview of Spring Framework Modules
1 page
Inventory Management System
No ratings yet
Inventory Management System
8 pages
Ict200 - Final Test
No ratings yet
Ict200 - Final Test
8 pages
Offline
No ratings yet
Offline
2 pages
Association Joins for Pega Developers
No ratings yet
Association Joins for Pega Developers
19 pages
IT & Software Engineering Resume
No ratings yet
IT & Software Engineering Resume
3 pages
MongoDB Cheat Sheet
No ratings yet
MongoDB Cheat Sheet
4 pages
Practical File-Class XII
No ratings yet
Practical File-Class XII
39 pages
DevOps Engineer Expertise
No ratings yet
DevOps Engineer Expertise
2 pages
Adt308 Comprehensive Course Work, June 2023
No ratings yet
Adt308 Comprehensive Course Work, June 2023
6 pages
Let'S: Understand The Difference Between View VS CTE Common Table Expression VS Temp Tables Vs Sub Query IN SQL
No ratings yet
Let'S: Understand The Difference Between View VS CTE Common Table Expression VS Temp Tables Vs Sub Query IN SQL
7 pages
CS614 Mid Subjective PDF
No ratings yet
CS614 Mid Subjective PDF
18 pages
Mastering JSON Processing in Snowflake Cheat Sheet
No ratings yet
Mastering JSON Processing in Snowflake Cheat Sheet
2 pages
C9560-519 Exam Q&A PDF Demo
No ratings yet
C9560-519 Exam Q&A PDF Demo
3 pages
TCS BaNCS Pre-Migration Activities Report
No ratings yet
TCS BaNCS Pre-Migration Activities Report
20 pages
OpenERP Technical Training Guide
0% (1)
OpenERP Technical Training Guide
27 pages
MCS-220 Assignment
No ratings yet
MCS-220 Assignment
51 pages
Azure Data Fundamentals Exam Guide
0% (1)
Azure Data Fundamentals Exam Guide
3 pages
40 Lpa Roadmap by Ribhu Susmita
No ratings yet
40 Lpa Roadmap by Ribhu Susmita
6 pages
StarRocks Intro
No ratings yet
StarRocks Intro
23 pages
Microsoft MB 820 Vceexamstest Actual Questions by Lott 22 07 2024 7qa
No ratings yet
Microsoft MB 820 Vceexamstest Actual Questions by Lott 22 07 2024 7qa
12 pages
IT Applications in Business - MODULE-V
No ratings yet
IT Applications in Business - MODULE-V
34 pages
Shelly Bansal - SR Data Engineer
No ratings yet
Shelly Bansal - SR Data Engineer
6 pages
IT (402) Class X SAMPLE PAPER 1
No ratings yet
IT (402) Class X SAMPLE PAPER 1
7 pages
CHAPTER 2: Tutorial: Lesson I: Create A Tabular Report
No ratings yet
CHAPTER 2: Tutorial: Lesson I: Create A Tabular Report
18 pages
Advanced Computing and Writing
No ratings yet
Advanced Computing and Writing
2 pages
Storage Technologies Unit 3 Part 1
No ratings yet
Storage Technologies Unit 3 Part 1
15 pages
50 Most Common SQL Questions and Answers 50 Most Common SQL Questions and Answers
No ratings yet
50 Most Common SQL Questions and Answers 50 Most Common SQL Questions and Answers
5 pages
Relational Database Essentials
No ratings yet
Relational Database Essentials
14 pages
Computer Practical Examination
No ratings yet
Computer Practical Examination
4 pages