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 available for the search engine.

The very first ingestion of searchable data into the search index is called the initial data ingestion. For indexes that are initialized using the ESS job to create index definition and perform initial ingest to OSCS scheduled process, the initial ingestion of each search index 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 avoid loading up 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. Use this process only for the indexes listed in the HCM and SCM tables in this topic.

Navigate to Tools > Scheduled Processes.
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.
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 runs for all predefined indexes that support this initial-ingestion process. We recommend that you only create indexes related to your product family.
- 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 that you submit indexes one by one to keep from loading up the OSCS.

Run the process for the respective products deployed in your environment. The following tables list the HCM and SCM indexes that you can use as input to this scheduled process.

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-learningassignmentprofile fa-hcm-learningrecordtask 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 fa-hcm-contentitem fa-hcm-teamskills fa-hcm-careerrole fa-hcm-wlf-rolealignment
Journeys	fa-hcm-workerjourney fa-hcm-workerjourneytask
Connections	fa-hcm-profile-tag
Benefits	fa-hcm-personbenefits

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 Note: Some Supply Chain Planning indexes are system-managed and aren’t initialized using the ESS job to create index definition and perform initial ingest to OSCS process. For information about setting up the `fa-scm-msc-plan-members` and `fa-scm-msc-supplies-demands` indexes, see Set Up Oracle Search for Supply Chain Planning.
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