A buyer uses the extractor in Oracle Purchasing to pull categories and items from the following sources in Oracle Applications:Classifications (categories):Oracle Application categories are extracted to Oracle iProcurement to become catalog categories. Since those application categories are often created to satisfy planning or production needs, they don’t usually provide a good basis for a user friendly shopping catalog. Oracle provides the ability to identify only those categories necessary for creating iProcurement orders.

• Web-enabled Purchasing categories - In Oracle Purchasing or Inventory, enter Y in the descriptive flexfield (attribute 10) for the purchasing category code.
• Requisition template headers

Items:

• Belong to web-enabled Purchasing categories
• Items on catalog quotations
• Items on blanket purchase agreements
• Items in the Approved Supplier List
• Items on requisition templates
• Classifications

Running the ExtractorThere are two ways to extract the data:

• Define Catalog Server Loader Values window
• Concurrent programs: Catalog Extract Data – Classifications  & Catalog Extract Data – Items

Populating the local catalog Populating the local catalog with content consists of the following activities. Either extracting or bulk loading data is required; everything else is optional:■ Extracting Catalog Data from Oracle Applications■ Bulk Loading Catalog Data ■ Define Category Mapping■ Define Classification and Supplier DomainsExtracting Catalog Data from Oracle ApplicationsThe following purchasing data from Oracle Purchasing can be reflected in the Oracle iProcurement catalog:

• Purchasing categories
• Requisition templates
• Approved supplier list (ASL) entries
• Items from the item master file, including internally orderable items
• Blanket purchase agreements
• Global agreements
• Catalog quotations

The catalog extractor in Oracle Purchasing is used to populate the Oracle iProcurement catalog with your Oracle Purchasing data. Before running the catalog extractor, you must specify which data elements youwish to make available in Oracle iProcurement. For example, if your company does not use requisition templates, there is no need to extract them. To specify data elements for extraction Open the Define Catalog Server Loader Values window using the following navigation path after logging into Oracle Purchasing: Setup > E-Catalog Admin > Loader Values. 1. By default, blanket purchase agreements (including global agreements) and quotations are extracted. These are grouped together in the Contracts option.Selecting Item Master extracts purchaseable items in the master item file and item-level ASL entries. Selecting Internal Items extracts internally orderable items, which can be placed on internal requisitions, if the internal requisitions functionality has been implemented in Oracle Purchasing. If an item is both purchaseable and internally orderable, it is extracted based on your selection. If you select only Item Master, it is extracted as a strictly purchaseable (external) item. If you select only Internal Items, it is extracted as a strictly internal item. If you select both, it is available as both an internal and external item in the catalog (if POR: Legal Requisition Type is set to BOTH).2. Define Rollback Segment (Optional)Use the Concurrent Programs window to define rollback segments for each of the extractor programs:■ Catalog Data Extract - Classifications■ Catalog Data Extract - Items■ Catalog Data Extract - PurgeRollback segments are used by the database to store the information needed to undo changes when necessary (for example, during a system failure). Defining rollback segments is optional, because the default rollback settings should be adequate. If you choose to define rollback segments, however, get help fromyour database administrator. Defining rollback segment sizes can affect the successful completion and performance of the extractor.3. Extract the Data (Required)Extract the data in one of two ways: ■ Click the Extract buttons in the Define Catalog Server Loader Values window. ■ Use the Submit Requests window. See Launching the Catalog Extractor from the Submit Request WindowManaging the Catalog ExtractorTo transfer your purchasing data into the Oracle iProcurement catalog, the catalog extractor must be launched. The catalog extractor can be launched from either the Define Catalog Loader Values window or the Submit Request window. The recommended order for running the catalog extractor is:1. Catalog Data Extract - Classifications2. Catalog Data Extract - Items3. Catalog Data Extract - Purge (Optional)Note: Other than for exceptions, you should not run this program independently. For example, if you are upgrading Oracle iProcurement or extracting data and the log indicates a database error occurred while the interMedia Index was running, you could run the interMedia Index program independently; however, youshould always investigate the error before running the program, to make troubleshooting the problem easier.4. Rebuild the Catalog Item interMedia Index (Only if data corruption or some other exception occurs)  Launching the Catalog Extractor from the Loader Values Window To launch the catalog extractor from the Define Catalog Server Loader Values window:1. Click Extract Classifications.2. Monitor the extraction request in Oracle Purchasing by choosing Requests. Choose View Log to check for errors. 3. Once the classifications request completes successfully, return to the Define Catalog Server Loader Values window and click Extract Items.4. Monitor the extraction request in Oracle Purchasing by choosing Requests. Choose View Log to check for errors.