My Oracle Support Banner

Need To Update A Dynamic Field Field Definition (Doc ID 2808710.1)

Last updated on SEPTEMBER 23, 2021

Applies to:

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

Goal

We currently have a dynamic field at POL_POLICY_ENROLLMENTS level.
This field has a field definition as Numeric 1, 0.
We need to increase the field size to 2, but we cannot simply update the field definition, cause the same field definition is being used in other dynamic fields.

And we cannot create a new field and migrate the old data, cause for that, we would need to edit and submit all the policies which are already in the system.

Can you create a query to run in the DB, and make this change?
 

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.