JSON Search Index Maintenance

OHI applications make use of JSON Search Indexes. These indexes require regular maintenance. The following table lists the JSON Search Indexes per OHI application:

Oracle Health Insurance Application	JSON Search Index
Oracle Health Insurance Authorizations	OHI_REF_SHEET_LINE_IDX1
Oracle Health Insurance Value-Based Payments	OHI_REF_SHEET_LINE_IDX1
OHI Claims Adjudication and Pricing	OHI_REF_SHEET_LINE_IDX1
OHI Enterprise Policy Administration	OHI_REF_SHEET_LINE_IDX1
Oracle Insurance Gateway	OIG_EXCHANGE_IDX1
Oracle Health Insurance Product Definition	OHI_REF_SHEET_LINE_IDX1

Oracle recommends to set up a scheduled job in the database to regularly optimize the index using the OPTIMIZE_INDEX procedure (see the Oracle Database documentation for details).