Set Up Elastic Search for Catalog Shopping

To use the Responsive Self Service Procurement application, you must set up elastic search in addition to the regular implementation setup for Oracle Self Service Procurement.

To set up elastic search for catalog shopping, ensure you have the Manage Procurement Catalog Content privilege and follow these steps:

1. In Manage Administrator Profile Values task, set the values for these profile options:
   1. Enable/Disable Search Ext Framework profile (Code: ORA_FND_SEARCH_EXT_ENABLED) to Yes.
   2. Set Row fetch count for initial ingest process (Code: ORA_FND_SEARCH_FETCH_COUNT) to 100.
2. Navigate to Tools>Scheduled Processes and then click Schedule New Process.
   1. Search and select process name: Transform Data Post Upgrade.
   2. Parameter Value for Feature Name: POPULATE_ELASTIC_INTERMEDIATE_TABLE.
3. Monitor the process Transform Data Post Upgrade and after it’s complete, wait for at least 2 hours to ensure that the updated database statistics are available for the next process to run efficiently.
4. Navigate to Tools>Scheduled Processes and then click Schedule New Process.
   1. Search and select process name: ESS job to create index definition and perform Initial Ingest to OSCS.
   2. Parameter Value for Index Name to Reingest: fa-prc-shoppingcatalog.

Note: You must run the ESS job to create index definition and perform Initial Ingest to OSCS and Transform Data Post Upgrade scheduled processes only once when setting up the elastic search.