JSON Search Index Maintenance

Oracle Health Insurance applications make use of JSON Search Indexes. These indexes require regular maintenance. The following table lists the JSON Search Indexes per the Oracle Health Insurance 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
Claims	OHI_REF_SHEET_LINE_IDX1
Policies	OHI_REF_SHEET_LINE_IDX1
Oracle Insurance Gateway	OIG_EXCHANGE_IDX1
Oracle Health Insurance Product Definition	OHI_REF_SHEET_LINE_IDX1

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

Claims

OHI_REF_SHEET_LINE_IDX1

Policies

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).