R12 Oracle EBS Essentails - Lab Guide
R12 Oracle EBS Essentails - Lab Guide
R12 Oracle EBS Essentails - Lab Guide
Guide
Tasks
1. 2. 3. 4. 5. Log in to Oracle Applications. On the PHP, click the iProcurement responsibility to open the iProcurement Home page. Go to the Notifications Web page using (T) Requisitions > Notifications. Find All Notifications. Go back to the Home page.
3.
4.
Navigate to the Notification Web page using (T) Requisitions > Notifications.
5.
6.
(B) Go
7.
Click the Home link to go back to the Personal Home Page (PHP).
Guided Demonstration - Logging In to and Out of Oracle Applications (Professional and Self-Service Interface)
Logging In to Oracle Applications 1. 2. In Netscape or Internet Explorer Web browser, enter the URL for the R12 E-Business Suite instance. On the login screen enter: Username: OPERATIONS Password: welcome Accessibility: None Note: Accessibility: There are three types of accesses that can be selected before logging in to Oracle Applications. 1) Standard Accessibility: This renders the pages accessible for users using assistive technology. 2) Screen Reader Optimized: This optimizes the pages for screen readers. This may degrade the output for sighted users. 3) None: The pages may include behaviors that are not accessible. Select anyone of the above depending on the requirements. Usually None is chosen as all the contents can be accessed. 3. (B) Login
Setting Preferences 4. 5. 6. 7. Click the Preferences link on the Personal Home Page. In the Territory field, select a country other than the country that is shown, say United Kingdom or the country where the class is being taught, from the list of values (LOV). In the Currency field, select the currency of the country that is selected above, say British pound from the LOV. Select any one Number format from the LOV. Note: Inform students that the preferences can be set as required by the organization. But in the class all the students cannot change preferences as everyone is accessing the same instance. Also inform that if the default preferences are to be restored, one can do so by clicking the Reset to Default button.
Navigating Between Responsibilities and Opening a Form 8. 9. Click Order Management Super User, Vision Operations (USA) on the Personal Home Page. Click the Sales Orders link under Orders, Returns to open a form.
10. On the PHP, show what a responsibility is and what the different responsibilities that are available are. 11. Show how to go to a menu under a responsibility by clicking on a responsibility, say Application Developer and show the different menus such as Profile, Flexfield Test, Segments, Sets, Values, under this responsibility. 12. In the form-based interface, demonstrate the following options: Fields wherein the data can be entered (Optional and Mandatory) List of values (LOV) icon in the form and how to find and enter a value The toolbar with different icons like Save, Switch Responsibility, Find, Help, Alter Date, and so on The different Menu options and the submenus under each menu. File Menu consisting of submenus like Save, Close Form, Switch Responsibility, Exit Oracle Applications, and so on The Tab regions, which show different fields at the Header level and the Line level Show the usage of the Expand, Collapse, Expand All, Collapse All, and Expand Branch buttons. Also, show how these buttons can be accessed from the Tools Menu. Show how to add and delete values to the Top 10 List from the Navigator Menu.
Exit Oracle Applications 13. Log out of the form-based interface. (M) File > Exit Oracle Applications
Note: Highlight that logging out of a form-based interface does not log out the user from PHP also. 14. Activate PHP and log out of PHP.
Practice - Logging In to Oracle Applications, Creating Favorites, Navigating Through Responsibilities and Menus, Closing a Form, Logging Out of Oracle Applications
Overview
In this practice, you log in to Oracle Applications, navigate through the responsibilities and menus
Assumptions
Replace XX with your initials or a terminal number as given by your instructor.
Tasks
Logging In to Oracle Applications 1. 2. Open the URL given by the Instructor in Internet Explorer or Netscape. Use the following information to log in: Username: OPERATIONS Password: welcome Accessibility: None (B) Login
Section I: Creating Favorites 3. Enter a function: a. Responsibility: Inventory, Vision Operations (USA) b. Function Prompt: Receipts c. Favorite: XX_Receipts Section II: Logging In to Forms-Based Interface 4. Navigating through responsibilities and menus: a. On the PHP, click the Assets, Vision Operations (USA) responsibility to find the different menus available such as Financial Information, Transaction History, and Accounting Events under this responsibility.
b. Click the Financial Information link under Inquiry to open up a form. c. Go through the different fields such as Asset Number, Description, Tag, Asset Key, and Book in this form. d. On the PHP, click the Cash Management, Vision Operations (USA) to find the different menus available under this responsibility. e. Click the Bank Balances link to open a Web page. f. Go through the different fields such as Balance Date, Name, Type, and Account Number on this Web page. g. Close the Web page. 5. Closing a form: a. On the PHP, click Cash Management, Vision Operations (USA) responsibility. b. Open the Reconcile Bank Statements form. c. Use menu to close form. 6. Logging out of Oracle Applications: a. Exit R12 Forms Interface. b. Log out of the PHP.
Solution - Logging In to Oracle Applications, Creating Favorites, Navigating Through Responsibilities and Menus, Closing a Form, Logging Out of Oracle Applications
Logging In 1. 2. Open the URL given by the Instructor in Internet Explorer or Netscape. Use the following information to log in: Username: OPERATIONS Password: welcome Accessibility: None (B) Login
b. Responsibility: Inventory, Vision Operations (USA) c. Go d. Select Receipts. e. (B) Add f. Favorite = XX_Receipts
g. (B) Apply
Section II: Logging In to Forms-Based Interface 4. Navigating through responsibilities and menus: a. On the PHP, click the Assets, Vision Operations (USA) responsibility to find the different menus in this responsibility. b. Click the Financial Information link under Inquiry.
i. Go through the different fields such as Asset Number, Description, Tag, Asset Key, Book in this form. ii. On the PHP, click the Cash Management, Vision Operations (USA) responsibility. iii. The different menus under this responsibility can be seen. iv. Click the Bank Balances link.
v. This opens a Web page. vi. Go through the different fields such as Balance Date, Name, Type, Account Number on this Web page. vii. Click the link Home at the top right-hand corner to close this Web page.
5.
Closing a form: a. Open the Cash Management, Vision Operations (USA) responsibility b. (N) Bank Statements > Bank Statements and Reconciliation c. The form showing the Reconcile Bank Statement opens.
6.
Logging out of Oracle Applications: a. Exit R12 Forms Interface (M) File > Exit Oracle Applications
Tasks
Switch Responsibility 1. 2. Switch responsibility from Cash Management, Vision Operations (USA) to General Ledger, Vision Operations (USA) using Menu. Switch responsibility from General Ledger, Vision Operations (USA) to Payables, Vision Operations (USA) using the Switch Responsibility icon.
c. (B) OK
2.
c. (B) OK
Click Order Management Super User, Vision Operations (USA) on the Personal Home Page (PHP). Click the Sales Orders link under Orders, Returns to open a form.
Creating and Saving a Record 4. Enter the following information: a. Customer: A. C. Networks (Select from the list of values.) Other fields are filled automatically. b. (T) Line Items c. Ordered Item: AS54999 (Select from the LOV.) d. Quantity: 1 All other fields in this row are filled up automatically. e. Place cursor in next row to get 2.1 as the row number. f. Ordered Item: AS54888 (Select from the LOV.) g. Quantity: 1 h. (I) Save i. Write down the Sales Order number: ________
Tasks
1. 2. 3. On the PHP, click the Human Resources, Vision Enterprises link to open the menus under this responsibility. Click the Description link under Work Structures: Position to open a form. Create and save a record: a. Create a 123.XX position. Enter Position Number: 123 and Position Name: XX. Enter Type: Single Incumbent. Enter Organization: Vision Operations. Enter Job: ANA.400.Analyst. Enter Status: Active. Enter FTE: 1. Enter Headcount: Choose default.
b. Save the record using Menu. 4. Search or retrieve the record: a. Search for Date Effective Name =123.XX using both the search criteria: 5. Keyboard shortcuts: Press [F11] and [Ctrl] + [F11]. Using menu, Query By Example > Run and Query By Example > Enter
Edit a record: a. Edit the Date Effective Name field details from 123.XX to 123.1XX. b. Save the record.
6.
2. On the menu, click the Description link under Work Structures: Position to open a form.
3.
Enter the following: Date Effective Name has two fields to be filled (Position Number and Position Name): Position Number: 123 Position Name: XX
Select the default Permanent check box. Organization: Select Vision Operations from the LOV.
(B) OK
4.
Search and retrieve a record. Note: A record can be retrieved or searched for in two ways. Using shortcuts: a. Press [F11]. b. Enter the partial value, say 123.XX% in Date Effective Name. (Note: % is a wildcard, which can be used to retrieve the records, which have 123.XX as part of the record values.)
Note: While using the Menu option to find a record, we cannot use Query By Example > Run directly. Instead, we have to follow the above steps to enter the search criteria first and then query as per the given criteria. A record can also be retrieved using the Find icon information to retrieve the record or records. 5. Edit a record. a. Edit Position Details from 123.XX to 123.1XX . Then enter the requisite
i. Place cursor over Start Date. ii. Click the Edit Field icon. iii. On the Calendar screen you get, do not change the date.
iv. (B) OK v. On the Position Flexfield screen you get, change the Position Name from XX to 1XX.
vi. (B) OK
b. (I) Save
6.
d. (B) Purge
e. Save to make the changes to the database. Suggestion: Retrieve the 123.1XX record. The record cannot be retrieved. Note: All records cannot be deleted in this manner. Those records, which cannot be deleted, need to have an end date given. After this end date, the records cannot be used.
Tasks
1. 2. 3. 4. 5. Log in to Oracle Applications. Access the online Help from PHP. Navigate to the form-based interface. For example: Open the Sales Orders form in the Order Management Super User, Vision Operations (USA) responsibility. Access Keyboard Help. Find Record History for an existing record.
Accessing Online Help from PHP 3. Click the Help link on the top right corner of the PHP to open the online Help.
Note: Navigate through all the Tabs (Contents, Search, and View Topic) to familiarize yourself with the interface.
4.
Close the online Help to return to PHP. Note: You can close the online Help simply by closing your Web browser window.
5. Select the Order Management Super User, Vision Operations (USA) responsibility from the list on the E-Business Suite home page by clicking the responsibility name. Press [Tab] to go down the list and select your responsibility, then press Enter. Use the mouse button to click Responsibility. 6. Click the Sales Orders link under the Orders, Returns submenu to open the form in the professional applications interface.
Finding Record History 8. Open the record for which you would like to find the Record History. a. Press [F11]. b. Enter Customer Number as 1608.
9.
Note: Observe different information that is shown for the record. For example: Table/View Name, Update Date, and so on.
Run a Single Request Report 1. 2. 3. 4. 5. 6. 7. 8. 9. Use Order Management Super User, Vision Operations (USA) responsibility. Navigate to the submit request form (N) Reports, Requests > Run Reports. Choose the default Single Request and click OK. Select Orders Summary Report from the LOV. Choose the default Operating Unit: Vision Operations. In the parameters window, choose the default and click OK. Click Submit. Note the Request ID and click No on the decision screen. View the above request using (M) View > Requests.
10. Choose the default All my requests. 11. Click Find. 12. Click View Output to find the Orders Summary report.
Tasks
1. 2. 3. Log in to Oracle Applications. Select the Human Resources, Vision Enterprises responsibility. Navigate to the Submit Request window: 4. (N) Processes and Reports > Submit Processes and Reports
Enter the following information: Name: Employee Periodic Detail Report Enter the following Parameters: o Beginning Date Paid: Enter a date two months prior to Current/System date o Ending Date Paid: Select Current/System Date o Jurisdiction Level: Federal (Choose default.) o Detail Level: Summary within Selected Period (Choose default.) o Output file type: Comma Delimited (Select Default.) Submit the request.
5. View the Output. Create a Request Set Using the Request Set Wizard: 6. 7. Switch responsibility to System Administrator. Use Standard Request Submission to run your Request Set. 8. (N) Requests > Set
Schedule your Request Set to run once a week for four weeks. Note: The purpose of this practice is to understand how to use the Wizard to create a Request Set, not to teach you which reports to run, or what parameter values should be used for specific reports.
4.
E-Business Suite home page will display menu options and functions in a new column on the page that is currently displayed.
Click the Submit Processes and Reports link under the Processes and Reports submenu to open the Submit a New Request dialog box.
5.
Select the default Single Request and click OK to open the Submit Request dialog box.
6.
Enter the following information: Name: Employee Periodic Detail Report (Select from the LOV.)
(B) OK Enter the following in the Parameters window: Beginning Date Paid: Enter a prior date (say two months prior to Current/System Date). Ending Date Paid: Select Current/System Date Jurisdiction Level: Federal (Select default.) Detail Level: Summary within Selected Period (Choose default.) Output file type: Comma Delimited (Select default.)
(B) OK
(B) Submit
9.
Click the Request Set Wizard button in the form. (Do not fill in any other fields.)
10. Accept the default value to run your requests sequentially. Click Next. This will create one stage for each request in the set.
11. Accept the default to Abort Processing if one of your requests ends in Error. Click Next.
12. Enter the required information for your Request Set. Click the Next button.
Enter XX Weekly Reports as the Request Set name. Select Application Object Library as the Application name.
13. (B) Next 14. Accept the default print option As Each Request in the Set Completes. Click the Next button.
15. Select the concurrent program(s) that you want to run: Select Active Responsibilities and Users.
(B) OK
16. Click the Finish button. 17. Click the OK button in the Note dialog box that appears.
18. Click the Define Stages button to review your three stages.
19. Click the Requests button for Users of a Responsibility (20) and then, click the Parameters button to view the parameters for this program. You can also review your other stages, requests, and parameter windows.
Note: Close all windows until you are back to the Request Set window. 23. Return to the Request Set form and click the Link Stages button to view the default values you selected to link your stages. Notice the Start Stage value and the values for Success, Warning, and Error. Click the Cancel button after you have completed your review.
24. Close the Request Set form. 25. Navigate to the Standard Request Submission form. (N) Requests > Run
26. Select the Request Set option button and click OK. 27. Select your XX Weekly Reports from the list of values (LOV).
28. Complete the parameter values for each report: Active Responsibilities has no parameters. Active Users has no parameters. Users of a Responsibility: Enter System Administration for Application Name and System Administrator for Responsibility Name.
29. Click OK to close the parameter window. 30. Click the Schedule button. 31. Select the Periodically option under the Run the Job section, provide an End Date for this schedule, and finally click the OK button.
Note: You can save this schedule by selecting the Save this schedule check box. 32. Click the Submit button to submit the request.
33. Record your Request ID and Click No when asked to submit another request.
34. View your Reports online. (M) Requests > View Accept the All My Requests option by clicking the Find button in the Find Requests window.
35. Click the line with the completed Users of a Responsibility report.
36. Click the View Output button to see the report online.
Note: Navigating around the online report depends on the viewer you are using at your site.
Assumptions
Replace XX with your terminal number or initials.
Tasks
Defining / Creating an Item 1. 2. Responsibility = Inventory, Vision Operations (USA) Navigate to the Master Item Window. a. (N) Items > Master Items b. Organization = M1- Seattle Manufacturing Create a new item by entering the following information. a. Item = XX_Item b. Description = XX_Item c. Template = Finished Goods Save the record. Close the Form.
3.
4. 5.
Using XX_Item in Order Management 6. 7. 8. Switch responsibility to Order Management Super User, Vision Operations (USA). (N) Orders, Returns > Sales Order Enter the following information: Order Type = Mixed Ordered Item = XX_Item Close the Form without saving.
9.
c.
(B) OK
3.
Create a new item. Enter the following information: a. Item = XX_Item b. Description = XX_Item
i.
ii. (B) OK
4.
5.
Accessing the item XX_Item from Order Management 6. Switch responsibility to Order Management Super User, Vision Operations (USA). a. (I) Switch Responsibility
b. (B) OK
7.
Navigate to the Sales Orders (Vision Operations) New form. a. (N) Orders, Returns > Sales Orders
8.
Select the following Information: a. (T) Order Information b. Select Order Type = Mixed from LOV
c. (T) Line Items d. Select from LOV Ordered Item = XX_ Item
9.
b. You get a note stating that this item is invalid or does not exist in the warehouse.
c. (B) OK
e. (B) Yes
Note: An item defined in an Inventory application can be used in another application, namely Order Management. This shows that the Item entity is shared across applications.
e. Address Line 4: Fizzy Road f. City: New York g. County: New York h. State: NY i. Postal Code: 10020 j. Address Name: XX_Supplier_Site (Mandatory) k. Language = American English l. (B) Continue m. Address Purpose: Select the Purchasing and Payment check boxes n. (B) Continue o. Select the check box besides XX_Supplier and Vision Operations p. (B) Apply 6. 7. 8. 9. Click Quick Update Link. Accept the default Ship To Location and Bill To Location, FOB, Country of Origin values. (B) Save Close the window.
10. Switch responsibility to Purchasing, Vision Operations (USA). Enter a Purchase Order as follows: 11. (N) Purchase Orders > Purchase Orders 12. Enter the following information: a. Operating Unit: Select Vision Operations from LOV b. Type: Accept Default (Standard Purchase Order) c. Supplier: Find the Supplier XX_Supplier d. Close the form without saving. Therefore, it is seen that the Suppliers entity is shared across applications. It is defined in one application and accessed in another.
Note: Suppliers are now part of the Trading Community Architecture. To show how an entity defined in the Forms-Based Interface can be seen in a Self Service Application: 13. Use the Purchasing, Vision Operations (USA) responsibility. a. Navigate to the Requisitions Window using (N) Requisitions > Requisitions b. Operating Unit: Select Vision Operations from LOV c. Type = Select Purchase Requisition from LOV d. Description = Test for SSA e. (T) Lines f. Item = Select AS54999 from the LOV g. Quantity = 10 h. Need-By = Take Current Date +1 Day i. Below the Line level, select Supplier = XX_Supplier (created above) j. Select Site = XX_Supplier_Address k. Select the default values. l. Save m. Write down the Requisition Number = _______________ n. Close the Requisitions Form. 14. Switch responsibility to iProcurement. a. On the Web page that opens, click (T) Requisitions. b. The above created requisition can be seen under the My Requisitions region with status = Incomplete c. Close the window. Therefore, it is seen that an entity (Requisition), which is defined in a Forms-Based Interface can be accessed through the Self Service Applications.
Assumptions
Replace XX with your terminal number or initials.
Tasks
Defining an Employee 1. 2. 3. Responsibility = Human Resources, Vision Enterprises Navigate to the Define Person Window. (N) People > Enter and Maintain Enter the following information: Last = Samuels First = XX_James Gender = Select M or F as appropriate Action = Create Employment Person Type = Employee Save your record. Record your employee number __________________.
4. 5.
Creating an Assignment 6. 7. Navigate to the Assignment Window by clicking (B) Assignment. Enter the following information: a. Organization = Vision Operations In the Group field, enter as follows: b. Team = Financials c. National Bargaining Unit = ALPA d. Select following: Job = MGR500.Manager Position = MM400.Materials Manager
8. 9.
Accept the default values. (T) Supervisor Name = Brown, Ms. Casey
10. Save your record. 11. Accept the default location value. 12. Close all the windows and return to the Navigator page. Creating a Resource 13. Responsibility = CRM Resource Manager, Vision Enterprises 14. Navigate to the Select Resources to Import Window. (N) Maintain Resources > Import Resources 15. Select / Enter the following: Resource Category = Employee Number = Employee number of Samuels, XX James created above 16. Search for the Employee. 17. Import the details of Employee to create a Resource. - Select Role = Credit Manager (From LOV) 18. Save the created Resource. 19. Find the Resource details. 20. Record your resource number _______________. 21. Close all the windows and return to the Navigator page.
(B) New
3.
Enter the following information: Last = Samuels First = XX_James Gender = Select M or F as appropriate Action = Create Employment
(B) OK 4. 5. (I) Save Accept the two Note dialog boxes you get by clicking (B) OK
6.
Record your employee number __________________. Note: The system will generate an employee number that will be visible in the field above the Social Security Number field.
Creating an Assignment In this section of the solution, you view how to assign an employee to an organization. 7. (B) Assignment
8.
Enter the following information: a. Organization = Vision Operations (Select from LOV) In the Group field, enter following: b. Team = Financials (Select from LOV)
Note: You will get a message prompting you to choose between keeping the history of the existing information and correcting the existing information. Click (B) Correction.
- (B) OK Note: You get a Decision dialog box asking whether to accept the default values.
Note: You will get a caution form asking whether you would want to use thelocation of the new position.
13. Close all the windows and return to the Navigator page. Creating a Resource 14. Use Responsibility = CRM Resource Manager, Vision Enterprises
15. Navigate to the Select Resources to Import Window. - (N) Maintain Resources > Import Resources 16. Select / Enter your resource. - Resource Category = Employee (Delect from LOV) - Number = 1944 (Employee Number of Employee created above)
18. (B) Start Import - Role = Credit Manager (Select from LOV)
Note: You get a message confirming the successful import of the employee record. - (B) OK 20. (B) Details (to find the details of the Resource)
22. Close all the windows and return to the Navigator page.
Assumptions
Replace XX with your terminal number or initials. You must have access to an Oracle Application Vision database, or a comparable training or test instance at your site on which to complete this practice.
Tasks
Creating a New User 1. 2. 3. Responsibility = System Administrator Navigate to the Define Users Window. (N) Security > User > Define Specify User details. Username = XXEBSTUDENT (where XX is your terminal ID or initials) Password = welcome (Click [Tab], re-enter password to verify) Person = the employee you created in earlier practice. (T) Direct Responsibilities Add the following responsibilities to your new Username:
Responsibility Purchasing, Vision Operations (USA) Payables, Vision Operations (USA) Payables, Vision Services (USA) System Administrator Inventory, Vision Operations (USA) General Ledger, Vision Operations (USA) Human Resources, Vision Enterprises Assets, Vision Operations (USA)
4. 5.
6. 7. 8.
Save (M) File > Exit Oracle Applications Log out from the Personal Home page.
Logging in As a New User 9. Log in as a new User. Login = XXEBSTUDENT Password = welcome Current Password = welcome New Password = XXEBSTUDENT Re-enter New Password = XXEBSTUDENT
Navigate to the Define Users Window. (N) Security > User > Define 3. Specify User details. Username = XXEBSTUDENT (where XX is your terminal ID) Password = welcome (tab, re-enter the password to verify) Person = The employee you created in earlier practice
4.
(B) OK
5.
6.
Save
7. 8.
Logging in As a New User 9. Log in as a new User. Login = XXEBSTUDENT Password = welcome
11. The system will prompt you to create a new password: Current Password = welcome New Password = XXEBSTUDENT Re-enter New Password = XXEBSTUDENT
o o o o o o
To set System Profile Values: o Switch responsibility to Inventory, Vision Operations (USA). o (N) Items > Master Items o Organization = M1-Seattle Manufacturing (Select from LOV) o Note the value of the Item Status = _____________ (which is Active, at present) o Close Form. o Switch responsibility to System Administrator. o (N) Profile > System o Select application: Application = Inventory (Select from LOV) o Select responsibility:
Responsibility = Inventory, Vision Operations (USA) (Select from LOV) o Select user User = Operations (Select from LOV) o Profile = INV: Default Item Status o (B) Find o In the Note Window that you get, click (B) OK o Tab to the User field. o OPERATIONS = Inactive (Select from LOV) o Save o Close Form. o Switch responsibility to Inventory, Vision Operations (USA). o (N) Items > Master Items o Organization = M1-Seattle Manufacturing (Select from LOV) o Note the value of the Item Status= _____________ (which will now show Inactive)
Assumptions
Replace XX with your terminal number or initials. You must have access to an Oracle Application Vision database, or a comparable training, or test instance at your site on which to complete this practice.
Tasks
Creating a Value Set 1. 2. 3. Responsibility: System Administrator Navigate to the Value Sets window: (N) Application > Validation > Set Create the independent value set:
Field Name Value Set Name Description List Type Security Type Format Max. Size Uppercase Only (AZ) Right Justify and Zerofill Numbers (001) Validation Type Major class List of Values Non-Hierarchical Security Char 10 Check box to be selected Check box to be deselected Independent Value XXPO Class
4.
5.
Value Set Name Description List Type Security Type Format Maximum Size Uppercase Only (AZ) Right Justify and Zerofill Numbers (001) Validation Type
6.
(B) Edit information and enter the following information: - Independent Value Set Name: XXPO Class - Value: NONE - Description: None Save
7.
4. 5.
Value Set Name Description List Type Security Type Format Max. Size Uppercase Only (AZ) Right Justify and Zerofill Numbers (001) Validation Type
6.
(B) Edit Information. Name: XXPO Class Value: NONE Description: None
7.
Click Save.
Practice - Creating a Structure for a Key Flexfield and Adding Value Sets
Overview
In this practice you will create a structure for a key flexfield.
Assumptions
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
Querying the Item Categories Structure 1. 2. Responsibility: System Administrator Navigate to the Key Flexfield Segments window: (N) Application > Flexfield > Key > Segments Query the structure and enter following information: Application: Inventory Flexfield Title: Item Categories
3.
Creating a New Structure 4. Create a new structure: Code: XXPO_ITEM_CAT Title: XXPO_ITEM_CAT Description: PO Item Category
Assigning Segments 5. Create the structure based on the segment information in the following table:
No 1 2 Name PO Class PO Subclass Window Prompt Class Sub Column (LOV) SEGMENT1 SEGMENT2 Value Set (LOV) XXPO Class XXPO Subclass
6.
7.
8.
Adding Values 9. Navigate to the Values window: (N) Application > Validation > Values
10. Search for any existing values using your value sets. 11. Enter values according to the following table and Save:
Value CCOMP CSYS Description Computer Component Computer System
Entering Values Dependent on the CCOMP Value 12. Query the PO Subclass segment of the XXPO_ITEM_CAT structure. 13. Enter values dependent on the CCOMP value according to the following table and Save:
Value MOUSE MONITOR Description Mouse, Optical Monitor, Flat Panel
Entering Values Dependent on the CSYS Value 14. Enter values dependent on the CSYS value according to the following table and Save:
Value PC SERVER PC Server Description
DESKTOP Desktop
4.
Creating a New Structure 5. Place cursor over the Title field: a. (M) File > New b. Enter the following information: Code: XXPO_ITEM_CAT
Create the structure based on the segment information in the following table:
No 1 2 Name PO Class PO Subclass Window Prompt Class Sub Column (LOV) SEGMENT1 SEGMENT2 Value Set (LOV) XXPO Class XXPO Subclass
- Save.
7.
Place your cursor on line 1 (PO Class). a. (B) Open to add additional information to the segment definition.
Field Description Required Security Enabled Value PO Class Checked Checked
b. Save.
c. Close the Segments window. 8. Place your cursor on line 2 (PO Subclass). a. (B) Open to add additional information to the segment definition.
Field Description Required Security Enabled Value PO Subclass Checked Checked
b. Save. 9. Close windows until you are back at the Key Flexfield Segments window. Select the Freeze Flexfield Definition check box. (B) OK (B) Compile
Adding Values 10. Navigate to the Values window. (N) Application > Validation > Values 11. Search for any existing values using your value sets: Find Values By: Key Flexfield Application: Inventory Title: Item Categories Structure: XXPO_ITEM_CAT Segment: PO Class (B) Find
- Save. - (B) OK to acknowledge the Note dialog box. Entering Values Dependent on the CCOMP Value 13. Navigate to Find Key Flexfield Segment window. - (N) Application > Validation > Values a. Find your value sets: Find Values By: Key Flexfield Application: Inventory Title: Item Categories Structure: XXPO_ITEM_CAT Segment: PO Subclass Independent Value: CCOMP
d. Save. e. (B) OK to acknowledge the Note dialog box. Entering Values Dependent on the CSYS Value 14. Navigate to Find Key Flexfield Segment window. - (N) Application > Validation > Values a. Find your value sets: Find Values By: Key Flexfield Application: Inventory Title: Item Categories Structure: XXPO_ITEM_CAT Segment: PO Subclass Independent Value: CSYS
DESKTOP Desktop
d. Save.
e. (B) OK to acknowledge the Note dialog box. 15. Close windows until you are back at the Navigator.
Assumptions
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
Defining Valid Category Combinations 1. 2. 3. Responsibility: Inventory, Vision Operations (USA) Navigate to the Category Codes window: (N) Setup > Item > Categories > Category Codes Set up new category codes combinations according to the following table. Name your structure XXPO_ITEM_CAT.
Structure Name XXPO_ITEM_CAT XXPO_ITEM_CAT Category CCOMP.KEYBOARD CSYS.PC Description Component, Keyboard System, PC
Setting Up Category Codes 4. 5. Navigate to the Category Sets window: (N) Setup > Item > Categories > Category Sets (M1 - Seattle) Set up category codes: Name: XXPurchasing Description: Purchasing Category Set Flex Structure: XXPO_ITEM_CAT Controlled At: Master Level Default Category: CSYS.PC Click Save.
Note: Sometimes the Key Flexfield segments may not come automatically. In such cases, enter some letter in the Category field and press [Tab] to open the structure. 3. Define combinations according to the following table:
Structure Name XXPO_ITEM_CAT XXPO_ITEM_CAT Category CCOMP.KEYBOARD CSYS.PC Description Component, Keyboard System, PC
4.
Select/Enter the following values: a. Class: CCOMP Sub: KEYBOARD Description: Component, Keyboard (B) OK b. Structure: XXPO_ITEM_CAT Class: CSYS Sub: PC Description: System, PC (B) OK
5.
Click Save.
6.
Setting Up Category Codes 7. Navigate to the Category Sets window: (N) Setup > Item > Categories > Category Sets (M1 Seattle Manufacturing) Select M1 Seattle Manufacturing from the list. (B) OK Create category code combinations: Name: XXPurchasing Description: Purchasing Category Set Flex Structure: XXPO_ITEM_CAT Controlled At: Master Level Place cursor over the Default Category field. Activate the list of values. Class: CSYS Activate the list of values in the Sub field. Select PC. (B) OK Click Save. Note the values are dependent on the independent value of CSYS. Test the independent/dependent relationship by placing cursor over the Default Category field.
8.
9.
Assumptions
Replace XX with your terminal number or initials. You must have access to an Oracle Application Vision database, or a comparable training or test instance at your site on which to complete this practice.
Tasks
Creating a Supplier 1. 2. 3. 4. 5. Log in to Oracle Applications On the Personal Home page click the Payables, Vision Operations (USA) responsibility. Click the Entry link under Suppliers. Create a new supplier. Specify supplier details: Supplier Type = Standard (Choose default) Organization Name = XXSupplier Country of Origin = United States Search and Select, Country Code = US Apply and Note the Supplier Number. Create a supplier site according to the following details in the Address Book link. Country = United States (Default) Address = You choose City = New York County = New York State = NY Postal Code = 10020 Address Name = XXSupplier_Site Address Purpose = Select Purchasing and Payment Operating Unit = Vision Operations
6.
7.
Entering an Invoice 8. 9. Click the Invoices link under Invoices: Entry to open the Invoices Window. Enter an invoice with the following details: Trading Partner = XXSupplier Site = Choose the default option, XXSupplier_Site Invoice Date = System / Current Date Tab to Invoice Num field Invoice Num = 1000 Invoice Amount = 10000 Close Form without saving.
10. Close all the windows and return to the Navigator page. Attempting to Enter an Invoice 11. Switch responsibility to Payables, Vision Services (USA). Note: You might have to add this responsibility to your User. 12. Navigate to the Invoices Window. (N) Invoices > Entry > Invoices 13. Trading Partner = XXSupplier 14. Tab out of the supplier field. 15. Note that this is an Invalid Supplier for this operating unit. 16. Close all the windows and return to the Navigator page.
3.
Click the Entry link under Suppliers to open the Supplier Entry Web page.
4. (B) Create Supplier 5. Specify supplier details: Supplier Type = Standard (Choose Default) Organization Name = XXSupplier Country of Origin = United States
- Search for Country = United States - (B) GO - Select Option, Country Code =US
- Note the Supplier Number = ____________ 6. Click the Address Book link to create a Supplier site and enter the following details: Country = Choose the default option, United States Address = You choose
City = New York County = New York State = NY Postal Code = 10020 Address Name = XXSupplier_Site
- (B) Apply Note: You get a confirmation stating that the XXSupplier_Site has been added to the Address Book for XXSupplier.
7.
Entering an Invoice 8. On the Personal Home page click the Invoices link under Invoices: Entry to open the Invoices Window.
9.
Site = Choose the default option, XXSupplier_Site Invoice Date = Enter System / Current Date Invoice Num = 1000 Invoice Amount = 10000
- (B) Yes 10. Close all the windows and return to the Navigator page.
12. Select Responsibility = Payables, Vision Services (USA) 13. (B) OK 14. Navigate to the Invoices Window. (N) Invoices > Entry > Invoices
Note: At the bottom of the window, you see that there are no records available for Trading Partner = XXSupplier. 16. Tab out of the Supplier field. 17. Note that this is an Invalid Supplier for this operating unit. 18. Close all the windows and return to the Navigator page.
Thus, it can be seen that Multi Org secures Application Data. A Supplier created in one Operating Unit cannot be retrieved in another Operating Unit.
2.
Setting up Grants 3. Navigate to the Grants Window. (N) Setup > Shipping > Grants and Role Definitions > Grants User = OPERATIONS Role = Upgrade Role
4.
Entering a Sales Order 5. Navigate to the Sales Orders Window. 6. (N) Orders, Returns > Sales Orders
Enter the Sales order. Customer = Business World (1608) Order Type = Mixed (T) Line Items Ordered Item = AS54999 Quantity = 10 Tax Code = Exempt Save
7.
8.
10. (B) View Diagram Note: You can also view the diagram by clicking the Status Diagram on the left Navigation pane. 11. Double-click the Enter-Line icon.
12. Note the Workflow reflects that the line has been entered and is waiting for booking. 13. Close the Workflow Monitor. Booking the Sales Order 14. (B) Book Order 15. Make a note of your order number. Viewing the Workflow Monitor 16. (M) Tools > Workflow Status 17. (B) View Diagram Note: You can also view the diagram by clicking the Status Diagram on the left Navigation pane. 18. Note the Workflow reflects that the line has been booked. 19. Close the Workflow Monitor. 20. Close all the windows and return to the Navigator page. Releasing the Sales Order for Picking 21. Navigate to the Shipping Transactions Window. (N) Shipping > Transactions Order Number = Your sales order number
22. (B) Find 23. Action = Launch Pick Release 24. (B) Go 25. View your requests and ensure that the concurrent requests complete successfully. 26. Close all the windows and return to the Navigator page. Confirming the Shipment 27. Navigate to the Shipping Transactions Window. (N) Shipping > Transactions Order Number = Your sales order number
29. (T) Delivery Actions = Ship Confirm 30. (B) Go 31. (B) OK Viewing the Workflow Monitor 32. Navigate to the Orders Window. (N) Orders, Returns > Orders
33. Query your Sales Order. 34. (T) Line Items 35. (M) Tools > Workflow Status 36. (B) View Diagram Note: You can also view the diagram by clicking the Status Diagram on the left Navigation pane. 39. Note that the process has continued. 40. Close the Workflow Monitor.
Assumptions
Replace XX with your terminal number or initials. You must have access to an Oracle Application Vision database, or a comparable training or test instance at your site on which to complete this practice.
Tasks
Creating a Requisition 1. 2. Responsibility: Purchasing, Vision Operations (USA) Navigate to the Requisitions Window: 3. (N) Requisitions > Requisitions
Specify the requisition details: Operating Unit: Vision Operations Description: XXSupplies Type: Purchase Requisition (T) Lines Item: f71000 Quantity: 40 Need by: Todays date + 1
4. Save your requisition. 5. 6. 7. Review the accounting distributions created automatically by Workflow. Make a note of your requisition number: _____________ Approve your requisition.
Viewing Approval Through Workflow 8. Navigate to the Requisitions Summary Window: (N) Requisitions > Requisition Summary
9.
10. (M) Tools > View Approval through Workflow 11. View the diagram. Drill down on both the Verify Approval Authority and Approval List Routing subprocesses. 12. Close the Workflow Monitor. 13. (M) File > Exit Oracle Applications 14. Make your Personal Home Page the active page, and then log out. Approving the Requisition 15. Log in as cbaker and approve the requisition: User: cbaker Password: welcome Viewing Approval Through Workflow 16. Log in as XXebstudent: User: XXebstudent Password: XXebstudent 17. Responsibility: Purchasing, Vision Operations 18. Navigate to the Requisition Summary Window: (N) Requisitions > Requisitions
19. Find your requisition and view the requisition approval by using the Workflow Monitor: Requisition Number: Your requisition number 20. Close the Workflow Monitor.
Specify the requisition details: Operating Unit: Vision Operations Type: Purchase Requisition Description: XXSupplies (T) Lines Item: f71000 Quantity: 10 Need by: Todays date + 1
4. 5.
6. 7.
Close the Distributions Window. Make a note of your requisition number: _____________
8. 9.
(B) Approve Select the default Submit for Approval check box.
11. (B) OK 12. Close the Requisitions Window. Viewing Approval Through Workflow 13. Navigate to the Requisitions Summary Window: (N) Requisitions > Requisition Summary
14. Find your requisition: Requisition Number: Your requisition number 15. (B) Find
17. (B) View Diagram Note: You can also view the diagram by clicking Status Diagram on the left Navigation pane.
18. Browse to the centre of the process map, and double-click the Approval Routing Chooser icon.
22. Notice that an approver has been found and a notification has been sent.
25. (M) File > Exit Oracle Applications 26. Make your Personal Home Page the active page, and then log out.
Approving the Requisition 27. Log in as cbaker: User: cbaker Password: welcome
28. Click the link for your notification that requires approval: (L) Notifications under Favorites
Notice that your created requisition appears as a notification, awaiting action from cbaker. 29. Open your requisition by clicking the subject line in the Subject column.
31. Log out. Viewing Approval Through Workflow 32. Log in as XXebstudent: User: XXebstudent Password: XXebstudent 33. (L) Purchasing, Vision Operations (USA) 34. Navigate to the Requisition Summary Window: (N) Requisitions > Requisitions Summary
35. Find your requisition: Requisition Number: Your requisition number 36. (B) Find 37. (M) Tools > View Approval through Workflow 38. (B) View Diagram Note: You can also view the diagram by clicking Status Diagram on the left Navigation pane.
Note that the path has continued and is completed. 39. Close the Workflow Monitor.
Assumptions
Use the Vision demo database for this practice.
Tasks
1. 2. 3. 4. 5. 6. Responsibility = Daily Supply Chain Intelligence (N) Dashboards > Shipping Management Review the change in the number for Shipping KPIs by altering Period, Compare To and Organization. Open the Lines Late to Schedule Trend. Browse through details of Lines Late to Schedule. Open and review line level details for a delayed order.
Suggestion: Change the report parameters like Period, Compare To, and Organizations and observe the changes to the report. 3. Scroll down the page and click on the Lines Late To Schedule link, to display the Lines Shipped Perforrmance Trend.
4.
On the Lines Shipped Performance Trend specify: Period = Year Compare To = Prior Year Note: That the graphs change automatically to reflect the data according to the specified parameters.
5.
Scroll down the page to view the links listed at the bottom of the report, click on Lines Shipped Late to Schedule Detail to view the details of order an lines which got delayed.
6.