Sourcing Wizard

×
Menu
  • About Sourcing Wizard

About Sourcing Wizard

 
 
      
 
Welcome to Sourcing Wizard.
 
Note – This is the user documentation for the latest version of Sourcing Wizard.  Versions 2.0.05 and older have been superseded.  Click here if you wish to view the documentation for these.
 
We developed this tool in response to demand from Oracle Pricing users for a user friendly and robust spreadsheet tool to load Approved Supplier Lists, Sourcing Rules and Assign Sourcing Rules into the Oracle E-Business Suite module.
 
Sourcing Wizard is a VBA program embedded in a Microsoft Excel workbook.  It is a close cousin to our other ‘Wizard’ products and shares the same look and feel.
 
The software interfaces with a standard Oracle Sourcing API for Approved Supplier Lists, Sourcing Rules and Assign Sourcing Rules in ASCP and Purchasing.  It does NOT modify any other Oracle objects except during the installation, where it adds the More4apps packages and profile options.
 
Features
 
All options are available on a ribbon.  Double-clicking in the spreadsheet also loads the forms.  The forms are optional, and you can simply type, import, or paste the values into the spreadsheet.
 
You can upload records one at a time, or your entire worksheet.
 
The program is flexible about the spreadsheet layout.  You can move, delete, or hide (not recommended) unwanted columns.  You can also have multiple sheets or even sheets in other workbooks.
 
 
Current features include:
 
   Add, Update and Delete Approved Supplier and Sourcing.
 
   Add, Update and Delete attributes for these lists with validation that adheres to Oracle business rules.
 
   Create and Delete Authorizations, Capacities and Tolerances.
 
   Descriptive Flexfields where available in Oracle.
 
   Create, Update and Delete Sourcing Rules, Assignment Sets and their Assignments.
 
 
Features not currently available:
 
       Attachments.
 
This program is supported on E-Business Suite 12 onwards (i.e. 12.0.*, 12.1.*, 12.2.*).
 
Note - You must install the following patches in R12 for this Wizard to operate successfully:  18493909, 20694271.
 
Patch 18493909 – In Oracle Purchasing this patch will resolve:
1.    The invalids created by Patch 17964511:RT12.PO.B
2.    DUPLICATE SEQUENCE_NUM IN PO_ASL_DOCUMENTS
3.    Dependency on 11i features, due to which 18154451:R12.PO.B creates the invalids in 10g db
 
Patch 20694271 – In Oracle Purchasing, user now able to create or delete ASL using API successfully.
 
If you encounter any problems or have any suggestions, please do not hesitate to contact us at https://more4apps.com/support/new-support-request