Enhancement Request - Additional Column on Primary/Unique Key Fin_financial_holds

(Doc ID 2343179.1)

Last updated on DECEMBER 26, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms