My Oracle Support Banner

Enhancement Request - Additional Column on Primary/Unique Key Fin_financial_holds (Doc ID 2343179.1)

Last updated on MARCH 28, 2019

Applies to:

Oracle Health Insurance Claims Adjudication - Version 2.17.2.0.0 and later
Information in this document applies to any platform.

Goal

The use case is the need to add multiple financial holds of the same type on CTR level; the provider identification on remark field is used to sort the financial hold.  There is a unique key composed of subject_id, financial_hold_type and start_date; the use case mentioned creates an error message saying that the hold already exists.  The suggestion is to add the provider field into fin_financial_holds table and use it as part of unique key.
A workaround is to add to the dynamic logic (which adds the holds) a delay between the creation of holds, but this impacts performance.
 

Solution

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
Goal
Solution
References


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