My Oracle Support Banner

Policy Calculation Error (Doc ID 2405240.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Health Insurance Enterprise Policy Administration - Version and later
Information in this document applies to any platform.


When creating a new policy and changing the enrollment period, an error is thrown: ORA-00001: unique constraint (OHI_POLICIES_OWNER.POL_CALCULATION_RESULT_UK1)
from the following scenario:

1. Create a new policy with a member for a full year, run calculate and financial steps
2. Change policy by adding an end date for the member of June 15, i.e. reduce to a shorter period. Run calculate and financial steps. The July-Dec results are now reversed -- this works fine.
3. Change the policy again by increasing to a longer period, for example until August. Run calculate and financial steps.
4. When calculating the new versions, the reversed results are ignored, leading to duplicate versions.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.