Downloaded 4,772 times
![• SBI Buying Company Identifier is a unique code for the operating unit. This is defined as a Purchasing Option and need not be unique.
• Selling Company Identifier is a code for the supplier site. It is defined in the supplier site window.
The Selling Company Identifier does not need to be unique within the same supplier; however, it must be unique across suppliers.
• Invoice Type Code:
• ERS (Evaluated Receipt Settlement) for Pay on Receipt invoices
• RTS (Return to Supplier) for Debit Memos
• PPA (Purchase Price Adjustment) for invoices resulting from a retroactive price adjustment
• Seq# is a gapless sequence numberdefined for each buying company/selling company/invoice type combination when Gapless
Invoice Numbering is enabled.
All segments of the gapless invoice number are separated with a hyphen.
10. The PO Output Format
Selection defines the output format for purchase orders sent to the supplier using print, e-mail, or fax. It also enables functionality
related to that output format. Setting Up 1-37
PDF: Purchase orders are output in the Adobe Portable Document Format (PDF).
You can view the purchase order fully formatted from the Enter Purchase Order window, Purchase Order Summary window, Change
History page, Oracle iProcurement, and Oracle iSupplier Portal.
You can also communicate the purchase order to the supplier from the Purchase Order Summary window.
Text: Purchase orders are output in text.
Note: Your ability to communicate the purchase order to the supplier from the Approval window remains the same with either setting.
Only the formatting of the output changes.
See: Setup Purchase Order Communication to Suppliers, page 1-75
11. Ifthe PO Output format is PDF,
Enter the Maximum Attachment Size. This indicates the maximum file size, in megabytes, that is allowed as a File type attachment to
an e-mailed purchase order.
See: About Attachments, Oracle ApplicationsUser's Guide.
12. Select Enforce Price Tolerance Percentage
If you want Purchasing to enforce the price tolerance percentage.
13. Select Enforce Price Tolerance Amount
If you want Purchasing to enforce the price tolerance amount.
14. Select Display Disposition Messages
If you want to see any disposition messages defined against inventory items when they are placed on requisitions.
15. Select Notify IfBlanket PO Exists
If you want to be notified of existing blanket purchase agreements when you create a requisition, purchase order, or blanket
purchase agreement line for the item. If you sourced the item, you see the following message: Blanket purchase order [number] already
exists for this item. Your requestors can directly create a release for the blanket purchase agreements instead of creating a requisition or
purchase order if you allow your requestorto enter releases. See: Viewing and Responding to Notifications, page 2-29.
16. AllowItem Description Update
You can define for each item whether you allow updating of the item description during the creation of requisition, RFQ, quotation,or
purchase order lines. This update affects only the line you are creating. Select Allow Item Description Update if you want Yes to be the
initial default of the Allow Description Update attribute when you are defining a new item.
17. Select Enforce Buyer Name
To enforce entry of only your name as the buyer on purchase orders. Otherwise, you can enter the name of any active buyer.
See:Defining Buyers, page 1-20.](https://image.slidesharecdn.com/elshayeboracler12purchasing-141118065305-conversion-gate02/85/Oracle-Purchasing-R12-Setup-Steps-40-320.jpg)
![26. Enter the Quote Warning Delay.
This is the number of days before a quotation expires that you want to receive an expiration warning. When a quotation is due to
expire within the number of days you provide here, you receive the following message in the Notifications Summary window:
Quotations active or approaching expiration: [number]. See: Viewing and Responding to Notifications, page 2-29.
27. Line Type
Select a default Line Type for requisition, RFQ, quotation,and purchase order lines.
When you create any of these documents,the line type is part of your item information. You can override the line type for each
document line. See: Defining Line Types, page 1-62.
Important: This field is enterable only when the form is accessed from the Purchasing menu.
28. Rate Type
Select the currency Rate Type that defaults on requisitions, purchase orders,RFQs, and quotations.If the Rate Type is User, you can
override this default for each document line. If either your functional currency (defined in yourledger) or your transaction currency (the
currency you enter in a purchasing document window) is Euro (the European Monetary Unit currency), and the other is another
European currency, Purchasing defaults in the appropriate conversion Rate Type, Rate, and Rate Date. See: Defining Conversion Rate
Types,Oracle General Ledger User's Guide.
29. Match Approval Level:
Select one of the following options for Match ApprovalLevel:
Two-Way: Purchase order and invoice quantities must match within tolerance before the corresponding invoice can be paid.
Three-Way: Purchase order, receipt, and invoice quantities must match within tolerance before the corresponding invoice can be paid.
Four-Way: Purchase order, receipt, inspection,and invoice quantities must match within tolerance before the corresponding invoice can
be paid. See: Receiving Controls, Options, and Profiles, page 9-7.
Note: The Invoice Match Option in the purchase order Shipments window and the Match Approval Level here are independent options.
The Invoice Match Option determines whether Payables performs invoice matching to the purchase order or the receipt.
You can perform whichever Invoice Match Option you want on a shipment regardless of the Match Approval Level you choose here.
30. Price Break Type
Select the Price Break Type that defaults on blanket purchase orders:
Cumulative:Price breaks apply to the cumulative quantity on all release shipments for the item.
Non-cumulative:Price breaks apply to quantities on individual release shipments for the item.
31. Price Type
Select the Price Type that defaults on purchase orders.Use the Lookup Codes window to define price types.See: Defining Lookup
Codes, page 1-55.
32. Minimum Release Amount
Enter the Minimum Release Amount that defaults on blanket, contract, and planned purchase orders.This amount is in your functional
currency. See: Overview of Multi-Currency Accounting, Oracle General Ledger User's Guide.](https://image.slidesharecdn.com/elshayeboracler12purchasing-141118065305-conversion-gate02/85/Oracle-Purchasing-R12-Setup-Steps-43-320.jpg)
![Receipt Accounting Options:
33. Accrue Expense Items
Choose one of the following Accrue Expense Items options:
At Receipt: Accrue expense items upon receipt. You can override this flag in the Shipment Details window when you are entering
purchase orders and releases.
Period End: Accrue expense items at period end.
Important: When using Cash Basis Accounting,you should set this option to Period End, but you will not normally run the Receipt
Accrual - Period End process.
34. For Accrue Inventory Items,you currently have only one choice: On Receipt.
35. Automatic Offset Method
An offset is an accounting entry that is created to offset, or balance, another accounting entry. Automatic Offset Method is the method
used to automatically create the account for the offsetting transaction.Here the offsetting account is the
Receiving Inspection Account,which offsets the Accrual Account transaction at the time of receipt and the Charge Account at the time
of delivery.
The Automatic Offset Method controls which of the two accounts are used as the base account and which as the overlay account,as
well as which segment is used to overlay the base account segment.
Choose one of the following Automatic Offset Method options:
None: No substitutionsare made and the Receiving Inspection account for the destination organization is used.
Balancing:The base account is the Receiving Inspection Account for the destination organization and the balancing segment is overlaid
with the balancing segment of the Charge Account.
Account:The base account is the Charge Account and the account segment is overlaid with the account segment of the Receiving
Inspection Account.
Note: The Automatic Offset Method is not supported with retroactive pricing, shared services, and drop shipment flows.
36. Enter the default Expense AP Accrual Account. 01-000-1340-0000-000
Document Numbering Options
37. Entry method:
Select the [Document] Number Entry method for RFQ, quotation,purchase order, and requisition numbers:
Automatic: Purchasing automatically assigns a unique sequentialnumber to each document when you create the document.
Manual:You provide a document number manually when you enter the document.
Important: You can change the method of entering document numbers at any time. If you originally allow manual entry and
switch to automatic entry, make sure to enter a Next Number that is higher than the highest number you assigned manually.
38. Number Type :
Select the [Document] Number Type you want Purchasing to use for RFQ, quotation,purchase order, and requisition numbers: Numeric
or Alphanumeric.
Important: If you choose Automatic document number entry, you can generate only numeric document numbers, but you can still
import either numeric or alphanumeric values from anotherpurchasing system.
Important: If you import purchasing documents from a foreign systemthat references alphanumeric numbers, you must choose
Alphanumeric as your number type, regardless of your numbering method.
If you choose Manualdocument number entry, you can choose numeric or alphanumeric numbers. You can change the document
number type from Numeric to Alphanumeric whenever you want. You can change the document number type from Alphanumeric to
Numeric only if all your current document numbers are numeric.
Important: The ordering of numeric values in lists of values can appear random when you use the Alphanumeric number type. If you
are using Alphanumeric numbering, considerentering all numeric values with the same number of digits. For example, if you can
assume all numeric values contain six digits, you should enter the first value as 000001.
Important: You should setup the numbering type to be the same in all operating units in which you are planning to create and enable
global agreements.
39. Enter the Next Number.](https://image.slidesharecdn.com/elshayeboracler12purchasing-141118065305-conversion-gate02/85/Oracle-Purchasing-R12-Setup-Steps-44-320.jpg)
![33. Notice the value in the Released field is $360 – the amount of your first release.
34. What would happen to this value if you issue another release with a value of $1,800?
Run the Purchase Order and Releases Detail Report
35. Navigate to the Submit Request window
(N) Reports > Run
Choose Single Request
Name = Purchase Order and Releases Detail Report
Or Purchase Order and Releases Detail Report (XML)
Operating Unit = Vision Operations
Purchase Order Numbers From = 20140010
[Purchase Order Numbers] To = 20140010
36. (B) OK
37. (B) Submit](https://image.slidesharecdn.com/elshayeboracler12purchasing-141118065305-conversion-gate02/85/Oracle-Purchasing-R12-Setup-Steps-201-320.jpg)
![• SBI Buying Company Identifier is a unique code for the operating unit. This is defined as a Purchasing Option and need not be unique.
• Selling Company Identifier is a code for the supplier site. It is defined in the supplier site window.
The Selling Company Identifier does not need to be unique within the same supplier; however, it must be unique across suppliers.
• Invoice Type Code:
• ERS (Evaluated Receipt Settlement) for Pay on Receipt invoices
• RTS (Return to Supplier) for Debit Memos
• PPA (Purchase Price Adjustment) for invoices resulting from a retroactive price adjustment
• Seq# is a gapless sequence numberdefined for each buying company/selling company/invoice type combination when Gapless
Invoice Numbering is enabled.
All segments of the gapless invoice number are separated with a hyphen.
10. The PO Output Format
Selection defines the output format for purchase orders sent to the supplier using print, e-mail, or fax. It also enables functionality
related to that output format. Setting Up 1-37
PDF: Purchase orders are output in the Adobe Portable Document Format (PDF).
You can view the purchase order fully formatted from the Enter Purchase Order window, Purchase Order Summary window, Change
History page, Oracle iProcurement, and Oracle iSupplier Portal.
You can also communicate the purchase order to the supplier from the Purchase Order Summary window.
Text: Purchase orders are output in text.
Note: Your ability to communicate the purchase order to the supplier from the Approval window remains the same with either setting.
Only the formatting of the output changes.
See: Setup Purchase Order Communication to Suppliers, page 1-75
11. Ifthe PO Output format is PDF,
Enter the Maximum Attachment Size. This indicates the maximum file size, in megabytes, that is allowed as a File type attachment to
an e-mailed purchase order.
See: About Attachments, Oracle ApplicationsUser's Guide.
12. Select Enforce Price Tolerance Percentage
If you want Purchasing to enforce the price tolerance percentage.
13. Select Enforce Price Tolerance Amount
If you want Purchasing to enforce the price tolerance amount.
14. Select Display Disposition Messages
If you want to see any disposition messages defined against inventory items when they are placed on requisitions.
15. Select Notify IfBlanket PO Exists
If you want to be notified of existing blanket purchase agreements when you create a requisition, purchase order, or blanket
purchase agreement line for the item. If you sourced the item, you see the following message: Blanket purchase order [number] already
exists for this item. Your requestors can directly create a release for the blanket purchase agreements instead of creating a requisition or
purchase order if you allow your requestorto enter releases. See: Viewing and Responding to Notifications, page 2-29.
16. AllowItem Description Update
You can define for each item whether you allow updating of the item description during the creation of requisition, RFQ, quotation,or
purchase order lines. This update affects only the line you are creating. Select Allow Item Description Update if you want Yes to be the
initial default of the Allow Description Update attribute when you are defining a new item.
17. Select Enforce Buyer Name
To enforce entry of only your name as the buyer on purchase orders. Otherwise, you can enter the name of any active buyer.
See:Defining Buyers, page 1-20.](https://image.slidesharecdn.com/elshayeboracler12purchasing-141118065305-conversion-gate02/75/Oracle-Purchasing-R12-Setup-Steps-40-2048.jpg)
![26. Enter the Quote Warning Delay.
This is the number of days before a quotation expires that you want to receive an expiration warning. When a quotation is due to
expire within the number of days you provide here, you receive the following message in the Notifications Summary window:
Quotations active or approaching expiration: [number]. See: Viewing and Responding to Notifications, page 2-29.
27. Line Type
Select a default Line Type for requisition, RFQ, quotation,and purchase order lines.
When you create any of these documents,the line type is part of your item information. You can override the line type for each
document line. See: Defining Line Types, page 1-62.
Important: This field is enterable only when the form is accessed from the Purchasing menu.
28. Rate Type
Select the currency Rate Type that defaults on requisitions, purchase orders,RFQs, and quotations.If the Rate Type is User, you can
override this default for each document line. If either your functional currency (defined in yourledger) or your transaction currency (the
currency you enter in a purchasing document window) is Euro (the European Monetary Unit currency), and the other is another
European currency, Purchasing defaults in the appropriate conversion Rate Type, Rate, and Rate Date. See: Defining Conversion Rate
Types,Oracle General Ledger User's Guide.
29. Match Approval Level:
Select one of the following options for Match ApprovalLevel:
Two-Way: Purchase order and invoice quantities must match within tolerance before the corresponding invoice can be paid.
Three-Way: Purchase order, receipt, and invoice quantities must match within tolerance before the corresponding invoice can be paid.
Four-Way: Purchase order, receipt, inspection,and invoice quantities must match within tolerance before the corresponding invoice can
be paid. See: Receiving Controls, Options, and Profiles, page 9-7.
Note: The Invoice Match Option in the purchase order Shipments window and the Match Approval Level here are independent options.
The Invoice Match Option determines whether Payables performs invoice matching to the purchase order or the receipt.
You can perform whichever Invoice Match Option you want on a shipment regardless of the Match Approval Level you choose here.
30. Price Break Type
Select the Price Break Type that defaults on blanket purchase orders:
Cumulative:Price breaks apply to the cumulative quantity on all release shipments for the item.
Non-cumulative:Price breaks apply to quantities on individual release shipments for the item.
31. Price Type
Select the Price Type that defaults on purchase orders.Use the Lookup Codes window to define price types.See: Defining Lookup
Codes, page 1-55.
32. Minimum Release Amount
Enter the Minimum Release Amount that defaults on blanket, contract, and planned purchase orders.This amount is in your functional
currency. See: Overview of Multi-Currency Accounting, Oracle General Ledger User's Guide.](https://image.slidesharecdn.com/elshayeboracler12purchasing-141118065305-conversion-gate02/75/Oracle-Purchasing-R12-Setup-Steps-43-2048.jpg)
![Receipt Accounting Options:
33. Accrue Expense Items
Choose one of the following Accrue Expense Items options:
At Receipt: Accrue expense items upon receipt. You can override this flag in the Shipment Details window when you are entering
purchase orders and releases.
Period End: Accrue expense items at period end.
Important: When using Cash Basis Accounting,you should set this option to Period End, but you will not normally run the Receipt
Accrual - Period End process.
34. For Accrue Inventory Items,you currently have only one choice: On Receipt.
35. Automatic Offset Method
An offset is an accounting entry that is created to offset, or balance, another accounting entry. Automatic Offset Method is the method
used to automatically create the account for the offsetting transaction.Here the offsetting account is the
Receiving Inspection Account,which offsets the Accrual Account transaction at the time of receipt and the Charge Account at the time
of delivery.
The Automatic Offset Method controls which of the two accounts are used as the base account and which as the overlay account,as
well as which segment is used to overlay the base account segment.
Choose one of the following Automatic Offset Method options:
None: No substitutionsare made and the Receiving Inspection account for the destination organization is used.
Balancing:The base account is the Receiving Inspection Account for the destination organization and the balancing segment is overlaid
with the balancing segment of the Charge Account.
Account:The base account is the Charge Account and the account segment is overlaid with the account segment of the Receiving
Inspection Account.
Note: The Automatic Offset Method is not supported with retroactive pricing, shared services, and drop shipment flows.
36. Enter the default Expense AP Accrual Account. 01-000-1340-0000-000
Document Numbering Options
37. Entry method:
Select the [Document] Number Entry method for RFQ, quotation,purchase order, and requisition numbers:
Automatic: Purchasing automatically assigns a unique sequentialnumber to each document when you create the document.
Manual:You provide a document number manually when you enter the document.
Important: You can change the method of entering document numbers at any time. If you originally allow manual entry and
switch to automatic entry, make sure to enter a Next Number that is higher than the highest number you assigned manually.
38. Number Type :
Select the [Document] Number Type you want Purchasing to use for RFQ, quotation,purchase order, and requisition numbers: Numeric
or Alphanumeric.
Important: If you choose Automatic document number entry, you can generate only numeric document numbers, but you can still
import either numeric or alphanumeric values from anotherpurchasing system.
Important: If you import purchasing documents from a foreign systemthat references alphanumeric numbers, you must choose
Alphanumeric as your number type, regardless of your numbering method.
If you choose Manualdocument number entry, you can choose numeric or alphanumeric numbers. You can change the document
number type from Numeric to Alphanumeric whenever you want. You can change the document number type from Alphanumeric to
Numeric only if all your current document numbers are numeric.
Important: The ordering of numeric values in lists of values can appear random when you use the Alphanumeric number type. If you
are using Alphanumeric numbering, considerentering all numeric values with the same number of digits. For example, if you can
assume all numeric values contain six digits, you should enter the first value as 000001.
Important: You should setup the numbering type to be the same in all operating units in which you are planning to create and enable
global agreements.
39. Enter the Next Number.](https://image.slidesharecdn.com/elshayeboracler12purchasing-141118065305-conversion-gate02/75/Oracle-Purchasing-R12-Setup-Steps-44-2048.jpg)
![33. Notice the value in the Released field is $360 – the amount of your first release.
34. What would happen to this value if you issue another release with a value of $1,800?
Run the Purchase Order and Releases Detail Report
35. Navigate to the Submit Request window
(N) Reports > Run
Choose Single Request
Name = Purchase Order and Releases Detail Report
Or Purchase Order and Releases Detail Report (XML)
Operating Unit = Vision Operations
Purchase Order Numbers From = 20140010
[Purchase Order Numbers] To = 20140010
36. (B) OK
37. (B) Submit](https://image.slidesharecdn.com/elshayeboracler12purchasing-141118065305-conversion-gate02/75/Oracle-Purchasing-R12-Setup-Steps-201-2048.jpg)
Uploaded byAhmed Elshayeb
Oracle Purchasing R12 Setup Steps
The document provides instructions for setting up Oracle Purchasing including: 1. Creating users, responsibilities, and defining security and control options 2. Setting up departments, jobs, positions, and employees in Oracle HRMS 3. Associating employees with users and defining buyers, financial options, and purchasing options 4. Defining approval hierarchies, groups, inventory items, locations, and other master data
More Related Content
Similar to Oracle Purchasing R12 Setup Steps
More from Ahmed Elshayeb
Oracle Purchasing R12 Setup Steps
- 1.
- 4. Purchasing Implementation Basic Set-up 1-Creating Users 2- Creating Purchasing Responsibility (For Each OU) 3- Set Profile Option To New Responsibility 4- Adding Responsibility to the Users 5- Defining Department, Jobs & Positions 6- Creating Employees in Oracle HRMS 7- Associating Job &Position with the respective employees in the organization. 8- Associate employee with the User Ids 9- Define Buyers 10- Define Financials Options 11- Define Purchasing Options 12- Define Document Security & Control 13- Defining Approval Hierarchies for Document approval. 14- Defining Approval Groups And Assignments. 15- Controlling Purchasing Periods 16- Define UOM’s & Its Conversions 17- Defining Items in Oracle Inventory. 18- Define Multi-Org Access Control (MOAC)
- 5. Define Locations To EnableEgyptStill AndCurrency Global HRMS ManagerView>Requests>International HRMSSetup Human Resources. LocationAddress
- 6. Num Name Window Prompt ColumnValue Set Required Display Size 10 Country Country COUNTRY PER_TERRITORIES Yes 25 20 Address Address ADDRESS_LINE_1 Yes 50 30 Telephone 1 Telephone 1 TELEPHONE_NUMBER_1 40 Telephone 2 Telephone 2 TELEPHONE_NUMBER_2 50 E-mail 1 E-mail 1 LOC_INFORMATION14
- 7.
- 9. Human Resources. PersonalAddressInformation ToDefine Location
- 11. Define Human ResourcesKey Flexfields (Required) You may not need toset up Human Resources key flexfields if you havealready installed and set up Oracle Human Resource Management Systems or performed a common-applications setup.Refer to the Oracle HRMS Implementation Guide for details. Important: Ifyou are, or will be, fully installingother Oracle applications,be sureto coordinate with thoseproducts' flexfield setup before defining the key flexfields here, as it is not recommended to change flexfields after you acquire any flexfield data. Purchasing: > Setup:> Flexfields:> Key:>Segments 1- Job Flexfield JOB_FLEXFIELD
- 13.
- 15.
- 16. Add Values ToLov. Purchasing: Setup: Flexfields: Key: Values 1-JobSegmentValues =ElshayebJob Engineer- Manager-HelpDesk-OfficeBoy-Accountant-Buyer-General Manager-Operator 2- AddValue ForDepartmentLOV.= ElshayebDepartment Top Management-ITDepartment-StockControl-Purchasing-Production-HumanResources 3- AddValue ForDepartmentLOV.= ElshayebPositions Engineer- Manager-HelpDesk-OfficeBoy-Accountant-Buyer-General Manager-Operator
- 18. Define HR Jobs GlobalHRMS Manager:> Work Structure:>Job:> Description
- 19. Steps For CreatingEmployees in Oracle HRMS 1. Define HR Organization (HR Departments ) 2. Defining Jobs & Positions 3. Associating Job & Position with the Respective Employees in the Organization. 4. Defining Positions Hierarchies 5. Creating Employees in Oracle HRMS 6. Associate employee with the User Account Define Departments as Organizations Global HRMS Manager: Work Structure: Organization: Description Add HR Organization To Organization Classifications To All Department Deified Before In LOV.
- 20. Define HR Position GlobalHRMS Manager: Work Structure: Position: Description - Alter Effective Date To Organization Start Date
- 22. Define Job Grads GlobalHRMS Manager: Work Structure: Grad: Description
- 23. Define Employees Global HRMSManager: People: Enter and Maintain Employee Name Department Name Position Name Limit Value User Name Ahmed Elshayeb Top Management Top Management.General Manager 999999999 A.elshayeb Mohamed Kamal IT Department IT Department.Manager 10000 Ahmed Zakaria IT Department IT Department.Engineer 2000 Saad Osman SH Purchasing Purchasing.Manager 10000 Mohamed Arafa SH Purchasing Purchasing.Accountant 2000 Mostafa Gamal IT Department IT Department.Help Desk 200 Refat Ibrahem SH Production Production.Engineer 2000 Ahmed Mokhtar SH Production Production.Engineer 2000
- 25. Define Position Hierarchy GlobalHRMS Manager: Work Structure: Position: Hierarchy - PR Hierarchy As below Name PR Hierarchy after that go to Position Block and click on F11 to find Position Which will be here Top Management.General Manager after that go to Subordinates to assign
- 26. Click on DownButton to add fill select subordinates from select record as below. Run Position Hierarchy Report To View Hierarchy Definition
- 27. Fill Employee HierarchyProcess Use the Fill Employee Hierarchy process to create a direct mapping between the defined position hierarchies and the employees holding positions in each hierarchy. When you run this process,it checks each position hierarchy and updates each employee, his supervisor,the level o f supervision (a direct supervisoris level 1), the employee's position,and the supervisor's position. The process creates an error log which lists all positions to which no employee is assigned,but having such positions is a b enign error that does not hamper systemoperation. If you do not use hierarchical security for any of yourdocuments and do not use position hierarchies for your approvals, you do not need to run this process.Otherwise, you must run this process before any of the following changes can take effect: • add or delete an employee • change an employee name or an employee position. See: Enter Person, Oracle HRMS Enterprise and Workforce Management Guide. • add, delete, or modify a position. See: Representing Jobs and Positions, . • add, delete, or modify a position hierarchy. See: Representing Jobs and Positions, Oracle HRMS Enterprise and Workforce Management Guide. To run the Fill Employee Hierarchy process: 1. Navigate to the Submit Requests window. 2. Select Requests in the first field. 3. Select Fill Employee Hierarchy in the Name field. 4. Choose Submit to begin the process. Run Request := Fill Employee Hierarchy Every Time You Add Employee Or Changing His Position 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 Run the Fill Employee Hierarchy process 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
- 29.
- 31.
- 32. Define InventoryOrganizationSH1 Define InventoryOrganizationSH2 DefineYourOwn PurchasingResponsibilitysame As PurchasingSuperUser
- 33. Profile Option ForNew Responsibility Profile OptionName Value HR: SecurityProfile VisionCorporation HR:BusinessGroup VisionCorporation HR:User Type HR withPayroll User MO: DefaultOperatingUnit SH OU MO: OperatingUnit SH OU MO: SecurityProfile VisionCorporation GL LedgerName VisionOperations(USA) INV:Override NegforBackflush NO TP:INV Transactionprocessingmode online
- 34. Run Request== ReplicateSeedData SystemAdministrator>Requests
- 35. Define Financials OptionsFor SH OU Use the Financials Options window to define the options and defaults that you use for your Oracle Financial Application(s). Values you enter in this window are shared by Oracle Payables, Oracle Purchasing, and Oracle Assets.You can define defaults in this window to simplify supplier entry, requisition entry, purchase order entry, invoice entry, and automatic payments.Depending on your application, you may not be required to enter all fields. Although you only need to define these options and defaults once,you can update themat any time. If you change an option and it is used as a default value elsewhere in the system, it will only be used as a default for subsequent transactions.For example, if you change the Payment Terms from Immediate to Net 30, Net 30 will be used as a default for any new suppliers you enter, but the change will not affect the Payment Terms of existing suppliers. Attention Oracle Payables Users: You are required to enter defaults for the Accounting Financials Options in the Accounting region. If you do not use encumbrance accounting or budgetary control, you do not need to enter defaults in the Encumbrance region. If you do not also have Oracle Purchasing installed, you do not need to enter defaults in the Supplier- Purchasing region. If you do not have Oracle Human Resources installed, you are not required to enter defaults in the Human Resources region. If your enterprise does not need to record a VAT registration number, you don't need to enter defaults in the Tax region. To see the default hierarchy for Payables review the Account Default Hierarchy Define the following financial options in the Financial Options window; Attention Oracle Purchasing Users: If Purchasing is the only Oracle application installed at your site, you are only required to enter information in the following regions: Accounting and Supplier Purchasing. Attention Oracle Assets Users: If Oracle Assets is the only product you use,you are only required to enter information in the following regions: Supplier, Human Resources, and Accounting.Attention Encumbrance Accounting Users: If you use encumbrance accounting,and you have Oracle Payables,Oracle Purchasing, and Oracle General Ledger installed, define your encumbrance options in the Encumbrance Financials Options region. See: Defining Encumbrance Types, Oracle General Ledger User's Guide. See: Defining Financials Options, Oracle PayablesUser's Guide (Required): • Employee numbering • Position approval hierarchies option (whether to use position approval hierarchies) • Inventory organization • Business group (Make sure a business group is specified.) • Supplier numbering Accounting Financials Options Future Periods. Payables displays the number of future periods you use in your ledger. Payables uses this value to limit the number of future periods you can maintain in the Control Payables Periods window. You can enter invoices in future periods. GL Accounts Liability. Payables assigns this account as the default Liability Account for all new suppliers you enter. You can override this value during supplier entry. If you use Accrual Basis accounting, then the Liability Account for an invoice determines the liability account(s)charged when you create accounting entries for invoices. Prepayment. The Prepayment account and description for a supplier site's invoices. The Financials option value defaults to new suppliers, and the supplier value defaults to new supplier sites. For more information see: Accounting for Prepayments, Oracle Payables User's Guide. Future Dated Payment. If you use future dated payments, then enter a value for Future Dated Payment account. This value defaults to all new suppliers and new bank accounts. The supplier value defaults to all new supplier sites.
- 36. The bank accountvalue defaults to new payment documents. When Payables accounts for future dated payments, it uses the Future Dated Payment Account from either the supplier site or the payment document, depending on the option you select in the Payment Accounting region of the Payables Options window. If you relieve liability payment time, this should be an asset account. If you relieve liability at future dated payment maturity, then this should be a liability account. Discount Taken. If you choose to distribute your discounts to the systemDiscount Taken Account,Payables uses this account to record the discounts you take on payments. Use the Payables Options window to select your method for distributing discounts foryour invoices. PO Rate Variance Gain/Loss. Payables uses these accounts to record the exchange rate variance gains/losses foryour inventory items. The variance is calculated between the invoice and either the purchase order or the receipt, depending on how you matched the invoice. These accounts are not used to record variances for yourexpense items. Any exchange rate variance for your expense items is recorded to the charge account of the purchase order. Payables calculates these amounts during Payables Invoice Validation. Expenses Clearing. This account is optional when you use the Company Pay payment option of Oracle Internet Expenses. Payables uses this as a temporary account to record credit card transaction activity. Payables debits this account when you create an invoice to pay a credit card issuerfor credit card transactions.Payables credits this account with offsets to the original debit entries when an employee expense report entered in Internet Expenses that has credit card transactions on it. If you enter an expenses clearing account in this field and in the Expenses Clearing Account field of the Card Programs window, the account entered in the Expenses Clearing Account field of the Card Programs window takes precedence. See: Expenses Clearing Account,page 3-6 Miscellaneous. Used only when importing invoices submitted in XML Gateway. If you enter a value here then the systemuses this account for all Miscellaneous charges on invoices your suppliers enter in iSupplier Portal. If you do not enter a value here then the systemprorates Miscellaneous charges across Item lines on iSupplier Portal invoices. The systemalso uses this value for any miscellaneous charges your suppliers send in XML invoices. If you do not enter a value here then import prorates miscellaneous charges across Item lines for XML invoices. Retainage: Used for the amounts or percentages of payments that are withheld until work under a contract is completed and accepted. GL Account Account Number Liability 01-000-2210-0000-000 Prepayment 01-000-1340-0000-000 Bills Payable 01-000-2580-0000-000 Discount Taken 01-740-7825-0000-000 PO Rate Variance Gain 01-740-7842-0000-000 PO Rate Variance Loss 01-740-7844-0000-000 Supplier - Purchasing Financials Options The options you define in this region, except for Inventory Organization, are used as default values for the Purchasing region of the Suppliers window. The supplier values default to new supplier sites for the supplier, which default to new purchasing documents for the supplier site. Note: If you use the Multiple Organizations Support feature, values you enter in this window will default to both the Supplier and Supplier Site. You can override defaulted values during entry of the supplier, supplier site, and purchasing documents. RFQ Only Site. Default value for all new suppliers. You cannot create purchase orders in Purchasing for a supplier site which is an RFQ Only Site. Ship-To and Bill-To Location. The name of the ship-to and bill-to location for the systemdefault values. If the name you want does not appear in the list of values,use the Location window to enter a new location. See also: Setting Up Locations, Oracle Human Resources Management Systems Enterprise and Workforce Management Guide. Inventory Organization.
- 37. You need tochoose an inventory organization if you use Purchasing. You can associate each of your Purchasing operating units with one Inventory item master organization. When you associate yourPurchasing operating unit with an inventory organization, items you define in this organization become available in Purchasing. You can only choose an inventory organization that uses the same ledger as your Purchasing operating unit. Do not change the Inventory Organization after you have already assigned one to Purchasing. Ship Via. Freight carrier you use with suppliers.If the type of freight carrier you want does not appear in the list of values, use the Freight Carriers window to define a new shipping method. The value you enter here is the value in the Description field of the Freight Carriers window in Purchasing. FOB. If the type of FOB you want is not in the list of values,use the Oracle Purchasing Lookups window to define a new FOB. Freight Terms. The freight terms for a supplier identify whether you or your supplier pays for freight charges on goods you receive. You can define new freight terms in the Oracle Purchasing Lookups window. Human Resources Financials Options Use this region to enter the options and defaults for entering employee information in the Enter Person window. Business Group. Enter the name of the business group that you want to associate with Purchasing. If you use Purchasing jointly with Oracle Human Resources,you must reference the business group that you define in Oracle Human Resources. If you use Purchasing without Human Resources, you can use the default value. The default for this field is the Human Resources default of Setup Business Group. The business group determines which employees you can use in Purchasing. In Purchasing, you can see only the employees in this business group. Expense Reimbursement Address. Select the default address you want to use on payments for employee expense reports: Home or Office. The systemuses this default for each new employee you enter. You can override this default during employee entry or expense report entry. Use Approval Hierarchies. Enable this option to use positions and position hierarchies to determine approval paths for your documents within Purchasing. Disable this option of you want approval paths based on the supervisorstructure. Employee Numbering Method. You can enter your employee numbers manually or let the systemgenerate sequential employee numbers. The systemprevents you from entering a value in this field if you install Oracle Human Resources or Oracle Payroll. You can change the numbering method at any time. • Automatic. The systemautomatically assigns a unique sequentialnumber to each employee when you enter a new employee. • Manual. You enter the employee number when you enter an employee. • Use National Identifier Number. The systemautomatically enters the employee's National Identifier Number as the employee number. For example, a Social Security number for a United States employee. ***Important: Be careful if you switch from manual to automatic entry. The employee number must be unique. When you use manual entry, you can assign any number and in any order. If you switch to automatic after having entered employee numbers manually, the systemmay try to assign a number that you already assigned.If you switch from manual to automatic entry, make sure the next available number for automatic entry is larger than the largest number you have already recorded. Next Automatic Number. If you select the Automatic Employee Numbering method, enter the starting value you want the systemto use for generating unique sequential employee numbers. After you enter a number and save your changes,the system displays the number that it will assign to the next new employee you enter.
- 38. Define Purchasing Options:For Operating Unit SH OU SH Purchasing Supper User : Setup: Organizations: Purchasing Options Use the Purchasing Options window to define default values and controls for functions throughout Purchasing. You can often override purchasing options when you are creating documents. You can define specific categories of options: • Document Control Define control options, such as the receipt close point. • Document Defaults Define default options, such as the minimum release amount. • Receipt Accounting Define the accrualmethod and the accounts which Purchasing will use as for receipt accounting. • Document Numbering Define the numbering method, numbering type, and next number for each of your documents. To define Purchasing Options: 1. Navigate to the Purchasing Options window. 2. Select the Purchasing Options Operating Unit. Document Control Options 3. Enter the Price Tolerance Percentage. This is the percentage by which the auto created purchase order line price cannot exceed the requisition line price. If you select Enforce Price Tolerance Percentage,you can create,but not approve, purchase orders for which this tolerance is exceeded. There is no restriction on how much a price can decrease,but changes to the line (quantity or unit of measure for example) may cause the price tolerances to be exceeded. Note: If the price on a requisition line is zero, then price tolerance checks do not apply. 4. Enter the Price Tolerance Amount. This is the dollar amount by which the Auto created purchase order line price cannot exceed the requisition line price. Note:If you set both price tolerance percentage and amount values, the systemwill apply the more restrictive of the two. 5. Select one ofthe following values for the Enforce Full Lot Quantity option: None: The requisition quantity is not rounded to the lot quantity. Automatic: The requisition quantity is forced to the rounded quantity. Advisory: An advisory message suggesting rounding and a suggested rounding quantity are displayed,but you can override. Enforce Full Lot Quantity is used for rounding quantities on Internal Requisitions,
- 39. For example: • SystemOptions Enforce Full Lot Quantities = Yes • Items Rounding Factor = 75% • Items Unit of Issue = DZ • Unit of Measure on Internal Requisition = Each If the userenters 6 Each on the Internal Requisition, the quantity will be rounding to 0. If the user enters 11 Each on the Internal Requisition, the quantity will be rounded to 12 Each. See: Overview of Requisitions, page 3-1. 6. Select the Receipt Close Point, which is when the shipment is closed for receiving: Accepted (passed inspection),Delivered, or Received. Note: that you need to set the receipt close tolerance percentage in the Default Options window. 7. The Cancel Requisitions options apply only to requisitions from which purchase orders were auto created. Select one of the following: Always: When canceling the purchase order, Purchasing also cancels the requisition. Never: When canceling the purchase order, Purchasing does not cancel the requisition, so it is again available for inclusion on a purchase order. Optional:When canceling the purchase order, you are given the option to cancel the requisition. 8. Select a Security Hierarchy, which is a position hierarchy from the Position Hierarchy window. When the Security Level is set to Hierarchy for a document in the Document Controls window, this position hierarchy governs access security for the document. Important: This field is enterable only when the form is accessed from the Purchasing menu. 9. If you have Selected Gapless Invoice Numbering forthe entire business unit or for a specific supplier site, enter the SBI Buying Company Identifier. This is an identifier included in the invoice number created by the Pay on Receipt process,as well as for debit memos resulting from return receipts, and invoices resulting from retroactive purchase price adjustments. This portion of the invoice number identifies the buying business unit and is included as follows: <Prefix>-<SBI Buying Company Identifier>-<Selling Company Identifier>-<Invoice Type Code>-<Seq #> Where: • Prefix is specified by the profile option PO: ERS Invoice Number Prefix. (optional) and only applies to invoices resulting from the Payment on Receipt process. See: Profile Options in Purchasing, page C-1. See: Payment on Receipt, page13-16.
- 40. • SBI BuyingCompany Identifier is a unique code for the operating unit. This is defined as a Purchasing Option and need not be unique. • Selling Company Identifier is a code for the supplier site. It is defined in the supplier site window. The Selling Company Identifier does not need to be unique within the same supplier; however, it must be unique across suppliers. • Invoice Type Code: • ERS (Evaluated Receipt Settlement) for Pay on Receipt invoices • RTS (Return to Supplier) for Debit Memos • PPA (Purchase Price Adjustment) for invoices resulting from a retroactive price adjustment • Seq# is a gapless sequence numberdefined for each buying company/selling company/invoice type combination when Gapless Invoice Numbering is enabled. All segments of the gapless invoice number are separated with a hyphen. 10. The PO Output Format Selection defines the output format for purchase orders sent to the supplier using print, e-mail, or fax. It also enables functionality related to that output format. Setting Up 1-37 PDF: Purchase orders are output in the Adobe Portable Document Format (PDF). You can view the purchase order fully formatted from the Enter Purchase Order window, Purchase Order Summary window, Change History page, Oracle iProcurement, and Oracle iSupplier Portal. You can also communicate the purchase order to the supplier from the Purchase Order Summary window. Text: Purchase orders are output in text. Note: Your ability to communicate the purchase order to the supplier from the Approval window remains the same with either setting. Only the formatting of the output changes. See: Setup Purchase Order Communication to Suppliers, page 1-75 11. Ifthe PO Output format is PDF, Enter the Maximum Attachment Size. This indicates the maximum file size, in megabytes, that is allowed as a File type attachment to an e-mailed purchase order. See: About Attachments, Oracle ApplicationsUser's Guide. 12. Select Enforce Price Tolerance Percentage If you want Purchasing to enforce the price tolerance percentage. 13. Select Enforce Price Tolerance Amount If you want Purchasing to enforce the price tolerance amount. 14. Select Display Disposition Messages If you want to see any disposition messages defined against inventory items when they are placed on requisitions. 15. Select Notify IfBlanket PO Exists If you want to be notified of existing blanket purchase agreements when you create a requisition, purchase order, or blanket purchase agreement line for the item. If you sourced the item, you see the following message: Blanket purchase order [number] already exists for this item. Your requestors can directly create a release for the blanket purchase agreements instead of creating a requisition or purchase order if you allow your requestorto enter releases. See: Viewing and Responding to Notifications, page 2-29. 16. AllowItem Description Update You can define for each item whether you allow updating of the item description during the creation of requisition, RFQ, quotation,or purchase order lines. This update affects only the line you are creating. Select Allow Item Description Update if you want Yes to be the initial default of the Allow Description Update attribute when you are defining a new item. 17. Select Enforce Buyer Name To enforce entry of only your name as the buyer on purchase orders. Otherwise, you can enter the name of any active buyer. See:Defining Buyers, page 1-20.
- 41. 18. Select EnforceSupplier Hold If you do not want to be able to approve purchase orders created with suppliers that are on hold. Use the Suppliers window to place suppliers on hold. See: Suppliers, Oracle iSupplierPortal Implementation Guide. Note: Even if you put a supplier on hold in the Suppliers window, you can still approve a purchase order to that supplier if Enforce Supplier Hold is not checked here. 19. Select GaplessInvoice Numbering To enable gapless (no breaks in numbering) invoice number generation for yourbuying organization during Pay on Receipt processing.See: Payment on Receipt, page 13-16. Note: that you can enable gapless SBI numbering for the entire operating unit with this setting or limit it to a supplier site(s) in the Supplier Site window. 20. Select RFQ Required To require an RFQ for an item before you can auto create the corresponding requisition line onto a purchase order. You can override this value for each item or requisition line.
- 42. Document Default Options 21.Requisition Import Group By , Select one of the following Requisition Import Group By options for requisitions imported through the requisition open interface: All (not grouped), Buyer, Category, Item, Location, or Supplier. See: Requisition Import Process, page 13-29. • All: Group all requisition lines on one requisition • Buyer: Group requisition lines for each buyername on a separate requisition • Category:Group requisition lines for each purchasing category on a separate requisition • Item: Group requisition lines for each item on a separate requisition • Location:Group requisition lines for each location on a separate requisition • Supplier:Group requisition lines for each supplier name on a separate requisition 22. Select the default Order Type for internal requisitions. Important: The Order Type field is visible only if the application Oracle Order Management is installed. Order types are defined in Order Management. The order type you choose here is the type that Purchasing uses to create sales orders from internal requisitions. 23. Select the default Order Source for internal requisitions. Purchasing defaults and only uses Internal. This is the source Order Import uses to transfer internal requisitions from Purchasing to Order Management. 24. Receipt Close Tolerance (%) Enter the Receipt Close tolerance percentage for your shipments.Purchasing automatically closes a shipment for receiving if it is within the receiving close tolerance at the receiving close point. Set the receiving close point in the Control Options window. You can override this option for specific items and orders. See: Defining Control Options, page 1-34. 25. Enter the Invoice Close tolerance Percentage for shipments. Purchasing automatically closes a shipment for invoicing if it is within the invoicing close tolerance at billing, when Payables matches invoices to purchase orders or receipts. You can override this option for specific items and orders. See: Defining Control
- 43. 26. Enter theQuote Warning Delay. This is the number of days before a quotation expires that you want to receive an expiration warning. When a quotation is due to expire within the number of days you provide here, you receive the following message in the Notifications Summary window: Quotations active or approaching expiration: [number]. See: Viewing and Responding to Notifications, page 2-29. 27. Line Type Select a default Line Type for requisition, RFQ, quotation,and purchase order lines. When you create any of these documents,the line type is part of your item information. You can override the line type for each document line. See: Defining Line Types, page 1-62. Important: This field is enterable only when the form is accessed from the Purchasing menu. 28. Rate Type Select the currency Rate Type that defaults on requisitions, purchase orders,RFQs, and quotations.If the Rate Type is User, you can override this default for each document line. If either your functional currency (defined in yourledger) or your transaction currency (the currency you enter in a purchasing document window) is Euro (the European Monetary Unit currency), and the other is another European currency, Purchasing defaults in the appropriate conversion Rate Type, Rate, and Rate Date. See: Defining Conversion Rate Types,Oracle General Ledger User's Guide. 29. Match Approval Level: Select one of the following options for Match ApprovalLevel: Two-Way: Purchase order and invoice quantities must match within tolerance before the corresponding invoice can be paid. Three-Way: Purchase order, receipt, and invoice quantities must match within tolerance before the corresponding invoice can be paid. Four-Way: Purchase order, receipt, inspection,and invoice quantities must match within tolerance before the corresponding invoice can be paid. See: Receiving Controls, Options, and Profiles, page 9-7. Note: The Invoice Match Option in the purchase order Shipments window and the Match Approval Level here are independent options. The Invoice Match Option determines whether Payables performs invoice matching to the purchase order or the receipt. You can perform whichever Invoice Match Option you want on a shipment regardless of the Match Approval Level you choose here. 30. Price Break Type Select the Price Break Type that defaults on blanket purchase orders: Cumulative:Price breaks apply to the cumulative quantity on all release shipments for the item. Non-cumulative:Price breaks apply to quantities on individual release shipments for the item. 31. Price Type Select the Price Type that defaults on purchase orders.Use the Lookup Codes window to define price types.See: Defining Lookup Codes, page 1-55. 32. Minimum Release Amount Enter the Minimum Release Amount that defaults on blanket, contract, and planned purchase orders.This amount is in your functional currency. See: Overview of Multi-Currency Accounting, Oracle General Ledger User's Guide.
- 44. Receipt Accounting Options: 33.Accrue Expense Items Choose one of the following Accrue Expense Items options: At Receipt: Accrue expense items upon receipt. You can override this flag in the Shipment Details window when you are entering purchase orders and releases. Period End: Accrue expense items at period end. Important: When using Cash Basis Accounting,you should set this option to Period End, but you will not normally run the Receipt Accrual - Period End process. 34. For Accrue Inventory Items,you currently have only one choice: On Receipt. 35. Automatic Offset Method An offset is an accounting entry that is created to offset, or balance, another accounting entry. Automatic Offset Method is the method used to automatically create the account for the offsetting transaction.Here the offsetting account is the Receiving Inspection Account,which offsets the Accrual Account transaction at the time of receipt and the Charge Account at the time of delivery. The Automatic Offset Method controls which of the two accounts are used as the base account and which as the overlay account,as well as which segment is used to overlay the base account segment. Choose one of the following Automatic Offset Method options: None: No substitutionsare made and the Receiving Inspection account for the destination organization is used. Balancing:The base account is the Receiving Inspection Account for the destination organization and the balancing segment is overlaid with the balancing segment of the Charge Account. Account:The base account is the Charge Account and the account segment is overlaid with the account segment of the Receiving Inspection Account. Note: The Automatic Offset Method is not supported with retroactive pricing, shared services, and drop shipment flows. 36. Enter the default Expense AP Accrual Account. 01-000-1340-0000-000 Document Numbering Options 37. Entry method: Select the [Document] Number Entry method for RFQ, quotation,purchase order, and requisition numbers: Automatic: Purchasing automatically assigns a unique sequentialnumber to each document when you create the document. Manual:You provide a document number manually when you enter the document. Important: You can change the method of entering document numbers at any time. If you originally allow manual entry and switch to automatic entry, make sure to enter a Next Number that is higher than the highest number you assigned manually. 38. Number Type : Select the [Document] Number Type you want Purchasing to use for RFQ, quotation,purchase order, and requisition numbers: Numeric or Alphanumeric. Important: If you choose Automatic document number entry, you can generate only numeric document numbers, but you can still import either numeric or alphanumeric values from anotherpurchasing system. Important: If you import purchasing documents from a foreign systemthat references alphanumeric numbers, you must choose Alphanumeric as your number type, regardless of your numbering method. If you choose Manualdocument number entry, you can choose numeric or alphanumeric numbers. You can change the document number type from Numeric to Alphanumeric whenever you want. You can change the document number type from Alphanumeric to Numeric only if all your current document numbers are numeric. Important: The ordering of numeric values in lists of values can appear random when you use the Alphanumeric number type. If you are using Alphanumeric numbering, considerentering all numeric values with the same number of digits. For example, if you can assume all numeric values contain six digits, you should enter the first value as 000001. Important: You should setup the numbering type to be the same in all operating units in which you are planning to create and enable global agreements. 39. Enter the Next Number.
- 45. This is thestarting value you want Purchasing to use for generating unique sequentialdocument numbers if you choose Automatic document number entry. Purchasing displays the next document number that will be used for a new document when you create the new document. You cannot enter this field if you choose Manualdocument number entry. If you use MasterScheduling/MRP, Inventory, Work in Process, or any non-Oracle systemto create requisitions automatically, you must also let Purchasing number the corresponding requisitions automatically. 40.Click Save.
- 46. Defining Receiving Options Inventory: > Setup: > Organizations: > Organizations Use the Receiving Options window to define options that govern receipts in your system. Most of the options that you set here can be overridden for specific suppliers, items, and purchase orders. See: Receiving Controls, Options, and Profiles, page 9-7. To Define Receiving Options: 1. Navigate to the Receiving Options window. 2. Select your Inventory Organization.
- 48. Receiving Options 3. EnforceShip To Enter the Enforce Ship To location option to determine whether the receiving location must be the same as the ship-to location. Choose one of the following options: None - The receiving location may differ from the ship-to location. Reject - Purchasing does not permit receipts when the receiving location differs from the ship-to location. Warning - Purchasing displays a warning message but permits receipts when the receiving location differs from the ship-to location. 4. Advance Shipment Notice (ASN) Control Action Choose an action for ASN Control. This field determines how Purchasing handles receiving against purchase order shipments for which an Advance Shipment Notice (ASN) exists. Choose one of the following options. None - Purchasing does not prevent or warn you when you try to receive against a purchase order shipment for which an ASN exists. Reject - Purchasing gives you a message and prevents you from receiving against a purchase order shipment for which an ASN exists. Warning - Purchasing gives you a message informing you that an ASN exists for the purchase order shipment and lets you decide whether to receive against the purchase order shipment or its ASN. 5. Days Early and Days Late for receipts : Enter the maximum acceptable number of Days Early and Days Late for receipts. 6. Days Exceed-Action : Enter an action for Receipt Days Exceed-Action. This field determines how Purchasing handles receipts that are earlier or later than the allowed number of days selected above. Choose one of the following options: None - Receipts may exceed the allowed days early or late. Reject - Purchasing does not permit receipts outside the selected number of days early or late. Warning - Purchasing displays a warning message but permits receipts outside the selected number of days early or late. 7. Over Receipt Tolerance : Enter the maximum acceptable Over Receipt Tolerance percentage. 8. Over Receipt Action : Enter the Action for Over Receipt Action. This field determines how Purchasing handles receipts that exceed the quantity received tolerance. Choose one of the following options: None - Receipts may exceed the selected tolerance. Reject - Purchasing does not permit receipts that exceed the selected tolerance. Warning - Purchasing displays a warning message but permits receipts that exceed the selected tolerance. 9. Enter the default RMA Receipt Routing that you assign goods:Direct Delivery, Standard Receipt, or Inspection Required. 10. Enter the default Receipt Routing that you assign goods: Direct Delivery, Standard Receipt, or Inspection Required. You can override this option at receipt time by changing the destination type for specific suppliers, items, and orders if the RCV: Allow Routing Override userprofile is set to Yes. See: Profile Options in Purchasing, page C-1. 11. Check Allow Substitute Receipts if you want to receive substitute items in place of ordered items. You must define substitute items in the Item Relationships window before you can receive them. You can override this option for specific suppliers, items, and orders. See: Defining Item Relationships, Oracle Inventory User's Guide.
- 49. 12. Check AllowUnordered Receipts if you want to receive unordered items. You can later match the unordered receipts to a purchase order. If you enable this option, you can override it for specific suppliers and items. 13. Check Allow Express Transactions to enable express deliveries and receipts. See: Express Receipts and Receiving Transactions,page 9-23. 14. Check Allow Cascade Transactions to enable cascading for receipts and receiving transactions.See: Cascading Receipts and Receiving Transactions 15. Select Allow Blind Receiving: If you want blind receiving at yoursite. Blind receiving helps you ensure that receivers record the exact amount they receive. With blind receiving, you cannot see the quantity due or the quantity ordered for shipments when you receive items. Purchasing ignores all quantity receipt tolerances to help ensure that you can receive the exact amount the supplier shipped. 16. Select Validate Serial Numbers on RMA Receipts if you want serial numbers validated. Restricts serial numbers displayed in the list of serial numbers for an RMA line. 17. Choose the Receipt Number Generation method for receipt numbers Automatic: Purchasing automatically assigns a unique sequentialnumber to each receipt when you create the receipt. Manual:You provide a receipt number manually when you enter the receipt. Purchasing numbers receipts within inventory organizations rather than across inventory organizations. So, for example, the same receipt number could be used by different inventory organizations. Important: You can change the method of entering receipt numbers at any time. If you originally allow manual entry and switch to automatic entry, make sure to entera Next Number that is higher than the highest number you assigned manually. 18. Choose the Receipt Number Type you want Purchasing to use for receipt numbers: Numeric or Alphanumeric. Important: If you choose Automatic receipt number entry, you can generate only numeric receipt numbers, but you can still import either numeric or alphanumeric values from anotherpurchasing system. Important: If you have any alphanumeric documents in your system, you must choose Alphanumeric as your number type, regardless of your numbering method. If you choose Manualreceipt number entry, you can choose numeric or alphanumeric numbers. You can change the receipt number type from Numeric to Alphanumeric whenever you want. You can change the receipt number type from Alphanumeric to Numeric only if all your current receipt numbers are numeric. Important: The ordering of numeric values in lists of values can appear random when you use the Alphanumeric number type. If you are using Alphanumeric numbering, consider entering all numeric values with the same number of digits. For example, if you can assume all numeric values contain six digits, you should enter the first value as 000001. 19. Enter the Next Receipt Number. This is the starting value you want Purchasing to use for generating unique sequentialreceipt numbers if you choose Automatic receipt number entry. Purchasing displays the next receipt number that will be used for a new receipt when you create the new receipt. You cannot enterthis field if you choose Manualreceipt number entry. Accounting 20. Enter the accounting flexfield for the default Receiving Inventory Account. 21. Enter the account number for the Retroactive Price Adjustment Account. This is the account that receiving will use to post an adjusting entry for changes in pricing after a shipment has been received and accrued. See: Retroactive Price Update on Purchasing Documents, page 13-34. 22. Enter the account number for the Clearing Account.This is the account that is used for intercompany receivables in the procuring organization when the receiving organization is not the same as the procuring organization. CostFactors 23. If you have implemented Oracle Advanced Pricing to calculate cost factors,check Interface to Advanced Pricing. 24. If you have implemented Oracle Transportation Execution to calculate transportation costs,checkInterface to Transportation Execution. 25. Click Save.
- 50. Defining Document Types Usethe Document Types window to define access,security, and control specifications for all Purchasing documents. You cannot enter new document types; you can enter new document subtypes only for RFQs and quotations. Prerequisites Before you use this window to set up yourdocument types,you should perform the following steps: 1 - If you want to be able to choose the document approval hierarchy in this form, you must enable Use ApprovalHierarchies in the Financials Options window. See: Defining Financials Options, Oracle PayablesUser's Guide. 2 - You must use the Position Hierarchy window to create and update the position hierarchies, since Purchasing uses these hierarchies as document approval routings. Refer to 'Representing Jobs and Positions' in your Oracle HRMS documentation set for more information To define document types: 1. Navigate to the Document Types window. Purchasing Super User:Setup: Purchasing: Document Types 2. Select your Operating Unit and click Go 3. Document Type :
- 51. Select a DocumentType from the list and click its icon in the Update column. If yourdocument type is one of Purchase Agreement, Purchase Order, Quotation, Release, Request for Quotation, or Requisition you can update the attributes discussed in the following steps. 4. Check Owner Can Approve : To indicate that document preparers can approve their own documents. This field is not applicable when the Document Type is Quotation or RFQ. Important: If you are using budgetary control and enable this option, you should also enable the Reserve at Requisition Completion option in the Financials Options window. Likewise, if you disable this option, you should also disable the Reserve at Requisition Completion option. 5. Check Approver Can Modify : To indicate that document approvers can modify documents.This field is not applicable when the Document Type is Quotation or RFQ. 6. Check Can Change Forward-To : To indicate that users can change the person the document is forwarded to. This field is not applicable when the Document Type is Quotation or RFQ. For more information on how this and the next two fields affect your approval routing, see: Approval Routing, page 2-10. 7. Check Can Change Approval Hierarchy To indicate that preparers and approvers can change the default approval hierarchy in the Approve Documents window. This field is not applicable when the Document Type is Quotation or RFQ. 8. Check Can Change Forward-From To indicate that preparers can change the name of the document creator. This field is applicable only when the Document Type is Requisition. 9. Document Security You can restrict document access based on the following Security Level options for each document type: Public All systemusers can access thedocument Private Only the document owner and subsequent approvers can access the document Purchasing Only the document owner, subsequent approvers, and individuals defined as buyers can access thedocument Hierarchy Only the document owner, subsequent approvers, and individuals included in the security hierarchy can access the document Within the installation security hierarchy, you can access only those documents that you or your reporting employees own
- 52. Important: You mustdefine one position hierarchy including all positions that require access to the document types you want to control with a Security Level of Hierarchy. You need to specify this hierarchy in the Purchasing Options window before you can choose a Security Level of Hierarchy for a given document type. 15. For Purchase requisitions only, select Use Contract Agreements for Auto Sourcing to require the requisition creation auto sourcing logic to include approved contract purchase agreements. The auto sourcing logic for requisition creation will not considercontract purchase agreements if this box is unchecked, even if you have the profile PO: Automatic Document Sourcing set to Yes. Include Non-Catalog Requests - For Oracle iProcurement only, this checkbox is used in conjunction with the Use Contract Agreements for Auto Sourcing. Select this checkbox to enable the use of contract purchase agreements when auto sourcing non-catalog requisitions. 16. For user-defined quotations and RFQs, Purchasing displays as a default the Security Level of the Standard Quotation or RFQ, and you cannot enter the field. Otherwise, choose one of the following options: • Hierarchy - Only the document owner and users above the owner in the defined purchasing security hierarchy may access these documents. • Private - Only the document owner may access these documents. • Public - Any user may access these documents. • Purchasing - Only the document owner and users listed as buyers in the Define Buyers window may access these documents. For an overview of Security Level and Access Level, see: Document Security and Access,page 2-7. 17. For user-defined quotations and RFQs, The Access Level is that of the Standard Quotation or Standard RFQ, and you cannot enter the field. Otherwise, choose one of the following Access Level options: • Full - Users can view, modify, cancel, and final close documents. • Modify - Users can only view and modify documents. • View Only - Users can only view documents. 18. The Forward Method Field is not applicable when the Document Type is Quotation or RFQ. The following options apply regardless of whether you are using position hierarchies or the employee/supervisor relationship to determine your approval paths.Choose one of the following options: • Direct - The default approveris the first person in the preparer's approval path that has sufficient approval authority. • Hierarchy - The default approver is the next person in the preparer's approval path regardless of whether they have approval authority. (Each person in the approval path must take approval action until the person with sufficient approval authority is reached.) 19. The Archive When field is applicable only when the Document Type is Purchase Agreement, Purchase Order, or Release. Choose one of the following options: • Approve - The document is archived upon approval. This option is the default. The Change Order workflow begins only if this option is chosen.See: Workflow Processes for Approving Change Orders, page E-133. • Communicate - The document is archived upon communication. A document communicate action would be printing, faxing, or e-mail. 20. The Default Hierarchy field is not applicable when the Document Type is Quotation or RFQ. Otherwise, when Use Approval Hierarchies is enabled in the Financial Options window, you can enter a position hierarchy from the Position Hierarchy window. This hierarchy then becomes the default in the Approve Documents window. Approval workflows for specific document types: In Purchasing, all approvals are handled in the background by Oracle Workflow technology. The default approval workflow processes in Purchasing use the approval controls and hierarchies you define according to the setup steps in Setting Up Document Approval and Security, page 2-1. If you created a workflow process of your own and wanted to associate it with a specific document type, you would choose that workflow process here. 1. Select the ApprovalWorkflow you want to use for this particular document type,oruse the default that is already provided. The PO Approval workflow is used for approving purchase orders.The PO Requisition Approvalworkflow is used for approving requisitions. If you've created a workflow of your own, you can select that for this document. See: Approval Workflows, page E-89. 2. Select the Workflow Startup Process you want to use for this particular document type, or use the default that is already provided. Usually the Workflow Startup Process is the highest-level process in a workflow. The default startup process for the PO Approval workflow is the PO ApprovalTop Process. The default startup process for the PO Requisition Approval workflow is the Main Requisition Approval Process. If you've created a startup process ofyour own, you can select that for this document. 3. For requisitions only, select the Approval Transaction Type. If you have implemented Oracle Approvals Management, this selection associates the transaction type with the requisition document type. Leave the field blank to use the standard Oracle Purchasing approval logic.
- 53. See: Oracle iProcurement ImplementationGuide and Oracle ApprovalsManagement Implementation Guide. See: Setting Up Document Approval and Security, page 2-1. 4. For requisitions only, select the Autocreate Workflow you want to use for automatically creating purchase orders or releases from approved requisition lines, or use the default that is provided. The default workflow that comes with Purchasing is the PO Create Documents workflow. If you've created a workflow of your own, you can select that for this document. See: Workflow for Creating Purchase Orders or Releases, page E-161. 5. For requisitions only, select the Autocreate Workflow Startup Process you want to use,or use the default that is already provided. The highest-level process for the PO Create Documents workflow is the Overall Document Creation / Launch ApprovalProcess. If you've created a startup process of your own, you can select that for this document.
- 54. Defining Buyers SH PurchasingSupper User: Setup: Personal: Buyers Use the Buyers window to define and maintain your buyers.Buyers can review all requisitions using the Requisitions window, and only buyers can enter and auto create purchasing documents. See the Document Types window for rules governing access to documents. Prerequisites: Define employees before performing this step. See the online help for the Enter Person window for details. • Define locations before performing this step. To define buyers: 1. Navigate to the Buyers window. SH Purchasing Supper User: Setup: Personal: Buyers 2. If you are defining a new buyer click Add Buyer in the Buyers window. To enter changes to an existing buyer use the Search region to enter the buyer's name in the Buyer field, the category assigned to the buyer in the Category field, or the buyer's ship-to location in the Ship- to field. Once you have completed one or all of these fields click Go. Linkes: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=456687151891182&id=134947.1&displayIndex=3&_afrWindowMode =0&_adf.ctrl-state=h1lji010k_136#aref_section26 3. Enter the Name of an employee who you want to define as a buyer. If the name you want does not appear in the list of values, use the Enter Person window to enter that person as an employee. 4. Enter the default purchasing Category of the goods the buyertypically orders. Purchasing defaults this value in the Category field when you are auto creating documents. See: Defining Categories, Oracle Inventory User's Guide. 5. Enter the name of the ship-to location for which the buyertypically creates purchase orders. Purchasing defaults this value when you are auto creating documents. 6. Enter the Start Date that you want to initiate the responsibilities for a buyer. The default is the current date. 7. Enter the End Date after which the employee is no longer a buyer. 8. Click Save.
- 55. Defining Approval Groups Usethe Approval Groups window to define and update approval groups. Once you have defined an approval group here, you can then use it to assign approval functions to jobs or positions in the Approval Assignments window. You cannot delete an approval group that is used in an active assignment. You can enable or disable the entire approval group, or you can enter inactive dates for individual approval rules. Prerequisites Define employees before performing this step. See the online help for the Enter Person window for details. • Review how your choices in this window affect your approval routing. See: Defining Approval Authorization Rules, page 2-13. To define approval groups: 1. Navigate to the Approval Groups window. SH Purchasing Supper User: Setup: Approvals:Approval Groups 2. Select the Operating Unit for this approval group. 3. Enter the Name of the approval group. You can change existing approval group names, but names must be unique. Approval group names := Approve Until 25000 4. Select Enabled to permit the approval group to be assigned to a position/job in the Approval Assignments window. 5. Choose one of the following Objects: Account Range - (Required) For this option, you enter the accounting flexfields for the Low and High Values. Include Type rules identify accounts that you want to be included on the document. Exclude Type rules identify accounts that you do not want on the document. If you do not enter a rule for an account, the default is to exclude the account.
- 56. If you enteronly an Exclude Type rule, Purchasing does not automatically include everything else. For example, entering only the following account includes account 01.000.0451 and Excludes all else: Account Range Include 01.000.0451 01.000.0451 Entering only the following account Excludes all accounts: Account Range Exclude 01.000.0451 01.000.0451 Entering only the following two accounts includes all accounts except 01.000.0451: Account Range Include 00.000.0000 ZZ.ZZZ.ZZZZ Exclude 01.000.0451 01.000.0451 The Inactive Date is optional, but you must enter an Amount Limit for Include Type rules. Document Total - (Required) The document total refers to the monetary limit on an individual document. For this option, the Type defaults to Include, and you can enter only the Amount Limit (required) and the Inactive Date (optional). Item Category Range - For this option, you enter the purchasing category flexfields for the Low and High Values. Include Type rules identify manufacturing categories that you want to be included on the document. Exclude Type rules identify categories that you do not want on the document. If you do not define a rule for a category, the default is Include. The Inactive Date is optional, but you must enter an Amount Limit for Include Type rules. Item Range - For this option, you enter the item flexfields for the Low and High Values. Include Type rules identify items that you want to be included on the document. Exclude Type rules identify items that you do not want on the document. If you do not define a rule for an item, the default is Include. The Inactive Date is optional, but you must enter an Amount Limit for Include Type rules. Location - The location refers to the deliver-to location on a requisition as well as the ship-to location on purchase orders and releases. Include Type rules identify locations that you want to be included on the document. Exclude Type rules identify locations that you do not want on the document. For this option, you enter the location in the Low Value field. If you do not define a rule for a location, the default is Include. The Inactive Date is optional, but you must enter an Amount Limit for Include Type rules. 6. Select the rule Type: Include or Exclude indicates whether to allow objects that fall within the selected range. 7. Enter the Amount Limit. This is the maximum amount that a control group can authorize for a particular object range. This field is required only for Include type rules. 8. Enter the Low Value. This is the lowest flexfield (accounting, purchasing category, or item) in the range pertinent to this rule. When the object is Location, enter the location. You cannot enter this field when the object is Document Total. 9. Enter the High Value. This is the highest flexfield (accounting, purchasing category, or item) in the range pertinent to this rule. You cannot enter this field when the object is Location or Document Total. 10. Enter the Inactive Date on which Purchasing will no longer use this rule in formulating the group. To Define Unlimited Approval Group. 11. Save your work.
- 57. Item Category WithinPurchasing Approval Rules How INCLUDE And EXCLUDE Rules Work For Item Category Within Purchasing Approval Rules (Doc ID 1285094.1) GOAL To Explain the following detail provided in the Purchasing Users Guide for defining approval rules. Item Category Range - For this option, you enter the purchasing category flexfields for the Low and High Values. Include Type rules identify manufacturing categories that you want to be included on the document. Exclude Type rules identify categories that you do not want on the document. If you do not define a rule for a category, the default is Include. SOLUTION Object Type Amount Limit Low Range High Range Account Range Include 1000 00.000.0000 99.999.9999 Document Total 1000 Item Category Range Include 500 200.000 300.999 Item Category Range Exclude 301.999 302.999 A single line document is raised for a total of 600 with an Item Category of 210.100 With these rules the document is not approved because although the document Item Category is within the INCLUDE range,it is greater than the Amount Limit set for the INCLUDE range,500. A single line document is raised for a total of 600 with an Item Category of 302.555 With these rules the document is not approved because the document Item Category is within the EXCLUDE Item Category range. A single line document is raised for a total of 600 with an Item Category of 100.555 With these rules the document is approved because the document Item Category is not within the EXCLUDE Item Category range and not within the INCLUDE Item Category range that has an Amount Limit of 500. For the Item Category, all can be approved up to the Amount Limit of the Account Range or Document Total or to the Amount Limit of the INCLUDE Item Category if the document Item Category is within the INCLUDE range,unless the document Item Category is within the EXCLUDE range. If the business requirement is that only document Item Category between 200.000 and 300.999 can be approved then the following set up is required: Object Type Amount Limit Low Range High Range Account Range Include 1000 00.000.0000 99.999.9999 Document Total 1000 Item Category Range Include 500 000.000 999.999 Item Category Range Exclude 000.000 199.999 Item Category Range Exclude 301.000 999.999
- 58. Assigning Approval Groups Usethe Assign Approval Groups window to assign approval groups and approval functions to positions or jobs. If you are using approval hierarchies (the Use Approval Hierarchies option in the Financials Options window is enabled), You must first use the Approval Groups window to establish rules for your approval groups. Then you can assign approval groups to positions in this window. When you are not using approval hierarchies, you can use this window to assign approval groups and approval functions to jobs within your organization. To assign approval groups: 1. Navigate to the Assign Approval Groups window. SH Purchasing Supper User: Setup: Approvals: Approval Assignments 2. Select the Operating Unit for this approval group assignment. 3. Enter the Position for which you want to assign approval groups and approval functions.If the Use Approval Hierarchies option in the Financial Options window is not enabled, this field is not applicable. 4. If you are not using approval hierarchies, enter the Job. 5. Select the approval function you want to assign to this position or job. 6. Enter the approval group that you want to assign to the selected position or job. The list of values includes only enabled approval groups with at least one approval rule. See: Defining Approval Groups, page 1-21. 7. Enter the Start Date and End Date for the assignment. Important: The start and end dates that you assign here are the Effectivity dates of the assignment. When the systemdate reaches the end date of the assignment,the rule no longer applies. There is no explicit warning that the rule is no longer in effect. 8. Save your work. Repeat This Steps For The Following Potions
- 59. Employee Name DepartmentName Position Name Limit Value User Name Ahmed Elshayeb Top Management Top Management.General Manager 999999999 A.elshayeb Mohamed Kamal IT Department IT Department.Manager 25000 Ahmed Zakaria IT Department IT Department.Engineer 2000 Saad Osman SH Purchasing Purchasing.Manager 25000 Mohamed Arafa SH Purchasing Purchasing.Accountant 2000 Mostafa Gamal IT Department IT Department.Help Desk 200 Refat Ibrahem SH Production Production.Engineer 2000 Ahmed Mokhtar SH Production Production.Engineer 2000
- 60. Solution - Createa Purchase Requisition PO: Default Need-ByTime PO: Default PO Promise Date from Need By Date PO: Validate Need-by Time For Requisition Submit Log on to the System: User Name Approval Limit Document Type MOHAMED KAMAL 25000 Purchase Requisition Responsibility = SH Purchasing Supper User Create a Purchase Requisition for your Item 1. Open the Requisitions window: (N) Requisitions>Requisitions Operating Unit = Visions Operations Note : Purchase Requisition Don't Need User Set As Buyer 2. Click on the Lines tab. Item = DD-00020-0110-01 Quantity = 10 Need-by = Today’s Date Destination Type = Inventory Organization = SH 1 Location = NY- Workers Comp. Note: After you enter the Need-by date, the Source Details tab is displayed automatically.
- 61. 3. Click onthe Details tab Note to Receiver = Be sure to inspect this item 4. Save 5. Make a note of your requisition number 6. Click the Approve button to approve the requisition
- 62. 7. Select theSubmit for Approval option button 8. OK 9. OK Open Requisition Summary From To Find The Requisition Status
- 63. To Find TheNext Person Requisition Need His Approval To Approve This Requisition Next Person Must Logan (Ahmed Elshayeb) To Approve
- 65. Entering Requisition Preferences Usethe Requisition Preferences window to enter requisition line defaults (including currency, destination,project, and sourcing default information). These defaults are applicable during this user session to all new requisition lines you create after you set the defaults until you exit Purchasing. You can override these defaults for specific lines. To enter main preferences: 1. Navigate to the Requisitions Preferences window by selecting Preferences on the Tools menu in the Requisitions window or in the Requisitions Headers, Lines, and Distributions Summary windows. In the Main tabbed region, you can enter the defaults described in the following steps.
- 66. 2. Enter theNeed By date and time. 3. Enter the GL Date to be used when funds are reserved. You can enter a GL Date only if you set up your financials systemoptions to use encumbrance or budgetary control for requisitions. 4. Enter the Charge Account for the cost of the items on the requisition line. The account you enter here is used only for expense destinations,and it overrides any account built b y the Account Generator. 5. Enter a Justification for your requisition line. Buyers and approvers can review this justification. 6. For Internal requisitions only, enter a Note To Receiver. For example, you could note that the receiver should unpack your requested items or that only you can accept delivery. For both internal and purchase requisitions, you can provide additional notes to the re ceiver by using attachments. 7. Enter the default Reference Number for all requisition lines. You use the reference number to match your requisition line with a specific work, project, etc. 8. Enter the Transaction Nature. See: Defining Lookup Codes, page 1-55. 9. Check Urgent to indicate that your requisition should be expedited. Buyers have the option to process urgent requisitions fasterwhen they AutoCreate purchase orders from requisitions. 10. Enter a default suggested Currency for the requisition lines. This must be an enabled code from the Currency window. 11. Enter the default Rate Type. You can also set this default in the Purchasing Options window. Defining Default Options, page 1-38. Purchasing supplies you with one of two predefined currency rate types:User or EMU Fixed. A rate type of User means that you can enter a conversion rate between the foreign currency (or transaction currency in a document entry window) and the base currency (or functional currency, defined in your ledger). A rate type of EMU Fixed means that if either yourtransaction currency or your functional currency is Euro (the European Monetary Unit currency) and the other is anotherEuropean currency, Purchasing automatically enters a conversion Rate Date and Rate for you that you cannot change. You can define additional currency rate types in the Daily Conversion Rate Types window. 12. Enter the default currency Rate Date. 13. Enter the default currency conversion Rate. Purchasing overrides this default when you are entering requisition lines if the rate type is not User and if you have established a rate for the rate type and date. 14. Enter the Destination Type to indicate the final destination of the purchased items: • Expense - The goods are delivered to the requestorat an expense location. • Inventory - The goods are received into inventory upon delivery. This option is appropriate only if the item is stock enabled in the deliver-to organization. • Shop Floor - The goods are delivered to an outside processing operation defined by Work in Process. This option is appropriate only for outside processing items. If Enterprise Asset Management (EAM) is installed, you can use the shop floor destination for one-time (description based)and non-stocked items to be delivered to a maintenance work order location. You can also reserve or encumber funds for shop floor destination type purchase requisitions and purchase orders associated with EAM work orders. For information, refer to the Encumbrance Accounting section in the Oracle Enterprise Asset Management User's Guide.
- 67. 15. Enter theRequestor. This is the employee who requests the quantities on the requisition lines. Purchasing copies this name as the requestorfor every requisition line. 16. Enter the Organization. The default is the requestor's organization. The List of Values displays all valid receiving organizations. 17. Enter the delivery Location for all requisition lines. The default is the requestor's location. You can pick any location that does not have an organization or any location whose o rganization matches the deliver-to organization. If the Destination Type is Inventory,you can also enter the Subinventory. 18. Enter the Source type: Inventory or Supplier. If you have both options,you can source requisition lines independently of the document type. You can also mix inventory and supplier sourced requisition lines in the same requisition. Purchasing creates one internal sales order for all Inventory source type requisition lines on this requisition. You can use the Autocreate Documents window to place Supplie r source type requisition lines onto purchase orders. For Inventory source type lines, you can enter a default Organization and Subinventory.If you specify a subinventory for an internal requisition line, Order Management reserves the goods and uses only the specified subinventory for allocation. If the goods d o not exist at the specified subinventory,Order Management backorders them, even if they do exist in anothersubinventory. For Supplier source type lines, you can enter the following defaults: Buyer, Note to Buyer, Supplier, Site, Contact, and Phon e. You can also check RFQ Required to indicate that you want to require an RFQ before the buyer creates a purchase order for the requisition. If RFQs are required and you AutoCreate a purchase order before creating an RFQ for the requisition line, Purchasing displays a warnin g message. You can also set this default in the Purchasing Options window. See: Defining Default Options, page 1-38. Project tabbed region • Use the Project tabbed region to enter additional information if your organization has implemented any of the follo wing products: • Oracle Projects • Oracle Project Manufacturing • Oracle Grants • Oracle Project Contracts The project information you enter is used by Oracle Projects for Deliver To destination types of Expense, or by Oracle Project Manufacturing for Deliver To destination types of Inventory or Shop Floor. See: Oracle Projects User's Guide. See: Oracle Project Manufacturing Implementation Manual. To enterproject information preferences: 1. Choose the Project Information tabbed region. 2. Select a Project Number. For a Deliver To destination type of Inventory or Shop Floor, you can optionally enter a Project Number if the Project Contro l Level is set to Project in the Project Information tabbed region of the Organization Parameters window. For a Deliver To destination type of Expense, you can always optionally enter a Project Number. 3. If you entered a Project number, select a Task number. You must enter a Task number for a Deliver To destination type of Inventory or Shop Floor, if the Project Control Level is set to Task in the Organization Parameters window and if you have entered a Project number. 4. If Oracle Grants is implemented, select an Award identifier. 5. Enter Expenditure information: Expenditure information is required only if your Destination Type is Expense. • Select the Expenditure Type. • If you chose an Expenditure Type, enter an Expenditure Organization. • If you chose an Expenditure Organization, select the Expenditure Item Date. To apply your defaults: • Select the Apply button to apply your defaults. The preferences entered here will affect new lines entered after you select Apply until you exit the application.
- 69. Define Supplier To enterbasic supplier information: SH Purchasing Supper User: Supply Base: Supplier 1. From the main Suppliers page,click the Create Supplier button. 2. In the Create Suppliers page, enter a unique Supplier Name. Tip: Use a naming convention that minimizes risk of separate entries for the same supplier under different names. For example, if you consistently spellthe full name of a supplier, do not enter both Orion Corp. and Orion Corporation. 3. If the Supplier Number Entry option in the Payables System Setup window is set to Automatic, Payables automatically enters a Supplier Number for you. If this option is set to Manual, you must enter a unique Supplier Number. 4. Optionally enter Alias, Name Pronunciation, and D-U-N-S number. 5. Optionally enter the supplier's tax identification number in the Taxpayer ID field; for example, an individual's social security number, or a corporation or partnership's federal identification number/federal tax ID. 6. Optionally enter the value-added tax (VAT) registration number in the Tax Registration Number field if you are entering a VAT supplier. 7. Click Apply. The systemcreates the supplier record and accesses the Suppliers: Quick Update page. 8. If you want to prevent invoice or purchase order entry for this supplier after a certain date, access the Suppliers: Organization page and then enter the date in the Inactive Date field. 9. To create locations for the supplier, go to the Suppliers: Address Book page and click the Create button. 10. Enter supplier and site information in the appropriate Supplier pages.See the following page reference sections for detailed information. • Quick Update.
- 70. • Organization. • TaxDetails. • Address Book. • Contact Directory. • Business Classification. • Products and Services. • Banking Details. • Surveys. • Accounting. • Tax and Reporting. • Purchasing. • Receiving. • Payment Details. • Relationship • Invoice Management. Note: Save your updates for each page before navigating to a new section. Create a Supplier 5. Navigate to the Suppliers page. (N) Suppliers > Entry 6. (B) Create Supplier. Supplier Type = Standard supplier Organization Name = Elshayeb Corporation 7. (B) Apply. 8. Navigate to (H) Organization. Type = Manufacturing
- 71. 9. (B) Save. 10.(B) Save. 11. Navigate to (H) Purchasing. Create Debit Memo from RTS Transaction = Check
- 72. Note: Enable theCreate 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. 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 14. (B) Save. 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
- 73. 16. (B) Save. 17.Navigate to (H) Payment Details. Payment Method : Check 18. (B) Save. Create a Pay Site 19. Navigate to (H) Address Book. 20. (B) Create. 21. Enter the supplier site address information as follows: Country = Egypt Address Line 1 = Cairo City = Cairo County = Egypt Address Name = Cairo Address Purpose = Payment, Purchasing
- 74. Note: This addressshould be complete as this is the address that will appear on any payment cut to this site! 22. (B) Continue 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 SH OU operating unit by checking the Select check box. 24. (B) Apply. This creates the basic supplier site. 25. To update the supplier site attributes, click (I) Manage Sites. In the Pay site, check and see that XXPay Group is also in the supplier site record.
- 75. 26. (T) Uses. Pay = Check Purchasing = Check 27. (T) Communication. Notification Method = Print 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 = 10 Th Of Ramadan Address Line 1 = 10 Th Of Ramadan City = 10 Th Of Ramadan
- 76. County =Egypt Address Name = 10 Th Of Ramadan 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) Continue. 32. Assign the address to the SH OU operating unit, by checking the Select check box. 33. (B) Apply. This creates the basic supplier site. 34. To update the 10 Th Of Ramadan supplier site attributes, click (I) Manage Sites. Review and ensure that your default pay group is assigned at the site level. 35. (T) Communication. Notification Method = Print
- 77. Note: When youenter 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. 36. (B) Apply. 47. (H) Close Window or (H) Home to return to the Navigator.
- 78. Create a PurchaseOrder and Submit For Approval Responsibility = SH Purchasing Super User 1. Navigate to the Purchase Order window (N) Purchase Orders > Purchase Orders Operating Unit = SH OU Type = Standard Purchase Order Supplier = Elshayeb Corporation Site = CAIRO Description = Document Approval Lab 2. (T) Lines Item = DD-00010-0040-01 Quantity = 250 Price = 50 3. Shipments (B) :To Define Inventory Organization And Location You Want To Receive Goods 3. Save and write down your purchase order number : 201440001. 4. (B) Approve Submit for Approval = Check box Uncheck all other options
- 79. 5. (B) OK Viewpurchaseorder summary to determine status assigned and viewaction history to determine who the purchase order was forwarded to for approval. 6. Navigate to the Purchase Order Headers window (N) Purchase Orders > Purchase Order Summary Operating Unit = Vision Operations Buyer = Your employee name 7. (B) Find 8. What is the status? _________ Why weren’t you able to approve your own document?
- 80. Managing Buyer Workload FindingRequisition Lines for Review or Assignment Purchasing lets you suggest a buyerfor each supplier-sourced requisition line you create. See: Entering Requisition Lines When you assign requisitions or requisition lines to buyers, the buyers can choose the requisition lines assigned to them and place these lines on purchase orders. Use the Find Requisition Lines window to choose whether to review requisition assignments or to assign/reassign requisition lines and to enter selection criteria for the lines. Choosing the Review action takes you to the Review Buyer Workload window, where you can review requisition assignments. You can identify requisition lines that reference the wrong buyer or that were not assigned to a buyer. You can also use this window to analyze buyers'workloads. Choosing the Assign action takes you to the Assign Requisition Lines window, where you can assign or reassign requisition lines to buyers. To enter search criteria: 1. Navigate to the Find Requisition Lines window by selecting Manage Buyer Workload from the menu. 2. Select the Operating Unit for this search. 3. Select Assign or Review mode. Then enter desired search criteria as described in the following steps. 4. Enter the Requisition number. 5. Enter the Requestor. 6. Enter the Supplier Sourcing criterion (Sourced or Unsourced). If you leave this field blank, Purchasing displays both sourced and unsourced requisition lines. Requisitions have a suggested suppliereither if the preparer entered a supplier when creating the requisition, or if Purchasing sourced the requisition. 7. Enter the Buyer name. 8. For sourced lines, enter the Supplier and Supplier Site 9. Enter the Ship To location to locate requisition lines for a specific location. When you set up Deliver-To Locations, you specify a Ship-To Location for each Deliver-To Location. If you enter a Ship-To Location, Purchasing displays all requisition lines for Deliver-To Locations that reference the Ship-To Location. 10. Enter the Rate Type. 11. Enter the Currency. 12. Use the tabbed regions to further restrict the search: 13. In the Status region, you can limit the search by Late status (Yes or No), Urgent status (Yes or No), Assigned status (Yes or No), RFQ Required status (Yes or No), Approval status (Approved,Incomplete, In Process,Pre-Approved, Rejected, Requires Reapproval, or Returned), or Need By date. 14. In the Line region, you can enter the following search criteria: Item number, Job (Oracle Services Procurement), Revision number, Category, item Description, and Line Type. 15. Select the Find button to initiate the search and open the Review Buyer Workload or the Assign Requisition Lines window, as chosen above. To clearexisting search criteria: • Select the Clear button to clear any existing search criteria.
- 81.
- 82. Return Requisition Lines ReturnRequisition Lines Oracle Purchasing lets you return a requisition line to the requisition preparer. You might want to return a requisition line if you are unable to obtain the requestor’s price and want the requestor to resubmit the requisition for approval at a higher price. From the Tools menu, select Return Requisitions to display the Return Requisitions window. Enter a reason for the return and select OK to return all requisition lines on the current requisition except any lines from the requisition already placed on a purchase order. When you return requisition lines, they are no longer available in the requisition pool. Once a requisition submitted in Oracle Purchasing has been approved, the requisition must be returned for the original submitter to make changes to it. If the requisition was submitted using Oracle iProcurement, the requestor can use the Withdraw feature to make changes and re-submit the requisition. The Withdraw feature is not available in Oracle Purchasing and can only be used in Oracle iProcurement if no lines on the requisition are associated with purchase documents. The Send Notifications for Purchasing Documents program will distribute notifications for returned requisitions. This program should be scheduled to run periodically.
- 83. Practice - Returna Requisition Overview In this practice, you will use the AutoCreate form to return a requisition. Log on to the System Responsibility = Purchasing, Vision Operations Requisition your Expensed Item 1. Open the Requisitions window: (N) Requisitions > Requisitions Operating Unit = Vision Operations Description = XXPurchases 2. (T) Lines Item = XXSoftware Quantity = 10 Need-by = Tomorrow’s Date 3. (T) Source Destination Type = Expense Organization = Vision Operations Location = V1- New York City Supplier = Blank Site = Blank 4. Save Requisition your InventoryItem 5. (T) Lines 6. (M) File > New Item field on line 2 = XXMonitor Quantity = 5 Need-by = Today’s Date Destination Type = Inventory Organization = Seattle Manufacturing Location = M1 – Seattle Supplier = Blank Site = Blank 7. Save 8. Record your requisition number = 20140014
- 84. Approve the Requisition 9.Submit for Approval = Checked 10. OK 11. Close the Requisitions window. Return your Requisition 12. Open the Find Requisition Lines window: (N) AutoCreate (B) Clear to clear existing query criteria. Operating Unit = Vision Operations Requisition = 20140014 (B) Find to open the AutoCreate Documents window. 13. Open the Return Requisitions window (M) Tools > Return Requisition.
- 85. In theReason field, enter a reason for returning the requisition. Note: The return reason can be viewed in the Action History window. 15. (B) OK Note: This action returns ALL requisition lines associated with this requisition unless they have been placed on a purchase document. Notification Send To Requester
- 86. Reapprove your Requisition 16.Open the requisitions window (N) Requisitions > Requisition Summary Operating Unit = Vision Operations 17. Enter your requisition number in the Requisition Number field 18. (B) Find 19. Note the approval status. 20. (M) Tools > View Action History 21. Close the Action History window 22. (B) Open 23. (B) Approve Submit for Approval = Checked Uncheck all other options 24. (B) OK OR You Can Cancel Your Requisition
- 88. 25. (B) OKto close the note window.
- 89. Modify Requisition Lines ModifyRequisition Lines Use the Modify feature when you want to split an existing requisition line into multiple requisition lines that represent the same or different items. For example, if the requisition line quantity is so large that a single supplier cannot fill the entire order by the need-by date, you can split the requisition line and assign the split lines to different purchase documents written to different suppliers. In an additional example, if you have a requisition line item that contains parts that you want to order as unique items, you can split the requisition line into several lines. Enter as many new lines as you need to represent the original requisition line. For each newly created line, Oracle Purchasing automatically creates distribution lines and prorates quantities for the new distributions based on the original requisition line distributions. When you return to the AutoCreate Documents window, Oracle Purchasing displays the new requisition lines that are now available for placement on a purchase order or RFQ if they meet your original search criteria. The original requisition line is no longer available for purchase order or RFQ placement, but your requester can easily review the modification status of a requisition line in the Requisitions Summary window. - First You Must Define Profile Option PO: Restrict Requisition line modify to quantity split To Yes
- 90. Open the FindRequisition Lines window: (N) AutoCreate (B) Clear to clear existing query criteria. Operating Unit = Vision Operations
- 91. After You CorrectThe Quantity To Equal The Quantity On The Original Line Quantity You Can Fined The Splitting In Requisition
- 93. Defining Requisition Templates Usethe Requisition Templates window to define requisition templates. These templates automate requisitioning of commonly ordered items like office supplies. To create a requisition for office supplies, requestors in your organization simply use your template and enter the quantity of each item they want to order. To create a template, you can specify the items individually or you can reference an existing requisition or purchase order. If you reference an existing document, Purchasing adds all lines on the document to the template. You can reference multiple documents to add all their lines to the same template. After you define a template, you can reference the template in the Supplier Item Catalog. When you do so, Purchasing displays all template lines that are valid for the destination organization, and you can use any of these lines on your requisition. You can create requisitions with this template as long as the requisition creation date is before the template inactive date. To define requisition templates: 1. Navigate to the Requisition Templates window. 2. Select the Operating Unit for this template. 3. Enter the requisition Template name. 4. Enter a Description of the template. 5. Enter the Inactive Date after which you do not want any requestor to create a requisition from this template. 6. Enter the requisition Type: Internal or Purchase. In either case,you can enter individual requisition lines of either type. 7. If this template is to be used in Oracle iProcurement, select the Reserve PO Number option. No prevents the requester from reserving a purchase order number at the time the requisition is approved. Optional allows the requester to reserve a purchase order number at the time the requisition is approved. Yes will automatically reserve a purchase order number at the time the requisition is approved. To copy lines to a template: 1. Select the Copy button to open the Base Document window. 2. Enter the Base Document Type: Purchase Order or Requisition. 3. Enter the base document Number from which you want to copy lines to the template. 4. Choose the OK button to copy all lines of the base document onto the template. You can choose the Cancelbutton to return to the Requisition Templates window without copying.
- 94. You can placelines from multiple documents onto the same requisition template. To manually add lines to a template: 1. Use the Lines region to manually add new lines to the template. You can also remove lines that you have copied from a base document, and you can change certain information in these lines. 2. Enter a Number in this field to identify the sequence of the line on your requisition. Purchasing provides default sequence numbers in increments of one. 3. Enter the line Type. You can enter or change information in this field only for new lines. The default is from the Purchasing Options window. See: Defining Default Options, page 1-38. 4. Enter the Item number. You can enter or change information in this field only for new lines. 5. For new lines only, you can enter the item Revision number. 6. If you entered an item, Purchasing displays the purchasing Category, and you cannot change it. Otherwise, you must enter a purchasing category. 7. Purchasing displays the item Description from the document you selected in the Base Document Number field. If you are entering a new line, the description is from the item master. You can change the description only if this attribute is active for the item. 8. The Source type determines the source of the requisitioned items. The choice you have in this field is dependent on your user profile options and the system profile options. At either level, you may be restricted to one of the following options: Inventory or Supplier. Note that if you have both options, you can source requisition lines independently of the requisition type. You can even mix inventory and supplier sourced requisition lines in the same requisition. Purchasing creates one internal sales order for each inventory source type requisition line on this requisition. The supplier source type requisition lines go onto purchase orders, either automatically with Auto Create Documents or manually with the Purchase Orders window. 9. Enter the default unit of measure. 10. Optionally, enter a suggested quantity for requisitioners in Oracle iProcurement. 11. For supplier sourced lines, you can enter the unit price, and this price is used in the Requisitions window. For inventory sourced lines, the cursor does not enter this field, and the price in the Requisitions window is the actual cost from inventory. 12. If Oracle Services Procurement is implemented, enter an amount for a fixed price services line type. Amount is required and the source type must be Supplier. 13. Indicate that this line was from a negotiated source by checking the Negotiated checkbox. You can change it only if your responsibility has that function enabled. 14. Save your work. To enter sourcing information : You can enter sourcing information for the current line in the lower part of the window. 1. For supplier source type lines, you can enter the name of the Buyer to whom you want to assign the requisition line. The buyers can query requisition lines that you assign to them when they Auto Create purchase orders. 2. For supplier source type lines, you can select RFQ Required to indicate that you want to require an RFQ before the buyer can create a purchase order for the requisition. Purchasing displays a warning message if you try to create a purchase order without a required RFQ. 3. For supplier source type lines, you can enter a suggested Supplier for your requisition items. You can choose a supplier from the list of available suppliers. 4. For supplier source type lines, you can enter the supplier Site. You can enter this field only if you provide a suggested supplier name. You can choose a supplier site from the list of values. 5. For supplier source type lines, you can enter the name of your Contact at the supplier site. 6. For supplier source type lines, you can enter the Supplier Item number. 7. For inventory source type lines, you can specify the source Organization. 8. For inventory source type lines, you can optionally specify the Subinventory source. If you do so, Oracle Order Management reserves the goods and uses only the specified subinventory for allocation. If the goods do not exist at the specified subinventory, Order Management backorders them, even if they do exist in another subinventory.
- 95. Solution - Createa Requisition Template Log on to the System Responsibility = Purchasing, Vision Operations PO: Default Supplier Item Catalog Option Create a Requisition Template 1. Open the Requisition Template window: (N) Setup>Purchasing>Requisition Templates Operating Unit = Vision Operations Template = IT Equipment Description = IT Equipment Items Inactive Date = One month from today Type field = Purchase Requisition 2. Save Copy From Base Document 3. Click the Copy button to open the Base Documents window Type = Requisition Number field = your purchase requisition from the earlier lab 4. Click OK to copy all lines of the base document onto the template.
- 96. 5. Save 6. Manuallyand lines 2-4 according to the table: Num Item Category Description Source 1 DD-00010-0040-01 MISC.MISC Inventory Item Supplier 2 DD-00030-0110-01 MISC.MISC 8GB Hard Drive Supplier 3 DD-00063-0110-01 MISC.MISC Monitor - 17"(16" Viewable) Short Depth Supplier 4 DD-00160-0105-01 MISC.MISC Keyboard - 101 Key Supplier Note: For supplier-sourced lines, you can enter the unit price, and this price is used in the Requisitions window. For inventory source lines, the cursor does not enter this field, and the price in the Requisitions window is the actual cost from inventory. You can enter sourcing information for the current line in the lower part of the screen. 7. Save
- 97. Using Requisition Templates SupplierItem Catalog Window There are four tabbed regions in the upper screen of this folder window,but Function Security can be used to determine whether a user will be able to see all of them.A profile option (PO: Default Supplier Item Catalog Option) determines which of these tabbed regions is the default when the catalogopens from the menu and for the first time in a user session that thecatalog opens from a requisition or purchaseorder. If you close thecatalog and reopen it from a purchaseorder or requisition durin g the same session, thedefault source region is the last one previously open. The regions are:Supply Base Management 5-7 NegotiatedSources Long term agreements with a supplier that support repetitive buys: Blanket purchase agreements, quotations, plannedpurchaseorders, andglobalagreements enabledfor your operating unit. This tabbed region is a folder. Prior Purchases Actualpast buys: Standardpurchase orders, scheduledreleases, blanket releases. This tabbedregion is a folder. Sourcing Rules Sourcing rules. There are + and - iconic buttons just belowthe region box. Select the + icon or ExpandSourcing Rules on the Tools menuto display source documents for the rule in a folder region. Use the - icon or Collapse Sourcing Rules on the Tools menuto collapse the region displaying the documents. You must be in the documents region to addto the Order Pador to select a price. Requisition Templates The PO: LegalRequisition Type profile option governs whether templates for supplier andinternally sourcedlines are displayed. This tabbedregion is a folder. From the Requisitions window, use the Supplier Item Catalog window and Requisition Templates to create requisitions more easily. To use requisition templatesto enterrequisitions: 1. Navigate to the Requisitions window by selecting Requisitions from the menu. 2. Enter requisition header information. See: Entering Requisition Headers, page 3-48. 3. Navigate to the Items tabbed region. See: Entering Requisition Lines, page 3-51 4. Select Catalog to open the Search Supplier Item Catalog window. See: Finding Supplier Items, page 5-9. 5. Select the desired Requisition Template from the list of values. See: Defining Requisition Templates, page 1-46. 6. Choose the Find button to open the Supplier Item Catalog window and display the template lines.
- 98. 7. Copy thedesired lines to the Order Pad. See: Using the Supplier Item Catalog Tabbed Regions, page 5-13. 8. Choose the Select button to close the Supplier Item Catalog window and transfer the order pad lines to the requisition. 9. Save your work.
- 99. Solution - AutoCreate a Purchase Order Log on to the System Responsibility = Purchasing, Vision Operations Auto create a Standard Purchase Order 1. Open the Auto Create Documents window: (N) Auto Create PO: Allow Buyer Override in Autocreate Find PO: Display the Autocreated Document 2. (B) Clear 3. Enter the number of your purchase requisition in the Requisition field. 4. (B) Find to open the AutoCreate Documents window.
- 100. Action =Create Document Type = Standard PO Grouping = Default 5. (M) Edit > Select All to select all lines 6. (B) Automatic to create a standard purchase order. Supplier = Elshayeb Corporation 7. (B) Create 8. Record the purchase order number. 20140001
- 101. 9. Save 10. (B)Approve 11. (B) Submit
- 102. Practice - Createa Standard Receipt Overview In this practice you will create a standard receipt against the purchase order you created in the prior practice. Note: You can use iSupplier Portal to allow your suppliers to record ASNs. Deliveries must still be processed using this window, but much of the information will already be recorded and as a result, receipt processing cost and time will be lower. Note: You can only override the default destination type if the RCV: Allow Routing Override is set to Yes. Note: The RCV: Processing Mode profile option determines how receipts are processed: Setting Meaning Online The user will not be able to perform any other application activities until the process completes. Immediate The window will start running Receiving Transaction Processor as a background process. The system will not hold the screen and the user can do something else.. Batch Control is returned to the User immediately so other application activities may be performed. The transaction will be processed by running Concurrent Program Receiving Transaction Processor (RVCTP). Typically, customers will run this program periodically based on their processing and system requirements.
- 103. Solution - Createa Standard Receipt Log on to the System 1. Log on to the system using the following information. Responsibility = SH Inventory Find Expected Receipts 2. Open the Find Expected Receipts window: (N) Receiving > Receipts (SH1) Operating Unit = Vision Operations Purchase Order = Your Purchase Order from previous practice. (20140002) Supplier = Elshayeb Corporation 3. (B) Find Fill in Receipt Header Details Note: The Receipt Header window opens on top of the Receipts window. When you have completed the Receipt Header window, click in the Receipt window, which is located behind the Receipt Header window to navigate to it.
- 104. Process a StandardReceipt 4. (M) Window > Receipts (SH1) 5. Select the checkbox to the left of the Quantity field Quantity = 20001 6. Save We Receive Qty Greater Than The Qty In PO Because Allow Blind Receiving Is Checked In Receiving Options
- 105. 7. (B) Header 8.Record your receipt number.( 201400001) Note: You can only override the default destination type if the. Profile Option (RCV: Allow Routing Override) is set to Yes. Note: The RCV: Processing Mode profile option determines how receipts are processed: Setting Meaning Online The user will not be able to perform any other application activities until the process completes. Immediate The window will start running Receiving Transaction Processor as a background process. The system will not hold the screen and the user can do something else.. Batch Control is returned to the User immediately so other application activities may be performed. The transaction will be processed by running Concurrent Program Receiving Transaction Processor (RVCTP). Typically, customers will run this program periodically based on their processing and system requirements. 9. Deliver Goods To Inventory (N) Receiving > Receipts Transactions (SH1)
- 106.
- 107. Practice - Inspectand Deliver a Receipt Overview In this practice you will inspect and deliver a receipt. Half of the items you found to be defective. You will deliver half to their final destination and the other half will be returned. To Do This Practice You Must Define PO Receipt Option Inspection Required PO Number = 20140003 To Test Over Receipt Tolerance Change Allow Blind Receiving To Unchecked
- 108. Log on tothe System 1. Log on to the system using the following information. Responsibility = SH Purchasing Supper User You Can not Receipt Quantity Over = PO Line QTY + (PO Line QTY* Over Receipt Tolerance) = 100 + (100*0.1) = 110
- 109. Performa Quality Inspection 2.Open the Receiving Transactions window: (N) Receiving > Receiving Transactions (SH1) Purchase Order = Your receipt number 3. (B) Find 4. (B) Inspect Note: If Oracle Quality is installed and at least one inspection plan exists for the transaction, both the Enter Quality Results option in the Tools menu and the Quality button on the menu bar will be enabled. If the QA: PO Inspection Profile option is set to Quality, when you click the Inspect button, it opens the Quality Inspection window that you defined, instead of the Purchasing Inspection window. If the quality window is displayed instead of the Purchasing Inspection window, ask the instructor to change the QA:PO Inspection Profile option to Purchasing.
- 110. Change To :Oracle Purchasing 5. Enter inspection results according to the table: Item Inspect Result Quantity Quality Code Reason Code Comment DD-00050-0220-01 Accept 2 Above Average Blank Passed inspection DD-00050-0220-01 Reject 2 Below Average Comp Defect Failed inspection 6. (B) OK 7. Save
- 111. 8. Close theReceiving Transactions window. Deliver Goods to a Final Destination 9. Open the Receiving Transactions window: (N) Receiving > Receiving Transactions 10. In the Receipt field, enter your receipt number. 11. (B) Find
- 112. 12. Complete theReceiving Transaction according to the following table: Inspection Qty UOM Destination Type Item Subinventory Location Accepted Defaults Each Inventory XXMonitor Stores M1-Seattle Rejected Defaults Each Receiving XXMonitor M1-Seattle Note: You’ll need to use this window carefully. Determine which record was the accepted item and which was the rejected item! 13. Save Review Receiving Transactions 14. Open the Find Receiving Transactions window:
- 113. (N) Receiving> Receiving Transactions Summary (M1-Seattle Manufacturing) 15. In the Receipt field, enter your receipt number. 16. (B) Find 17. (B) Transactions to open the Receipt Transaction Summary window. 18. Review your receipt.
- 114. Unordered Receipts You canreceive items from a supplier when you do not have a corresponding purchase order but want to receive the items so you can track them on the systemwhile you wait for a buyer to decide which purchase order to use. You can receive returned items from a customer that were issued on a sales order in Order Management while you find out from the sales representative which return material authorization (RMA) to use. First receive the items as Unordered Receipts in the Receipts window. You can create a new receipt or add to an existing receipt for the supplier or customer who shipped the unexpected items. Then perform a standard receipt for the unordered item shipment quantity. Use the Find Unordered Receipts window to find the receipts or RMAs that are available for matching. Then use the Match Unordered Receipts window to specify the purchase order or RMA number, release, line, and shipment schedule to which you want to match the unordered receipt. Purchasing restricts the list of possible matching purchase orders/releases as follows: • The purchase order must have the same supplier as the unordered receipt (when matching to RMAs, the RMA must have the same customer as the unordered receipt) • The purchase order cannot be final closed or cancelled • The purchase order must have at least one approved shipment in the same organization where you performed the unordered receipt (when matching to RMAs, the receiving organization on the RMA must be the same organization where you performed the unordered receipt) • Except for receipts for one-time items, the item and the purchasing category on the purchase order (or the item on the RMA) must be the same as the item and purchasing category on the unordered receipt • The purchase order must have a receipt routing of Standard Receipt, Inspection Required, or none (blank). If the purchase order shipment has a routing of Direct Delivery, the profile option RCV: Allow Routing Override must be set to Yes. This routing requirement also applies to RMAs, which use the routing specified in the Receiving Options window. You can match only to approved shipments. If you cannot locate a valid matching document for yourunordered receipt, you can modify and approve an existing purchase order/release or you can create and approve a new purchase order. You can then match to this new, approved shipment. For RMAs, you can ask the sales representative to create one in Order Management, and then you can match to the new RMA or RMA line. When you choose a shipment or RMA line, Purchasing performs receiving control checks of the quantity received tolerance and due date threshold. If the RCV: Print Receipt Traveler profile option is set to Yes, receipt travelers are printed automatically when you match unordered receipts.
- 115. Practice - CreateUnordered Receipts To enterunordered receipts: 1. Select Receipts on the menu to open the Find Expected Receipts window. 2. Choose the appropriate tabbed region. Choose the Supplier and Internal tabbed region to create an unordered receipt that will later be matched to a purchase order or release. Or Choose the Customer tabbed region to create an unordered receipt that will later be matched to a return material authorization (RMA). An RMA is created in Order Management to authorize a customer's returning an item to your company. Important: It is important to choose the correct tabbed region. For example, if the Customer tab is selected, later when you enter the receipt you will see only customer information in the lists of values. 3. Select the Unordered button to open the Receipt Header window. 4. Enter receipt header information. Enter Supplier Name You Want Receipt From Them - Enable Unordered Receipt To Supplier
- 116. 5. Enter receiptline information. 6. Save your work.
- 117. Matching Unordered Receipts Usethis window to match unordered receipts to purchase order shipments. To select unorderedreceipts for matching: 1. Navigate to the Find Unordered Receipts window by selecting Match Unordered Receipts on the menu. 2. Enter any of the following as selection criteria for the receipts you want to match to purchase orders or return material authorizations (RMAs): Receipt Number, Supplier or Customer name, Item, Category, Supplier Item Number, Receiver, Transaction Date, Receiving Location, Item Description. 3. Select the Find button.If your selection criteria produce any receipts for matching, the Item Number, Revision, Category, and Supplier or Customer are displayed in the Unordered Receipts block in the Match Unordered Receipts window. The Receipt Number, Quantity Received, Receiving UOM, Deliver To, Receiver, Item Description, Quantity Ordered, Order UOM, Destination, and Supplier Item Number for the current receipt are displayed in the lower part of the window. To match unordered receipts: 1. Navigate to the Match Unordered Receipts window by selecting the Find button in the Find Unordered Receipts window.
- 118. 2. In theOrder Information block in the Match Unordered Receipts window, enter a purchase order number in the Order Number field. For customer-returned items (a Customer is displayed rather than a Supplier), enter the return material authorization (RMA) number in the Order Number field. You can also choose List of Values from the tool bar to query the purchase order shipments or RMA lines available to match the current unordered receipt. This displays the Order Number, Release, Line, and Shipment for all shipments appropriate for matching. To display receipt headerinformation: • Select the View Receipt Header on the Tools menu to display receipt header information.
- 120. To display receiptline information: • Select the View Receipt Line on the Tools menu to display receipt line information. To display purchase order information: • If an Order Number is entered, select View Purchase Orders on the Tools menu to display purchase order header information.
- 121. Practice - Createa Supplier List Overview In this practice you will add several suppliers and the supplier you created in a previous practice to a supplier list. Responsibility = Purchasing, Vision Operations Create a Supplier List 1. Navigate to the Define Supplier Lists window (N) Supply Base > Supplier Lists Name = SH Computer Hardware Description = Computer Hardware Make the list inactive in three months. 2. Add the supplier you created to your list, as well as the following suppliers (use the list of values from the toolbar to select vendors and sites): Name Site Advanced Network Devices SANTA CLARA Star Gate Ltd STARGATE-BUY Advantage Corp ADVANTAGE - US XXIBM Corporation NEW YORK 3. (B) Save
- 122. Request For QuotationAnd Quotations A request for quotation (RFQ) is sent to a supplier to request pricing and other information for an item or items. A quotation is the supplier's response to that RFQ. Some examples of how you send an RFQ to a supplier include creating an RFQ in the RFQs window and sending it by facsimile, ma king a phone call, or using Oracle iSupplier Portal. One way a supplier can send a quotation,whether or not in response to an RFQ, is through the Purchasing Documents Open Interface. (See: Receiving Price/Sales Catalog Information Electronically, page 5-18.) If you don't receive quotations electronically from your supplier, you can create the quotation manually using the Quotations window, or copy the quotation from an RFQ. (See: Copying Quotations from RFQs, page 5-74.) Using Quotation Information on Your Documents Purchasing lets you use your quotation information when you build purchase orders. Using Quotation Information for a Purchase Order When you create a purchase order (manually or from requisitions), you can use the Supplier Item Catalog window to retrieve quotation information. (The Supplier Item Catalog window can include quotations sent to you by yoursupplier through the Purchasing Documents Open Interface. See: Receiving Price/Sales Catalog Information Electronically, page 5-18.) Purchasing provides all your approved quotation shipment information for a specific item or manufacturing category. You can copy this quotation shipment to an existing blanket purchase agreement or standard purchase order when you add this item or purchasing category to a purchase order line. You can sort this quotation information according to your needs,using criteria such as price or quantity. You can easily evaluate the source that is best for an item. After you select the quotation shipment you want to use, Purchasing copies the item unit price, quantity,unit of measure, supplier product number, inspection required status,receipt required status,quotation number, quotation type,and supplier Supply Base Management 5-5 quotation number on your purchase order. Purchasing automatically warns you when the terms and conditions of the quotation are different from the terms and conditions of your purchase order. The original purchase order terms and conditions remain unchanged. Using Partial Quotation Information on a Requisition When you enter an item or purchasing category on a requisition line, you can use the Supplier Item Catalog window to access quotation shipment information for the item or category.After you select the quotation shipment you want to use,Purchasing automatically copies the item unit price, quantity, unit of measure, supplier product number, supplier name, supplier site, and supplier contact to your requisition line. Purchasing also copies the quotation item description on yourpurchase order if you define your items to do so. Types of Quotations and RFQs There are three types of quotations and RFQs that come with Purchasing by default: • Catalog:Used for high-volume items or items for which yoursupplier sends you information regularly. A Catalog quotation or RFQ also includes price breaks at different quantity levels. • Standard: Used for items you'll need only once or not very often, but not necessarily for a specific, fixed quantity,location, and date. For example, you could use a Catalog quotation or RFQ for office supplies,but use a Standard quotation or RFQ for a special type of pen you don't order very often. A Standard quotation or RFQ also includes price breaks at different quantity levels. • Bid: Used for a specific, fixed quantity,location, and date. For example, a Bid would be used for a large or expensive piece of equipment that you've never ordered before, or for an item that incurs transportation or other special costs. You cannot specify price breaks for a Bid quotation or RFQ. For all three types,you can define effectivity dates at the header level. For Catalog and Standard quotations,you can also specify effectivity dates for individual price breaks. (For a Bid, you cannot specify effectivity dates at the shipment level.) You can also define yourown RFQ or quotation types using the Document Types window. See: Defining Document Types,page 1-67. For advanced features in RFQs and quotations,please refer to the Oracle Sourcing Implementation and Administration Guide.
- 123. Practice - CreateA Manual Request For Quotation To enterRFQ headerinformation: 1. Navigate to the RFQs window. Purchasing displays today's date as the Created date and the functional Currency from your ledger. 2. Select the Operating Unit for this RFQ. 3. Enter a unique number for the RFQ. In the Purchasing Options window, you can choose whether RFQ numbers are numeric or alphanumeric and whether Purchasing automatically generates them when you save yourchanges. See: Defining Numbering Options, page 1-41. 4. In the Type field, enter one of the document names defined for RFQs. The list of values lists the Document Type (Document Name) and Quotation Class from the Document Types window. For existing RFQs, the list of values includes only RFQs with the same Quotation Class. See: Defining Document Types, page 1-67. See also: Types of Quotations and RFQs, page 5-5. 5. Enter the Ship-To and Bill-To locations for the items on the RFQ. See: Defining Locations, page 1-18. 6. Use the Status field to control the status ofthe RFQ: • In Process - The initial status when you create the RFQ. • Active - Choose this status when the RFQ is complete and you are ready to send it to your suppliers. Only Active RFQs are printed. • Printed - The status assigned to the RFQ when you have printed at least one copy of it. You must change the status to Active if you want to reprint the RFQ. • Closed - Choose this status to close the RFQ when all suppliers have responded or when you no longer want responses. When you close an RFQ, Purchasing deletes all follow up notifications associated with it. 7. Enter the Due Date when you want your suppliers to reply. Purchasing prints the reply due date on the RFQ. Purchasing notifies you if the current date is between the RFQ reply due date and the close date and if the RFQ is Active. Purchasing knows that a supplier replied to an RFQ if you enter a quotation for this supplier referencing the RFQ. See: Viewing and Responding to Notifications, page 2-29. See: Entering Quotation Headers, page 5-62. 8. Enter the Reply/Receive Via code for the method you want the supplier to use to send the quotation. For example, by mail, telephone,or FAX. See: Defining Lookup Codes, page 1-55. 9. Enter the Close Date for the RFQ. Purchasing prints the close date on the RFQ. Purchasing notifies you if the current date is between the RFQ reply due date and the close date and if the RFQ is Active. Purchasing warns you when you enter a quotation against this RFQ after the close date. See: Viewing and Responding to Notifications, page 2-29. 10. Select Require Quote Approval to enforce approval of any quotation referencing this RFQ before the quotation can be used for a purchase order. 11. Purchasing displays yourname as the Buyer. You can forward the RFQ to another buyerby choosing the name of this buyer from the list of values. The buyer you enter receives all notifications regarding this RFQ. 12. Enter the beginning and ending Effectivity Dates for the supplier quotation.
- 124. 13. Enter RFQlines in the Lines tabbed region: See: Entering RFQ Lines, page 5-53. To entersupplierinformation: • Select the Suppliers button to open the RFQ Suppliers window. See: Entering RFQ Supplier Information, page 5-55 To entercurrency information: • Select the Currency button to open the Currency window. See: Entering Currency Information, page 4-60. To enterterms and conditions information: • Select the Terms button to open the RFQ Terms window. See: Entering RFQ Terms Information, page 5-57. To entershipment information: • When the Quotation Class of the header Type is Bid, you can select the Shipments button to open the RFQ Shipments window. See: Entering RFQ Shipment Supply Base Management 5-53 Information, page 5-58. To enterprice break information: • When the Quotation Class of the header Type is Catalog, you can select the Price Break button to open the Price Breaks window. See: Entering RFQ Price Break Information, page 5-60. Entering RFQ Lines Use the Items tabbed region in the RFQs window to enter and edit RFQ lines. To enteran RFQ line: 1. Select the Items tabbed region in the RFQs window. 2. Enter a unique Number for the RFQ line. 3. Enter the line Type for the item. When you enter a line type, Purchasing automatically copies the corresponding purchasing category,unit, and unit price. You can enter predefined items only when you choose a quantity based line type. Purchasing defaults the value you define in the Purchasing Options window. 4. Enter the Item for yourRFQ line. Purchasing retrieves the item description, purchasing category,and unit of measure. If you do not enter a predefined item, you must provide a purchasing category and item description for the RFQ line. For amount based line types,the cursordoes not enter this field. See: Defining Items, Oracle Inventory User's Guide. 5. Enter the Revision number for the item on the requisition line. 6. Enter the purchasing category for your RFQ line. If you enter a predefined item, Purchasing supplies the purchasing category.
- 125. 7. Enter theitem Description for your RFQ line. If you enter an item, Purchasing supplies the item description. You can set up the item definition so that you can override the item description for this particular RFQ. See: Defining Items, Oracle Inventory User's Guide. 8. Enter the UOM for your RFQ line. If you enter an item number, Purchasing supplies the unit of measure. For amount based line types,the cursordoes not enter this field. 9. Enter an optional Target Price for the RFQ line. You may want to provide a target price on the RFQ line for negotiation purposes. For amount based line types, Purchasing uses a target price of 1. 10. Enter the supplier's number for the item. To enter additional RFQ line information: 1. Select the More tabbed region in the RFQs window. You can enter optional information in the fields described in the following steps. 2. Enter a unique line number for your RFQ line. Purchasing defaults the next available line number. 3. Enter the UN Number for the item on the RFQ line. See: Defining UN Numbers, page 1-54. 4. Enter the Hazard class for the item on the RFQ line. If you enter a UN number, Purchasing displays the corresponding hazard class if one has been defined. See: Defining Hazard Classes,page 1-53. 5. Enter the Minimum Order Quantity for the item on the RFQ line. 6. Enter the Maximum Order Quantity for the item on the RFQ line. 7. Optionally enter a Project Number. 8. Optionally enter a Task Number. 9. Optionally enter a Contract Number for Oracle Project Contracts. 10. Optionally enter a Revision for Oracle Project Contracts. 11. Enter a note to the supplier about this item. This note prints on the RFQ. Entering RFQ Supplier Information Use the RFQ Suppliers window to: • Enter the suppliers to which this RFQ will be sent.You can also delete suppliers from the RFQ until you have printed the RFQ for them. • Review the supplier activity. To enterRFQ supplierinformation: 1. Navigate to the RFQ Suppliers window by selecting the Suppliers button in the RFQs window. For each supplier that you enter, Purchasing displays the Printed and Responded dates as well as the Count of the number of times the RFQ has been printed. The Responded date is the receipt date recorded for the quotation from the supplier. Include In Next RFQ Printing check box is checked when you add a supplier. You can postpone printing the RFQ for a supplier by deselecting the check box. After you print the RFQ for a supplier, Purchasing deselects this field. If you want to reprint the RFQ for a supplier, you must use this window to select the field again. 2. Enter a unique sequence number for the supplier on the RFQ Suppliers list. Purchasing uses this sequence number to print your RFQs for these suppliers. 3. Enter the name of the active Supplier you want to place on the RFQ Supplier list. The list of values displays the supplier name, number, Tax ID number, and VAT number. 4. Enter the Supplier Site you want to place on the RFQ Supplier list for this supplier. You can choose only sites that you defined as RFQ Only suppliers. You cannot enter the same supplier site twice. 5. Enter the name of the Contact for this site 6. If you want to postpone printing the RFQ for a supplier, you can deselect Select for Printing.
- 126. To add suppliersfrom supplier lists: 1. Select the Add From List button in the RFQ Suppliers window to open the Supplier Lists window. This window is a display-only version of the Supplier Lists window, but includes only the Supplier List name, Description, and a Count of the number of suppliers on the list. See: Defining Supplier Lists, page 5-81. 2. Select any supplier list for which you want to copy all suppliers to the RFQ. Suppliers already on the RFQ are omitted. 3. Select the Apply button to close the window and add these suppliers to the RFQ. Otherwise, you can select the Cancel button to return to the RFQ Suppliers window without adding suppliers from a list. To copy RFQs to quotations: • Select Copy Document on the Tools menu to open the Copy Document window. See: Copying Quotations from RFQs, page 5-74.
- 127. Practice - Createa Requisition, RFQ ,Quotation ,Purchas Order 1- Create a Requisition 20140004 Auto Create RFQ From Requisition PO: Warn if RFQ Required before Autocreate
- 128. • Change DocumentType To RFQ And (B) Automatic
- 129. (B) Create Select SupplierFor Send RFQ To Them
- 130. Or Choose FromSupplier List You Can Define Shipment Create Quotation
- 132. Chang Status ToActive Create Quotation To Second Supplier
- 133. Approve Quotation ReturnFrom Supplier
- 135. Create PO FromApproved Quotation
- 138. Approve PO AndReceipt It To Inventory
- 139. Practice - Createa Catalog RFQ Overview In this practice you will add an item that you created in previous practice to a Catalog RFQ. You will use the supplier list you created in the prior practice to copy suppliers on to the RFQ. Log on to the System Responsibility = Purchasing, Vision Operations Create a Catalog RFQ 1. (N) RFQs and Quotations > RFQs Operating Unit = Vision Operations Type = Catalog RFQ Status = Active Due Date = Two weeks from today Note: The due date will print on the RFQ Description = SH Computer Hardware Reply Via Field = Mail Close Date = Three weeks from today Note: Purchasing warns you if a new quote is entered into the system that references this RFQ after the close date. Quote Approval Required = Checked Quote Effectivity = Today’s date to one year from today 2. Save Note: You can override the name in the Buyer field. The person specified in the buyer field will receive notifications associated with this RFQ. Complete the Requested Terms 3. (B) Terms Payment Terms = 45 Net (terms date + 45)
- 140. Carrier =UPS Note to Supplier = Please expedite your response! 4. Save 5. Close the RFQ Terms window. Add Items 6. (T) Items Enter items according to the table: Number Item Category UOM Target Price 1 CM13139 PRODUCTN.DRIVES Each Blank 2 XXSoftware MISC.MISC Each Blank 3 XXMonitor MISC.MISC Each Blank Note: The supplier will reply with pricing information. Add Requested Price Breaks to EACH Line 7. (B) Price Breaks
- 141. 8. Ask forprice breaks at 10, 25, and 50 Num UOM Quantity Price Org Ship-To Discount 1 Each 10 Blank M1 M1-Seattle 10 2 Each 25 Blank M1 M1-Seattle 15 3 Each 50 Blank M1 M1-Seattle 20 Note: This must be done for EACH item on your RFQ. 9. Save 10. Exit the RFQ Price Breaks window. 11. Verify that all items have the price break structure entered according to the table above. Add Suppliers 12. (B) Suppliers 13. (B) Add From List SH Computer Hardware = Checked 14. (B) Apply
- 142. 15. (B) Ok Note:the suppliers from your supplier list were added to your RFQ. Also, note the Printed field is blank and the Print Count is 0. 16. Save your work and exit the RFQ Suppliers window. 17. Record your RFQ number. Print the RFQ 18. Navigate to the request submission window: 19. (N) Reports > Run 20. (B) Ok to choose Single Request Name = Printed RFQ Report(Landscape) Operating Unit = Vision Operations Parameter Value Report Type All RFQ Number From 20140002 To 20140002
- 143. 21. Click OK 22.(B) Submit 23. Do not submit another request 24. (M) View > Requests 25. (B) Find 26. (B) Refresh Data until your request completes 27. (B) View Output Note: After the RFQ is printed; the status changes to from Active to Printed. If you want to reprint your RFQ, re- query your RFQ, change the status to Active. Click the Supplier button and select the “include in next printing” check box. Save your changes then re-run the Printed RFQ report.
- 144. Printed RFQ Report(Landscape)(XML) Printed RFQ Report(Portrait) (XML) Request Group = All Reports. Purchasing For Purchasing Reports Information Visit : http://docs.oracle.com/cd/E18727_01/doc.121/e13410/T446883T471354.htm#4022785
- 145. Defining Approved SupplierStatuses You can create any number of Approved Supplier Statuses to describe the condition of the Approved Supplier, ranging from fully Approved (the supplier has demonstrated the ability to satisfy rigorous quality, cost, and delivery requirements over a sustained period) to Debarred (no business is allowed with this supplier for a particular item or commodity), or New if you have never placed a purchase order with the supplier. Note: If you debar a supplier for a specific commodity (category) in the Approved Supplier List, the supplier is prevented from supplying all items within that commodity. However, if you approve a supplier for a commodity, the item-specific status for the supplier still takes precedence. Each Approved Supplier Status can have business rules applied to manage the characteristics of the status. You can prevent or allow certain business rules for each status,change the name of a status,orcreate a status ofyour own. For example, the default status ofApproved allows all the default business rules: PO Approval, Sourcing, Schedule Confirmation, and Manufacturer Linking. But you could change the Approved status to prevent one of the Business Rules. Likewise, you can create your own status with your own combination of Business Rules. In the Status field in the Approved Supplier List window, Purchasing lets you choose among these supplier statuses. Defining your own supplier statuses in this window is optional. To define Approved SupplierStatuses: 1. Navigate to the Approved Supplier List Statuses window. 2. Enter a unique Status name. 3. Enter a status Description to convey the meaning of the status. 4. Optionally check Approved Supplier List Default to set this status as a default. This is the status that appears as the default for suppliers you add to the Approved Supplier List window. (You can change a supplier's status from within the Approved Supplier List window.) Note: You can only have one Approved Supplier Status as a default. 5. Optionally choose a date for Inactive On to set the time when the status will no longer be active. Existing Approved Supplier List entries still use the status you inactivate today. New entries you create, however, will not. 6. If you choose to apply Business rules to the Approved Supplier Status, choose a Control. By choosing a Control, you either Allow or Prevent the Business Rule. 7. Select a Business Rule. • PO Approval - Enables you to allow or prevent purchase order approvals sourced to this supplier. • Sourcing - Enables you to allow or prevent sourcing to this supplier. • Schedule Confirmation - Enables you to allow or prevent schedule confirmation for this supplier in Supplier Scheduling. • Manufacturer Link - In the Approved Supplier List window, you choose a Business from one of the following: Direct (Supplier), Manufacturer, or Distributor. If you have a Distributor defined in the Approved Supplier List window, this Business Rule enables you to allow or prevent linking to the Manufacturer also defined in the Approved Supplier List window.
- 146. Solution - Createan Approved Supplier List Status Overview In this practice you will create an approved supplier list status. Log on to the System 1. Enter sign on information 2. Select a responsibility Responsibility = Purchasing, Vision Operations Create a Supplier Status 3. Navigate to the Approved Supplier List Status window (N) Supply Base > Supplier Statuses 4. (M) File > New Status = SH Approved Description = Approved for Business Approved Supplier List Default = Unchecked Assign Business Rules 5. Create business rules for the status according to the following table: Control Rule Rule Description Allow PO Approval Purchase Order Approval Allow Sourcing Sourcing 6. Save
- 147. Practice - Requirean Approved Supplier for an Item Overview In this practice you will set the Use Approved Supplier attribute on an item. Log on to the System 1. Enter sign on information. Responsibility = Purchasing, Vision Operations Set the Use Approved Supplier Flag for an Item 2. Navigate to the Organization Items window (N) Items > Organization Items Organization = SH1 Item = XXMonitor (B) Find (T) Purchasing Use Approved Supplier = Checked 3. Save Attempt to Enter a Purchase Order for the Item 4. Navigate to the Purchase Orders window (N) Purchase Orders > Purchase Orders Operating Unit = Vision Operations Supplier = Advanced Network Devices Site = SANTA CLARA (T) Lines Item = SH Approved Supplier Quantity = 10 Price = 20 Need-By = Today’s date
- 148. Save (B)Approve 5. Verify that this item requires an approved supplier list
- 149. Solution - Createan Approved Supplier List Overview In this practice you will enter a supplier and add it to a supplier list. Log on to the System Responsibility = Purchasing, Vision Operations Make the Approved Supplier List a Global Approved Supplier List 3. (T) Record Details Global = Yes Define the Attributes of the Approved Supplier List Entry You will use the PO Create Documents workflow or the AutoCreate window to create standard purchase orders. Make sure that the release method is set appropriately. Release Method = Release Using AutoCreate Type = Quotation Number = Your quotation number 4. In the Line field enter the line number of your inventory item. Log on to the System Responsibility = Purchasing, Vision Operations Add an Approved Supplier for your Item 11. Open the Approved Supplier List window: (N) Supply Base > Approved Supplier List (SH1 Manufacturing) Type = Item Item = XXMonitor 12. (T) Key Attributes Business = Direct Supplier = Advanced Network Devices Site = SANTA CLARA Operating Unit = Vision Operations Status = Approved Supplier Item = XXSVGA17 13. Optionally specify a review-by date. Note: You can use this date to determine when a proactive business review should be performed for the supplier. There are no standard reports, alerts or notifications associated with this field. To have advance notification, create an alert. Note: You can search suppliers requiring a review using the Approved Supplier List Summary window.
- 150. Make the ApprovedSupplier List a Global Approved Supplier List 14. (T) Record Details Global = Yes from the pop-up list to indicate this item and supplier site combination should be available to all organizations. A local ASL entry will override a global ASL entry. 15. Save Define the Attributes of the Approved Supplier List Entry 16. (B) Attributes Release Method = Release Using AutoCreate 17. (T) Source Documents Type = Quotation Number = Your quotation number Note: If your quotation does not appear on the list of values check to ensure the status is active and the quote is approved! Recall that we selected the Quote Approval Required option on the RFQ that is associated with this quotation. 18. In the Line field enter the line number of your inventory item.
- 151. 19. Save 20. Closethe Supplier-Item Attributes and Approved Supplier List forms to return to the Navigator. Note: Blanket purchase orders and quotations are not required to create an Approved Supplier List. In addition, it is not even necessary to associate a blanket purchase agreement or quotation in the Source Details window if you set the PO: Automatic Document Sourcing profile option to “Yes”.
- 153. Practice - UnderstandASL Precedence Overview Commodity level ASLs exist primarily for the buyer to be able to exercise control over a supplier’s ability to source. In other words, the buyer can with very little effort block a supplier for an entire commodity. In this exercise, you will learn to understand ASL precedence. Item Code Purchasing Category Approved Supplier Level DD-00200-0110-01 COMPUTER.MONITOR Category DD-00150-0220-01 COMPUTER.MONITOR Item Scenario 1 COMPUTER.SUPPLIES 101Key Keyboard 17" Flat Panel Monitor 36X CD-ROM COMPUTER.SUPPLIES Supplier DisabledStatus Supplier DisabledStatus 17" Flat Panel Monitor AND IBM Stargate Approved Approved Approved Which suppliers can approve POs for the Monitor? Note: In this scenario IBM and Stargate may supply 17" Flat Panel Monitors. AND can supply all supplies in the Computer.Supplies category. For approvals, as long as there are item level approved suppliers on the list, the category level suppliers are ignored.
- 154. Scenario 2 COMPUTER.SUPPLIES 101Key Keyboard 17"Flat Panel Monitor 36X CD-ROM COMPUTER.SUPPLIES Supplier DisabledStatus Supplier DisabledStatus 17" Flat Panel Monitor AND IBM Stargate Debarred Debarred Approved Which suppliers can approve POs for the Monitor? Note: Assuming that the Debarred status is set up to prevent PO approval and sourcing, in this scenario only AND can approve POs for the monitor. IBM and Stargate are still on the ASL, they just can't approve POs or source.
- 156. Scenario 3 COMPUTER.SUPPLIES 101Key Keyboard 17"Flat Panel Monitor 36X CD-ROM COMPUTER.SUPPLIES Supplier DisabledStatus Supplier DisabledStatus 17" Flat Panel Monitor AND IBM Stargate Debarred Debarred Approved Which suppliers can approve POs for the Monitor? Yes Yes Note: IBM and Stargate are no longer on the ASL since they are disabled. Status is irrelevant in this situation. AND can approve purchase orders. Scenario 4 COMPUTER.SUPPLIES 101Key Keyboard 17" Flat Panel Monitor 36X CD-ROM COMPUTER.SUPPLIES Supplier DisabledStatus Supplier DisabledStatus 17" Flat Panel Monitor AND IBM AND Debarred Approved Debarred Which suppliers can approve POs for the Monitor? Note: In this scenario no one may approve purchase orders for the monitor. If a supplier is debarred for a category of items,. AND is prevented from approving purchase orders or sourcing for the entire category of items. Purchasing uses commodity this way to debar suppliers.
- 157. Overview of InternalRequisitions Internal requisitions provide the mechanism for requesting and transferring material from inventory to otherinventory or expense locations. When Purchasing, Order Management, Shipping Execution, and Inventory are installed, they combine to give you a flexible solution for your inter-organization and intra-organization requests.You should be able to: • Set up your supply chain and automatically source yourrequirements from inventory or suppliers • Define yourinter-organization shipping network, and optionally require that you use internal orders for yourinter-organization transfers • Use intransit inventory when you want to track items as they move between organizations • Reduce warehousing, shipping, and handling costs by requesting items in fixed lot sizes • Use the same windows for data entry and inquiry that you use for purchase requisitions and sales orders • Take advantage of standard requisition and sales order functionality to suit your individual business requirements • Automatically generate inventory replenishment requisitions and fulfill them via internal or external suppliers • Automatically source MRP generated requisitions to internal or external suppliers • View the status ofrequests online • Use internal requisitions to move inventory items from one inventory organization to another, even if that organization belongs to a different operating unit, legal entity, or ledger Major Features Complete Item Sourcing Definition Purchasing and Inventory combine to provide the flexibility you need to define your item sourcing information. You can use the default sourcing options to automatically determine the correct source type and source for yourrequests. You can specify either Inventory or Supplier as the default source type, as well as the source organization and subinventory for internal requests. Inter-Organization Shipping Network Inventory provides the features you need to define your inter-organization shipping network. For transfers between two organizations, you can specify whether to use intransit or direct shipments. You can also require internal orders for transfers between specific organizations. Flexible Processing You can tailor internal requisition processing to fit your requirements. You can limit online interaction by setting up background processes to automatically perform specific actions such as creating inventory replenishment requests and creating internal sales orders in Order Management. Or, you can take advantage of otherfeatures such as online requisition approvals, internal sales order cycles, and online receipt and delivery of internally requested items.
- 158. Creating Online Requisitions Youcan create online internal requisitions for both expense and inventory destinations using the same windows you use to create purchase requisitions. You can combine inventory and supplier sourced requisition lines on the same requisition. Also, Purchasing uses your item sourcing information to default the correct source type and supplier for the item and destination.You can define requisition templates for commonly requested internally sourced items. Full Unit of Issue Enforcement Purchasing offers the option of full unit of issue enforcement in which quantities entered on internal requisitions are automatically rounded to a full unit of issue defined for the item. You can also set this option to recommend a rounded quantity on requisitions, but leave the opportunity to change the recommended quantity. The quantity rounding is based on the specified unit of issue,if available, otherwise on the primary unit of measure. Inventory Replenishment Requisitions Inventory generates replenishment requisitions through min-max planning, reorder point planning, subinventory replenishment for replenishment counts,and Kanban replenishment. Purchasing uses youritem sourcing information to create inter-organization or subinventory transferrequests. See: Overview of Inventory Planning and Replenishment, Oracle Inventory User's Guide. See: Demand for Internal Requisitions, page 3-16. MRP Generated Requisitions MRP generated requisitions are sourced using the same item sourcing information that you define for inventory replenishment and online requisitions. For "buy" items, the Requisition Import process uses the item sourcing information to create either a purchase requisition or an inter-organization internal requisition for planned orders. Approvals and Controls You can control internal requisition approvals and document security just as you control purchase requisitions.Purchasing gives you the flexibility you need to set up approvals and limits for internal requests. You can use the same authorization rules, or you can relax or tighten controls for internal requisitions. Creation of Internal Sales Orders When you approve an internal requisition for a stocked item, Purchasing translates the requisition into an internal sales order, providing a link between the end user's requirement and the physical demand against Inventory. Order Management Once you create an internal sales order from a requisition, you can manage internal requisitions just as you manage regular sales orders. You can use Order Management to define order cycles, approvals and holds to effectively process requisition orders. You can selectively pick release and otherwise process internal sales orders as easily as you do regular sales orders. Complete Requisitions Status Visibility You get complete visibility on the status ofrequests through inquiries and reports. You get online visibility to the internal sales order number, as well as the shipment and delivery status for requisitions. You can report on backordered items, internal requisition status,and delivery discrepancies. Exception Processing Internal requisitions help you manage exceptions to your normal business flow. Order Management automatically backorders yourrequest when you have insufficient supply to fill the internal order by creating anothershipment line for the unavailable quantity. You can reschedule orders when the shipment date changes,and the expected arrival date on the intransit shipment is updated automatically. Cancellation of Requisitions You can easily cancel a request if you have a change in requirements or if you cannot fulfill the entire order. Using Order Management, you can partially or fully cancel the line quantities on the internal sales order. You complete the cancellation process by cancelling the original requisition line in Purchasing. Using Internal Requisitions Internal requisitions provide a flexible solution to your inventory requisitioning needs. You can eliminate user intervention when you do not need it, such as when you are loading internal requisitions into Order Management or placing demand. The following sections describe the entire business and information flow for internal requisitions, and identifies opportunities for you to simplify processing. Demand for Internal Requisitions Demand for inventory requests can come from several sources.The primary sources are: • Online user's request for stockitems out of inventory • Inventory Replenishment Requests • Oracle MasterScheduling/MRP and Supply Chain Planning generated requisitions • External system's requests Online Requests Online requisitions give you the choice of supplier or inventory sourced requisitions. Default sourcing information is determined by the requisition type, the item, and the destination of the request.When you enter a requisition, Purchasing automatically selects the correct source type and source information for the item and destination.
- 159. To restrict certainusers to internal requisitions only, set their profile PO: Legal Requisition Type to Internal.Purchasing then requires that they source all internally orderable items from inventory. See: Entering Requisition Headers, page 3-48. For frequently requested items, you can define requisition templates to create internal requisitions quickly. Requestors can pull up the template they need,fill in the need-by date and destination of the request,and specify the quantity for each desired item. Internal requisitions also use the Account Generator, which automatically builds account distributions. You can specify only one accounting distribution per inventory sourced line. See: Using the Account Generator in Oracle Purchasing, page E-6. Inventory Replenishment Requests Inventory automatically generates requisitions to maintain an item's stocklevel. The requisitions may request stockfrom an internal predefined source organization or from an outside supplier. See: Overview of Inventory Planning and Replenishment, Oracle Inventory User's Guide. Inventory generates replenishment requests automatically using the following methods: • Min-Max Planning • Reorder Point Planning • Subinventory Replenishments for Replenishment Counts • Kanban Replenishments All inventory replenishment methods create requisitions via the Requisitions Open Interface. Important: If the destination subinventory uses locatorcontrol, you must specify a primary locator for direct inter-organization and subinventory transfers. Tip: You can interface with third-party systems to enter count information and load it into Inventory using the Replenishment Interface. Inventory automatically creates replenishment requisitions using the source and planning method you define. Kanban Replenishments In a pull-based system,inventory items for a particular part or assembly area are replenished as soon as they are needed. When the items are needed,kanban cards in Oracle Inventory change their Supply Status to Empty, and Inventory generates the kanban replenishment request automatically. Then Requisition Import in Purchasing validates and imports replenishment requests as requisitions. If the Source Type of the request is Supplier, Purchasing creates a blanket release (if a blanket agreement exists) or a standard purchase order (if a valid quotation exists) for the item. If the Source Type is Inter-Org, Requisition Import generates an internal requisition for the item. See: Overview of Kanban Replenishment, Oracle Inventory User's Guide. See: Requisition Import Process, Once Purchasing approves the standard purchase order, blanket release, or internal requisition, Inventory automatically receives a status for the kanban card of In Process. In Purchasing, Kanban replenishment requests look like any other purchasing document, and you receive them like you do any other shipment. As soon as you receive the item for delivery through the Receipts or Receiving Transactions windows in Purchasing, Inventory automatically receives a status for the kanban request of Full, indicating that the inventory supply has been replenished. MRP Generated Requisitions MasterScheduling/MRP creates requisitions for "buy" items when you release them using the Planner Workbench. MRP generated requisitions are sourced using the same rules as online and inventory replenishment requisitions. However, since MRP is planning for the entire organization, inventory sourced requisitions for MRP planned orders must be inter-organization transfer requests.You cannot request subinventory transfers using internal requisitions for MRP planned orders, unless you specify a non-nettable source subinventory on the internal requisition. See: Viewing On-hand Quantities, Oracle Master Scheduling / MRP User's Guide. External Systems You can automatically import internal requisitions from other Oracle Applications or existing non-Oracle systems using the Requisitions Open Interface. This interface lets you integrate the Purchasing application quickly with new or existing applications. Purchasing automatically validates your data and imports your requisitions. You can import requisitions as often as you want. Then, you can review these requisitions, approve or reserve funds for them if necessary,and place them on internal sales orders. See: Requisition Import Process,page 13-29. Internal Requisition Approvals After you create an internal requisition, you can optionally require approval. For online requests,you can set up approval rules that are specific for internal requisitions, or you can share the same rules you use for purchase requisitions. If you do not require additional approval steps,you can set up rules so that you can always complete and approve the document in the Requisitions window. See: Entering Requisition Headers, page 3-48. Min-max planning, Reorder Point planning, and MRP generated requisitions are loaded as approved requisitions through the Requisitions Open Interface. If you set the Inventory Profile INV: RC Requisition Approval to Unapproved, you can optionally load Subinventory Replenishment requisitions as unapproved and use the document approval functionality in Purchasing. This profile option affects only Subinventory Replenishment requisitions. See: Submitting a Document for Approval, page 2-32. See: Oracle Inventory Profile Options, Oracle Inventory User's Guide. An internal requisition corresponding to a kanban card in Oracle Inventory enters Purchasing through Requisition Import with a status of Approved.(If encumbrance/budgetary controlis on, Purchasing sets the status to Pre-Approved.) As soon as the internal requisition is approved,Inventory automatically receives a status forthe kanban card of In Process. See: Demand for Internal Requisitions, page 3-16. See: Requisition Import Process, page13-29. Requisition supply is created for the destination organization as soon as the requisition is approved.If you create approved requisitions through Requisition Import, supply is created at the time the requisition is created. MasterScheduling/MRP and Inventory planning get complete visibility to the incoming internal requisition supply so the planning processes do not create additional reorders for items that you have already requested.
- 160. Creation of InternalSales Orders Once you approve inventory sourced requisition lines, Purchasing translates the requisition into an internal sales order, providing the link between the requestor's requirement and the physical demand against inventory. You run two separate batch processes to create the internal sales order from the approved requisition: • Create Internal Sales Orders. See: Create Internal Sales Orders Process,page 13-4. • Order Import. See: Order Import, Oracle Order Management Implementation Manual. Purchasing uses location associations to create internal sales orders from internal requisitions for a given deliver-to location. When you associate a customer and customer site with a location and then enter an internal requisition with that location as the deliver-to point, Purchasing uses the associated customerand customer site on the internal sales order that it creates. The associated customersite becomes the ship-to site for Order Management's ship confirmation. See: Defining Locations, page 1-18. See: Creating and Updating Customers, Oracle Receivables User's Guide. Internal orders are automatically scheduled by setting the Schedule Ship Date on the sales order to the Need-by Date from the requisition. If you specify a subinventory on the internal requisition line, Order Management reserves the goods and uses only the specified subinventory for allocation. If the goods do not exist at the specified subinventory,Order Management backorders them, even if they do exist in another subinventory. The Create Internal Sales Orders process loads the Order Management open interface, OrderImport, using the order type you define in the Purchasing Options window. See: Defining Internal Requisition Options, page 1-38. OrderImport creates internal sales orders from the records in the interface table, and determines the order cycle and defaults values based on the order type. Note: You should not drop-ship internal sales orders. See: Drop Shipments, page 4-114. Multi-Org: Creation of Internal Sales Orders Across Operating Units A Multi-Org implementation of Purchasing enables separate operating units within an organization to operate independently of each other. However, you may still need to obtain goods from anotheroperating unit, and Purchasing supports this. You can create an internal sales order for an item in anotheroperating unit. When creating this internal sales order, you must create it in the destination organization's operating unit, and all Order Management activity must take place within that destination operating unit. For example, the following table lists the generalized steps involved and indicate the organization in which they take place. StepAction Operating Unit 1 Inventory Org A Operating Unit 2 Inventory Org B 1- Create and approveinternal requisition. X 2- Run Create Internal Sales Orders. X 3- Run Order Import in Order. Management X 4- Perform pick release and ship confirm in Order Management. X 5- Receive goods. X When you use internal sales orders to transfer goods from anotheroperating unit, the items' transfer cost is posted to the intercompany payables and receivables accounts as defined in the shipping network and an intercompany invoice can be generated. See: Inter-Organization Shipping Network, Oracle Inventory User's Guide. Management of Internal Sales Orders You manage internal sales orders using some of the same windows as customer sales orders. Once you import an internal requisition using Order Import, you can use the Sales Orders window to change the reserved quantity, schedule date, ship-to contact,and shipment priority. The destination organization has complete visibility to any changes in incoming supply based on schedule date changes or partial shipments. The price on the internal sales order line comes directly from the price on the requisition line, and is always the item cost. Order Import does not use the price list to recalculate the line price and Oracle Receivables ignores internal sales orders. So the price on the internal sales order is not used. The profile option INV: Advanced Pricing for Intercompany Invoice actually controls the price on the intercompany payables invoice. When this profile option is set to No (or null), the price on the intercompany invoice is derived from the Transfer Price List associated to the customer or item. If set to Yes, the price is derived from the Advanced Pricing engine. See: Intercompany Invoice Pricing and Using Advanced Pricing Engine with Intercompany Invoicing, Oracle Inventory User's Guide. Once an internal sales order is scheduled,it is visible as demand. You can reserve inventory for internal requisitions either to the organization, or the organization and subinventory levels. Order Management does not process internal sales order lines for the Receivables Interface, even if the Receivables Interface is an action in the order cycle for the internal sales order. Note: You should not drop-ship internal sales orders. See: Drop Shipments, page 4-114. Pick Release for Internal Sales Orders You can directly pick release from the Shipping Transactions window. Or you can selectively release one internal sales order at a time by entering the internal sales order number as a pick release criterion. Or, you can release a group of internal sales orders by specifying the internal sales order, order type,and a range of dates,or by using the shipment planning delivery, trip, and trip stop information. You can also release internal sales orders with customer orders by entering a range of dates. When you enter an internal requisition, you must specify the source organization, and you can optionally specify the subinventory source. If you do not enter source subinventory information on an internal requisition, picking proceeds using the standard inventory picking rules.
- 161. Oracle Shipping Executionreleases only order lines which meet the prerequisites of the order cycle specific to the internal sales order type. See: Oracle Shipping Execution User's Guide. Ship Confirmation for Internal Sales Orders Use the Shipping Transactions window to ship confirm entire or partial shipments. You can also backorder the internal sales order when you do not have enough on-hand quantity to fulfill the request. Partial shipments are handled by splitting internal order lines into multiple shipment schedules with different delivery dates.You cannot change the warehouse or the subinventories on the delivery details. When you ship confirm, Shipping Execution updates the Inventory Interface and generates a delivery ship notice outbound (DSNO) transaction.Inventory automatically updates on-hand quantities to reflect the internally ordered items that you shipped. If you are shipping using intransit inventory, the destination organization gets complete visibility of the incoming intransit supply.Internal requisition supply is reduced by the quantity of the shipment. You can also enter the expected arrival date at ship confirmation to provide a more accurate supply picture to MRP and inventory planning. See: Oracle Shipping Execution User's Guide. Management of Internal Requisitions Update Intransit Information For inter-organization transfers that use intransit, you can use the Manage Shipments window to update the expected arrival date. Master Scheduling/MRP and inventory planning get complete visibility to the change in expected arrival date. See: Managing Shipments, page 9-81. Receive, Inspect,and Deliver Items Use the Receipts and Receiving Transactions windows to process receipts of inter-organization requests that use intransit. Receiving personnelcan simply enter the requisition number on the shipping documentation and process the entire shipment using express receiving transactions.For receipt of partial shipments, you can record the quantities for the individual items included in the shipment. You can receive items into receiving, or you can receive the goods directly to the final destination,either an inventory or expense location. If you receive items into receiving/inspection, you process inspections,transfers,and deliveries for internal requisitions just as you would process supplierreceipts or inventory transfers. See: Overview of Receiving, page 9-1. View Internal Requisition Status In Purchasing, you can view the internal sales order and any changes to it, by selecting View Sales Orders on the Tools menu in the Requisition Lines Summary window. Or, you can access the Sales Orders window directly in Order Management and query on the specific internal sales order number, or any otherrelevant criteria. The Sales Orders window provides information about the status ofthe internal sales order, quantities shipped,quantities cancelled, and dates of transactions. You can also report on requisition status.See: Backordered Internal Requisitions Report, page 11-6, Internal Requisitions Status Report, page 11-19, Internal Requisitions/Deliveries Discrepancy Report, page 11-20, and Requisitions on Cancelled Sales Order Report, page 11-77. Cancelling Internal Requisitions If you cancel an internal sales order that was generated by an internal requisition, you get a warning message that the order line is related to a requisition line that is now awaiting cancellation. You can then use the Control Document window to cancel the requisition line. See: Controlling Documents, page 2-57. Purchasing lets you cancel or final close an inventory sourced requisition line only after you cancel the internal sales order in Order Management. See: Cancelling Orders, Oracle Order Management User's Guide. Internal Requisitions Processing Summary Below is a summary of key transactions and processes you use forInternal requisitions. If you are using inventory replenishment or MRP generated internal requisitions, Pick Release and Ship Confirmation are the only required online transactions.If you are creating online requests,you also use the Requisitions window. See: Online Processing Automation for Internal Requisitions, page 3-30 for suggestions on howto implement automated processing and reduce online interaction. StepAction Required Window/Process 1 Create Internal Requisition On-line or AutomaticRequisitions window and Requisition Import process: Inventory replenishment, MRP Planned Orders, External Sources 2 ApproveRequisition OptionalApproveDocuments window 3 Create Internal Sales Orders AutomaticCreate Internal Sales Orders process, Order Import process 4 Modify Order Schedule OptionalSales Orders window 5 Pick Release Orders On-line Release Sales Orders for Picking window or Shipping Transactions window 6 Confirm Pick-Wave MoveOrder OptionalTransact MoveOrder window (if not auto-pick confirming from Pick Release window) 7 Ship Confirmation On-line Shipping Transactions window, Order Management Interface, Inventory Interface 8 Receive Items OptionalReceipts window, Receiving Transaction Processor 9 Inspect Receipts OptionalReceiving Transactions window, Receiving Transaction Processor StepAction Required Window/Process 10 Deliver Receipts OptionalReceiving Transactions window, Receiving Transaction Processor, Inventory Transaction Processor
- 162. 11 View RequisitionStatus OptionalRequisition Headers Summary window, Requisition Lines Summary window 12 Cancelling Internal Orders OptionalSales Orders window, Control Document window, Define Mass Cancel window, Run Mass Cancel window Internal Requisitions Setup Overview Internal requisitions provide a solution to a variety of inventory requisitioning needs. When you implement this feature, you need to carefully review the options and configure the applications to support yourbusiness processes. For example, if you are using internal requisitions to generate inventory replenishment requisitions and fulfill them via subinventory transfers within a plant, you may want to limit your online interaction to pick release and ship confirmation. You do not have to record separate ship, receive, and deliver transactions when the same employee actually picks the items out of the source subinventory and places them at the destination in one step. Product Internal Requisition SetupFunction Order Management Updateprofileoptions, Define transaction types, Defineorder number sources, Update/define default value rules, Define price lists, Define Concurrent Program Resubmission interval for the Order Import process Shipping Execution Define release sequence rules, Define pick slip grouping rules, Define shipping parameters Inventory Define internally requested items, Define inter-organization shippingnetwork, Define item sourcing, Define Concurrent Program Resubmission intervals in Inventory planning and replenishment windows Product Internal Requisition SetupFunction Purchasing Define Internal Requisition Deliver-To Sites, Set Legal Requisition Typeprofile, Define Purchasing Options, Define Concurrent Program Resubmission intervals for theRequisition Import and Create Internal Sales Orders processes Minimum Order Management Setup for Internal Requisitions You use standard sales order functionality to define transaction types for internal sales orders. You also need to use the Purchasing Options window to specify the order type you use for internal requisitions. See: Defining Internal Requisition Options, page 1-38. You must perform the following setups in Order Management to use the internal requisition features. You may choose to take advantage ofother Order Management features which require additional setups.See: Oracle Order Management Recommended Setup, Oracle Order Management Implementation Manual. Define Order Management Profile Options Set the profile option OM: Item Flexfield. This profile option defines which structure of the item flexfield to use. See: Order Management Profile Options, Oracle Order Management Implementation Manual. Note that Order Management uses the same ledger as defined in the System Options window in Oracle Receivables. See: Accounting System Options, Oracle Receivables User's Guide. Use the Parameters window in Order Management to define the Item Master organization for this installation. Tip: Set the Item Validation Organization to the same Item Master organization as yourpurchasing reference organization (set in the Financials Options window). See: About Financials Options, Oracle Payables User's Guide. Define Transaction Types Use the Transaction Types window to define order and line types.Order Management provides default order cycle workflows that you must associate with each order and line type. See: Defining Transaction Types, Oracle Order Management Implementation Manual. Define an Order Management Number Source For Internal Requisitions Define order number sources to automatically number internal sales orders as you import them. You can use a single order number source to assign unique numbers to all yourorders, or you can use a different order number source within each order type. See: Defining Order Number Sources, Oracle Order Management Implementation Manual. Define a Price List For Internal Requisition Although internal requisitions use the item's cost as the price, Order Management requires price lists to process all sales orders. Define a price list for use with the internal requisition order type. You do not need to add any lines to the price list. See: Defining a Price List, Oracle Order Management Implementation Manual. Decide which Default Value Rules to Use Default value rules define the defaulting that occurs as orders are entered or imported. Order Management provides default value rules that you can use for internal sales orders. Confirm that the default value rules that Order Management provides suit your business needs.If not, use the Defaulting Rules window to modify them. See: Defining Default Value Rules, Oracle Order Management Implementation Manual. Define Inventory Accounting (Account Generator) Order Management can dynamically create the Cost of Goods Sold (COGS) Account for each shipped or returned item based on rules you define. Order Management provides a default Account Generator process to be used in determining the COGS Account during the Inventory Interface process. You can either accept the default COGS Account Generator process or customize it to suit yourbusiness needs.For more information on how to accept or customize this feature, see the Oracle Order Management documentation. Internal Sales Orders Processing Constraints (Optional) Order Management processing constraints apply to all your sales orders, including internal sales orders imported from Purchasing. Processing constraints prevent users from adding, updating, deleting and cancelling order information beyond certain points
- 163. in the ordercycles. You can use the Systemrules Order Management provides, which prevent data integrity violations, or define your own, stricter, rules. See: Defining Processing Constraints, Oracle Order Management Implementation Manual. Minimum Shipping Execution Setup for Internal Requisitions Perform the following steps: • Define release sequence rules • Define pick slip grouping rules • Define shipping parameters See: Oracle Shipping Execution User'sGuide. Minimum Purchasing Setup for Internal Requisitions Define Internal Requisition Deliver-To Sites Purchasing uses locations to identify the final delivery location for both inventory and supplier sourced requisitions. As a requestor, you want to specify the same destination for both purchase and internal requisitions.As a shipping clerk, you are concerned with the final delivery location of the item, regardless whether it is for an internal or external customer. Purchasing and Order Management use location associations to minimize the decisions you need to make when you create internal requests. Use the Location window to define a location for each site that receives either inventory or supplier sourced material. See: Defining Locations, page 1-18. For internal requisition deliver-to locations, you also need to associate the locations with a customer. Use the Customers window to define a Customer and Ship-To site for each deliver-to location. Use the Business Purposes region in the Customers window to associate yourinternal locations to your customers. See: Creating and Updating Customers, Oracle Receivables User's Guide Tip: Create an internal customer for each destination organization, and customer ship-to site for each deliver-to location within the destination organization. Tip: Define the same address for the customer ship-to site as the deliver-to location. Order Management prints the ship-to address on the shipping documentation. Tip: Order Management requires both a ship-to and an invoice-to for each order, even though internal order lines are not invoiced. When you define a customer, either make the ship-to address both a ship-to and bill-to business purpose and set the Primary flag to Yes on the business purpose,or assign the ship-to to a bill-to location. Set Up Internal Requisition Approvals and Security You set up approval and security rules for internal requisitions just as you do for purchase requisitions. Use the Document Types,Positions,Position Hierarchies, ApprovalGroups, and Assign ApprovalGroups windows to set up approval and security options for internal requisitions. See: Setting Up Document Approval and Security Define Purchasing Options for Internal Requisitions You need to set up these additional purchasing options to use internal requisitions: • Order Type Pick the Order Type you defined in Order Management for internal sales orders. Purchasing uses this type to create sales orders from internal requisitions. See: Defining Internal Requisition Options, page 1-38. • Enforce Quantity Rounding In the Purchasing Options window, specify whether you enforce lot quantity rounding or display advisory messages when you create online requisitions using the Requisitions window. See: Defining Control Options, page 1-34 Minimum Inventory Setup for Internal Requisitions Define Internally Orderable Items When you define internally orderable items, there are a few attributes that require extra consideration. See: Defining Items, Oracle Inventory User's Guide. • Inventory and Order Management regions Items you use on internal requisitions must be Inventory enabled, internally orderable and stockable, shippable, and Order Management transactable for the source organizations. Under Inventory,you need to select the Inventory Item, Transactable, and Stockable options.Under Order Management, you need to select the Internal Ordered, Internal Orders Enabled, OE Transactable, and Shippable options. • Source Type - General Planning region Specify a default source type of Inventory or Supplier. You cannot create intra-organization internal requisitions for MRP planned items. When you specify sourcing information for MRP planned items, you need to ensure that you do not define an intra-organization sourcing rule for these items. • List Price - Purchasing region Inventory sourced requisitions use item costs for pricing. You may still want to specify a list price for items that are sourced both from suppliers or inventory. • Unit of Issue - Purchasing region You use units of issue to round order quantities,minimizing shipping, warehousing, and handling costs. Enter the unit of measure you typically use to issue the item from inventory. Purchasing uses this unit of measure as the default for internal requisition lines sourced from inventory when you create them in the Requisitions window. • Rounding Factor - Purchasing region Enter a number between 0 and 1. This factor determines how to round the quantity on an internal requisition that results from conversions between the requisition line unit of measure and the item's Unit of Issue. This factor ensures that the unit of issue resolves to an integer, rather than a fractional amount.
- 164. Purchasing either performsrounding automatically or advises you of the suggested quantity,depending howyou set up your purchasing options. Set Up Item Sourcing Internal requisitions use the sourcing information you specify in Inventory. All items, subinventories, and organizations may have item sourcing information specified for them. At each level (item, subinventory,or organization), you can choose whether items are replenished from inventory or purchased from a supplier. • Source Type Specify Inventory as the default source type if you want to source requests from an internal stocklocation. • Source Organization and Subinventory If you specify an item to be replenished from inventory, you must specify a source organization; a source subinventory is optional. When you place an order for this item, Inventory creates an internal requisition for the item from the source location. In case of a conflict between the item, subinventory,and organization levels, internal requisitions use the following order of precedence to determine the default source type and source for the item and destination: • Sourcing information specified in the item-subinventory relationship • Sourcing information specified in the subinventory definition • Sourcing information specified in the item definition • Sourcing information specified in the organization setup options Define the Inter-Organization Shipping Network Use the Shipping Networks window to define your inter-organization network. You must enable the network between each source (shipping) and destination (receiving) organization. • Internal Order Required Select Internal Order Required if you want all transfers between these two organizations to use internal orders. • Transfer Type Specify whether you ship material directly, or use intransit inventory for shipments between these two organizations. Important: If you use Lot, Serial, or Item Revision Control in both the source and destination organization, you must use intransit if you ship from an organization with less control (i.e. Lot Control), to an organization with more control (i.e. Lot and Serial Control). • Receipt Routing For intransit transfers, you can choose from the following primary receipt routings: Standard receipt, Inspection required, or Direct delivery. • FOB Point Specify whether the destination organization takes ownership of transferred items when they are issued to intransit (Shipment), or when they are received out of intransit (Receipt). • Transfer Charge Type Specify how you want to apply transfer costs to the destination organization. Choose either a predefined or requested percentage of the transaction value or a fixed amount that represents an added value. Set Up a Customer Association To define your organization as the destination for an internal requisition, Order Management has to recognize you as a customer. See: Defining Locations, page 1-18. See: Creating and Updating Customers, Oracle Receivables User's Guide Online Processing Automation for Internal Requisitions Internal requisitions provide a number of options to automate processing. You can set up the following processes to run automatically as often as you like to limit online interaction and streamline processing. See: Submitting a Request, Oracle Applications SystemAdministrator's Guide. • Reorder Point Planning Report • Min-Max Planning Report • Requisition Import • Create Internal Sales Orders • Order Import Tip: Create a report group to run all requests back-to-back over specific time intervals when you are using internal requisitions for automatic subinventory transfers. Internal Requisitions Example Purchasing provides flexible internal requisitions that you can tailor to meet your needs.Review the example in this section to better understand howyou can use internal requisitions. You are not required to manage internal requisition activities exactly as described in the following example. Rather, the objective of these examples is to highlight the flexibility of internal requisitions across a variety of situations. Oracle Manufacturing recommends that you experiment and review the results of different approaches to determine the best implementation of the internal requisition functionality for your unique needs. You should use this example as a starting point to better understand how you might use internal requisitions.
- 165. Example Overview Global Computers,Incorporated is a computer manufacturer with organizations in Austin,TX and Sacramento, CA. The Austin organization repetitively manufactures plastic components and uses the components,along with purchased items, to assemble base and cover assemblies in the Sacramento organization. Ownership of inter-organization transfers between Austin and Sacramento changes hands at the time of receipt (FOB Point: Receiving). The Sacramento organization uses the Austin base and cover assemblies to assemble configurations of Sentinel computers. Sacramento also has a local sales offices for customer visits and demonstrations.Your salespeople distribute sales brochures during customer visits. Employees can request Sentinel Computers for their own use, as well as mouse pads and wrist pads for their offices. Define the following items at Global Computers: Item Description A54888 Sentinel Base Assembly Assembled in Austin, Sub Assembly of SentinelComputer, Internally Orderable in Austin, Default Source Typeof Inventory, Default Source Organization of Austin, Default Source Subinventory of Repetitive Assembly S86662 Sentinel Cover Assembly Sub Assembly of SentinelComputer, Assembled in Austin, Internally Orderable from Austin, Default Source Typeof Inventory, Default Source Organization of Austin, Default Source Subinventory of Repetitive Assembly S56302 Sentinel Computer Assembled in Sacramento, Internally Orderable by Employees C13139 Hard Drive Used in Sentinel Base Assembly S85773 Sales Brochure Purchased from external suppliers, Stocked at Sacramento for internal use, Limited quantities on hand at the sales office M1002 MousePad Purchased from external suppliers, Stocked at Sacramento for internal use M1002 Wrist Pad Purchased from external suppliers, Stocked at Sacramento for internal use Define the following subinventories at Global Computers: Organization Subinventory Austin AUS-FinishedGoods: Contains completed SentinelBase Assemblies, Contains completed SentinelCoverAssemblies, Tracked - asset subinventory Austin Repetitive Assembly: Contains Hard Drives for final assembly in WIP, Uses Min/Max replenishment to signal replenishment, Request from AUS-Stores subinventory Austin AUS-Stores:Contains additional supply of Hard Drives, Tracked - asset subinventory Organization Subinventory Sacramento SAC-FinishedGoods: Contains completed Sentinel Computers, Tracked - asset subinventory Sacramento SAC-Stores:Contains completed SentinelBase Assemblies shipped from Austin, Contains completed SentinelCoverAssemblies shipped fromAustin, Tracked - asset subinventory Sacramento Office Supplies:Contains supply of Wrist Pads and Mouse Pads for internal use, Not tracked - expense subinventory Sacramento Storage:Central storage for excess Sales Brochures, Tracked - asset subinventory Sacramento Visit Center:Contains local supply of SalesBrochures for customer visits, Space for only 100 Sales Brochures, Not tracked - expense subinventory Inventory Replenishment Request (Manufacturing) You use one Hard Drive during the assembly of each Sentinel Base Assembly, and keep a limited supply of the Hard Drives in yourRepetitive Assembly subinventory. As you consume Hard Drives from the Repetitive Assembly, you want to automatically send inventory replenishment requests to transfer additional Hard Drives from your Stores subinventory.The material handler needs to receive the inventory request and transfer the material before you run into a shortage situation. You create a report group that submits the Min-Max Planning, Requisition Import, Create Internal Sales Orders, and Order Import processes every two hours. As soon as the Hard Drive supply in the Repetitive Assembly subinventory drops below the minimum quantity,the next run of the Min- Max Planning process automatically creates a replenishment order for the reorder quantity. The reorder uses the item sourcing information to automatically create an intra-organization request in the Austin plant to move Hard Drives from Stores to the Repetitive Assembly subinventory. The request is automatically loaded as an internal requisition and an internal sales order, providing visibility of the request to the material handlers in the Austin plant. The material handler also runs Pick Release every two hours to identify the pull requests from the shop floor subinventory. The next run of Pick Release creates a move order line for the subinventory transferof Hard Drives. The material handler picks the Hard Drives out of the Stores subinventory,completes a ship confirmation and replenishes the Repetitive Assembly subinventory before a shortage occurs. At ship confirmation, the on-hand balances of the two subinventories are automatically updated. MRP Generated Inter-Organization Request (Manufacturing) You use Oracle Master Scheduling/MRP and Supply Chain Planning in Sacramento to schedule production of the final assembly of the Sentinel Computer. The Sentinel Base Assembly and Sentinel Cover Assembly are provided by the Austin organization, so you define these items as "buy" items in Sacramento. You also specify the following sourcing information for the item: • Source Type - Inventory • Source Organization - Austin • Source Subinventory - AUS-Finished Goods MasterScheduling/MRP recommends that you produce 400 Sentinel Computers to fulfill demand over the next four weeks (100 each week), and you only have 100 Sentinel Cover Assemblies and 100 Sentinel Base Assemblies on hand in Sacramento. You need five days to ship material from Austin to Sacramento, so the planner implements planned orders for 100 Sentinel Cover Assemblies and 100 Sentinel Base Assemblies for the next three weeks using the Planner Workbench. When the planner releases the planned orders for Sacramento, Master Scheduling/MRP automatically loads the Requisitions Open Interface and submits Requisition Import.
- 166. Requisition Import usesthe sourcing information that you set up to create a requisition line for each week sourced from the Austin AUS- Finished Goods subinventory. In the background, the Create Internal Sales Orders and Order Import processes automatically load the internal sales order against the Austin organization. What if you have a three day production delay in Austin and you need to delay the third shipment of Sentinel Base Assemblies for a few days? Sacramento needs visibility to the delay to adjust the production schedules of the final assembly of the Sentinel Computers. In Austin, you can use the Sales Orders window to update the scheduled shipment date by three days,or choose a different freight carrier for faster delivery if you need to expedite the shipment to prevent a shortage in Sacramento. When you ship the third shipment from Austin, you can update the expected arrival date, giving the planner and MRP in Sacramento full visibility of supply changes. Each ship confirmation of the Sentinel Base Assemblies creates an intransit shipment from Austin to Sacramento. You do not require inspection of your own inter-organization transfers, so the receiving clerk in Sacramento receives directly into the Final Assembly subinventory when the shipment arrives. The intransit inventory balance is automatically updated and the inter-organization accounting entries are created along with the receipt transaction. Inventory Replenishment Request (Office Stock Locations) In the Sacramento sales office, you use internal requisitions to replenish your stock of Requisitions 3-35 sales brochures in the Visit Center. Sales representatives use your brochures well, and most customers take brochures with them after the visit. You want easy access to brochures in the Visit Center, but only have room for 100 Sales Brochures. You typically use about 75 a week, but the number fluctuates with sales activity. Sales representatives take what they need; you do a stock count on Monday and Wednesday ofeach week and replenish whenever the stock count falls below 25. You need to define min-max information for the Sales Brochures that you stock in the Visit Center subinventory.Use the Item Subinventories window to specify a planning method of Min-max planning, a minimum quantity of 25, and a maximum quantity of 100. Requisition Import creates an approved internal requisition for subinventory transfers, and the sales order is automatically loaded. The material handler reviews the picking slip, pulls the 80 Sales Brochures from Storage Subinventory and delivers them to the Visit Center. After delivering the material the handler records the shipment using the Confirm Shipments window. The shipment, receipt, and delivery information is recorded at once, and the on-hand balance of the Storage subinventory is updated automatically. Inventory automatically creates the necessary accounting entries to reduce the overall value of Sales Brochures in the Storage subinventory and charges the accounts associated with the Visit Center subinventory. Online Request for Goods out of Inventory In Sacramento, you stocklow-cost office supplies on site to provide quick delivery to your employees. Employees can request items that are sourced from suppliers or inventory, but they do not know the source type at the time of the request. You also require internal requisitions to process requests for goods out of the stock locations. You have a company policy to always request items from Office Supplies whenever possible.You do not require any additional approvals, and a material handler picks the items out of inventory and delivers them directly to your office. A one day turnaround time is required for all internal requests. As a requestor, you want to order the following items to improve your comfort and productivity: • Sentinel Computer • Mouse Pad • Wrist Pad • Glare Screen (not stocked on site) Use the Requisitions window to create your request.Since company policy dictates that you request items from inventory whenever possible, the default requisition type is 3-36 Oracle Purchasing User's Guide Internal Requisition and the default source type is Inventory. When you create the four requisition lines for your items, Purchasing automatically uses the item sourcing information to source the Sentinel Computer from the SAC-Finished Goods subinventory.Since the Glare Screen can only be purchased from suppliers, Purchasing sets the source type to Supplier and uses yoursourcing rules and Approved Supplier List entries to determine the suggested supplierand document information. See: Automatic Sourcing, page 5-24. See: Approved Supplier List, page 5-35. Material handlers need immediate visibility of your requests to be able to deliver in 24
- 167. hours.The systemadministrator setsthe Create Internal Sales Orders and OrderImport processes to run every hour for internal sales orders. The material handler in charge of the Office Supplies subinventory runs Pick Release twice a day to generate pick slips. The material handler reviews the picking slip, pulls the Mouse Pad and Wrist Pad from Storage and delivers them to youroffice. After getting your signature, the handler records the shipment using the Confirm Shipments window. The shipment, receipt, and delivery information is recorded at once, and the quantity delivered on the internal request is updated. Office Supplies is an expense subinventory,and the correct accounts are charged when you receive the supplies into this subinventory.Since you are sourcing from an expense subinventory,ship confirmation does not generate any accounting entries for the issue of the items from the Office Supplies subinventory to youroffice location. A separate material handler receives the Sentinel Computer request,and picks and ships it from the SAC-Finished Goods subinventory.When you complete the ship confirmation, Inventory automatically issues the Sentinel Computer out of the SAC-Finished Goods asset subinventory to the expense location listed on the requisition. Inventory and Purchasing also record the accounting transactions to credit the SAC-Finished Goods asset account and debits the appropriate charge account listed on the requisition. Finding Requisitions Use the Find Requisitions window to: • Access the Requisitions window. • Perform requisition inquiries at header, line, and distribution levels Depending on the function security assigned to your responsibility, you have varying levels of access to information. A responsibility defines an application user's current privileges while working with Oracle Applications.See: Function Security for Purchasing, page D-1. To entersearch criteria: 1. Navigate to the Find Requisitions window. Then enter as many as desired of the search criteria described in the following steps. 2. Select the Operating Unit for this search. 3. Enter the requisition number. If you enter a requisition number, you can also enter a Line number. 4. Select the requisition Type (Purchase or Internal). 5. Enter the Preparer. 6. Enter the Requestor. 7. Enter the Buyer. 8. Select Yes or No to restrict the search to Modified requisitions. 9. Enter the Reference Number. 10. Enter the Import Source. 11. Enter the Line Type. 12. Use the tabbed regions to further restrict the search: • In the Item region, you can enter the following search criteria: Item number, Revision number, Category, item Description, and Supplier Item number. • In the Status region, you can limit the search by Approval status (Approved,Incomplete,In Process,Pre-Approved, Rejected, or Returned), Control status (Open, Cancelled, or Finally Closed), or Reserved status (Yes or No). • In the Date Ranges region, you can enter date ranges for the following dates:Creation, Need By, and Closed. • In the Sourcing region, you can limit the search by Source (Supplier or Inventory). For Supplier sourced requisitions, you can further limit the search by Supplier, Site, and Currency. For Inventory sourced requisitions, you can further limit the search by Organization and Subinventory. If you have enabled vendored managed inventory, you can limit your search results to those items by checking the VMI box. • In the Deliver To region, you can limit the search by Destination Type (Expense, Inventory,or Shop Floor), Organization, Location, and (for Inventory destinations only)Subinventory. • In the Related Documents region, you can limit the search by Document Type, Document number and Line Number, Purchase Order number, and drop shipment Sales Order number. • In the Accounting region, you can limit the search by Period, GL Date, Charge Account,Budget Account,and whether there are Active Encumbrances (Yes or No). • In the Projects region, you can limit the search by Project or Task number. 13. Select the Results group (Headers, Lines, or Distributions) to determine which summary window to open. Depending on the search criteria you have specified, all summary windows may not be available. For example, if you specify criteria in the Accounting region, only the Distributions summary window is available. 14. Select the Find button to initiate the search and open the appropriate Summary window. To clearexisting search criteria: • Select the Clear button to clear any existing search criteria.
- 168. To entera newrequisition: •Select the New button to open the Requisitions window. See: Entering Requisition Headers,
- 169. Practice - CreateInternal Requisitions Overview In order to use internal requisitions, you must have Oracle Inventory, Oracle Order Management,and Oracle Purchasing installed. Order Management is used to track internal sales orders. To enter an internal sales order, you must start with a requisition in Purchasing. Steps for this practice: Create an internal requisition in Oracle Purchasing Instructor will run processes in Oracle Order Management Verify the shipment of your internal order in Oracle Purchasing R12: What Are The Steps Required To Setup An Internal Requisition In Purchasing? (Doc ID 1384716.1) Goal Solution Step 1 - Creating the Item Step 2 - Creating the Shipping Network Step 3 - Create the Internal Location Step 4 - Conduct a Miscellanies Transaction (Receipt) Step 5 - Create the Internal Customer - Assign the Location Step 6 - Item Price Information Step 7 - Creating the Requisition Step 8 - Submitting the Create Internal Orders Concurrent Request Step 9 - Import the Internal Sales Order Step 10 - Execute Pick Release/Ship Confirm Step 11 - Conduct the Receipt in the Destination Organization Step 12 - Confirm the Quantity is Delivered SOLUTION Test case Scenario : The following setups will demonstrate the flow of an Internal Requisition between two inventory organizations. M1 - Seattle Manufacturing will represent the destination organization M2 - Boston Manufacturing will represent the source organization In this example, the item will be procured internally from the M2 - Boston Manufacturing inventory organization The following responsibilities are utilized in this example: Purchasing Super User (or equivalent) Order Management Super User, Vision Operations (USA) Inventory Step 1 - Creating the Item Purchasing Super User - Navigation: Items/MasterItems
- 170. Enter the ItemName Ensure it is Purchased and Purchasable Enter the Item Name Ensure it is Purchased and Purchasable
- 171. Select these attributes: CustomerOrdered and Customer Orders Enabled Shippable Internal Ordered Internal Orders Enabled OE Transactable Assign the item to the inventory organizations which are involved in the Internal Requisitioning process. M1 will be the destination inventory organization and M2 will be the Source Inventory Organization. Step 2 - Creating the Shipping Network Inventory: Navigation: Setup/Organizations/Shipping Networks
- 172. Enter the InventoryOrganization that will be the Source and the scope should be From or To Organizations Choose the Transfer Type: Direct - means that when the Internal Sales Order is shipped the receipt process in the destination organization 1. is done automatically 2. Intransit - means that when the Internal Sales Order is shipped - the destination inventory organization has to manually do the receiving process in Purchasing Choose Internal Order Required checkbox - Save In this example, the setups are being done to allow the user to Enter a Receipt in SH1 after the item has been shipped from SH2 (Intransit). Please Note - If the Source and Destination Inventory Organizations are the same, then this step is conditionally not required. (Essentially the Item is being transferred between subinventories in the same Inventory Organization). Step 3 - Create the Internal Location Purchasing Super User: Setup/Organizations/Locations Enter a Location Name - for the Internal Location This is the location that is used as the Destination Location The Location will eventually be tied to a customer Choose the Other Details tab, enter the Inventory Organization for the Destination Organization. The location created will be used to tie the Destination Location in the requisition form to the Internal Customer to be used on the Sales Order form. Purchasing does not allow the entry of a Customer - therefore it passes the location to Order Management.
- 173. During Order Importin Order Management - the systemlocates the Customer Record to which the Location is assigned.Associating the location to the customer record will be done in the later steps. Step 5 - Create the Internal Customer - Assignthe Location Order Management Super User: Navigation: Customers/Standard A web based form will open,choose the Create button in the lower left. Enter the Customer Name - in the Organization Name field. Choose the Profile Class that applies to the customer. Ex. Excellent.
- 174. Scroll further downand enter the Address details for the Internal Customer. Move to the bottomof the form and under Business Purposes - Choose Add AnotherRow. Set the purpose for the new row as 'Ship To' Choose the Save and Add Details
- 175. Move to thebottomof the page, and the address should be visible. Choose the Details icon The Account Site Information will appear, select the Business Purposes tab
- 176. The Ship Toand Bill To should now be visible. Select the Details icon to the right of the Ship To
- 177. Under the OrderManagement section,there is a field 'Internal Location' Enter the Location that was created in Step 3 (Ex. M1-Internal Location) Apply and save the record PLEASE NOTE: The Customer must be created in the Operating Unit of the Source Inventory Organization that is used on the Internal Requisition. You can check the Operating Unit for the Source Inventory Organization by using the following sql: select 'The Inventory Organization ' ||oo.organization_code||'has the inventory organization ID of ' ||oo.organization_id||' and is underthe Operating Unit' ||hro.name||' which has the Operating Unit ID of '||oo.operating_Unit from org_organization_definitions oo, hr_all_organization_units hro where upper(oo.organization_code) like upper('%&INV_ORG_CODE%') and hro.organization_id = oo.operating_unit; Pass in the Source Inventory Organization Code - and then ensure the Customer is created in the Operating Unit for the Source Inventory Organization. Step 6 - Item Price Information Purchasing Super User: Items/Master Items The price used on the requisition comes from the item costs section. Query back the item Choose from the top text menu - Tools/ItemCosts The screen to follow shows the item price that is used when creating the Internal Requisition. This is how purchasing derives the price when creating the Internal Requisition. It uses the price for the Cost - in the Source Inventory Organization. Whateverthe price is in the Source Inventory Organization used on the requisition - the price is derived. The reason is that the Sales Order is being created in the Source Organization, so the price in the Source Organization must be used. Step 7 - Creating the Requisition Purchasing Super User: Navigation - Requisitions/Requisitions
- 178. In the OrderType Field - change the Order Type to Internal Click into the Lines Region on the Item field At this point - look to the Destination fields - this information is fetched from the Employee Record If the Destination Inventory Organization is not proper - move to that field and change it If the Location is not the internal location - move to that field and change it to the new Internal Location Approve the requisition. Question: Why is the Following Error message encountered : 'Destination location requires customer association.' The reason for this error is that the code is trying to match the Location that is currently entered on the form to a customer, and the customer association is not found. This was done earlier in step 5. The solution to this error is to setup the employee record to default a location that was associated with a customer (as in step 5 above) or prior to entering the item, move to the destination section of the form and enter an inventory organization and location that is properly assigned to a customer, followed with entry of the item. Question: Why is the Source Inventory Organization Not showing the inventory organization which was setup in the shipping networks? If the internal requisition is going to be for a cross operating unit scenario - then it should be noted that the HR: Security Profile is used. Both operating units for which the inventory organizations belong too must exist in the HR: Security Profile. To confirm the operating units for the inventory organizations - this sql can be used: SELECT oo.operating_Unit OU_id, hro.name Oper_Unit, oo.organization_code inv_org FROM org_organization_definitions oo, hr_all_organization_units hro WHERE oo.organization_id in (207, 204) and hro.organization_id = oo.operating_unit; Confirm that the operating units in the given output exist in the security profile that is set for the HR: Security Profile - profile. Step 8 - Submitting the Create Internal Orders Concurrent Request Purchasing Super User: Navigation - Reports/Run
- 179. This process isresponsible for inserting data into the Order Management interface Tables. One of the fields that is inserted is the location_id - and because Order Management uses Customers rather than locations - this is why it is mandatory to assign the Internal Location to the Customer. The location that is passed from purchasing is correlated to a customer so as to allow the Order Import to run successfully. Please note that the calculate_price_flag is inserted as N into the Order Management interface tables. This means that Purchasing is going to pass the price and it will not be impacted or recalculated when imported into Order Management. This is proper functionality. We are currently tracking on Enhancement Request Bug 3095239 that would allow the use of an Internal Price List.
- 180. The following sqlcan be used to review the data in the oe_iface tables. SELECT * FROM OE_HEADERS_IFACE_ALL WHERE order_source_id = 10 AND orig_sys_document_refIN (SELECT REQUISITION_HEADER_ID FROM PO_REQUISITION_HEADERS_ALL WHERE segment1 = '&requisition_number'); SELECT * FROM OE_LINES_IFACE_ALL WHERE order_source_id = 10 AND orig_sys_document_refIN (SELECT REQUISITION_HEADER_ID FROM PO_REQUISITION_HEADERS_ALL WHERE segment1 = '&requisition_number'); Pass in the requisition number when prompted. Question: How can the interface data for Internal Requisitions be viewed in the Order Management Module? This is possible using the Order Management Responsibility - and navigating to Orders/Import Orders/Corrections Choose an order type of Internal In Order Reference use the List of Values to locate the Requisition Number If the Requisition is not located - it has either been created into a Sales Order or not inserted into the tables by the Create Internal Orders program The records are viewable at this stage and can be deleted. PLEASE NOTE - if records are going to be deleted, it is necessary to Delete the Lines first and then the header Be sure to choose Lines first - and then choose the delete icon from the toolbar - then delete the header Deletion of the header record will NOT delete the line - it is not a cascade delete option. If the headeris deleted prior to the line - it is not possible to ever again locate the line in this form - sqlplus will have to be used to remove the line. Enhancement Bug 4966920 has been created to improve this form and add the cascade delete functionality and now is implemented with the following Patch 13702362 - AFTER HEADER IS DELETED, ORPHAN DATA IS LEAVED IN SALES ORDER INTERFACE TABLES>> Question: How can the Internal Requisition be resubmitted to the Order Management interface tables? In the po_requisition_headers_alland po_requisition_lines_all table there is a column 'transferred_to_oe_flag '. Setting this column to a value of 'N' followed with a run of the Create Internal Orders process will again post the requisition data into the Order Management interface tables.There are currently no options available through the Oracle Purchasing forms that allow the updating of this flag, so sqlplus would have to be used. Question (Problem): When Running the Create Internal Sales Order Process - it completes with Success
- 181. But no recordsare inserted into the Order Management Interface Tables? When the internal requisition is created the code needs to validate that the customer was created in the Operating Unit that the Source Inventory Organization belongs too. When the Create Internal Sales Order process runs,if the Deliver to Location is not tied to a Customer Ship To Site in the Operating Unit of the Source Inventory Organization used on the requisition - then it will not insert data into the oe_headers_iface and oe_lines_iface table. Please review the previous step 5 and use the sql given to ensure that the Customer was created in the Operating Unit that belongs to the Source Inventory Organization. For this example, it would be required to check the Purchasing Options for the Operating Unit which M2 is belonging too. VERY IMPORTANT ALSO REGARDING Create Internal Orders In Release 12 you must make sure that you are choosing an Order Type in the Purchasing Options - that was created in the SAME operating unit for the Purchasing Options you are setting up. Ex. If you are in the Germany Purchasing Options - then ensure you choose a Order Management Order Type that was created in Germany Order Management. BEWARE - The list of values for Order Type is showing Transaction Types from other Operating Units. So, if you are in Germany Purchasing Options and then choose a France Created Transaction Type - no Records will be inserted during the Create Internal Orders Process.This is fixed in Release 12.1.1 and beyond. Also, remember that whatever the Source Inventory Organization that is used on the Internal Requisition - the purchasing options must be setup for that Source Organizations Operating Unit. So if the internal requisition has two inventory organizations from different Operating Units - ensure the Purchasing Options have been setup for both of the Inventory Organizations Operating Units - as the code is going to check the Purchasing Options from the operating unit of the Source Organization to obtain the Order Type to use - as the Sales Order is going to be created in the Source Organizations Operating Unit. Question: Does the Purchasing Create Internal Orders process pass flexfield values from the Purchase Requisition? Currently, the Create Internal Orders process does not pass any values from flexfields. If there are mandatory/required flexfields setup on the Order Lines table in Order Management, a value will have to be defaulted as a default value from some other method in order for the import process to complete successfully. Step 9 - Import the Internal Sales Order Order Management Super User: Navigation: Orders,Returns/Import Orders/Order Import Request Enter these values:
- 182. Operating Unit -Operating Unit of the Source Inventory Organization (Ex. M2) Order Source - Internal (or the order type being used Order Reference - Requisition Number Submit the request.Confirm that it completes. Navigating to Orders,Returns/Order Organizer Enter the requisition number in the Find form Confirm that the Internal Sales Order was created from the import
- 183. Question: Can theprice be updated adjusted during the Order Import? The calculate price flag is frozen and the price cannot be changed.This is based on the values inserted by the Create Internal Orders process from Purchasing. Question: Where is the schedule Ship Date coming from? The scheduled ship date is passed from the requisition Need By Date, it cannot be defaulted any differently. Question: How is the Order Type being chosen? This is coming from the Purchasing Options - Responsibility Purchasing Super User - Setup/Organizations/Purchasing Options. The following queries can be used to confirm that the Internal Sales Order was created. SELECT * FROM OE_ORDER_HEADERS_ALL WHERE order_source_id = 10 AND orig_sys_document_refIN (SELECT REQUISITION_HEADER_ID FROM PO_REQUISITION_HEADERS_ALL
- 184. WHERE segment1 ='&requisition_number'); SELECT * FROM OE_ORDER_LINES_ALL WHERE order_source_id = 10 AND orig_sys_document_refIN (SELECT REQUISITION_HEADER_ID FROM PO_REQUISITION_HEADERS_ALL WHERE segment1 = '&requisition_number'); Pass the requisition number into the script when prompted. Step 10 - Execute Pick Release/Ship Confirm Set Shipping Role For User Order Management Super User: Shipping/Transactions Enter the field - From Order Number - give the Internal Sales Order Choose Find From the Actions - choose Launch Pick Release Once the Pick Release has been completed, requery the Internal Sales Order in the shipping transactions form.
- 185. The field 'NextStep' should now be showing Ship Confirm. Choose the Delivery tab While in the Delivery form, choose actions 'Ship Confirm'
- 186. The Ship Confirmsubmission form appears. Ship Entered Quantities Create Delivery for Staged quantities Close Trip The selections above were all defaulted into the ship confirm submission form. Choose OK. Requiring the record shows that the Next Step is to Run Interfaces. This represents running the Interface Trip Stop process. In this example, the Interface Trip Stop ran automatically.
- 187. Navigation: Shipping/Interfaces/Run -Interface Trip Stop If required, run the Interface Trip Stop process for the Trip that was created. Confirm that it completes with success. The shipping process in M2 will also automatically create the receipt in M1 - if the Shipping Network was setup to have a transfer type of Direct. For this example, Intransit was used to as to be able to demonstrate the receiving process. Step 11 - Conduct the Receipt in the Destination Organization Purchasing Super User: Receiving/Receipts Upon entering the Receiving form, search based on the requisition number.
- 188. Select the linefor Receipt - and save the record. The Receiving Transaction Processor will be engaged and the item will be transacted into the M1 - Destination Inventory Organization.
- 189. Navigating to Receiving/ReceivingTransactions Summary - it is possible to search on the requisition and view the completed Receiving Transactions. Step 12 - Confirm the Quantity is Delivered Purchasing Super User: Requisitions/Requisition Summary Querying the requisition lines, it is possible to view the quantity delivered - giving confirmation that the Sales Order was shipped from the source inventory organization (M2) and receipted into the destination inventory organization (M1).
- 190. Purchasing Document Flow PurchasingDocument Flow A requisition is generated either manually or by the system, which may be turned into a purchase order by the buyer. Sometimes the buyer decides a request for quotation (RFQ) is required by other suppliers to determine the best price for the goods or services requested. Once the quote is received back, that information can be used to finalize the purchase order.
- 191. Purchase Order Types PurchaseOrder Types In Oracle Purchasing there are several different types of purchase orders designed to satisfy different business requirements. Standard Purchase Order (PO) A one-time commitment to purchase goods or services. You create standard purchase orders when you know the details of the goods or services, estimated costs, quantities, delivery schedules, and accounting distributions. Planned Purchase Order A long-term purchase agreement committing you to buy goods or services. Planned purchase orders include tentative delivery schedules and accounting distributions. Create planned releases to authorize suppliers to ship. Blanket Purchase Agreement A long-term agreement allowing for stable pricing over the life of the agreement, while also allowing flexible order quantity commitments and delivery schedules. Pricing on blanket purchase agreements can include break pricing. You typically use this agreement when negotiating volume discounts on individual items. Create blanket releases to authorize suppliers to ship. Contract Purchase Agreement A master terms and conditions document. Typically use contract purchase agreements when negotiating pricing on a volume of business to manage terms and conditions. Suppliers are authorized to ship through standard purchase
- 192. order lines referencingthe contract. Contracts can be coupled with a catalog quotation to reference pricing on a per item basis. Global Agreement (not shown above) A special type of purchase agreement that is similar in structure to a blanket purchase agreement. Using global agreements, buyers can negotiate enterprise-wide pricing, business by business, then execute and manage those global agreements in one central shared services environment. Organizations within the enterprise then access the agreement to create purchase orders that leverage the pre-negotiated prices and terms. Note: Global agreements can be either Blanket or Contract Purchase Agreements.
- 194. Practice - Createa Blanket Purchase Agreement and Blanket Release Overview In this practice, you will do the following: Create a blanket purchase agreement for two items which will establish pricing for the items, although the quantity and delivery dates/locations are not known. Create a blanket release against the agreement for your first order of these items. Tasks Log on to the System Create a blanket purchase agreement Enter your first item - Paper Enter price breaks for volume purchases Enter your second item - Desk Enter price breaks for volume purchases Enter notification controls so that you’ll be warned by the system of certain situations that are either expected or might occur with this blanket purchase agreement. Submit your purchase agreement for approval Issue a blanket release to place your first order against the agreement Submit your blanket release for approval Increase your quantity ordered to 3 so that the release will be above the minimum release amount Submit your blanket release for approval Return to the Blanket Purchase Agreement to view how it was updated as a result of the release Run the Purchase Order and Releases DetailReport
- 195. Solution - Createa Blanket Purchase Agreement and Blanket Release Log on to the System Responsibility = Purchasing, Vision Operations Create a blanket purchase agreement 1. Navigate to the Purchase Orders window (N) Purchase Orders > Purchase Orders Operating Unit = Vision Operations Type = Blanket Purchase Agreement Supplier = Elshayeb Corporation Site = CAIRO V Ship-to = M1- Seattle Mfg Bill-to = V1-New York City Amt Agreed = $20,000 2. Navigate to the Terms and Conditions window (B) Terms Payment = 45 Net (terms date + 45) Pay On = Blank Agreement Controls/Effective Dates = Enter dates starting Today and extending for one year Amount Limit = $21,000 Minimum Release = $50
- 196. 3. Close Termsand Conditions window 4. Save Enter your first item - Paper 5. (T) Lines Num = 1 Item = DD-00160-0105-01 Price = 20
- 197. Enter price breaksfor volume purchases 6. Navigate to the Price Breaks window (B) Price Breaks Enter the following price breaks for this item: Num Org Ship-to Quantity Break Price 1 SH1 M1-Seattle 10 $19.00 2 SH1 M1-Seattle 20 $18.00 3 SH1 M1-Seattle 30 $17.00 7. Save Enter your second item - Desk 8. (T) Lines Num = 1 Item = DD-00160-0110-01 Price = $1,000.00 Enter price breaks for volume purchases 9. Navigate to the Price Breaks window (B) Price Breaks 10. Enter the following price breaks for this item Num Org Ship-to Quantity Break Price 1 SH1 M1-Seattle 5 $950.00 2 SH1 M1-Seattle 10 $900.00 3 SH1 M1-Seattle 15 $850.00 11. Save
- 198. Enter notification controlsso that you’ll be warned by the system of certain situations that are either expected or might occur with this blanket purchase agreement. 12. Close the Price Breaks window 13. Navigate to the Notification Controls window (M) Tools > Notification Control 14. Enter controls to warn you of upcoming expiration of the agreement 120 days prior and 60 days prior to the effective end date. Condition Warning Delay From To % Amount Expiration 120 Defaults Defaults N/A N/A Expiration 60 Defaults Defaults N/A N/A 15. Enter controls to warn you if by 6 months into the agreement, you haven’t released at least 50% of the amount agreed. Condition Warning Delay From To % Amount Amount Not Released N/A Today Six Months from Today 50 Default 16. (B) Done 17. (B) OK Submit your purchase agreement for approval 18. Navigate to the Submit for Approval window (B) Approve Submit for Approval = Check box Uncheck all other options 19. (B) OK 20. Ensure that the status on the purchase order header is Approved and record your blanket number __________
- 199. Issue a blanketrelease to place your first order against the agreement 21. Navigate to the Releases window (N) Purchase Orders > Releases Operating Unit = Vision Operations PO, Rev = 20140010 22. (T) Shipments Line = open the list of values and select the DD-00160-0105-01 Quantity = 2 Need-By = One week from today Price Break Validation 23. (B) Save Submit your blanket release for approval 24. Navigate to the Submit for Approval window
- 200. (B) Approve 25.Why can’t it be approved? 26. (B) OK Increase your quantity ordered to 20 so that the release will be above the minimum release amount 27. Place your cursor in Quantity field and increase to 20 28. Save Submit your blanket release for approval 29. Navigate to the Submit for Approval window (B) Approve Submit for Approval = Check box Uncheck all other options 30. (B) OK Return to the Blanket Purchase Agreement to view how it was updated as a result of the release 31. Navigate to the Purchase Orders window (N) Purchase Orders > Purchase Orders 32. Using either find or query functionality, locate your blanket purchase agreement
- 201. 33. Notice thevalue in the Released field is $360 – the amount of your first release. 34. What would happen to this value if you issue another release with a value of $1,800? Run the Purchase Order and Releases Detail Report 35. Navigate to the Submit Request window (N) Reports > Run Choose Single Request Name = Purchase Order and Releases Detail Report Or Purchase Order and Releases Detail Report (XML) Operating Unit = Vision Operations Purchase Order Numbers From = 20140010 [Purchase Order Numbers] To = 20140010 36. (B) OK 37. (B) Submit
- 202. 38. (B) No 39.Monitor progress and view output when complete (M) View > Requests 40. (B) Find 41. Once the request completes, (B) View Output
- 204. Practice - Createa Contract Purchase Agreement Overview In this practice, you will do the following: Create a contract purchase agreement to establish general terms and conditions with this supplier. Items, quantities and delivery dates/locations are not known. Create a standard purchase order referencing the contract. Tasks Log on to the System Create a contract purchase agreement Submit your contract agreement for approval Issue a standard purchase order referencing the contract Enter an expense item that you need to order Submit your standard purchase order for approval Return to the Contract Purchase Agreement to view how it was updated as a result of the release Run the Contract Status Report
- 205. Solution - Createa Contract Purchase Agreement Log on to the System Responsibility = Purchasing, Vision Operations Create a contract purchase agreement 1. Navigate to the Purchase Orders window (N) Purchase Orders > Purchase Orders Operating Unit = Vision Operations Type = Contract Purchase Agreement Supplier = Elshayeb Corporation Site = NEW YORK Ship-to = M1-Seattle Bill-to = V1-New York City Amt Agreed = $10,000 2. Navigate to the Terms and Conditions window
- 206. (B) Terms Payment Terms = Immediate Agreement Controls/Effective Dates = Enter dates starting Today and extending for six months Amount Limit = $10,000 3. Close Terms and Conditions window 4. Save Submit your contract agreement for approval 5. Navigate to the Submit for Approval window (B) Approve Submit for Approval = Check box Uncheck all other options 6. (B) OK 7. Ensure that the status on the purchase order header is Approved and record your contract number 20140011 Issue a standard purchase order referencing the contract 8. Navigate to the Purchase Orders window (N) Purchase Orders > Purchase Orders
- 207. Operating Unit= Vision Operations Type = Standard Purchase Order Supplier = Elshayeb Corporation Site = NEW YORK Ship-to = M1- Seattle Mfg Bill-to = V1-New York City Enter an expense itemthat you need to order 9. (T) Lines Num = 1 Item = DD-00010-0040-01 Quantity = 10 Price = $50.00 Need-By = Two weeks from today 10. (T) Reference Documents Contract = Your PO number that was assigned to the contract. 11. Enter shipments for this item (B) Shipments Org = SH1 Ship-To = M1- Seattle Mfg 12. Enter distributions for this shipment (B) Distributions Subinventory = Stores 13. Save Submit your standard purchase order for approval 14. Navigate to the Submit for Approval window (B) Approve Submit for Approval = Check box Uncheck all other options 15. (B) OK 16. Ensure that the status on the purchase order header is Approved and record your contract number 20140011
- 208. Return to theContract Purchase Agreement to view how it was updated as a result of the release 17. Navigate to the Purchase Orders window (N) Purchase Orders > Purchase Orders 18. Using either find or query functionality, locate your contract purchase agreement 19. Notice the value in the Released field is $500 – the amount of your first release. 20. What would happen to this value if you issue another release with a value of $2,000? Run the Contract Status Report 21. Navigate to the Submit Request window (N) Reports > Run Single Request Name = Contract Status Report (B) Submit Operating Unit = Vision Operations PO Numbers From and To = Your contract purchase agreement number
- 209. 22. (B) OK 23.(B) Submit 24. (B) No 25. Monitor progress and view output when complete (M) View > Requests 26. (B) Find 27. Once the request completes, (B) View Output
- 211. Express Receipts andReceiving Transactions Overview The express function is a quick method of entering receipts and receiving transactions. This function is available in the Receipts window if you have specified or inferred a source in the Find Expected Receipts window. (The source would be inferred if you entered, for example, a purchase order number.) In the Receiving Transactions window, the express function is available for deliveries regardless of your search criteria in the Find Receiving Transactions window. Performing any manual action in a line disables the Express button,and it is not enabled until you have again selected the Find button. When you select the Express button in the Receipts window, Purchasing displays the Express Details window in which you must enter the destination: Final Destination or Receiving location. Note that this action is dependent on the profile RCV: Allow Routing Override. When you select the OK button in the Express Details window, all lines are selected and the Express button changes to Unexpress. When you select the Express button in the Receiving Transactions window, all lines are selected and the Express button changes to Unexpress. In either case, you can select the Unexpress button to return to manual mode. Otherwise, you can deselect lines to omit them from express processing and then save your work to initiate express processing. • You cannot perform data collection using Oracle Quality when you select the Express button in the Receiving Transactions window. See: Receiving Transactions,page 9-39. • Express receiving does not support entering Descriptive Flexfield segment values. The express processorperforms validation and rejects lines based on the following criteria: • the item revision/subinventory/locatoris required and not obtainable as a default from the item definition and the destination is Final • the early/late receipt date tolerance is exceeded and the exception control is Reject • Lot/serial information is required • Ship-to location is not available and the destination is Receiving • location is not available for Expense destination type and the destination is Final Destination • Purchase order supplier and receipt headersupplier do not match • Other receipts are pending for the specified shipment When validation processing is complete, Purchasing displays a dialog telling you how many lines passed validation and how many failed and are still available to receive manually.
- 212. Solution - Createan Express Receipt Log on to the System 1. Log on to the system using the following information. Responsibility = Purchasing, Vision Operations Find Expected Receipts 2. (N) Receiving > Receipts (M1 - Seattle Manufacturing) Purchase Order = Your Purchase Order from a previous practice Supplier = Advanced Network Devices Item = XXSoftware 3. (B) Find Note: In order to process an express receipt, all expected receipts queried must be from the same supplier! Record Receipt Header Details Packing Slip = PS-XX Freight Carrier = UPS Note: The Receipt Header window opens on top of the Receipts window. When you have completed the Receipt Header window, click in the Receipt window, which is located behind the Receipt Header window to navigate to it. Create the Express Receipt 4. (M) Window > Receipts (M1) 5. (B) Express to create an Express receipt. Destination Type = Final Destination
- 213. 6. (B) OK 7.Save
- 214. 8. (B) Header 9.Record your receipt number. 201400005 Note: If the Destination Type is Final Destination, to process the receipt as an express receipt, the requestor field must have been filled out on the purchase order or release!
- 215. Review Receiving Transactions 10.Open the Find Receiving Transactions window: 11. (N) Receiving > Receiving Transactions Summary (M1-Seattle Manufacturing) 12. In the Receipt field, enter the receipt number. 13. (B) Find 14. (B) Transactions to open the Receipt Transaction Summary window. 15. Review your receipt.
- 216. Cascading Receipts andReceiving Transactions The Cascade function facilitates thedistribution ofa given quantity of an item from a single supplier across multipleshipments and distributions.This function is availablein the Receipts window if you have specified a Supplier and Item in theFind Expected Receipts window and if Allow Cascade Transactions is enabled in the Receiving Options window. In theReceiving Transactions window,thecascadefunction is availablefor deliveries if you havespecified an Item in the Find Receiving Transactions window. Performing any manual transaction in a line disables the Cascade button,and it is not enabled until you haveagain selected the Find button in the appropriateFind window. When you select theCascade button,Purchasingdisplays theCascade Details window in which you must enter thecascade quantity and the unit of measure. When you select theOK button,the cascadeprocess begins. The process starts at thefirst displayed line and allocates the supply availableto receive/deliver to that linefrom thecascade quantity you entered. The process continues to thenext line and again allocates the quantity availabletoreceive/deliver, continuinguntil either the process reaches the last queried line or the cascadequantity is exhausted. Since the lines are displayed in order by promised date/need-by date, the process operates as a First In/First Out procedure. If you entered a cascade quantity larger than the quantity availabletoreceive/deliver, Purchasingdisplays a dialog window explainingthat the process could allocateonly so many.If thequantity availabletoreceive/deliver is greater than the cascadequantity,the last receipt/delivery may bepartial.To clearly indicatethat thecascade quantity has been exhausted, Purchasingdisplays a transaction quantity of0 for the remaining lines. The cascadefunction does not modify any destination information;it uses the information defined by therouting and defaulted from the shipment. If a given shipment line has multiple distributions and thedefault routingfor that line is direct receipt, the cascade process explodes the line and allocates the quantity availableon the shipment line to the component distributions based on the supply availablefor thedistribution.If you have over distributed a given line, Purchasing allocates all remainingsupply for the shipment to the last distribution.If you haveover delivered the transactions with prior receipts or transactions,then theprocess may fill thelines with undesired values, but you can reallocatein this situation oncethe cascade process is complete. Record validation is disabled during the cascadeprocess to facilitatethe runningof the process, but all lines are validated when you save them. Quantities areapplied to lines in the expectation that you will transact thelineas the default routingintended. However, you can manually overridethesevalues.
- 217. Practice - Createa Cascade Receipt Overview In this practice you will create an cascade receipt against the purchase order you created. 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. Logon to the system using the XXUSER you created earlier. Tasks Log on to the System 1. Log on to the system using the following information. Responsibility = Purchasing, Vision Operations Find Expected Receipts 2. Open the Find Expected Receipts window: Purchase Order = Your Purchase Order from a previous practice Supplier = Advanced Network Devices Item = XXMonitor Note: In order to process a cascade receipt, you must query expected receipts for a specific supplier and item. Record Receipt Header Details Packing Slip = PS-XX Freight Carrier = UPS Note: The Receipt Header window opens on top of the Receipts window. When you have completed the Receipt Header window, click in the Receipt window, which is located behind the Receipt Header window to navigate to it. Create the Cascade Receipt Cascade Quantity = 6 Unit of Measure = Each Note: Because the routing type was Standard Routing, these inventory items will show a destination type of Receiving. The items are delivered to inventory in a subsequent step. Complete the Deliveryfor the a Line of the Cascade Receipt (we will inspect the other later) 3. Open the Receiving Transactions window: 4. In the Receipt field, enter the number of the Cascade Receipt. 5. Select PO Line 2, Shipment 2 (qty of 2 available to deliver) by selecting the checkbox to the left of the Quantity field. We will inspect the other item in a later lab. Note: If you did not fill in requestor and subinventory information on the purchase order, you will need to do that now! Review Receiving Transactions 6. Open the Find Receiving Transactions window. 7. In the Receipt field, enter the receipt number. 8. Review your receipt.
- 218. Solution - Createa Cascade Receipt Log on to the System 1. Log on to the system using the following information. Responsibility = Purchasing, Vision Operations Find Expected Receipts 2. Open the Find Expected Receipts window: (N) Receiving > Receipts (M1 - Seattle Manufacturing) Purchase Order = Your Purchase Order from a previous practice Supplier = Advanced Network Devices Item = XXMonitor 3. (B) Find Note: In order to process a cascade receipt, you must query expected receipts for a specific supplier and item. Record Receipt Header Details Packing Slip = PS-XX Freight Carrier = UPS Note: The Receipt Header window opens on top of the Receipts window. When you have completed the Receipt Header window, click in the Receipt window, which is located behind the Receipt Header window to navigate to it. Create the Cascade Receipt 4. (M) Window > Receipts (M1) 5. (B) Cascade to create a Cascade receipt. Cascade Quantity = 4 Unit of Measure = Each 6. (B) OK 7. Note that the 4 items are applied to the expected receipt. 8. Save
- 219. 9. (B) Header 10.Record your receipt number. Note: Because the routing type was Standard Routing, these inventory items will show a destination type of Receiving. The items are delivered to inventory in a subsequent step. Complete the Deliveryfor the a Line of the Cascade Receipt (we will inspect the other later) 11. Open the Receiving Transactions window: (N) Receiving > Receiving Transactions (M1 - Seattle Manufacturing) 12. In the Receipt field, enter the number of the Cascade Receipt. 13. (B) Find 14. (T) Order Information 15. Select PO Line 2, Shipment 2 (qty of 2 available to deliver) by selecting the checkbox to the left of the Quantity field. We will inspect the other item in a later lab. Note: If you did not fill in requestor and subinventory information on the purchase order, you will need to do that now! 16. Save 17. Close the Receiving Transactions window. Review Receiving Transactions 18. Open the Find Receiving Transactions window: (N) Receiving > Receiving Transactions Summary (M1-Seattle Manufacturing) 19. In the Receipt field, enter the receipt number. 20. (B) Find 21. (B) Transactions to open the Receipt Transaction Summary window. 22. Review your receipt.
- 220. Benefits of usingthe Create Releases Program
- 221. Overview of theCreate Releases Program Overview of the Create Releases Program You can minimize purchase order administrative costs by automatically creating releases for both manually entered and imported requisitions. Oracle Purchasing provides you with the features you need to satisfy the following basic needs. You should be able to: • Automatically create a release when you source your items from a single supplier using a single blanket purchase agreement. • Specify for each approved supplier list entry whether you want to create approved releases automatically, create releases automatically but require manual approval, or require the use of the AutoCreate Documents window to create releases. • Run the Create Release process automatically as part of the requisition import process. The Create Releases program converts approved requisition lines to blanket purchase agreement releases based on the sourcing rules and approved supplier list entries.
- 222. Automatic Release Generation AutomaticRelease Generation When you are defining your approved supplier list, you define how you want your releases generated. The Create Releases program attempts to create a release only if the Release Method in the approved supplier list is set to Automatic Release or Automatic Release/Review. The following release methods are available in the approved supplier list: • Automatic Release: Automatically converts approved requisition lines to approved blanket purchase releases based on the sourcing rules and Approved Supplier List entries. • Automatic Release/Review: Automatically converts approved requisition lines to unapproved blanket releases. • Release Using Autocreate: Either the PO Create Documents workflow is used to create a purchase document or buyers use the AutoCreate Documents window to collect, review, and optionally modify requisition lines before creating and approving purchase documents. You can define a different release generation method for each item and supplier. For frequently purchased items, you can set up Oracle Purchasing to automatically create and approve releases. For expensive or critical items, you can let Oracle Purchasing create the releases, while you review and approve them in a separate step. For infrequent purchases, your buyers can take more control by using the AutoCreate Documents window to combine requests.
- 223. Running the CreateReleases Program Running the Create Releases Program Purchasing Responsibility (N) Reports > Run The Create Releases program and the PO Create Documents workflow can both create releases from requisitions submitted in either Oracle Purchasing or iProcurement. The Create Releases program ONLY creates Blanket Purchase Agreement releases. The Create Releases process generates releases when the following criteria are met: • The requisition is sourced to an approved blanket purchase agreement that is not on hold. • The approved supplier list entry for the item, supplier, and agreement must be active, and the release method must be set to Automatic Release or Automatic Release/Review in the Approved Supplier List window. • The source agreement is still active and the release will not put the agreement over the amount limit. • The release amount must be greater than the minimum line release amount. • The supplier on the source agreement is active and not on hold. • The requisition line is approved and not already on a purchase order. • The line type of the requisition line is quantity based. Manually submit: Manually submit the Create Releases program from the standard request submission window. Schedule: Schedule the Create Releases program to run periodically using the standard request submission window. Automatically submit after requisition import: If the PO: Release During ReqImport profile option is set to Yes, the Create Releases program will be submitted after the Req. Import program completes.
- 224. Create Releases DocumentCreation Prerequisites Create Releases Document Creation Prerequisites A blanket purchase agreement: There MUST be an approved blanket purchase agreement in place that is not expired and not over released. Approved supplier list entry: There MUST be an approved supplier list entry for the item. The Create Releases program does not work with commodities or one-time items (where just the category and description are specified). Release method: Along with the approved supplier list entry, the Release Method MUST be set to either Automatic Release or Automatic Release/Review. If the Release Method is left blank or set to Release using AutoCreate, the Create Releases program will not generate blanket purchase agreement releases. The release method MUST be set regardless of whether or not you have specified a source document. Sourcing Rules and Sourcing Rule Assignments: A sourcing rule with a sourcing rule assignment MUST be created for the Create Releases program to create blanket purchase agreement releases. It is not enough to supply source document information (using the supplier item catalog and selecting from a negotiated source for example) and a supplier and supplier site on the requisition when submitting requisitions manually. Effect of the PO: Automatic Document Sourcing profile option: If the PO: Automatic Document Sourcing profile option is set to No, you MUST specify a blanket purchase agreement on the Source Document tab relating the approved supplier list entry. If the PO: Automatic Document Sourcing profile option is set to Yes, you MUST have an approved supplier list entry with the release method set to Automatic Release or Automatic Release/Review. The release method cannot be blank and it cannot be set to Automatic Release using Autocreate to automatically create releases.
- 225. Solution - EnableAutomatic Document Sourcing Verify Automatic Document Sourcing is Enabled 1. Navigate to the System Profiles window (N) Personal Profiles 2. Query “PO%Auto%” in the Personal Profiles window. 3. Verify that the profile PO: Automatic Document Sourcing is set to Yes. If it is not set to Yes, you will need to use the System Administrator responsibility to set it to Yes at the Site level. Create a New Requisition Line/Verify Sourcing Information Defaults 4. Navigate to the Requisitions window. (N) Requisitions > Requisitions Operating Unit = Vision Operations 5. (T) Lines Item = XXMonitor Quantity = 11 6. (T) Source Details 7. Verify that quotation information has defaulted in. 8. Verify the agreement number in the note window and the supplier information that appears below the lines region. 9. Close the window without saving your work. Note: When using automatic document sourcing, documents are searched for and defaulted onto the requisition or purchase order based on the following rules: Blanket purchase agreements are always defaulted before quotations, even if the quotation is more recent. If only blanket purchase agreements and quotations exist, the most recent one (create dates are compared) is used.
- 226. Solution - Createa Sourcing Rule and a Sourcing Rule Assignment Log on to the System Responsibility = Purchasing, Vision Operations Create a Sourcing Rule 1. Navigate to the sourcing rules window. (N) Supply Base > Sourcing Rules (M1 – Seattle Manufacturing) Rule Name = SH Computer Hardware All Orgs = Selected From Date = Today’s date Type = Buy From Supplier = Elshayeb Corporation Site = CAIRO V (Vision Operations) Allocation % = 100 Rank = 1 2. Save Verify the Default Assignment Set 3. Navigate to the Personal Profile values window (N) Personal Profiles 4. (M) View > Find Profile = MRP:Default Sourcing Assignment Set Verify default value = Supplier Scheduling Note: Purchasing only uses sourcing rules assigned to the value in the MRP:Default Sourcing Assignment Set. It is essential this is clearly understood.
- 227. Create a SourcingRule Assignment 5. Navigate to the Sourcing Rule Assignments window (N) Supply Base > Assign Sourcing Rule 6. (M) View > Find 7. Choose Supplier Scheduling from the list of values 8. In the Assignments region, click in the customer field. 9. (M) File > New Assigned To = Item - Organization Item/Category = DD-00100-0220-01 Type = Sourcing Rule Sourcing Rule = SH Computer Hardware 10. Save Create a Requisition/View Sourcing Information 11. Navigate to the Requisitions window. (N) Requisitions > Requisitions Operating Unit = Vision Operations Item = DD-00100-0220-01 12. Tab out of the Item field.
- 228. 13. Verify thesupplier information that appears to the right below the lines region. 14. Create Quotation For This Item From Supplier Approve The Quotation
- 229. Define Attributes 14. Tabto the Quantity field and enter 50. Tab out of the field and verify that price breaks are defaulting in from your quote. DD-00100-0220-01 15. (T) Source Details 16. Verify source document information from the ASL defaults.
- 230. Create a PurchaseOrder/View Sourcing Information 17. Navigate to the Purchase Orders window (N) Purchase Orders > Purchase Orders Operating Unit = Vision Operations Supplier = Elshayeb Corporation Site = CAIRO V (T) Lines Item = DD-00100-0220-01 Quantity = 30 18. Verify price breaks are in effect 19. (T) Reference Documents 20. Verify quotation references have defaulted
- 231. Remove the SourceDocument from the ASL 21. Navigate to the Approved Supplier List window (N) Supply Base > Approved Supplier List 22. (M) View > Find Item = DD-00100-0220-01 23. (B) OK 24. (T) Key Attributes 25. Place cursor in the Supplier field 26. (B) Attributes
- 232. 27. (I) Deletethe quotation 28. Save Verify Source Document Information does not Default 29. Navigate to the Requisitions window. (N) Requisitions > Requisitions Operating Unit = Vision Operations 30. (T) Lines Item = DD-00100-0220-01 31. Verify the supplier information that appears to the right below the lines region. Quantity = 11 32. Tab out of the field and verify that price breaks are no longer defaulting in from your quote. 33. (T) Source Details 34. Verify there is no quotation information. Note: If source document information still defaults, use the System Administrator responsibility to verify the PO: Automatic Document Sourcing profile option is set to No at the Site level. 35. The reason supplier information STILL defaults is: __________________________________________________________________ 36. Close the window without saving your work.
- 233. Overview of AutomaticSourcing Purchasing lets you automatically source online requisitions with purchase agreements or quotations you create. You can easily assign any item with an item number to a specific purchase agreement or quotation. Purchasing automatically assigns the name of the supplier for the purchase agreement and quotation to any requisition for this item. To achieve automatic sourcing, use the Sourcing Rule and Sourcing Rule/Bill of Distribution Assignments windows to create sourcing rules. Optionally use the Approved Supplier List and Supplier-Item Attributes windows to specify source document information for a particular item, supplier, and site.
- 234. Solution - AutomaticallyCreate a Standard Purchase Order based on your Quotation Log on to the System Responsibility = Purchasing, Vision Operations Create a Catalog Quote 1. Open the Quotations window: (N) RFQs and Quotations > Quotations Operating Unit = Vision Operations Type = Catalog Quotation Supplier = Elshayeb Corporation Site = CAIRO V Status = Active Effectivity = Today to a year from today 2. (T) Lines Enter item information according to the following table: Num Item Category Description UOM 1 DD-00100-0220-01 MISC.MISC 22/0.4 kv1000k.v.A Each Specify Price Breaks 3. Specify price breaks according to the following table: Num UOM Quantity Price Org Ship-To Discount 1 Each 10 12 Calculates 2 Each 20 11 Calculates 3 Each 50 10.5 Calculates 4 Each 100 9.5 Calculates
- 235. 4. Exit thePrice Breaks window 5. (I) Save 6. Record the number of your quotation 20140003 Submit a Requisition 7. Navigate to the Requisitions form (N) Requisitions > Requisitions Operating Unit = Vision Operations 8. (T) Lines Item = DD-00100-0220-01 Quantity = 30
- 236. 9. (T) SourceDetails Supplier Item = DD-00100-0220-01 Type = Quotation Document = 20140003 Line = 1 Supplier = Elshayeb Corporation (Use the list of values!) Site = CAIRO V (Use the list of values!) 10. Save 11. (B) Approve Note: Sourcing rules automate the defaulting of a supplier and site. Verify a Standard Purchase Order Was Created 12. Navigate to the Purchase Order Summary form (N) Purchase Orders > Purchase Order Summary 13. (T) Related Documents Requisition = 20140018
- 237. 14. (B) Find 15.(B) Open
- 239. Practice - CreateReleases using the Create Releases Program Overview In this practice, you will use the AutoCreate form to return a requisition. Log on to the System Responsibility = Purchasing, Vision Operations Create a Blanket Purchase Agreement 1. Open the Purchase Orders window: (N) Purchase Orders > Purchase Orders Operating Unit = Vision Operations Type = Blanket Purchase Agreement Supplier = Elshayeb Corporation Site = CAIRO V Amount Agreed = 10000 Description = 40 MVA 66 ± 8X1.25 % / 11.86 KV Supplies 2. (T) Lines Select items according to the following table: Num Item Category Description UOM 1 PT-04000-0660-02 MISC.MISC 40 MVA 66 ± 8X1.25 % / 11.86 KV Each Specify Price Breaks 3. (B) Price Breaks Num UOM Quantity Price Org Ship-To Discount% 1 Each 10 Defaults 10 2 Each 25 Defaults 15 3 Each 50 Defaults 20 4. Save
- 240. 5. Close thePrice Breaks window. 6. Record your Blanket Purchase Agreement number. 20140018 7. (B) Approve Submit for Approval = Checked Uncheck all other options 8. (B) OK Create Anther BPA To Supplier Advanced Network Devices 9. (B) OK in the Note window Create a Sourcing Rule 10. Navigate to the Sourcing Rule window (N) Supply Base > Sourcing Rules Organization = SH 1 Name = SH Computer Purchases All Orgs = Selected Effective Date = From today Type = Buy From
- 241. Supplier =Advanced Network Devices Site = SANTA CLARA (Vision Operations) Allocation = 50% Rank = 1 11. Save. Create a Sourcing Rule Assignment 12. Navigate to the Sourcing Rule Assignments window (N) Supply Base > Assign Sourcing Rules 13. (M) View > Find 14. Choose Supplier Scheduling from the list of values 15. In the Assignments region, click in the customer field. 16. (M) File > New Assigned To = Item Item/Category = PT-04000-0660-02 Type = Sourcing Rule Sourcing Rule = SH Computer Hardware 17. Save Create an ASL Entry/Specify your Blanket as the Source Document 18. Open the Approved Supplier List window:
- 242. (N) SupplyBase > Approved Supplier List (SH 1) Type = Item Item = PT-04000-0660-02 19. (T) Key Attributes Business = Direct Supplier = Advanced Network Devices Site = FRESNO Status = Approved Supplier Item = PT-04000 Make the Approved Supplier List a Global Approved Supplier List 20. (T) Record Details Global = Yes 21. Save Define the Attributes of the Approved Supplier List Entry 22. (B) Attributes Release Method = Automatic Release 23. (T) Source Documents Type = Blanket Number = Your blanket purchase agreement number Line = 1 24. Save
- 243. 25. Close theSupplier-Item Attributes and Approved Supplier List forms to return to the Navigator. Submit a Requisition 26. Navigate to the Requisitions form (N) Requisitions > Requisitions Operating Unit = Vision Operations 27. (T) Lines Item = PT-04000-0660-02 Quantity = 30 28. (T) Source Details 29. Note that source document information has defaulted
- 244. 30. Save 31. Approvethe requisition Run the Create Releases Program 32. Navigate to the Standard Request Submission form (N) Reports > Run Choose Single Request Name = Create Releases 33. (B) Submit 34. Operating Unit = Vision Operations 35. (B) Submit
- 245. 36. (M) View> Requests 37. (B) Find 38. (B) Refresh Data until the request completes View the Release 39. Navigate to the Purchase Order Summary form (N) Purchase Orders > Purchase Order Summary 40. (T) Related Documents Requisition = Your requisition number View Releases = Checked 41. (B) Find 42. (B) Open.
- 246. Generate Sourcing RulesAnd ASLs From Blanket Agreements This program automatically creates or updates Sourcing Rules and ASLs (Approved Supplier List) for a blanket purchase agreement. The program acts upon documents which have the archival option set to Archive on Approve. Features: • Can specify the default assignment set and the blanket agreement, supplier and supplier site for which the sourcing rules or ASLs need to be created or updated. • Create global or local sourcing rules and ASLs: • Global: Create a sourcing rule that is enabled in all organizations and is assigned at the item level. Create a global ASL. • Local: Create a sourcing rule that is specific to the inventory organization selected. Create a Local ASL and associate the blanket agreement to the specific inventory organization. • Create or update sourcing rules or ASLs for all lines or for new lines (entered since the previous archive) only. Exceptions: The program inserts all Blanket Lines for which a Sourcing Rule or ASL was not created into the Purchasing Document Interface Errors table, with the appropriate reason. This enables the buyer to identify and fix the errors if required before resubmitting the program. The buyer can submit the Purchasing Document Interface Errors Report for source type of PO_DOCS_OPEN_INTERFACE to view the errors. Process Submission Navigate to the Submit Requests window and select Document Sourcing Rules Creation Process in the Name field. Process Parameters Supplier Select an active supplier who has at least one valid purchasing site in the current operating unit. Blanket Agreement Number Select a blanket purchase agreement for the selected supplier that is approved and is not cancelled, closed, finally closed, frozen or on hold. Global agreements must be owned by the current operating unit or the current operating unit must be the procuring organization. Purchasing Organization If you selected a global blanket agreement, select an organization listed as Purchasing Organization on the agreement. Select Blanket Lines Select either: All Lines or New Lines. Supplier Site Select a Purchasing Site for the global blanket agreement. Assignment Set Select an Assignment Set. Sourcing Level Select either: Item or Item-Organization. Inventory Organization If you selected a Sourcing Level of Item-Organization, select an Inventory Organization. Sourcing Rule Name Enter a name to update the sourcing rule name or for the given supplier, supplier site and item combination. Release Generation Method Select one of: Automatic Release/Review, Automatic Release, or Release Using Autocreate. Related Topics Overview of Approved Supplier List, Submitting a Request, Oracle ApplicationsUser's Guide
- 247. Professional Buyer's WorkCenter Buyer's Work Center Overview Based on a web-based user interface, the Buyer's Work Center is a central desktop from which buyers can efficiently perform their daily tasks—such as viewing and acting upon requisition demand, creating and modifying orders and agreements, initiating negotiations if Oracle Sourcing is licensed and implemented, and managing the supply base. The Buyer's Work Center provides you with the features you need to satisfy your document creation needs.You can: • Access requisition demand in the Demand Workbench and create procurement documents • Create a new standard purchase order, blanket purchase agreement, or contract purchase agreement • Update an existing standard purchase order, blanket purchase agreement, or contract purchase agreement • Create and maintain supplier information • If Oracle Sourcing is licensed and implemented, create buyer's auctions or sourcing RFQs • If Oracle Services Procurement is licensed and implemented, create and maintain purchase orders for complex work payments • If Oracle Procurement Contracts is licensed and implemented, author contract terms and manage deliverables • Use predefined document views 7-2 Oracle Purchasing User's Guide • Create and personalize your own document views including list of columns, where conditions,and sort sequences Major Features Varied Views of Demand The Buyer's Work Center presents requisition demand in views that are easily customized to an individual buyer's way of working. These views allow buyers to quickly prioritize requisition demand based on a variety of factors, such as sourcing status orcommodity. Improved Flows for Purchase Order and Agreement Creation The Buyer's Work Center simplifies the purchase order and long-term agreement creation and management processes.The purchase order flow streamlines data entry by enabling buyers to enter shipment and distribution information at the line level. It also enables you to enter shipment or distribution information without having to drill down. A separate agreements flow is tailored specifically for the strategic buyer, who is responsible for agreement maintenance and compliance. Document Styles Document styles allow procurement managers to control the look and feel of the application for different purchasing activities. For example, purchasing managers can create a document style for a specific commodity, such as temporary labor. This document style optimizes field labels and presentment for that commodity, simplifying purchase order entry. Easier Catalog Access with iProcurement-style Search Oracle Purchasing builds on the popularity of Oracle iProcurement's search capabilities by offering buyers a similar search interface to easily find the items they need to procure. In addition, an improved catalog display shows all relevant attributes in a user-friendly list with the ability to drill-down to further details. Procurement for Complex Services If your organization has licensed and implemented Oracle Services Procurement, the Buyer's Work Center supports a complete and integrated solution to procure complex work and manage the long-term contact execution. Services procurement often involves the definition and adherence of advanced payment terms when defining the contact. This solution is designed for fixed price contracts with either interim progress payments based on cost or milestones.
- 248. Profile Options inPurchasing During implementation, you set a value for each user profile option to specify how Purchasing controls access to and processe s data.The table below also indicates whether you (the "User") can view or update the profile option and at which System Administrator levels the profile options can be updated: at the user, responsibility, application, or site levels. A "Required" profile option requires you to provide a value. An "Optional" profile option already provides a default value, so you only need to change it if you don't want to accept the default. Generally, the systemadministrator sets and updates profile values. Key You can update the profile option. - You can view the profile option value but you cannot change it. Profile Option User System Administrator Requirements User User Resp App Site Required? Default Value Account Generator: Purge Runtime Data Optional Yes MRP: Default Sourcing Assignment Set - Required if using sourcing rules none MRP: Sourcing Rule Category Set Required if using sourcing rules none PO: Allow Buyer Override in AutoCreate Find Optional Yes PO: Allow Category Override in AutoCreate Find Optional Yes PO: AutoCreate GL Date Option Optional AutoCreate Date PO: Change Supplier Site - Optional none PO: Default Supplier Item Catalog Option Optional Negotiated Sources PO: Display AutoCreated Quotation Optional Yes PO: Display the Autocreated Document Optional Yes PO: Item Cross Reference Warning - Optional Disposition PO: Legal Requisition Type - Optional Both PO: Release During ReqImport Optional No PO: Supplier Pricing Method Optional Last Price PO: Warn if RFQ Required before AutoCreate Optional No PO: Workflow Processing Mode Optional Background RCV: Allow routing override - Optional No RCV: Fail All ASN Lines if One Line Fails - Optional No RCV: Print Receipt Traveler Optional No RCV: Processing Mode Optional Online PO: Check open periods Table 1 - 1. (Page 2 of 2) Account Generator: Purge Runtime Data Setting this profile option to Yes ensures that the Oracle Workflow data used to generate accounting flexfield code combinations using the Account Generator is purged after the Account Generator has completed. This profile option should always be set to Yes unless you are debugging the Account Generator. It is recommended to set it to No temporarily at the User level. Running the Account Generator with this profile option set to No fills the workflow tables and slows performance.
- 249. MRP: Default SourcingAssignment Set This profile option indicates which sourcing rules assignment set will be used in Purchasing and Supplier Scheduling. Plannin g allows the user to use multiple Assignment Sets, but Purchasing looks at only a single Assignment Set. The value of this profile option should be the name of the Assignment Set used in Purchasing. This profile option must be set if the user is using sourcing rules in Purchas ing. MRP: Sourcing Rule Category Set This profile needs to be set to display Category and Category-Organization assignments in the Assignments Sets form. PO: Allow Buyer Override in AutoCreate Find Yes or No indicates whether the suggested buyer(from the Enter Person window) defaulted into the Find Requisition Lines wind ow can be cleared or overridden. The default is Yes. PO: Allow Category Override in AutoCreate Find Yes or No indicates whether the category (from the Buyers window) defaulted into the Find Requisition Lines window can be cle ared or overridden. PO: AutoCreate GL Date Option Indicates the date used on purchase orders generated by AutoCreate: AutoCreate Date The autocreate date is used as the purchase order date. Requisition GL Date The GL date on the requisition distribution is used as the purchase order date. PO: Change Supplier Site Yes or No indicates whether users can change the supplier site on approved purchase orders. PO: Default Supplier Item Catalog Option Indicates the default source alternative region in the supplier item catalog: Negotiated Sources, Prior Purchases,Sourcing Rules, or Requisition Templates. PO: Display AutoCreated Quotation Controls the viewing of an autocreated quotation. PO: Display the Autocreated Document Yes or No indicates whether Purchasing opens the appropriate transaction window (Purchase Orders windo w or RFQs window) and displays the created line(s) when you autocreate a document. PO: Item Cross Reference Warning Indicates the Item Cross Reference Type that you want to use as a disposition warning message for requisitions. PO: Legal Requisition Type Indicates whether users can enter internal requisitions sourced from stock by means of an internal sales order, purchase requisitions sourced from a purchase order, or both types.Available values are Both, Internal, and Purchase. PO: Release During ReqImport Yes or No indicates whether Purchasing can automatically create releases during the Requisition Import process. PO: Set Debug Workflow ON This profile option should always be set to No. PO: Supplier Pricing Method Indicates the pricing method for lists of values in the Price field in purchase orders and requisitions: Catalog Price Pricing is from quotations and blanket purchase agreements. Last Price Pricing is from the price history.
- 250. PO: Warn ifRFQ Required before AutoCreate Yes or No indicates whether you are given a warning message and an opportunity to cancel autocreate if one or more of the req uisition lines selected for inclusion requires an RFQ and has not been placed on an RFQ. PO: Workflow Processing Mode Affects the performance of the Purchasing approval workflow processes: Online Completes an entire approval workflow process before letting you proceed to the next activity, but provides you with an updat ed Status (for purchase orders) as soon as it finishes. Background Enables you to proceed to the next activity while the approval process completes in the background. Whichever option you choose,you can always view the current status ofa requisition or purchase order through the Requisitio ns Summary or Purchase Orders Summary windows. The default value (if you don't provide one) is Background. Note: When this profile option is set to Background,you must start the Workflow Background Process,which you access through the System Administrator responsibility. It is recommended that you set this process to run frequently, if you are using it for Background mode approvals. RCV: Allow routing override Yes or No indicates whether the receiving routing assigned during requisition or purchase order entry can be overridden at receipt time. RCV: Fail All ASN Lines if One Line Fails If you choose Yes, you can reject an entire Advance Shipment Notice (ASN) if any ASN line fails validation or processing.If you choose No, then you can accept an ASN if at least one ASN line is successful. RCV: Print Receipt Traveler Yes or No indicates whether Purchasing automatically prints the receipt traveler when you perform a receipt or a receiving transaction,and when you match unordered receipts. You can always print receipt travelers from the Submit Requests window. RCV: Processing Mode Indicates the processing mode used after you save your work for receiving transactions: Batch The transaction goes to the interface table, where it will be picked up the next time the Receiving Transaction Processorruns. Immediate The transaction goes to the interface table, and the Receiving Transaction Processoris called for the group of transactions that you entered since you last saved yourwork. On-line The Receiving Transaction Processoris called directly. PO: Check open periods Yes indicates that the need by date and the promise by date must be in an open Purchasing period when entering purchase orders. Any other setting provides no validation against Purchasing periods. PO: Default Need-By Time Indicates the time used to default for the entry of need-by date when a requisition, purchase order, or release is created. RCV: Default Include Closed PO Option If it is set to Yes, a search in the Enter Receipts window and the Receiving Transactions window automatically select the Include Closed POs checkbox. Your search results will then include closed orders. The Receiving Open Interface (including ASN) will allow a receipt against orders with the status of Closed for Receiving if this profile is set to Yes. Any setting other than Yes prevents receiving against orders using the Receiving Open Interface with the status of Closed for Receiving.