Oracle Payable Student Activity Guide

Full text

(1)Activity Guide. D49300GC20 Edition 2.0 March 2009 D59114. THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. R12 Oracle Payables Management Fundamentals.

(2) Copyright © 2009, Oracle. All rights reserved. Disclaimer This document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way. Except where your use constitutes "fair use" under copyright law, you may not use, share, download, upload, copy, print, display, perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part without the express authorization of Oracle. The information contained in this document is subject to change without notice. If you find any problems in the document, please report them in writing to: Oracle University, 500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not warranted to be error-free. Restricted Rights Notice. U.S. GOVERNMENT RIGHTS The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose these training materials are restricted by the terms of the applicable Oracle license agreement and/or the applicable U.S. Government contract. Trademark Notice Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.. Authors Christine Monk, Carol-Ann Lapeyrouse Technical Contributors and Reviewers Mary Kalway, Peggy Larson, Ivan Pena, Stacey Gomes, Jyoti Pandey, Shelley Feng, Sharon Tennier, Ruth Kukla, Lata Sundar, Barbara Snyder, Bruce Isner, Barbara Nicholls, Christine Rudd, Brian Aitken, Melanie Heisler, Hilary McClure, Pamela Rietz, Melanie Featherstone, Brent Bosin, Aalok Shah, Wallace Gardipe, Oscar Brambila, Ivy Farren, Marilyn Montgomery, Leanne Wilborn This book was published using:. Oracle Tutor. THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. If this documentation is delivered to the United States Government or anyone using the documentation on behalf of the United States Government, the following notice is applicable:.

(3) R12 Oracle Payables Management Fundamentals - Activity Guide ...........................................................1-1 R12 Oracle Payables Management Fundamentals.........................................................................................1-3 Practice - Create a New Employee Record (Required)..............................................................................1-4 Solution - Create a New Employee Record (Required) .............................................................................1-6 Practice - Create a New User Record ........................................................................................................1-9 Solution - Create a New User Record........................................................................................................1-10 Practice - Set Yourself Up As a Buyer (Required) ....................................................................................1-12 Solution - Set Yourself Up As a Buyer (Required) ...................................................................................1-13 Guided Demonstration - Run the Fill Employee Hierarchy Process .........................................................1-14 Practice - Modify a List of Values and Create a Supplier With Two Sites................................................1-15 Solution – Modify a List of Values and Create a Supplier With Two Sites ..............................................1-16 Practice - Create a 1099 Supplier Record ..................................................................................................1-31 Solution - Create a 1099 Supplier Record .................................................................................................1-32 Practice - Review and Change Supplier Information.................................................................................1-37 Solution - Review and Change Supplier Information................................................................................1-38 Guided Demonstration: Submit the Suppliers Audit Report and Merge Suppliers ...................................1-40 Practice - Remove the Payment Hold On Your 1099 Supplier..................................................................1-41 Solution - Remove the Payment Hold On Your 1099 Supplier .................................................................1-42 Practice - Set Up an Invoice Batch ............................................................................................................1-43 Solution - Set Up an Invoice Batch ...........................................................................................................1-44 Practice - Create Folder Forms for the Invoice Header and Lines regions ................................................1-45 Solution - Create Folder Forms for the Invoice Header and Lines regions ...............................................1-46 Practice - Enter an Invoice with Two Lines that are Distributed to Different Departments ......................1-49 Solution - Enter an Invoice with Two Lines that are Distributed to Different Departments .....................1-50 Practice - Enter an Invoice for a Fixed Asset.............................................................................................1-52 Solution - Enter an Invoice for a Fixed Asset............................................................................................1-53 Practice - Create Distribution Sets.............................................................................................................1-55 Solution - Create Distribution Sets ............................................................................................................1-56 Practice - Enter Invoices Using your Distribution Sets .............................................................................1-58 Solution - Enter Invoices Using your Distribution Sets.............................................................................1-59 Practice - Create a Freight Distribution .....................................................................................................1-63 Solution - Create a Freight Distribution.....................................................................................................1-64 Practice - Allocate Freight Charges ...........................................................................................................1-67 Solution - Allocate Freight Charges ..........................................................................................................1-68 Practice - Create a Scheduled Payment Plan .............................................................................................1-71 Solution - Create a Scheduled Payment Plan.............................................................................................1-72 Practice - Cancel an Invoice ......................................................................................................................1-75 Solution - Cancel an Invoice......................................................................................................................1-76 Practice - Reverse Invoice Distributions....................................................................................................1-78 Solution - Reverse Invoice Distributions...................................................................................................1-79 Practice - Create a Standard Purchase Order .............................................................................................1-84 Solution - Create a Standard Purchase Order.............................................................................................1-85 Practice - Match Invoices to a Purchase Order ..........................................................................................1-88 Solution - Match Invoices to a Purchase Order .........................................................................................1-90 Practice - Enter Quick Invoices .................................................................................................................1-97 Solution - Enter Quick Invoices.................................................................................................................1-99 Practice - Enter a Purchase Order for Matching to Quick Invoices ...........................................................1-102 Solution - Enter a Purchase Order for Matching to Quick Invoices ..........................................................1-103 Practice - Match to a PO in Quick Invoices...............................................................................................1-105 Solution - Match to a PO in Quick Invoices ..............................................................................................1-106 Practice - Create a Special Calendar..........................................................................................................1-108 Solution - Create a Special Calendar .........................................................................................................1-109 Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals Table of Contents. i MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Table of Contents.

(4) Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals Table of Contents. ii MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Practice - Create Recurring Invoices .........................................................................................................1-111 Solution - Create Recurring Invoices.........................................................................................................1-112 Practice - Calculate a Supplier Balance .....................................................................................................1-115 Solution - Calculate a Supplier Balance ....................................................................................................1-116 Practice - Run the Invoice Holds Reports..................................................................................................1-117 Solution - Run the Invoice Holds Reports .................................................................................................1-118 Practice - Place a Hold on an Invoice ........................................................................................................1-120 Solution - Place a Hold on an Invoice .......................................................................................................1-121 Practice - Release Holds ............................................................................................................................1-122 Solution - Release Holds ...........................................................................................................................1-123 Practice - Validate Invoices Online ...........................................................................................................1-124 Solution - Validate Invoices ......................................................................................................................1-125 Practice - Create an Internal Bank Account...............................................................................................1-127 Solution – Create an Internal Bank Account .............................................................................................1-128 Practice - Create an External Bank Account..............................................................................................1-135 Solution - Create an External Bank Account.............................................................................................1-136 Practice - Create a Manual Payment..........................................................................................................1-139 Solution - Create a Manual Payment .........................................................................................................1-140 Practice - Create a Quick Payment ............................................................................................................1-144 Solution - Create a Quick Payment............................................................................................................1-145 Practice - Place a Stop on a Payment.........................................................................................................1-148 Solution - Place a Stop on a Payment ........................................................................................................1-149 Practice - Void and Re-issue a Quick Payment .........................................................................................1-151 Solution - Void and Re-issue a Quick Payment.........................................................................................1-152 Practice - Create a Payment Process Request Template ............................................................................1-155 Solution - Create a Payment Process Request Template ...........................................................................1-156 Practice - Run the Cash Requirement Report ............................................................................................1-160 Solution - Run the Cash Requirement Report............................................................................................1-161 Practice - Use your Template to run a Payment Batch with Straight-Through Processing........................1-165 Solution - Use your Template to run a Payment Batch with Straight-Through Processing.......................1-166 Practice - Payment Process Request with Stops ........................................................................................1-175 Solution - Payment Process Request with Stops........................................................................................1-177 Practice - Void a Payment in Payments Manager......................................................................................1-194 Solution - Void a Payment in Payments Manager .....................................................................................1-195 Practice - Stop a Payment in Payments Manager ......................................................................................1-199 Solution - Stop a Payment in Payments Manager......................................................................................1-200 Practice - Enter a Credit Memo and Record a Refund...............................................................................1-204 Solution - Enter a Credit Memo and Record a Refund ..............................................................................1-205 Practice - Create a Prepayment Invoice .....................................................................................................1-210 Practice - Create a Prepayment Invoice Invoice ........................................................................................1-211 Practice - Apply a Prepayment ..................................................................................................................1-217 Solution - Apply a Prepayment..................................................................................................................1-218 Practice - Set up Payment Terms ...............................................................................................................1-223 Solution - Set up Payment Terms ..............................................................................................................1-224 Practice - Create an Expense Report Template..........................................................................................1-228 Solution - Create an Expense Report Template .........................................................................................1-229 Practice - Enter an Expense Report in AP .................................................................................................1-231 Solution - Enter an Expense Report in AP.................................................................................................1-232 Practice - Create an Employee Advance....................................................................................................1-235 Solution - Create an Employee Advance ...................................................................................................1-236 Practice - Apply an Employee Advance ....................................................................................................1-242 Solution - Apply an Employee Advance ...................................................................................................1-243 Practice - Create Accounting .....................................................................................................................1-246 Solution - Submit the Create Accounting Process .....................................................................................1-247 Practice - Set Up US Sales Tax .................................................................................................................1-251 Solution - Set Up US Sales Tax.................................................................................................................1-253 Practice - Enter an Invoice with US Sales Tax Lines ................................................................................1-261.

(5) Oracle University and Egabi Solutions use only. Solution - Enter an Invoice with US Sales Tax Lines................................................................................1-262 Practice - Set Up UK VAT ........................................................................................................................1-265 Solution - Set Up UK VAT .......................................................................................................................1-267 Guided Demonstration - Enter an Invoice with UK VAT .........................................................................1-276 Practice - Verify Automatic Withholding Tax Setup.................................................................................1-279 Solution - Verify Automatic Withholding Tax Setup................................................................................1-280 Practice - Create Withholding Tax Invoices ..............................................................................................1-286 Solution - Create Withholding Tax Invoices .............................................................................................1-287. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals Table of Contents. iii MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT COMPUTER IS STRICTLY PROHIBITED.

(6) Oracle University and Egabi Solutions use only THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS COMPUTER IS STRICTLY PROHIBITED.

(7) Preface Profile Before You Begin This Course •. Thorough knowledge of accounting practices.. •. Working experience with Accounts Payables processes.. •. eBusiness Suite Essentials for Implementers.. How This Course Is Organized R12 Oracle Payables Management Fundamentals Ed 2 is an instructor-led course featuring lecture and hands-on exercises. Online demonstrations and written practice sessions reinforce the concepts and skills introduced.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals Table of Contents. v MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Prerequisites.

(8) Related Publications Oracle Publications Part Number. Oracle Payables User’s Guide. B25454-02. Oracle Payables Implementation Guide. B25453-02. Oracle Payables Reference Guide. B25455-02. Oracle E-Business Tax User Guide. B25959-01. Oracle Subledger Accounting Implementation Guide. B13984-02. Oracle Payments Implementation Guide. B28872-02. Oracle Payments User Guide. B28871-02. Oracle Internet Expenses Implementation and Administration Guide. B31551-03. Oracle iSupplier Portal Implementation Guide. B31600-02. Oracle iSupplier Portal User's Guide. B31601-01. Additional Publications •. System release bulletins. •. Installation and user’s guides. •. Read-me files. •. International Oracle User’s Group (IOUG) articles. •. Oracle Magazine. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals Table of Contents. vi MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Title.

(9) Typographic Conventions Typographic Conventions in Text. Caps and lowercase Courier new, case sensitive (default is lowercase). Initial cap. Element Glossary term (if there is a glossary) Buttons, check boxes, triggers, windows Code output, directory names, filenames, passwords, pathnames, URLs, user input, usernames. Arrow Brackets Commas. Graphics labels (unless the term is a proper noun) Emphasized words and phrases, titles of books and courses, variables Interface elements with long names that have only initial caps; lesson and chapter titles in crossreferences SQL column names, commands, functions, schemas, table names Menu paths Key names Key sequences. Plus signs. Key combinations. Italic. Quotation marks. Uppercase. Example The algorithm inserts the new key. Click the Executable button. Select the Can’t Delete Card check box. Assign a When-Validate-Item trigger to the ORD block. Open the Master Schedule window. Code output: debug.set (‘I”, 300); Directory: bin (DOS), $FMHOME (UNIX) Filename: Locate the init.ora file. Password: User tiger as your password. Pathname: Open c:\my_docs\projects URL: Go to http://www.oracle.com User input: Enter 300 Username: Log on as scott Customer address (but Oracle Payables) Do not save changes to the database. For further information, see Oracle7 Server SQL Language Reference Manual. Enter [email protected], where user_id is the name of the user. Select “Include a reusable module component” and click Finish. This subject is covered in Unit II, Lesson 3, “Working with Objects.”. Use the SELECT command to view information stored in the LAST_NAME column of the EMP table. Select File > Save. Press [Enter]. Press and release keys one at a time: [Alternate], [F], [D] Press and hold these keys simultaneously: [Ctrl]+[Alt]+[Del]. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals Table of Contents. viiMATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Convention Bold italic.

(10) Typographic Conventions in Code Element Oracle Forms triggers Column names, table names. Example When-Validate-Item. Passwords. DROP USER scott IDENTIFIED BY tiger; OG_ACTIVATE_LAYER (OG_GET_LAYER (‘prod_pie_layer’)). SELECT last_name FROM s_emp;. PL/SQL objects. Lowercase italic Uppercase. Syntax variables. CREATE ROLE role. SQL commands and SELECT userid FROM emp; functions. Typographic Conventions in Oracle Application Navigation Paths This course uses simplified navigation paths, such as the following example, to direct you through Oracle Applications. (N) Invoice > Entry > Invoice Batches Summary (M) Query > Find (B) Approve This simplified path translates to the following:. 1.. (N) From the Navigator window, select Invoice then Entry then Invoice Batches Summary.. 2.. (M) From the menu, select Query then Find.. 3.. (B) Click the Approve button.. Notations: (N) = Navigator (M) = Menu (T) = Tab (B) = Button (I) = Icon (H) = Hyperlink (ST) = Sub Tab Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals Table of Contents. viiiMATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Convention Caps and lowercase Lowercase.

(11) 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. 1.. In the navigation frame of the help system window, expand the General Ledger entry.. 2.. Under the General Ledger entry, expand Journals.. 3.. Under Journals, select Enter Journals.. 4.. Review the Enter Journals topic that appears in the document frame of the help system window.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals Table of Contents. ix MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. —represents the following sequence of actions:.

(12) Oracle University and Egabi Solutions use only Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals Table of Contents. x MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT COMPUTER IS STRICTLY PROHIBITED.

(13) Chapter 1. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 1 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. R12 Oracle Payables Management Fundamentals.

(14) Oracle University and Egabi Solutions use only Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 2 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED.

(15) Oracle University and Egabi Solutions use only. R12 Oracle Payables Management Fundamentals. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 3 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED.

(16) Practice - Create a New Employee Record (Required) Overview In this practice, you will create an employee record that you can use in other labs.. •. Replace XX with your terminal number or initials.. •. You must have access to an Oracle Application Vision database or comparable training or test instance at your site on which to complete this practice.. Tasks Create a new Employee Record in the Human Resources application. Responsibility: Human Resources, Vision Enterprises Define an Employee 1.. (N) > People > Enter and Maintain. 2.. (B) New. 3.. Last = Your last name. 4.. First = Your first name. 5.. Gender = Choose your gender. 6.. Action = Create Employment. 7.. Person Type = Employee. 8.. Social Security = Enter a 9 digit number (xxx-xx-xxxx) Note: If you get the error message *This social security number already exists. Continue?* Click OK or enter another Social security number. 9.. (T) Personal. 10. Birth Date = Enter a birthday (dd-mmm-yyyy) 11. Save Note: If you get the error message *Potential Duplicate People* choose No Match and (B) OK. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 4 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Assumptions.

(17) 12. (B) Assignment 13. Organization = Vision Operations 14. (B) Correction Note: Cancel out of Group flexfield window. 15. Job = MGR500.Manager. 17. (B) Yes to accept the default values 18. Location = M1 - Seattle 19. (T) Supervisor 20. Name = Brown, Ms. Casey 21. (T) Purchase Order Information 22. Ledger = Vision Operations 23. Default Expense Account = 01-110-7740-0000-000 24. (B) OK 25. Save. 26. A note appears asking if you want to use the location of the new position. Click (B) Cancel. Otherwise, the location will change from M1, to HR. 27. Close windows until you are back at the Navigator.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 5 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 16. Position = MM400.Materials Manager.

(18) Solution - Create a New Employee Record (Required) Log in Name: operations Password: welcome Responsibility: Human Resources, Vision Enterprises 1.. (N) > People > Enter and Maintain. 2.. (B) New. 3.. Last = yourlastname. 4.. First = yourfirstname. 5.. Gender = Choose your gender. 6.. Action = Create Employment. 7.. Person Type = Employee Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 6 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Create a new Employee Record:.

(19) 8.. Social Security = Enter a 9 digit number (xxx-xx-xxxx) Note: If you get the error message *This social security number already exists. Continue?* Click OK or enter another Social security number. 9.. (T) Personal. 10. Birth Date = Enter a birthday (dd-MMM-yyyy) 11. (I) Save Note: If you get the error message *Potential Duplicate People* choose No Match and (B) OK.. Oracle University and Egabi Solutions use only. 12. (B) Assignment. 13. Organization = Vision Operations Note: Changing the organization name is CRITICAL!! 14. (B) Correction Note: Cancel out of the Group flexfield window. 15. Job = MGR500.Manager. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 7 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED.

(20) 16. Position = MM400.Materials Manager 17. (B) Yes to accept the default values 18. Location = M1 - Seattle 19. (T) Supervisor 20. Name = Brown, Ms. Casey. 22. Ledger = Vision Operations 23. Default Expense Account = 01-110-7740-0000-000 24. (B) OK 25. (I) Save. 26. A note appears asking if you want to use the location of the new position. Click (B) Cancel. Otherwise, the location will change from M1 to HR. 27. (I) Show Navigator 28. (M) Tools > Close Other Forms. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 8 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 21. (T) Purchase Order Information.

(21) Practice - Create a New User Record Overview In this practice, you will create a new user.. •. Replace XX with your terminal number or initials.. •. You must have access to an Oracle Application Vision database or comparable training or test instance at your site on which to complete this practice.. Tasks 1.. Create a New User Record. 2.. Assign your new Employee Record to the User. 3.. Assign Responsibilities to the new User. 4.. Log in as your new user.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 9 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Assumptions.

(22) Solution - Create a New User Record Tasks Sign on Switch to the System Administrator responsibility. − (I) Black Hat (on toolbar) − Responsibility = System Adminstrator. Create a New User 2.. Navigate to the Define User form •. (N) Security : User > Define − User Name = XXUSER, where XX is your terminal ID. − Password = welcome (tab, re-enter to verify) − Person = Your name. Add Responsibilities 3.. Add the following Responsibilities to your new User record: Responsibility. Security Group. General Ledger, Vision Operations (USA). Standard. Payables, Vision Operations (USA). Standard. Purchasing, Vision Operations (USA). Standard. Cash Management, Vision Operations (USA). Standard. Approvals Management, Business Analyst. Standard. Human Resources, Vision Enterprises. Standard. iExpenses. Standard. System Administrator. Standard. Oracle Payments Payment Administrator. Standard. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 10 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 1..

(23) (I) Save and (I) Show Navigator. Login as your new User 5.. Exit Oracle Applications − (M) File > Exit Oracle Applications − (B) OK. 6.. From the Oracle e-Business Suite home page: − (H) Logout. 7.. Log back into the system with your newly created User Name and password. − Old Password = welcome − New Password = XXuser (Tab, re-enter to verify). 8.. (B) Submit.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 11 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 4..

(24) Practice - Set Yourself Up As a Buyer (Required) Overview In this exercise, you will set yourself up as a Buyer in the system so you’ll be able to enter Purchase Orders in Purchasing as needed.. •. Replace XX with your terminal number or initials.. •. You must have access to an Oracle Application Vision database or comparable training or test instance at your site on which to complete this practice.. Tasks 1.. Responsibility = Purchasing, Vision Operations (USA). 2.. Navigate to the Buyers definition window. 3.. Add yourself as a Buyer in the system. .. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 12 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Assumptions.

(25) Solution - Set Yourself Up As a Buyer (Required) Tasks 1.. Responsibility = Purchasing, Vision Operations (USA). 2.. Navigate to the Buyer definition window:. 3.. (N) Setup > Personnel > Buyers. •. Scroll to the bottom of the window. •. (B) Add Buyer. Oracle University and Egabi Solutions use only. •. Name = your employee name (enter your last name <Tab>) •. (I) Quick Select your name from the list if it doesn’t default in automatically. 4.. (B) Save. 5.. (I) Show Navigator Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 13 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED.

(26) Guided Demonstration - Run the Fill Employee Hierarchy Process Responsibility: Purchasing, Vision Operations Run the Fill Employee Hierarchy process to update the assignments of employee names to Positions on existing hierarchies. . This must be run at frequent intervals to ensure that approval workflow processes can run properly. (M) View > Requests > (B) Submit a New Request. 1.. (B) OK to submit a single request. 2.. Name = Fill Employee Hierarchy. 3.. (B) Schedule. 4.. Select “Periodically”. 5.. Re-run every 1 hour from the completion of the prior run. 6.. (B) OK. 7.. (B) OK on the Caution window. 8. (B) Submit 9. Do not submit another request. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 14 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Run the Fill Employee Hierarchy process.

(27) Practice - Modify a List of Values and Create a Supplier With Two Sites Overview Your supervisor has notified you that the company will be purchasing materials and services from new suppliers. In this practice, you will create a new Pay Group Code and a new supplier with two sites.. •. Replace XX with your terminal number or initials.. •. You must have access to an Oracle Application Vision database or comparable training or test instance at your site on which to complete this practice.. Tasks 1.. Create a new Pay Group Code under an existing Lookup Type (a named List of Values).. 2.. Create a supplier.. 3.. Create a pay site.. 4.. Create a purchasing site.. 5.. Create a contact for the pay site.. 6.. Create a contact for the purchasing site.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 15 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Assumptions.

(28) Solution – Modify a List of Values and Create a Supplier With Two Sites Tasks Responsibility = Payables, Vision Operations (USA). We will create a new Pay Group Code and assign it to several new suppliers. The Pay Group Code you create here will default from the supplier records to invoices that you enter. Named Lists of Values are known as Lookup Types, and in this exercise, you will add a new Lookup Code (a member of a List of Values) to an existing Lookup Type called PAY GROUP. Later, when you run a payment batch , you will use your Pay Group Code as search criteria for the invoice selection process so the system will select only YOUR invoices for payment! 1.. Navigate to the Oracle Purchasing lookups: •. (N) Setup : Lookups > Purchasing. 2.. Query up the PAY GROUP Lookup Type: − <F11> − Enter ‘PAY GROUP’ in the Type field − <Ctrl-F11>. 3.. Create a new Pay Group Code by inserting your cursor in any cell of the grid, then clicking (I) New to open a new row. Enter the following in the new row: Code. XXPAY GROUP. Meaning. Description. XXPay Group. XXPay Group. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 16 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Create a New Pay Group Code:.

(29) (I) Save.., (I) Show Navigator > (M) Tools > Close Other Forms - Check. Create a Supplier 5.. Navigate to the Suppliers page. − (N) Suppliers > Entry. 6.. (B) Create Supplier. − Supplier Type = Standard supplier − Organization Name = XXIBM Corporation. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 17 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 4..

(30) (B) Apply.. 8.. Navigate to (H) Organization. − Type = Manufacturing. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 18 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 7..

(31) (B) Save.. 10. (B) Save. 11. Navigate to (H) Purchasing. − Create Debit Memo from RTS Transaction = Check. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 19 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 9..

(32) 12. (B) Save. 13. Navigate to (H) Receiving. − Receipt Routing = Requires: Standard receipt, Deliver − Note: To find it: − (I) Search − Type in “requires%standard%” in the Routing Description search field, and click on (B) Go. − (I) Quick Select = Standard Receipt − Match Approval Level = 3-Way − Allow Substitute Receipts = Check. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 20 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Note: Enable the Create Debit Memo From RTS Transaction option if you want the system to automatically create a Debit Memo in Payables when you enter a Return to Supplier (RTS) transaction in Purchasing or Inventory. The value for supplier site defaults from the Purchasing Options window..

(33) 15. Navigate to (H) Invoice Management. − Invoice Currency = US dollar − Match Option = Purchase Order − Payment Currency = US dollar − Terms = Immediate − Pay Group = XXPay Group − Always Take Discount = Check. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 21 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 14. (B) Save..

(34) 17. Navigate to (H) Payment Details. − Payment Method : Check = Check Default box. 18. (B) Save. Create a Pay Site 19. Navigate to (H) Address Book. 20. (B) Create. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 22 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 16. (B) Save..

(35) Note: This address should be complete as this is the address that will appear on any payment cut to this site! 22. (B) Apply Note: If you get a message about the postal code, click (B) Continue to accept the entered Zip Code. 23. Assign the address to the Vision Operations operating unit by checking the Select check box. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 23 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 21. Enter the supplier site address information as follows: − Country = United States − Address Line 1 = 1 Main St. − City = San Francisco − County = San Francisco − State = CA − Postal Code = 94105 − Address Name = San Francisco − Addressee = Attn: Accts Receivable − Phone Area Code = 415 − Phone Number = 555-1234 − Email Address = [email protected] − Address Purpose = Payment = Check.

(36) 25. To update the supplier site attributes, click (I) Manage Sites.. 26. (T) Uses. − Pay = Check − Primary Pay = Check. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 24 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 24. (B) Apply. This creates the basic supplier site..

(37) 28. (B) Apply. Create a Purchasing Site 29. On the Address Book page, click (B) Create. 30. Enter the supplier site address information as follows: − Country = United States − Address Line 1 = 520 Madison Ave. − City = New York Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 25 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 27. (T) Communication. − Notification Method = Print.

(38) County = New York State = NY Postal Code = 10022 Address Name = New York Addressee = Attn: Sales Dept Phone Area Code = 212 Phone Number = 555-7703 Email Address = [email protected] Address Purpose = Purchasing = Check. Oracle University and Egabi Solutions use only. − − − − − − − − −. Note: This address should be complete as this is the address that will appear on any Purchase Order and RFQ sent to this supplier site! 31. (B) Apply 32. Assign the address to the Vision Operations operating unit, by checking the Select check box. 33. (B) Apply. This creates the basic supplier site. 34. To update the New York supplier site attributes, click (I) Manage Sites.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 26 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED.

(39) Note: When you enter and approve purchase orders for this supplier, the Supplier Notification Method will default. We’ve chosen printed document here. However, had we chosen e-Mail and specified an e-mail address, that information would default during purchase order approval so we could send the purchase order using the supplier’s preferred method. Valid options are e-Mail, Fax and Printed Document. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 27 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 35. (T) Communication. − Notification Method = Print.

(40) 36. (B) Apply. Create a Contact for the Pay Site. 38. (B) Create. − First Name = John − Last Name = Doe − Email Address = [email protected] − Phone Area Code = 415 − Phone Number = 555-1234 − Phone Extension = 1234 − Create User Account for this Contact = Check − iSupplier Portal Full Access = Check. 39. Scroll down to the Addresses for the Contact Region, and click (B) Add Another Row. 40. Type 'San Francisco' in the Address Name Field and <Tab>.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 28 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 37. Navigate to (H) Contact Directory..

(41) 41. (B) Apply.. 42. Navigate to (H)Contact Directory. 43. (B) Create. − First Name = Jane − Last Name = Doe − Email Address = [email protected] − Phone Area Code = 212 − Phone Number = 555-7703 − Create User Account for this Contact = Check − iSupplier Portal Full Access = Check. 44. Down in the Addresses for the Contact Region, click (B) Add Another Row. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 29 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Create a Contact for the Purchasing Site.

(42) 45. Type 'New York' in the Address Name Field and <Tab>. 46. (B) Apply. 47. (B) Save.. Oracle University and Egabi Solutions use only. 48. (H) Close Window or (H) Home to return to the Navigator.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 30 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED.

(43) Practice - Create a 1099 Supplier Record Overview Your company policy is to place a payment hold on all 1099 suppliers until their W-9 form (the tax verification letter) is completed and returned . In this practice, you will create a new 1099 supplier record and apply the hold .. •. Replace XX with your terminal number or initials.. •. You must have access to an Oracle Application Vision database or comparable training or test instance at your site on which to complete this practice.. Tasks 1.. Navigate to Suppliers page.. 2.. Create a 1099 supplier.. 3.. Place the supplier on payment hold.. 4.. Select a Supplier Site for Income Tax Reporting. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 31 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Assumptions.

(44) Solution - Create a 1099 Supplier Record Tasks Create a 1099 Supplier Navigate to the Suppliers page. •. (N) Suppliers > Entry. 2.. (B) Create Supplier. − Organization Name = XXComputer Consulting Services − Taxpayer ID = XX1-22-1560. 3.. (B) Apply.. 4.. Navigate to (H) Organization. − Type = Supplier. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 32 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 1..

(45) (B) Save.. 6.. Navigate to (H) Tax Details − Federal = Check − Income Tax Type = Non-employee compensation − State = Check. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 33 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 5..

(46) (B) Save.. Place this Supplier on Payment Hold 8.. Navigate to (H) Invoice Management. − Invoice Currency = US dollar − Invoice Match Option = Purchase Order − Hold from Payment, All Invoices = Check − Payment Hold Reason: Waiting for W-9 − Payment Currency = US dollar − Payment Priority = XX − Terms = 30 Net − Terms Date Basis = Invoice − Pay Group = XXPay Group. 9.. (B) Save.. Create a Supplier Site for Income Tax Reporting 10. Navigate to (H) Address Book. 11. (B) Create.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 34 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 7..

(47) Note: This address should be complete as this is the address that will appear on any payments sent to this site! 13. (B) Continue. 14. Assign the address to the Vision Operations operating unit, by checking the Select check box. 15. (B) Apply. This creates the basic supplier site. 16. Navigate to (H) Tax and Reporting. − − For the Supplier Site, Half Moon Bay − Income Tax Reporting Site = Check. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 35 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 12. Enter the supplier site address information as follows: − Address Line 1 = 25 Anywhere St − City = Half Moon Bay − County = San Mateo − State = CA − Postal Code = 94019 − Address Name = Half Moon Bay − Addressee = Attn: Accts Receivable − Phone Area Code = 650 − Phone Number = 555- 4567 − Email Address = [email protected] − Address Purpose, Payment = Check.

(48) 17. (B) Save.. Oracle University and Egabi Solutions use only. 18. (H) Close Window or (H) Home. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 36 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED.

(49) Practice - Review and Change Supplier Information Overview You have just created new suppliers and want to review and change some of the supplier and supplier site information. In this practice, you will review and change supplier information.. •. Replace XX with your terminal number or initials.. •. You must have access to an Oracle Application Vision database or comparable training or test instance at your site on which to complete this practice.. Tasks Responsibility: Payables, Vision Operations (USA) 1.. Navigate to the Suppliers page.. 2.. Search for XXIBM supplier and inactivate the New York site.. 3.. Change the terms for XXIBM supplier.. 4.. Add a contact name.. 5.. Reactivate the New York site.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 37 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Assumptions.

(50) Solution - Review and Change Supplier Information Tasks Search for your XXIBM Corporation supplier and inactivate the New York site: Navigate to the Suppliers page. •. (N) Suppliers > Entry. 2.. Search − Supplier Name = XXIBM Corporation. 3.. (B) Go.. 4.. Navigate to (H) Address Book.. 5.. For New York, click (I) Manage Sites. 6.. (T) Uses. − Inactive Date = Today’s date. 7.. (B) Apply.. Add a Contact Name: 8.. Navigate to (H) Contact Directory.. 9.. (B) Create.. 10. Enter your name and contact information. 11. In the Addresses for the Contact region, (B) Add Another Row 12. Type “San Francisco” in the Address Name field and <Tab>. 13. (B) Apply. Change the Terms for XXIBM Supplier: 14. Navigate to (H) Invoice Management. − Terms = 30 Net 15. (B) Save.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 38 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 1..

(51) Reactivate the New York site: 16. Navigate to (H) Address Book. 17. For New York, click (I) Manage Sites 18. (T) Uses Inactive Date = remove the date. 20. (H) Close Window or (H) Home. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 39 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 19. (B) Apply..

(52) Guided Demonstration: Submit the Suppliers Audit Report and Merge Suppliers Assume that you have discovered duplicate supplier records in your system with the help of the Supplier Audit Report. GE Plastics is the original supplier record, and GE Capital is the duplicate. You’ve done your research and learned that both supplier records include a BOSTON site with identical address information. You’ve also discovered that the duplicate supplier record – GE Capital – has used a site called DANBURY on at least one invoice and PO. But the street address for this site does not match the street address for the DANBURY site on GE Plastic’s record. So you’ve decided to re-name the DANBURY site on the GE Capital account to DANBURY_2 and copy the new site to your GE Plastics account, along with updating any related invoices and POs with the correct supplier name, number, and site number. Assumptions •. You must have access to an Oracle Application Vision database or comparable training or test instance at your site on which to complete this practice.. Tasks 1.. Submit the Supplier Audit Report.. 2.. Run the Supplier Merge Program for ALL invoices and POs related to GE Capital and the following sites: − GE Captial, Boston -> GE Plastics, Boston − GE Capital, Danbury_2 -> Check the Copy box > GE Plastics. 3.. (B) Merge, then Review the Supplier Merge Report.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 40 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Overview.

(53) Practice - Remove the Payment Hold On Your 1099 Supplier Overview Your 1099 supplier has returned their completed W-9 (a 1099 tax verification form), so in this practice, you will remove the payment hold on their supplier record.. •. Replace XX with your terminal number or initials.. •. You must have access to an Oracle Application Vision database or comparable training or test instance at your site on which to complete this practice.. Tasks Responsibility: Payables, Vision Operations (USA) 1.. Navigate to the Suppliers page.. 2.. Remove the 1099 payment hold.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 41 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Assumptions.

(54) Solution - Remove the Payment Hold On Your 1099 Supplier Tasks Update 1099 Information Navigate to the Suppliers page: •. (N) Suppliers > Entry. 2.. Search − Supplier Name = XXComputer Consulting Services. 3.. (B) Go. 4.. (I) Update. Remove the 1099 Payment Hold 5.. Navigate to (H) Invoice Management. − Hold from Payment, All Invoices = Uncheck. 6.. (B) Save. 7.. (H) Close Window or (H) Home. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 42 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 1..

(55) Practice - Set Up an Invoice Batch Overview You have received a number of invoices from XXIBM Corporation, which you will be entering into the Oracle Payables system manually using batching. In this exercise, you will create the Invoice Batch Header for the invoices you will enter later.. •. Replace XX with your terminal number or initials.. •. You must have access to an Oracle Application Vision database or comparable training or test instance at your site on which to complete this practice.. Tasks Responsibility: System Administrator 1.. Navigate to the System Profile Window. 2.. Turn on batching at the Payables, Vision Operations (USA) responsibility level. Responsibility: Payables, Vision Operations (USA) 3.. Navigate to the Invoice Batches window.. 4.. Enter Batch name XX Invoice Batch 1. 5.. Save your work.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 43 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Assumptions.

(56) Solution - Set Up an Invoice Batch Tasks Enable the “AP: Use Invoice Batch Controls” profile option Responsibility = System Administrator Navigate to the Find System Profile Values form: •. (N) Profile > System. •. Uncheck the Site checkbox. •. Check the Responsibility checkbox. •. Enter the Responsibility: Payables Vision Operations (USA). •. Accept the default for the Profiles with No Values field (usually checked). •. Enter the search criteria “ap%batch%” in the Profile field. 2.. Select (B) Find. 3.. Change the profile option setting at the Responsibility level to “Yes”.. 4.. (I) Save. Responsibility = Payables Vision Operations (USA) Enter a Batch Header 5.. Navigate to the Invoice Batches window. •. 6.. (N) Invoices > Entry > Invoice Batches − Batch Name = XX Invoice Batch 1. (I) Save.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 44 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 1..

(57) Practice - Create Folder Forms for the Invoice Header and Lines regions Overview In this practice, you will create Folders for the Invoice Header and Invoice Lines regions. •. Replace XX with your terminal number or initials.. •. You must have access to an Oracle Application Vision database or comparable training or test instance at your site on which to complete this practice.. Tasks Responsibility: Payables, Vision Operations (USA) 1.. Navigate to the Invoices window.. 2.. Create an Invoice Header folder and save it.. 3.. Create an Invoice Lines Folder and save it.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 45 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Assumptions.

(58) Solution - Create Folder Forms for the Invoice Header and Lines regions Tasks Create an Invoice Header Level Folder Navigate to the Invoices window. •. (N) Invoices > Entry > Invoice Batches. •. Query up your existing Invoice Batch and open the Invoice Entry form: o <F11> o Batch Name = XX Invoice Batch 1 o <Ctrl-F11> o (B) Invoices. 2. Create afolder for the Invoice Header region: •. Hide the Customer Taxpayer ID field. •. Reduce the width of the Type field slightly by dragging the right side of the column to the left. Hold down the left mouse button as you drag.. •. Widen the PO Number field slightly.. •. Widen the Trading Partner field to allow for most supplier names. Also, rename the Trading Partner field to “Supplier” by right-clicking on the column name. Enter the new name, then (B) OK.. •. Widen the Supplier Site field to accommodate most site names.. •. Change the name of the Invoice Curr field to Curr.. •. Add a new column by placing your cursor in the first row of the Invoice Amount field, and right-click. Then select Folder, and Show Field. Select the Requester field. The new column should appear to the right of the Invoice Amount field.. •. Move the GL Date field to the right of the Requester field by grabbing the column header with your left mouse button and dragging it to the desired location.. •. Move the Distribution Set field to the right of the GL Date field.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 46 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 1..

(59) Move the Description field to the right of the Distribution Set field. •. Change the Match Action field to read Purchase Order.. •. Move the Terms Date field to the right of the Description field. •. Move the Terms field to the right of theTerms Date field. •. Rename the Terms field to “Payment Terms”. •. Move the Payment Method field to the right of the Payment Terms field. •. Move the Pay Group to the right of the Payment Method field.. •. Move your cursor back to the Operating Unit field before saving.. 3.. Save the folder − (M) Folder > Save As − Name = XX Invoice Header Folder − Autoquery = Never − Open as Default = Check − Public = Uncheck − Include Query = Uncheck. 4.. (B) OK. Create an Invoice Lines Folder: 5.. 6.. Enter the following invoice header information: Invoice Type. Trading Partner. Invoice Date. Invoice Num. Invoice Amount. Terms. Standard. XXIBM Corporation. Today’s date. 11-150. 150. 30 Net. (T) Lines. 7. Create an Invoice Lines folder: •. Reduce the width of the Amount field slightly.. •. Move the Distribution Set field to the right of the Amount field. •. Move the Distribution Account field to the right of the Distribution Set field.. •. Hide the Track as Asset field, then place your cursor in the Distribution Account field, right-click, and select Show Field. Select Track as Asset from the list. The new column should automatically appear to the right of the Distribution Account field. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 47 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. •.

(60) Hide the Discarded field, then place it to the right of the Track as Asset field.. •. Hide the Cancelled field, then place it to the right of the Discarded field.. •. Move the GL Date field to the right of the Cancelled field.. •. Hide the Line Source field, then place it to the right of the GL Date field.. •. Hide the Inventory Item field, then place it to the right of the Unit Price field.. •. Move your cursor back to the Num field before saving.. Save the folder •. 9.. (M) Folder > Save As − Name = XX Invoice Lines Folder − Open as Default = Check − Public = Uncheck − Include Query = Uncheck. (B) OK. 10. (I) Save, then (I) Show Navigator. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 48 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 8.. •.

(61) Practice - Enter an Invoice with Two Lines that are Distributed to Different Departments Overview You have received invoice XX1000 in the mail from XXIBM Corporation, which you will be entering into the Oracle Payables system. The invoice is to be distributed to two departments in your company.. •. Replace XX with your terminal number or initials.. •. You must have access to an Oracle Application Vision database or comparable training or test instance at your site on which to complete this practice.. Tasks Responsibility: Payables, Vision Operations (USA) 1.. Navigate to the Invoices window.. 2.. Enter the XX1000 invoice. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 49 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Assumptions.

(62) Solution - Enter an Invoice with Two Lines that are Distributed to Different Departments Tasks Enter Invoice. 2.. Navigate to the Invoices window. •. (N) Invoices > Entry > Invoice Batches. •. Query up XX Invoice Batch 1. •. (B) Invoices. Enter an invoice on the first available row using the following information: Trading Partner XXIBM Corporation. Invoice Date. Invoice Num. Invoice Amount. Description. Payment terms. 5 days ago. XX1000. 10000. Promotional Giveaway. Immediate. Enter Two Invoice Lines and Distribute Each Line to a Different Department 3.. (T) Lines. 4.. Enter the invoice lines according to the following table: Num. Type. Amount. Distribution Account. 1. Item. 4000. 01-402-7110-0000-000. 2. Item. 6000. 01-404-7110-0000-000. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 50 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 1..

(63) (I) Save, and click on (B) All Distributions. Note that because you entered the GL account number for each Item line, the Distribution Lines were automatically createdfor you.. 6.. (I) Show Navigator Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 51 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 5..

(64) Practice - Enter an Invoice for a Fixed Asset Overview You have received invoice XX2000 in the mail for the purchase of a fixed asset. Enter the invoice into Oracle Payables manually. .. •. Replace XX with your terminal number or initials.. •. You must have access to an Oracle Application Vision database or comparable training or test instance at your site on which to complete this practice.. Tasks Responsibility: Payables, Vision Operations (USA) 1.. Navigate to the Invoices window:. 2.. Enter an Invoice Header. 3.. Enter a Line for the invoice, ensuring that the Track as Asset field is automatically checked. 4.. Save your work.. 5.. Verify that the Distribution Line was generated automatically.. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 52 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Assumptions.

(65) Solution - Enter an Invoice for a Fixed Asset Tasks Enter an Invoice for a Fixed Asset. 2.. 3.. Navigate to the Invoices window. •. (N) Invoices > Entry > Invoice Batches. •. Query up XX Invoice Batch 1. •. (B) Invoices. Enter an invoice on the first available row using the following information: Invoice Type. Trading Partner. Invoice Date. Invoice Num. Invoice Amount. Description. Terms. Standard. XXIBM Corporation. 3 days ago. XX2000. 40000. Computer Server. 30 Net. (T) Lines. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 53 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 1..

(66) Enter an Invoice Line according to the following table: Num 1. Type Item. Amount 40000. Distribution Account 01-000-1570-0000-000. Track As Asset Automatically checks. 5.. (I) Save. 6.. (B) Distributions to verify that the Distribution Line was generated automatically.. 7.. (I) Show Navigator. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 54 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 4..

(67) Practice - Create Distribution Sets Overview You frequently receive invoices for which the accounting is generally the same. Your controller has asked you to establish a Distribution Set to enable the accounting entries for some invoices to be automatically generated. In this practice, you will create a Full Distribution Set and a Skeleton Distribution Set.. •. Replace XX with your terminal number or initials.. •. You must have access to an Oracle Application Vision database or comparable training or test instance at your site on which to complete this practice.. Tasks Responsibility: Payables, Vision Operations (USA) 1.. Navigate to the Distributions Sets window.. 2.. Create a Full Distribution Set. 3.. Enter a Skeleton Distribution Set. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 55 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Assumptions.

(68) Solution - Create Distribution Sets Tasks Create a Full Distribution Set Navigate to the Distribution Sets window. •. (N) Setup > Invoice > Distribution Sets. 2.. Create a Full Distribution Set using the following information: − Name = XX Full Utilities − Description = XX Utilities Full Distribution Set. 3.. Enter a Full Distribution set, according to the following table: Num. %. Account. Description. 1. 25. 01-402-7410-0000-000. Utilities-East Region. 2. 50. 01-404-7410-0000-000. Utilities-West Region. 3. 25. 01-410-7410-0000-000. Utilities-Mgmt. Note that when the total = 100%, the Type = Full. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 56 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. 1..

(69) 4.. (I) Save. 5.. In the Distribution Sets window, place the cursor in Name Field and press the down arrow key on your keyboard to create a new record.. 6.. Create a skeleton distribution set using the following information: − Name = XX Skeleton Utilities − Description = XX Utilities Skeleton Distribution Set. 7.. Enter skeleton distributions according to the following table. Num. %. Account. Description. 1. 0. 01-402-7410-0000-000. Utilities-East Region. 2. 0. 01-404-7410-0000-000. Utilities-West Region. 3. 0. 01-410-7410-0000-000. Utilities-Mgmt. Note that when the percentage = 0%, the Type = Skeleton. 8.. (I) Save. 9.. (I) Show Navigator. Copyright © 2009, Oracle. All rights reserved.. R12 Oracle Payables Management Fundamentals. Chapter 1 - Page 57 ONLY. COPYING eKIT MATERIALS FROM THIS THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM COMPUTER IS STRICTLY PROHIBITED. Oracle University and Egabi Solutions use only. Create a Skeleton Distribution Set.

No results found