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