Run Initial Data Ingestion

What's Initial Ingestion?

A search index is a structured data store that enables fast and relevant search. An index allows the search engine to quickly look up documents that match a query.

The initial ingestion process is how the content becomes searchable in Oracle Search. It includes populating the searchable data from the relational database into the search index. Once ingested into the index, the content becomes then available for search engine.

The very first ingestion of searchable data into the search index is called the initial data ingestion. Initial ingestion of each search index utilized should only be done manually, once at initial configuration, and never scheduled.

If you're setting up multiple indexes for a given product, then you must submit the process in a sequence with each index name as input parameter in serial. We recommend you submit indexes one by one to keep from loading up the Oracle Search Cloud Service (OSCS).

Run the Initial Data Ingestion

Submit the ESS job to create index definition and perform initial ingest to OSCS scheduled process to create the index definition and perform initial ingest to the OSCS process for creating indexes and ingesting predefined indexes.

  1. Navigate to Tools > Scheduled Processes.
  2. Select ESS job to create index definition and perform initial ingest to OSCS from the menu and select OK.
    Note:

    If you need to set up the index for a feature, select the relevant parameter value. For example, fa-hcm-person for person search or fa-hcm-position for positions search. If you’re setting up multiple indexes, then you need to run multiple processes with different index name parameters.

  3. Enter the index you want to ingest in the Index Name to Reingest field. For example, enter fa-hcm-person for the person index.
    • If you don't specify any index names while submitting the process, the process will run for all predefined indexes. We recommend you to create indexes related to your product family only.
    • If you're setting up multiple indexes for a given product, then you must submit the process in a sequence with each index name as input parameter in serial. We recommended you submit indexes one by one to keep from loading up the OSCS.
  4. Run the process for the respective products deployed in your environment. See the following tables for HCM and SCM.

    List of Indexes for HCM

    Product Index Name
    General search infrastructure
    • fa-hcm-savedsearch
    Global Human Resources
    • fa-hcm-person
    • fa-hcm-job
    • fa-hcm-position
    • fa-hcm-location
    • fa-hcm-organization
    Learning
    • fa-hcm-learningitem
    • fa-hcm-learn-acl
    • fa-hcm-learningrecord
    • fa-hcm-learningbooking
    • fa-hcm-wlf-recommendationprofile
    • fa-hcm-wlf-recommendation
    Time and Labor
    • fa-hcm-timecard
    Recruiting
    • fa-hcm-requisition
    • fa-hcm-irc-hiring-events
    • fa-hcm-irc-messages
    Career and Profile Management
    • fa-hcm-modelprofile
    • fa-hcm-personprofile
    Journeys
    • fa-hcm-workerjourney
    • fa-hcm-workerjourneytask
    Connections
    • fa-hcm-profile-tag
    Benefits
    • fa-hcm-personbenefits
    Profile Management
    • fa-hcm-contentitem
    • fa-hcm-teamskills

    List of Indexes for SCM

    Product Index Name
    Asset Lifecycle Management
    • fa-alm-aset
    • fa-alm-work-order-asset
    • fa-alm-work-definition
    • fa-alm-maintenanceforecasts
    • fa-alm-work-order
    • fa-alm-warranty-claim
    • fa-alm-work-requirement
    Channel Revenue Management
    • fa-fscm-customerclaim
    • fa-cjm-customer-programs
    • fa-cjm-spa-programs
    • fa-cjm-supplier-programs
    Manufacturing
    • fa-scm-wls-work-definitions
    • fa-scm-mfg-work-order
    Receiving
    • fa-scm-rcv-expected-po-receipts
    • fa-scm-rcv-expected-asn-receipts
    • fa-scm-rcv-expected-to-receipts
    • fa-scm-rcv-expected-rma-receipts
    • fa-scm-rcv-transactions
    Order Management
    • fa-scm-fom-sales-orders
    • fa-scm-fom-sales-order-lines
    Product Lifecycle Management
    • fa-fscm-item
    • fa-fscm-proposal
    • fa-fscm-imanufacturer
    • fa-fscm-change
    • fa-fscm-change-history
    • fa-fscm-change-approvals
    • fa-fscm-structure
    • fa-fscm-item-version
    • fa-fscm-item-history
    • fa-fscm-tpi
    Service Logistics
    • fa-fsc-wocharges
    • fa-scm-depotsearch
    • fa-scm-partrequirements
    Supply Chain Planning
    • fa-scm-msc-lead-time-insights
    • fa-scm-msc-lead-time-orders
    • fa-scm-msc-plan-members
    • fa-scm-msc-supplies-demands
    Supply Chain Collaboration
    • fa-scm-vcs-customer-demand-documents
    • fa-scm-ypr-buyer-plan
    • fa-scm-vcs-supply-collaboration-relationships
    • fa-scm-vcs-collaboration-order-forecasts
    Supply Chain Orchestration
    • fa-scm-dos-supply-requests
    Sustainability
    • fa-prc-sus-activities

    External Purchase Prices

    • fa-scm-epp-lines

    Purchasing

    • fa-prc-po

    • fa-prc-po-schedules

    • fa-prc-pa

    • fa-prc-pa-line

    • fa-prc-wc

    Self Service Procurement

    • fa-prc-por

    • fa-prc-shoppingcatalog

    • fa-prc-pa

    Note: If the Purchasing indexes are not set up in your Fusion environment and you plan to use the Agreement LOV, then ensure that you also set up the fa-prc-pa index.

    Sourcing

    • fa-prc-pon-buyermessages

    • fa-prc-pon-suppliermessages

    • fa-prc-pon-negotiationresponses

    • fa-prc-pon-managenegotiations

    Supplier Model

    • fa-prc-poz-registrations

    • fa-prc-suppliers

    Supplier Qualification

    • fa-prc-poq-qualifications

    • fa-prc-poq-questionnaires

    • fa-prc-poq-initiatives

    Spend Classification
    • fa-prc-poi