Release Notes for Oracle Health Insurance Enterprise Policy Administration Release 4.24.1.0.0

This document contains the release notes for Oracle Health Insurance Enterprise Policy Administration Release 4.24.1.0.0.

Version compatibility: Oracle Health Insurance Enterprise Policy Administration Release 4.24.1.x is only compatible with other Oracle Health Insurance applications release version 4.24.1.x unless explicitly stated otherwise.

In accordance with the OHI error correction policy (Document 1494031.1 on My Oracle Support), error correction support will be provided for this release and the previous two releases.

Enhancements

ID	Summary	Patch
AUT-3282	Enhance Monitoring/Liveliness Check in OHI applications OHI applications expose a /health endpoint that should report the healthiness of the application on that node. The implementation originally was very limited: it returned a static response. This has been changed in 4.23.1: if memory is lower, /health returns 429. With this release we are extending the /health endpoint to: /health/ready which returns UP if the node is able to process requests, DOWN otherwise. A number of readiness checks have been implemented including memory, database connectivity and cpu utilisation for which the threshold is defined by a new optional system property ohi.system.cpu.threshold.high /health/live which returns UP if the node is still alive, DOWN otherwise. A liveliness check has been implemented using the Coherence Health Check API. Documentation Links: Administration Guide - Application Health Check Endpoint
AUT-3342	Automatic detection of stuck activities As part of this enhancement, when an activity is in queue, the Activities IP returns status QD (Queued). Added new status QD to the domain "ACTIVITY STATUS". Added a new column process_queued_datetime to the table "act_activities". Stuck Activities: Added a new functionality to detect and send notification for the activities that get stuck. This functionality is enabled by default and can be disabled by setting ohi.activityprocessing.heartbeat.frequency property value to '0'. The following system properties have been added to set up heartbeat and cleanup service time intervals for activities: ohi.activityprocessing.cleanup.frequency (default value is 600 seconds) ohi.activityprocessing.heartbeat.frequency (default value is 300 seconds) When an activity is detected as stuck, that is when the root activity’s status changes from InProcess (IP) to TechnicalError (TE) by the cleanup service, it is re-submitted and the maximum number of re-submissions can be configured by the following property: ohi.activityprocessing.max.resubmit.attempt.count (default value is 3) If the stuck activity exceeds max.resubmit.attempt.count, it is sent as a notification to any of the following configured endpoints: ohi.activityprocessing.notification.endpoint.<0>, where 0 is activity type. ohi.activityprocessing.notification.endpoint Documentation Links: Developer Guide - Activity Model Developer Guide - Activities
CPN-3037	Automatically gather SQL monitor report for REST API call In many scenarios, evaluating the SQL execution plan for REST API calls is crucial to determine the efficiency of their access paths and to gauge their potential resource cost. The current manual process of enabling SQL logging, identifying relevant SQL statements within the logs, and retrieving their execution plans/SQL monitor plan is time consuming for the DBA/AMS team (in SaaS deployments). This enhancement aims to automate the creation and retrieval of SQL monitor reports for Query API calls, eliminating the need for manual intervention and streamlining the process. As part of this feature, a new header parameter enablesqlmonitorreport is introduced in Query API. This parameter is intended for use only in Non-Production environments and can have the following values: all: Monitors all SQL queries generated in the Query API rootResourceOnly: Monitors only the SQL query generated on the root resource Not specified: If this header is not included, no SQL monitor report is generated for any SQL query, maintaining the current behavior Documentation Links: Developer Guide - Gathering of SQL Monitor Report
CPN-3079	Auto purge feature As data volume in Oracle Health Insurance applications continue to grow with the processing of more data, it becomes essential to manage the database efficiently. Oracle Health Insurance applications include various PL/SQL packages for purging processes. However, these processes currently require manual intervention by customer DBAs/AMS team to configure and schedule purge jobs during planned maintenance windows. To streamline this process and automate database maintenance, we are introducing an auto-purge job feature. This feature eliminates the need for manual scheduling of various purge jobs and ensures that data is regularly purged according to predefined criteria. As part of this enhancement, we have a introduced a new PL/SQL package ohi_auto_purge_pkg.purge_all and modified the following functionalities : The structure of the following procedures has been revised, introducing an optional input parameter p_commit_size to enhance flexibility and control over the purging process cla_data_purge_pkg.purge_data ohi_repl_purge_pkg.purge_data Log message purging is now integrated into the auto-purge feature, and as a result, the following HTTP API resources have been made read-only. logeventretentionperiods API loglevelretentionperiods API Purging of PHI logs is now integrated into the auto-purge feature. So, the property ohi.logging.phi.min.retentionperiod is removed The process now integrates purging of all datafile sets into the auto-purge system, eliminating the need for separate scheduled scavenging and purging of incident files. So, the property ohi.incident.datafileset.retentionperiod is removed Oracle recommends frequent and automatic purging of technical data and operational data using the auto-purge job feature. For example, customer DBA/AMS team (in SaaS) can set up auto purge through the use of a DBMS_SCHEDULER job. See the user guide for more details and for a sample SQL script that creates auto purge job using DBMS_SCHEDULER.create_job PL/SQL procedure. Note that the initial purge job might take longer if the volume of the data is very high (for example, if the system has two years of data to purge and if the retention days for technical data are set to 60 days). So, Oracle recommends the DBA/AMS team to set a higher retention period (for example, one year and 11 months) for the initial run (so only 30 days of data is purged in the very first run). The retention days can be reduced gradually until the historical data is purged. Documentation Links: Administration Guide - Auto Purge Administration Guide - Purging Data from Technical Tables Administration Guide - Purging Data from Replication Technical Tables Administration Guide - Datafile Set Trace Files Retention
CPN-3100	Enhancing Environment Name Setup in Oracle Health Insurance Applications We are improving how the environment name is set in Oracle Health Insurance applications using the (existing) system property ohi.environment.identifier which can be set by the DBA for on-prem deployments or by AMS team in case of SaaS deployment. This change will impact the following areas: Property Management: Property entity includes a name, value, and environment attribute. Previously, the environment attribute matched the application’s database name. Going forward, it will reflect the value set in the set for the system property ohi.environment.identifier. Source Environment Tracking: Configuration items selected for migration include eight auditing fields. Previously, the two source environment fields (createdByEnvironment and lastUpdatedByEnvironment) stored the database SID. These fields will now reflect the value set in the system property ohi.environment.identifier. Note that in the UI, the environment name in the configuration migration import page will show the database SID for the old imports, but going forward (for new imports), the value set in the system property ohi.environment.identifier will be shown. Data Set Operations Integration Point: When importing from an environment, the "sourceEnvironment" attribute is required. Previously, this attribute contained the database SID of the source environment. Now, it will reflect the value set in the system property ohi.environment.identifier from the source system. These changes remove the dependency on the database SID and eliminate the need to access the DBMS to retrieve the environment name. Note: The value of the ohi.environment.identifier system property should not exceed 158 characters, as specified in the property description. Documentation Links: Administration Guide - Property Management Configuration Guide - Source Environment Tracking Developer Guide - Data Set Operations IP - Import From Environment
CPN-3120	Dynamic chunk size for extract activities This enhancement is further optimization in extract execution on top of this enhancement POL-12778, which has been delivered as backports in 4.23.2, 4.23.1 and 3.22.2. This release introduces improvements to the memory utilization of the extract activity, optimizes the loading of dynamic records, and updates several configuration properties related to extract activity. Memory Utilization Improvement When an extract is executed, the application creates a global activity. The global activity spawns multiple child activities. Each child activity extracts a specific number of entities/records and creates a data file. Initially, each child activity extracts records in chunks, based on the system property ohi.processing.chunksize.SELECT_EXTRACT_ITEMS. In this release, the system dynamically adjusts the chunk size based on memory utilization, starting with the value configured in ohi.processing.chunksize.SELECT_EXTRACT_ITEMS and optimizing as needed. Optimization of Dynamic Records Loading The system previously loaded all dynamic records of an entity into memory and then filter for the required dynamic record. In this release, the system directly loads only the required dynamic records into memory, significantly optimizing the process. Configuration Properties Update Following properties have been added in POL-12778 and we have removed them in this enhancement: ohi.extract.datafilesize ohi.extract.datafilesize.{0} We’ve introduced 3 new properties (see Configuration Properties section for more details on these properties): ohi.extract.datafilecount ohi.extract.datafilecount.resourcename.{0} ohi.extract.datafilecount.notificationkey.{0} Documentation Links: Developer Guide - Processing of extracts
NXT-24066	WebLogic authentication implemented compliant with the Java Authorization and Authentication Service (JAAS) specification This enhancement introduces support for the SAML 2.0 authentication mechanism in the Oracle Health Insurance. Additionally, a new JAR file named "CustomIdentityAsserter" has been created to accommodate the Basic Auth configuration. Refer installation guide for further detail. Documentation Links: Installation Guide - Users and Authentication	3.22.2.0.26, 4.23.1.0.6, 4.23.2.0.5
NXT-24398	Cache query (by code) results on configuration entities This enhancement implements caching for all the configuration entities using code. This has been previously implemented only for a few entities.	4.23.2.0.0
NXT-27703	New REST endpoint to return fully constructed property model using floorplan & metadata A new IP has been introduced, which combines floor plan and metadata in the same response. This reduces the number of REST calls from UI, thereby improving page loading time.
NXT-27912	Support for regEx in UI This enhancement introduces ability to: * Specify regular expressions for string and number fields * Define the range for date fields * Override the minimum and maximum field length for number and string fields Documentation Links: Developer Guide
NXT-28011	Search Page for all Providers This enhancement introduces a new search Page for all Providers, where all providers (organizational and individual) can be searched.
NXT-28050	Improvements to page templates : Search Pages (List and Table) With this enhancement, Search Object List View and Search Object Table View Floorplan look and feel is updated: Global header is fixed when page scrolls Theme strip bar is moved from Global header to App header bottom Floor Plan Selection, Quick Search and Advanced Search are left aligned Page level Primary and Secondary actions are right aligned Table and Result level actions are shown in content area Documentation Links: Developer Guide
NXT-28067	UI: Copy feature for editable table This enhancement allows user to configure copy action on table and tab table components in the floorplan at the row level. Clicking on copy: - Creates a new entry in Edit mode. - Does a deep copy of the object including child resources as configured in the Floorplan.
NXT-28236	UI: Download in Widgets This enhancement introduces ability to download viewed data from widgets
NXT-28241	Upgrade Coherence library in activity processing In this release, we have upgraded Coherence library used in activity processing to enhance the efficiency. Additionally, a new system property has been introduced, giving you the flexibility to disable activity processing on a specific JVM/node if necessary. This can help manage workloads more effectively. Documentation Links: Developer Guide - Disable Activity Processing on a Specific JVM/Node
NXT-28449	Additional functionality for UI Form component With this enhancement, the UI Form component now supports: Editable list resources Sort capabilities for tables configured within a Form Conditionally hiding a sub-section	4.23.2.0.1, 4.23.2.0.3
NXT-28465	Optimize REST graph recreation of reference sheet line when a new reference sheet is created It was observed that creating reference sheet line every time a reference sheet creates is expensive process, which is causing huge memory consumption and causing time out issues. To address this, some source code have been optimised in ReferenceSheet.
NXT-28671	Improvements to page templates : View and Edit List (Table) With this enhancement, Search View and Edit Object List (Table) Floorplan look and feel is updated: Global header is fixed when page scrolls Theme strip bar is moved from Global header to App header bottom Floor Plan Selection, Quick Search and Advanced Search are left aligned Page level Primary and Secondary actions are right aligned Table and Result level actions are shown in content area
NXT-29497	UI: Copy feature on Floorplan, Widget pages and dynamic records This enhancement gives the copy action on Floorplan and Widgets pages out of the box and for tab list (result component) a user can configure copy action for all dynamic records
NXT-30155	Removal of whitespaces from the HTTP API responses In Oracle Health Insurance Enterprise Claims Adjudication, to optimize the loading time of the claims page to improve overall performance, we have disabled fomatting of HTTP API responses. This reduces the size of the response.
POL-11680	Metadata change for conditional mandatory dynamic field usages When retrieving the metadata for a resource, dynamic field usages configured as conditional mandatory are now excluded from the list of required attributes.
POL-11786	Automatic detection of stuck long running operations (activities, tasks) Stuck Activities: Added a new functionality to detect, re-submit and send notification for the activities that get stuck. This functionality is enabled by default and can be disabled by setting ohi.activityprocessing.heartbeat.frequency property value to '0'. The following system properties have been added to set up heartbeat and cleanup service time intervals for activities: ohi.activityprocessing.cleanup.frequency (default value is 600 seconds) ohi.activityprocessing.heartbeat.frequency (default value is 300 seconds) When an activity is detected as stuck, that is when the root activity’s status changes from InProcess (IP) to TechnicalError (TE) by the cleanup service, it is re-submitted and the maximum number of re-submissions can be configured by the following property: ohi.activityprocessing.max.resubmit.attempt.count (default value is 3) If the stuck activity exceeds max.resubmit.attempt.count, it is sent as a notification to any of the following configured endpoints: ohi.activityprocessing.notification.endpoint.<0>, where 0 is activity type. ohi.activityprocessing.notification.endpoint Documentation Links: Developer Guide - Activities Developer Guide - Activity Model	4.23.2.0.0
POL-12035	Include Flex Code Identifiers in Extracts For multi-value or time-validity usage: . Unique ID added for for multi-valued or time-validity usage for the field/FlexCode . FlexCodeSystem ID added as "flexCodeDefinitionId” for FlexCode/DynamicRecord . Additional fields to be added which are not marked as key value or descriptors and the actual usage name for FlexCode/DynamicRecord For Single value Non Time Valid usage: . FlexCodeSystem ID added as "flexCodeDefinitionId” for FlexCode/DynamicRecord . Additional fields to be added which are not marked as key value or descriptors and the actual usage name for FlexCode/DynamicRecord
POL-12640	Handle the activity failover elegantly When the node processing activities crash, the InProcess (IP) activities remain stuck indefinitely. These stuck activities can’t be recovered because they are not in end state (completed/ error state). As part of this enhancement, a periodic scan is performed to identify and mark the stuck activities with a TechnicalError (TE) status. These activities (parent activities) are then resubmitted for processing, if their re-submission count is less than the value configured by the system property "ohi.activityprocessing.max.resubmit.attempt.count". Documentation Links: Developer Guide - Automatic Detection of Stuck Activities Developer Guide
POL-12778	Extracts: Decouple bucket size from fetch size When an extract is executed, the application creates a global activity. The global activity spawns multiple child activities. Each child activity fetches a specific number of entities and stores them in a data file. The ohi.processing.bucketsize.SELECT_EXTRACT_ITEMS system property determines the number of entities fetched per child activity or the fetch size. All the fetched entities per child activity, are stored in the same data file. Therefore, the higher the value of the system property, the higher the number of entities gathered in a single data file. This could cause memory issues when a large number of entities and subresources (from a single data file) are fetched into the memory at the same time. The ohi.processing.chunksize.SELECT_EXTRACT_ITEMS` property determines the size of a chunk and has a default value of 100. The value of this property represents the number of entities fetched at the same time in a single chunk. Setting a higher value for this property (for example, 500) decreases the duration of the extract as the number of entities fetched each time increases. The ohi.processing.bucketsize.SELECT_EXTRACT_ITEMS is no longer required and hence can be removed from the configuration. The change of property values is only recommended if the application is facing issues performing at optimal levels. Documentation Links: Installation Guide - Application Properties	3.22.2.0.25, 4.23.1.0.4, 4.23.2.0.1
POL-12956	Purge data files In Oracle Health Insurance applications, data files generated during various activities (e.g., extract activity, financial messages activity and data files uploaded to initiate long-running operations) remain in the system even after they have been processed/consumed. Currently, there is no mechanism in place to automatically clean up these data files once they have been processed/consumed, leading to inefficiency of the database storage space. This enhancement aims to automate the cleanup process and optimize database storage space. To enable purging data files, we have introduced a new PL/SQL package ohi_purge_datafileset_pkg. Documentation Links: Administration Guide - Purging Data from Data File Sets
POL-12999	Patch operation on policy enrollment product With this enhancement, the system supports automatic update on the policy enrollment product list for various update use cases when an update is received via 'Policy IN Patch' or 'Policy Update Request'. The system also supports the user to configure, to allow or restrict mulitple active policy enrollment products with the same product category. Documentation Links: Configuration Guide - Enrollment Product Developer Guide - Patch on Policy Enrollment Product Operations Guide - Cover Never In Force Reason
POL-13500	Tracking processed policy mutations This enhancement introduces an ability to back up the processed policy mutations. This helps fix the premium calculation result after a configuration error and identifies the policies to recalculate.	4.23.2.0.5
POL-13518	Endpoint change for data masking definitions As part of this enhancement, the endpoint to configure and maintain data masking definitions is updated to /datamaskingdefinitions along with updated response messages. Documentation Links: Developer Guide
POL-13544	Remove Deprecated Feature: Activity to execute dynamic logic This enhancement removes the deprecated activity to execute dynamic logic.
POL-13577	Remove marital status type domain This enhancement removes the deprecated marital status type domain.
POL-13923	Policy and Policy Enrollment pages for Medicare Advantage This enhancement introduces additional Policy and Policy Enrollment pages that allow users to view and maintain Medicare Advantage-related policies. The Medicare Advantage floorplans for Policies, that is, POLICIESMA, POLICYENROLLMENTSMA, and POLICYENROLLMENTPRODUCTSMA are disabled by default and can be enabled using the Floorplans page. UI uses the field type on the Policy to identify Medicare Advantage policies and uses the same to load appropriate floorplans to render the policies page, that is, policy.type = MEDICARE ADVANTAGE. It is recommended to configure and use separate floorplan tags for other Policies and Policy related floorplans after enabling the Medicare Advantage floorplans, including the default system floorplans for Policies, that is, POLICIES, POLICYENROLLMENTS, and POLICYENROLLMENTPRODUCTS to ensure correct floorplans are rendered for non-Medicare Advantage policies. See Floor Plan Loading and Storage for user interface for additional details on floorplan tags.	4.23.2.0.1
POL-13924	UI: Improved embedded view for tab component This enhancement introduces additional control for the embedded view for tabs i.e. by configuring 'dualDefault' within the floorplans
POL-13948	A notification message when user leaving a group on "changed" status. This enhancement introduce a notification message to be displayed when a user exist a group in "changed" status.
POL-14056	Policy Enrollment Product page for Medicare Advantage policies A new Policy Enrollment Product page is introduced providing users the ability to view and maintain policy enrollment product details for Medicare Advantage policies.	4.23.2.0.1
POL-14105	Medicare Data-model for Policies - Additional Transactional Details This enhancement Introduces new fields to store additional transactional and audit-related details for Medicare Advantage policies. Ability to configure OEC SEP codes, SEP reasons, and disenrollment reasons, including new UI pages. Ability to cancel late enrollment penalty, creditable coverage, and period records for policy enrollment Medicare details using the Policy In patch operation. Ability to view and update county and state county code fields using the person’s address page. Additional validations to only allow positive values for number fields on Medicare Advantage related entities. Documentation Links: Developer Guide Operations Guide
POL-14106	Allow adding and removing parameter values on an enrollment product at the same time in dynamic logic This enhancement enables customers to add and remove parameter values at the same time in (validation) dynamic logic .	4.23.1.0.3, 4.23.2.0.1
POL-14132	Clearance of activities stuck in In Process stage from coherence submission caches using IP Due to excessive load, the processing-pattern grid service stops processing activities, causing them to be stuck in the in process stage for a long time. Manually marking these activities to technical error (TE) and resubmitting them results in an exception as a reference to these activities already exist in coherence submission caches. Thus, the recovery of activities is only possible upon a full restart. The new integration point supports the clearance of coherence submission caches to facilitate the activity recovery process to avoid a complete restart. Documentation Links: Developer Guide - Clear Coherence Submission Cache Integration Point	3.22.2.0.26, 4.23.1.0.5, 4.23.2.0.3
POL-14140	ADF specific configuration removed This enhancement removes and modifies configuration that was for ADF specific Documentation Links: Developer Guide - External Links Developer Guide
POL-14177	UI: Configuration page changes for Medicare Advantage This enhancement: Introduces a new UI page to configure Medicare Plan Listings Updates the existing business event rules, change event rules and configuration migration pages to support the new Medicare Advantage related entities
POL-14247	Transaction Reply Report page A new 'Transaction Reply Report' object navigation page is introduced for Policy page providing users the ability to manage Transaction Reply Reports for Medicare Advantage policies.	4.23.2.0.1
POL-14287	UI: Premium and sample run results auto-expaned (default) This enhancement allows the user to view the premium results expanded at a detailed level by default; to view an overview of the premium, click the collapse button.	4.23.2.0.5
POL-14406	JET UI: Ability to search policies based on group client code This enhancement introduces ability to search on policies based on group client code
POL-14411	Optimization : Process registration process Process registration process is optimized to ignore future dated mutations and thereby preventing unnecessary re-calculations.
POL-14578	Announce deprecation to Remove property ohi.ws.enrollmentresponse.request.lob This enhancement deprecates the ohi.ws.enrollmentresponse.request.lob property
POL-14595	Additional logs for flexcodesystem code at the level of dynamic field setup cache and for translation records in the database Policy submission led to a Null Pointer Exception because flexcodesystem code was not found at the dynamic field setup cache or because of missing entries for translation records of the code in the database.	4.23.1.0.3, 4.23.2.0.1
POL-14640	Introducing a scheduler for checking the status of the current tasks The task processing framework has been improved with automated mechanisms for task recovery and notifications in case tasks (for example, data replication synchronization task) become stuck in a particular status for a long time. Documentation Links: Administration Guide - Application
POL-14825	UI: Policy enrollment products as table and member election responses for Medicare Advantage policies With this enhancement Policy page is updated to display the policy enrollment products in tabular fashion for Medicare Advantage policies Medicare details section for Policy Enrollment Product page is expanded by default A new section is introduced under policy enrollment products page to capture member election responses for Medicare Advantage policies
POL-15307	Financial: Ability to send Accounting Details seperately OHI application sends out accounting details along with the financial message. Also, the granularity of grouping of account details is bounded by invoice grouping. That is details within an invoice can only be grouped. This posses challenges for customers who would like accounting to be done at different level , compared to invoice. Example Invoice is per member, but accounting across member for a product With this enhancement it will be possible to 1) send out account details as part of separate batch and 2) have grouping logic which is not bounded by financial message grouping or invoice grouping.
POL-15391	Additional rules to restrict updates on payment registrations Australian premium calculation process depends on various settings on payments registrations, and some of these attributes can only be set by the calculation process. Currently there are no restrictions which prevents changes to these setting though API/IP. This posses a risk that apply registration process may not compute the date paid to correctly or may get completed with errors. This enhancement introduces new business rules on registration entity to prevent errors which can be caused by adjusting payment registrations though external interface.
POL-9574	Populating elementId in activity messages (for technical errors) Activity messages have an elementId populated in almost all cases (except for global activities, where, for instance, a message is added, if a parameter is not passed on correctly). That way, it is possible to correlate an error to a policy.
POL-16238	Deprecated APIs in Groovy 3 In the upcoming 4.25.1.0.0 release, we will upgrade the Groovy library from 3.x to 4.x. Several APIs have been deprecated in Groovy 3 and are removed in Groovy 4.

Upgrade Steps for Installation

To perform the upgrade, perform the following steps:

1. Perform any pre-upgrade steps.

2. Stop all the managed nodes running the existing version of the application.

3. Perform any pre-undeploy steps.

4. Undeploy the existing version of the application.

5. Back up the database.

6. Perform any post-undeploy steps.

7. Unpack the release bundle into a directory that we refer to as OHI_ROOT from now on.

8. Change Installation Configuration: In <OHI_ROOT>/util/install, make a copy of ohi_install.cfg.template and name it ohi_install.cfg.

9. Edit ohi_install.cfg to contain your specific database connection data and other configuration settings. The settings are explained in the file itself.

10. Make sure NO connections are present to the database using the OHI_xxx_USER account (where xxx is the abbreviation of the application)

11. Run the Upgrade script:

    1. Open a command window and browse to <OHI_ROOT>/util/install.

    2. Run the upgrade by executing ./ohi-update.sh .

12. Make the required changes to the ohi properties file

13. Perform any post-upgrade steps

14. Start WebLogic application server

15. Deploy the Application

16. Perform any post-deploy steps

Additional Upgrade Steps for Installation

The following phases are defined: pre-upgrade: Application is still running pre-undeploy: Application is stopped, but not undeployed. post-undeploy: Application is undeployed. Database is backed up post-upgrade: Released upgrade script has run. post-deploy: New application is deployed and is up and running.

post-undeploy

1. See "Users and Authentication" section in the "Install and Configure Oracle WebLogic" topic in the Installation Guide, before deploying the new upgraded EAR if you are using Basic Auth as the authentication mechanism.

2. Install the mandatory Coherence 14.1.1 Feature Pack 22.06 Cumulative Patch 9. See the Installation Guide, section "Required Software" for more details.

3. Removal of the deprecated operational reporting views:
   The support of the operational reporting views has been removed from this release, and their schemas and the roles will no longer be required. The below steps are optional and if the customer wants to use the deprecated operational reporting views, they can retain the below schemas
   OHI_POLICIES_VIEWS_OWNER
   OHI_POLICIES_CONF_VWS_OWNER
   OHI_POLICIES_NONCONF_VWS_OWNER
   

   OHI will not support any changes or fixes to the above mentioned schemas.
   

   As a part of the upgrade, it is recommended to run the following commands as SYSTEM user to remove the below schemas and the roles from the application pdb:

   DROP USER OHI_POLICIES_VIEWS_OWNER CASCADE;
   DROP USER OHI_POLICIES_CONF_VWS_OWNER CASCADE;
   DROP USER OHI_POLICIES_NONCONF_VWS_OWNER CASCADE;
   DROP ROLE OHI_POLICIES_CONF_VWS_ROLE;
   DROP ROLE OHI_POLICIES_NONCONF_VWS_ROLE;

4. As part of POL-14140, the HttpLink entity has been removed. If the HttpLink was exported or imported using the Configuration Migration Tool (CMT), the technical tables may still contain references to the HttpLink record. To clear these references, run the following commands as OHI_POLICIES_OWNER:

   TRUNCATE TABLE OHI$CFG_MIGR_MARSHALLED_ITEMS;
   TRUNCATE TABLE OHI$DATA_SET_PROCESS_FAILURES;

post-upgrade

Note: This action applies only to the production environment.

Action: In the properties file, add a new property ohi.query.api.enable.sqlmonitorreport and set its value to false.

Example: ohi.query.api.enable.sqlmonitorreport=false

Configuration Properties

Ref	Action	Description
AUT-3282	Added	ohi.system.cpu.threshold.high Property to set the system CPU utilisation threshold. If system CPU goes above this value, the system enters the low CPU state.
AUT-3342	Added	ohi.activityprocessing.max.resubmit.attempt.count This property configures the maximum number of times a stuck root activity can be re-submitted for processing.
AUT-3342	Added	ohi.activityprocessing.heartbeat.frequency This property configures the scheduled time frame for updating the last_updated_date column for the running activities to rectify the activities getting stuck in the progress status.
AUT-3342	Added	ohi.activityprocessing.cleanup.frequency If any in progress activities, (current - last updated date) timestamp is greater than value configured by this property, then the status gets updated to technical error.
CPN-3037	Added	ohi.query.api.enable.sqlmonitorreport Property to enable SQL monitor reports. Set to TRUE (by default) for lower environments and set to FALSE for production environment.
CPN-3079	Removed	ohi.incident.datafileset.retentionperiod Purging of all datafile sets is now integrated into the auto-purge system, hence, eliminating the need for separate scheduled scavenging and purging of incident files. So, this property is removed.
CPN-3079	Removed	ohi.logging.phi.min.retentionperiod Purging of logs is now integrated into the auto-purge feature. So, this property is removed. The default retention for PHI logs with the auto-purge function is 2560 days (7 years) and can be managed through the autopurgemetadata API
CPN-3120	Added	ohi.extract.datafilecount.resourcename.{0} This property behaves similar to ohi.extract.datafilecount, but controls the number of data files generated for a specific resourcename/entity. The placeholder value {0} refers to the resourceName used in the extract request.
CPN-3120	Added	ohi.extract.datafilecount.notificationkey.{0} This property behaves similar to ohi.extract.datafilecount, but controls the number of data files generated for a specific notificationKey. The placeholder value {0} refers to the notificationKey used in the extract request.
CPN-3120	Added	ohi.extract.datafilecount A new optional configuration property is added which controls the number of data files generated by the extract activity. This property also determines the number of child activities executed. The value set for this property directly impacts the parallelism of child activities. A higher value allows for more parallel child activities, which can improve performance by making the extraction process multi-threaded, but at the cost of generating more number of data files. On the other hand, Setting a value too low, such as 1 or 10, may result in the extract process functioning as a single-threaded operation, potentially reducing performance. While the default value of this property is set to 100, Oracle recommends to evaluate your specific requirements and performance needs to determine the optimal value.
CPN-3120	Removed	ohi.extract.datafilesize.{0} This property is replaced with new property ohi.extract.datafilecount.resourcename.{0}
CPN-3120	Removed	ohi.extract.datafilesize This property is replaced with new property ohi.extract.datafilecount
NXT-28241	Added	ohi.activityprocessing.enabled A new optional system property is introduced to disable activity processing on a specific JVM/node
POL-11786	Added	ohi.activityprocessing.heartbeat.frequency This property configures the scheduled time frame for updating the last_updated_date column for the running activities to rectify the activities getting stuck in the progress status.
POL-11786	Added	ohi.activityprocessing.max.resubmit.attempt.count This property configures the maximum number of times a stuck root activity can be re-submitted for processing.
POL-11786	Added	ohi.activityprocessing.cleanup.frequency If any in progress activities, (current - last updated date )timestamp is greater than value configured by this property then the status gets updated to technical error
POL-12640	Added	ohi.activityprocessing.max.resubmit.attempt.count This property configures the maximum number of times a stuck root activity can be re-submitted for processing.
POL-12778	Added	ohi.processing.chunksize.SELECT_EXTRACT_ITEMS This property controls how many items the system exports in one chunk. Once a single chunk is extracted, the memory gets cleared and the system will continu with the next chunk. The default value for this property is 100. If the value of ohi.processing.bucketsize.SELECT_EXTRACT_ITEMS is currently set to a lower value than 100, we recommend to use that value for this property as well.
POL-12778	Added	ohi.processing.chunksize.SELECT_EXTRACT_ITEMS.{0} This property controls how many items the system exports in one chunk per entity. Once a single chunk is extracted, the memory gets cleared. The placeholder should be replaced with the entity name, to be similar as the resourceName attribute in the Extract definition.
POL-12778	Removed	ohi.processing.bucketsize.SELECT_EXTRACT_ITEMS This property was formerly used to determine the number of entities fetched within a single child activity and therefore also determines the number of entities to be created in a data file. Now that those sizes as decoupled, this property does not serve any function anymore. Therefore, this property can be removed from the configuration (e.g. properties file)
POL-13625	Added	ohi.workflow.enable.request Decides whether workflow events should go out or not, if set to true workflow events will go out
POL-14640	Added	ohi.taskprocessing.<0>.processing.timeinterval Determines the overhead in seconds over the pending time interval to check if a task is stuck in the PENDING status.
POL-14640	Added	ohi.taskprocessing.scheduler.pending.overhead The maximum time for which a task can be present in the PROCESSING status. The scheduler will recover the task if it is in PROCESSING status for a time greater than this time interval. Allowable values are the ref_code’s: 'PolicyUpdateRequestPolling', 'DataReplicationTargetSynchronization', 'IntegrationEventAggregateCreator', 'IntegrationTransformation', 'RepublishingFailedMessages'. ref_code replaces {0}.
POL-14640	Added	ohi.taskprocessing.scheduler.frequency Determines how frequently the scheduler should run.
POL-14640	Added	ohi.taskprocessing.notification.endpoint The URL to which notifications should be sent by OHI if the task is in PROCESSING/PENDING status for a longer period or if the task is in ERRORED status. (Note that the maximum time a task can be in PROCESSING/PENDING status is configurable)
POL-14845	Added	ohi.oauth.token.jwt.assertion.param.name Name of JWT assertion parameter used in OAuth token request. It could be different across OAuth server. Default value is "assertion"

Web Services

Ref	Action	Description
AUT-3342	Modified	Activities API Attribute resubmitAttemptCount added.
CPN-3037	Modified	Query API A new header parameter enablesqlmonitorreport is introduced in Query API. This parameter is intended for use only in Non-Production environments and can have the following values: all: Monitors all SQL queries generated in the Query API rootResourceOnly: Monitors only the SQL query generated on the root resource Not specified: If this header is not included, no SQL monitor report is generated for any SQL query, maintaining the current behavior
CPN-3079	Added	autopurgemetadata API Added a new autopurgemetadata API
CPN-3079	Removed	logeventretentionperiods API logeventretentionperiods API supports only GET operation. POST/PATCH/PUT/DELETE operations are not longer supported
CPN-3079	Removed	loglevelretentionperiods API loglevelretentionperiods API supports only GET operation. POST/PATCH/PUT/DELETE operations are not longer supported
NXT-27703	Added	floorplans This IP will return floor plan combined with metadata in a single response.
POL-12999	Modified	neverinforcereasons API New attribute defaultNeverInForceReason (default false)
POL-12999	Modified	enrollmentproductcategories API New attribute restrictConcurrentProducts (default false)
POL-13500	Added	processedpolicymutation API New API to retrieve (un)processed policy mutations
POL-13500	Modified	Purge Policy Purge processed policy mutations
POL-13500	Modified	Premium Calculation Store processed policy mutations
POL-13500	Modified	Cancel Policy Store (un)processed policy mutations
POL-13518	Added	datamaskingdefinitions API deidentificationmetadata API got renamed to datamaskingdefinitions API
POL-13518	Added	datamaskingdefinitions IP deidentificationmetadata IP got renamed to datamaskingdefinitions IP
POL-13577	Removed	Policies integration point Removed previously deprecated "maritalStatusType" attribute for marital status of a Person.
POL-13577	Removed	Relation integration point Removed previously deprecated "maritalStatusType" attribute for marital status of a Person.
POL-14105	Modified	Policy Enrollment Medicare Periods API Added new audit columns transactionReceiptDateTime and transactionUpdateDateTime
POL-14105	Modified	Policy Enrollment Medicare CARA Statuses API Added new audit columns transactionReceiptDateTime and transactionUpdateDateTime
POL-14105	Modified	Medicare SEP reasons API It is allowed to delete, create and update all attributes
POL-14105	Modified	Medicare Disenrollment Reasons API It is allowed to delete, create and update all attributes
POL-14105	Modified	Medicare OEC SEP Codes API It is allowed to delete, create and update all attributes
POL-14105	Modified	Policy In IP Added optional attributes to policyMedicareReplyReport: memberContractId memberPBPNumber memberSegmentNumber transactionDate transactionEffectiveDate. Also added matching on: * File name * Transaction Code * Transaction Reply Code * Member Contract ID * Member PBP Number * Transaction Effective Date * Transaction Date Added new audit columns transactionReceiptDateTime and transactionUpdateDateTime for medicare CARA status, Part D Creditable Coverage, Enrollment Penalties and Low Income subsidies.
POL-14105	Modified	Attached Policy IP Added optional attributes to policyMedicareReplyReport: memberContractId memberPBPNumber memberSegmentNumber transactionDate transactionEffectiveDate
POL-14105	Modified	Policy Medicare Transaction Reply Reports API Added optional attributes: memberContractId memberPBPNumber memberSegmentNumber transactionDate transactionEffectiveDate
POL-14105	Modified	Addresses API Only positive values are allowed for stateAndCountyCode
POL-14105	Modified	Policy Enrollment Medicare Part D Creditable Coverages API Only positive values are allowed for uncoveredMonthsIncremental and uncoveredMonthsCumulative. Added new audit columns transactionReceiptDateTime and transactionUpdateDateTime
POL-14105	Modified	Policy Enrollment Medicare Part D Late Enrollment Penalties API Only positive values are allowed for lepAmount. Added new audit columns transactionReceiptDateTime and transactionUpdateDateTime
POL-14105	Modified	Policy Enrollment Medicare Part D Low Income Subsidies API Only positive values are allowed for premiumSubsidyAmount. Added new audit columns transactionReceiptDateTime and transactionUpdateDateTime
POL-14105	Modified	Medicare Plan Listings API Only positive values are allowed for amounts on totalPremiumPartC, totalPremiumPartD and totalPremium.
POL-14132	Added	clearsubmissioncaches IP New IP to clear coherence submission caches.
POL-14845	Added	Generic API for OAuthParameter Introduced generic APIs to manage OAuth parameters. Refer /generic/oauthparameters/metadata to know available endpoints to manage OAuthParameter entity
POL-14845	Modified	oauthassertionjwtbearergrantconfigurations Supports configuration of OAuth parameters through oAuthClientParameters
POL-14845	Modified	oauthclientcredentialsgrantconfigurations Supports configuration of OAuth parameters through oAuthClientParameters

Data Conversion

Ref	Action	Description
NXT-27703	Added	Access Restrictions Read access for the floorplans IP is provided as a part of mandatory accesses required for the applications in SETUP_ACCESS_ROLE.
NXT-28067	Modified	View Object List Pages System floorplan with View Object List template is updated with Copy action (also few system floorplan having tab table configuration)
NXT-29497	Modified	Floorplan and Widgets page System floorplan for Floorplans and widgets is updated with Copy action
POL-12999	Added	EnrollmentProductCategory New indicator restrictConcurrentProducts on EnrollmentProductCategory is set to false
POL-12999	Added	NeverInForceReason New indicator defaultNeverInForceReason is set to false
POL-13924	Modified	DualDefault property of floorplan is modified The following system floorplans are modified : Claims - "dualDefault": "expandedCreate" Policies - "dualDefault": "expanded" Policies (MedicareAdvantage) - "dualDefault": "expanded"
POL-14105	Modified	Medicare OEC SEP Codes This entity is no longer seeded
POL-14105	Modified	Medicare Disenrollment Reasons This entity is no longer seeded
POL-14105	Modified	Medicare SEP reasons This entity is no longer seeded
POL-14406	Modified	Modified search criterias in Policy Page Modified the system specific floorplan with policy holder and policy enrollment member lastname based search to LOV on persons. Added the support for group client search and group accounts.

Dynamic Logic

Ref	Action	Description
POL-13544	Removed	Execute Dynamic Logic Removed previously deprecated "Execute Dynamic Logic" from the list of activities.
POL-14140	Removed	country (Entity) Remove dynamic logic addressed to signature (Country Format)
POL-15176	Modified	groupClient.addGroupClientEvent The method groupClient.addGroupClientEvent returns the groupClientEvent created, so it is possible to set any (dynamic) field possible on it in the dynamic logic that calls this method

UI Changes

Ref	Action	Description
AUT-3342	Modified	All activity pages A new status - 'Queued' and a new field 'processQueuedDateTime' has been added to these pages.
NXT-28011	Added	Providers(All)(RM0036) New search page for Providers which displays results from both organization and individual provider. The create button provides a dropdown with the option to create an organization or individual provider.
NXT-28067	Modified	View Object List Pages Copy row action added for view object list pages and in some pages having tab table configuration
NXT-28236	Modified	Widgets Download button added to widgets
NXT-28449	Modified	Policy Enrollment page Form Table is made editable and sort is enabled in the form table for policy enrollment page with 'MEDICARE_ADVANTAGE' tag
NXT-29497	Added	Floorplan and Widgets page Added copy action in floorplan and widgets hierarchical recursive pages
POL-12999	Added	Never In Force(PO0209) New Checkbox added for Never In Force Reason
POL-12999	Added	Enrollment Product Categories(PO0134) New Checkbox added for Restrict Concurrent Product
POL-13923	Modified	Policy Enrollments page An additional Policy Enrollment page is added with 'MEDICARE_ADVANTAGE' tag
POL-13923	Modified	Policies page An additional Policy page is added with 'MEDICARE_ADVANTAGE' tag
POL-13948	Added	Group Client(PO0083) When the page is in changed status and the user navigates out of the page, a new dialog prompts the user to submit the Group Client or continue with navigation. This happens in view and edit mode.
POL-14056	Modified	Policy Enrollment Products An additional Policy Enrollment Product page is added with 'MEDICARE_ADVANTAGE' tag
POL-14105	Added	Medicare SEP Reasons Added new page
POL-14105	Added	Medicare OEC SEP codes Added new page
POL-14105	Added	Medicare Disenrollment Reason codes Added new page
POL-14105	Modified	Policy Enrollment Medicare Details Added new columns in the medicare related tables
POL-14105	Modified	Persons Added two new fields in the system floorplan
POL-14105	Modified	Transaction Reply Report Added new columns in the seeded floorplan.
POL-14140	Modified	Country(RM0004) Removal of below attributes from the country floorplan prompt additional part 1 prompt additional part 2 prompt additional part 3 dynamic function (Number Format)
POL-14177	Added	PO0208 New page Medicare Plan Listing added
POL-14177	Modified	Enrollment Product page, Business event rules page, Configuration Migration page Business Event Rules, Change Event Rules and Configuration Migration Pages are modified to support the new Medicare Advantage related entities
POL-14247	Added	Policy page - Transaction Reply Report (PO0212) An object navigation link and the associated floorplan for 'Transaction Reply Reports' page is added. The link is displayed only when policy type is 'Medicare Advantage'.
POL-14287	Modified	Policies(PO0001) Added a expand/collapse button to Example Calculation Dialog and View Premium Page. When the page opens the results are auto-expanded.
POL-14406	Added	Search component in Policy Page Search criteria is extended to support search on policies based on group client code
POL-14825	Modified	Policies Updated the policy enrollment product page to display the products in tabular fashion for Medicare Advantage policies
POL-14825	Modified	Policies Updated the policy enrollment products detail page to show election responses as a form in tab.

Breaking Changes

Ref	Action	Description
CPN-3079	Removed	loglevelretentionperiods API loglevelretentionperiods support only GET operation. POST/PATCH/PUT/DELETE operations are no longer supported. So, it is not possible to purge log messages based on a specific log level. Instead purging of logs (irrespective of the log level) is now integrated into the auto-purge feature
CPN-3079	Removed	logeventretentionperiods API logeventretentionperiods API support only GET operation. POST/PATCH/PUT/DELETE operations are no longer supported. So, it is not possible to purge log messages based on a specific log level. Instead purging of logs (irrespective of the log level) is now integrated into the auto-purge feature
CPN-3100	Modified	properties API If the environment attribute is used when configuring properties using the properties API, the value of the environment attribute should now match the value set for the system property ohi.environment.identifier. If these values differ, update the environment attribute using the properties API. Example: If the following properties (with different values for two different environments) are configured in the system: Property-1 id: 123 name: fusion.financials.url value: http://host-dev:port/fusion environment: DEV_CPN_PDB Property-2 id: 456 name: fusion.financials.url value: http://host-prod:port/fusion environment: PROD_CPN_PDB And if the value of the system property ohi.environment.identifier is set to OHI Capitation Production Environment in the Production environment and to OHI Capitation Development Environment in the Dev environment, then the environment attribute of the above two properties should be updated using the properties API after upgrading to this release, i.e., PATCH http://[hostName]:[portNumber]/[api-context-root]/generic/properties/123 { "environment": "OHI Capitation Development Environment" } and PATCH http://[hostName]:[portNumber]/[api-context-root]/generic/properties/456 { "environment": "OHI Capitation Production Environment" }
NXT-24066	Modified	Installation Configuration Customers using the Basic Authentication mechanism must follow the installation guide to install the newly built JAR file, "CustomIdentityAsserter.jar," and configure the WebLogic security provider accordingly.
POL-13518	Removed	deidentificationmetadata API deidentificationmetadata API got renamed to datamaskingdefinitions API
POL-13518	Removed	deidentificationmetadata IP deidentificationmetadata IP got renamed to datamaskingdefinitions IP
POL-14105	Added	Added unique key to PolicyMedicareTransactionReplyReport The unique key consist of: File name Transaction Code Transaction Reply Code Member Contract ID Member PBP Number Transaction Effective Date Transaction Date
POL-14140	Removed	Claims Forms (Entity) Removal of below attributes . procedure 1 display name . procedure 2 display name . procedure 3 display name
POL-14140	Removed	Schedule Dimension (Entity) Removal of below attributes display length
POL-14140	Removed	Access Restriction Remove access restriction type : attached data (Policies), financial hold and unlock claim lines (Claims)
POL-14140	Removed	Agent (Entity) Remove dynamic logic addressed to signature Name Format (Agent)
POL-14140	Removed	MDS Remove signature, Name : MDS (COND) and MDS (FUNC)
POL-14140	Removed	System Properties Remove system properties ohi.ui.maxrowstoreretrieve
POL-14140	Removed	https-link (Entity) Remove entity (httplinks) Remove dynamic logic addressed to signature (HTTP LINK)
POL-14140	Removed	Usages (Entity) Removal of below attributes In Lov? Search in Lov?
POL-14140	Removed	country (Entity) Removal of below attributes from the country entity . Number format . Amount Number Format . Integer Format . prompt additional part 1 . prompt additional part 2 . prompt additional part 3 . Dynamic Function (Address Format Code)

Bug Fixes

BugDB	SR	Internal	Summary
33018225		POL-8480	In policy details page, floorplan tagging is not working for attach data object navigation link
Description:		Floorplan tagging is not working for attach data object navigation link.
Resolution:		If any of policy page floorplan has tagging attached and the same tag is added to attached data object navigation, the tagged floorplan of attachedData page loads.
35694284		POL-12480	Internal server error is shown when fetching a person having an identifier with non regEx based concealment
Description:		Fetching a person having an identifier with non regEx based concealment results in a 500 error instead of showing person data on the JET page
Resolution:		REL-IDTP-003 and POL-PITY-002 are replaced by a generic check: GEN-RULE-036: The concealment expression xxx must be a valid regular expression. There is also an internal check added for any entity that has attribute concealmentExpression for this check to be implemented to prevent future mistakes.
34579712	3-30561689958, 3-30460458241	POL-11323	Errors in the policies object model for classes in policyversionchangedetection package
Description:		We can generate the groovy objects model of the application from the Objects Integration Point or via ADF UI → Configuration → System → View Objects → Generate Objects button. The problem is the groovy object model does not compile out-of-the-box. In particular, there are compilation errors in the policyversionchangedetection package.
Resolution:		the generated groovy files for PolicyEnrollmentEventKey and ObjectChangePolicyEnrollmentEvent no longer include two "id" variables.
34709135		POL-11482	Person details are not correctly copied with Policy In Patch integration point
Description:		Person details (like Assigned Providers, Contract Alignments, Person Covered Services etc.) were not correctly copied when using Policy In Patch IP. If change events are configured for create, delete and update operations then on updating any details corresponding create and delete events were getting registered instead of update events. This signifies that in Patch update operation too respective record was getting deleted and created instead of update.
Resolution:		Entity specification implementation has been changed to apply list behavior for Person details when using Policy In Patch IP. On doing update operations corresponding update change events are getting registered instead of create and delete events.
36659255	3-36463843611	POL-15209	Generate mutations activity takes disproportionate amount of time to complete in a specific scenario.
Description:		Generate mutations activity takes very long to complete in a scenario where although there are no group client level events, there are a large number of existing events (of other event levels) and group account products.
Resolution:		Generate mutations activity is optimized for this scenario and hence completes in reasonable amount of time.
Backports:		4.23.1.0.6, 4.23.2.0.4
36752259	3-37045628421	POL-15339	The page keeps loading while trying to add fields under usage
Description:		Go to 'Usages'. Select any usage, click on add then select field. We should be able to add a field/record under usage
Resolution:		It is possible to add a field/record under Usage and page opens without any issues
Backports:		4.23.2.0.5
36767285	3-36452370811	POL-15380	Advanced search lov’s for dynamic fields are not loading in referencesheetlines
Description:		Not able to search using the LOV’s in the reference sheet lines page. When clicking in the LOV field an error occurs on the api/generic/flexcodes/search.
Resolution:		Proper results are displayed in the LOV for flexcodes based on diagnosis, procedures and providers, displays.
Backports:		4.23.1.0.6, 4.23.2.0.5
36316992		POL-14623	Generate baseviews fails intermittently with CacheCreationException
Description:		Generate baseviews fails intermittently with CacheCreationException: Name of the cache entityNamePropertyCache already exists.
Resolution:		Generation of base views works fine without any intermittent exceptions.
Backports:		4.23.2.0.1, 4.23.1.0.4
36376584		POL-14765	Connector config: spinner shown on create
Description:		Click on Create button in Connector configuration Page, Create page is not loaded with spinner shown for long time and there is a console error
Resolution:		User is able to view Create page on click of Create button in Connector configuration Page
Backports:		4.23.2.0.2
36276110		POL-14573	Business event is not getting generated due to incorrect parameter(entity name)
Description:		JET is sending incorrect value(employmentOfMember#policyEnrollment) to entity when creating a business event rule. As it is not matching the entity name in PolicyEnrollmentEvent, Business event is not getting generated.
Resolution:		Business event is getting generated properly and proper payload is sent from JET when creating a business event rule
Backports:		4.23.1.0.3, 4.23.2.0.1
36593601		POL-15135	Remove the usage of utl_tcp DBMS package in extract functionality
Description:		Using utl_tcp DBMS package requires explicit grant in SaaS environments. This has operational challenges as the grants that are explicitly granted are periodically revoked by DBA as part of a scheduled process
Resolution:		Removed the usage of utl_tcp DBMS package in extract functionality and replaced it with a standard DB function
Backports:		4.23.2.0.4, 4.23.1.0.5
36189467		POL-14301	Execute datafile incident cleanup job (scavenging scheduler job) only on single node
Description:		The datafile set scavenging/cleanup job is scheduled to clean up application incidents (trace files) every day at midnight. This Spring scheduling job is executed on all the nodes, which is an unwanted use of resources, it is it would be efficient to run this only once (eg: on the master/oldest node in the coherence cluster).
Resolution:		Added condition to execute the scheduled job only on single node.
35608523	3-32973122991,3-35175959281	POL-13222	All future dated mutations should be deleted when calculate premium activity is executed
Description:		Future dated mutations are not deleted when calculate premium activity is executed but are expected to be deleted.
Resolution:		All future dated mutations are deleted when calculate premium activity is executed.
Backports:		4.23.2.0.1, 3.22.2.0.23, 4.23.1.0.4
35684750		POL-13393	For certain special LOV properties configured in the floorplan with suffix 'JET', upon selecting a value, the focus moves out of the table row
Description:		On selecting a value from dropdown for special functional LOV properties in table pages, the focus moves out of the table row
Resolution:		On selecting a value from dropdown for the special functional LOV properties in table, the focus remains on the respective field.
36213029	3-35477511858	POL-14421	System unable to offset refund when there is an unapplied amount greater than refund
Description:		System unable to offset refund when there is an unapplied amount greater than refund
Resolution:		Enhanced SQL query to check if there is a registration with status 'N' and earliest offset payment date will only be set when there is no registration with status 'N' otherwise it will be NULL, and mutation recalculation will be done only when earliest offset payment is not null
Backports:		3.22.2.0.23, 4.23.1.0.3, 4.23.2.0.1
36243787	3-35475079541	POL-14500	Enrollment Changes are not separated per person in Enrollment Events
Description:		During Policy Version Change functionality, the creation of policy Enrollment Events turns out to be different when a new policy is created versus when an existing one is updated. In the first case, a single event is created for all Enrollments instead of one Enrollment Event per person. This can be reproduced by creating a policy (with the compare versions process step) and then including two different enrollments with two different persons. This should result in two different events per person so the customer can identify which enrollment got changed/added. Instead, it only creates a general enrollment event, including both enrollments.
Resolution:		When a new policy (version1) is created, and the compare policy version functionality is enabled, enrollment changes are separated per person in Enrollment Events.
Backports:		4.23.1.0.4, 4.23.2.0.2
36300161	3-35742239861	POL-14603	End policy action in view and edit policy page ends inactive time valid records
Description:		Select an active policy which has at least one or more policy enrollment products in the past. Using End policy action, end the policy with end date as current date. Inactive time valid records are ended as well
Resolution:		Only active time valid records (enrollment products) will be ended when a Policy is ended and inactive records are not modified with policy end date
Backports:		4.23.1.0.4, 3.22.2.0.23, 4.23.2.0.2
36352064		POL-14712	Dynamic field value is getting wiped off and not holding the data upon save and also title is not displayed
Description:		When a dynamic field is of string type, converted to Lov field and attached to Dynamic record and used as a detail page, the value selected is not retained on the page, also, when that field is used to display title of the page, the title is not displayed.
Resolution:		The selected value from LOV is retained and page is saved, also the selected value is displayed in title of the page
Backports:		4.23.2.0.2
36765506	3-37171730421	POL-15371	Policy - user operations 'cancel policy' & 'generate output' should be hidden - 4.24.1.0.0
Description:		When the user does not access restriction grants on the Cancel Policy or Generate Output operations in the Policies page are still being displayed. It is expected that these options be hidden from the user unless they have the appropriate access restrictions.
Resolution:		Cancel policy and generate output buttons shown in policies only if user has separate access mapping for them.
36915693		POL-15653	When logging is switched on for policyversionchangedetection (trace level), a null pointer exception occurs
Description:		The null pointer occurs in a logging statement that gets the name of the class of the value of the changed attribute, which can be null, hence the exception.
Resolution:		Logging statement adjusted, so null pointer no longer occurs when logging on trace level for policyversionchangedetection is enabled.
36430538		POL-15019	Macro filter example does not work.
Description:		When a filter is added in the macro definition parameter of the type picklist, the picklist is not getting filtered in the Start Macro drawer.
Resolution:		Users can filter the macro definition parameter of type picklist.
35686462		POL-13398	Relation Links aren’t removed for a relation when empty list is given as payload
Description:		Unable to delete Relation Links by giving empty relation link list as payload for Policy IN patch and Persons IP.
Resolution:		Relation Links can be deleted by giving empty relation link list as payload in case of Policy IN patch and Persons IP.
36211313		POL-14418	Adjustment Rules - The amount field is not accepting negative value, also few columns are missing
Description:		In the amount field of Adjustment and Surcharge Rules page, negative values are not accepted. Also 'Amount Function' and 'Amount Not Prorated' is not displayed.
Resolution:		In the amount field of Adjustment and Surcharge Rules page, negative values are accepted. Also 'Amount Function' and 'Amount Not Prorated' is displayed.
Backports:		4.23.2.0.1, 4.23.1.0.3
36204006	3-34786906091	POL-14385	Dynamic logic byte code is not loaded during server startup on non master nodes after invalidateall API is invoked
Description:		Dynamic logic byte code is expected to load at the startup of non-master nodes if the invalidateall API was invoked in master node but was not being observed.
Resolution:		Dynamic logic byte code is now loaded at the startup of non-master nodes if the invalidateall API was invoked in master node.
Backports:		3.22.2.0.23, 4.23.2.0.1, 4.23.1.0.3
36371670	3-35948698481	POL-14755	Response time of adding a dynamic record on attached policy data using collection patch is high
Description:		If attached policy data has large number of dynamic records (for example, 1000), then adding a new dynamic record (for a different dynamic field usage) using collection patch (of 200 records) operation takes more time.
Resolution:		Reduced the number of iterations to validate the dynamic records
Backports:		4.23.1.0.4, 3.22.2.0.24, 4.23.2.0.2
36380961		POL-14771	Priority field is missing on Business event Definition
Description:		Priority field is missing on Business event Definition
Resolution:		Priority field is added to Business event Definition data model and can now be used by customers to prioritize messages.
36502537		POL-15011	Access mapping (relation links api) missing for organization/person page
Description:		Upon clicking the person in the policy enrollment, the member window opens but does not loads the person details
Resolution:		Person details are loaded on clicking the person in the policy enrollment and there is no error related to access
Backports:		4.23.2.0.2, 4.23.1.0.5
36491929		POL-14998	Purging does not work for policies in 'EDIT' status if a working copy with details exists
Description:		For non-approved/cancelled policies with working copies purging the policy fails on 'GEN-ORA-02292: Delete not allowed because dependent "<detail>" exists'.
Resolution:		Deletion of details of working copies are included in the Purge Policy IP.
36493451	3-36171988661	POL-15001	Date Paid To is not reset when enrollment ended and future dated payments exist
Description:		When policy enrolllment products are all (retroactively) ended while applied registrations exist after the end date, the date paid to is not reset to the end date of the policy enrollment products when apply registrations is executed.
Resolution:		If there are no new calculation results, but only reversed calculation results (which means that the (unzipped) registrations are no longer applicable for that period that is reversed): the date paid to is set to the start date of the first reversed calculation result minus one day.
Backports:		4.23.2.0.3, 4.23.1.0.6, 3.22.2.0.26
36048674		POL-14020	Business event rule to calculate age of a person should not be to triggered when the policy version is 1
Description:		The business event rule to calculate the age of a person was triggered for the initial version (version-1) of the policy, returning NULL as DOB
Resolution:		Policy enrollment events were generated.
36037344		POL-13997	Change event rules monitoring delete of adjustment value do not trigger
Description:		Change event rules with Delete action do not get triggered in case of deleting a default adjustment value.
Resolution:		Policy events for deletion of default adjustment value are getting triggered.
35780292		POL-13625	Null Pointer received when workflow endpoint property is not set
Description:		The workflow endpoint property is mandatory now, and when not set, it leads to a Null Pointer Exception.
Resolution:		Added new system property which when set to true workflow events will go out and setting workflow end point property is expected to be set. By default workflow events will not be sent (default property value is false).
36059038	3-34865124911	POL-14032	Search on Datasetdefinitiondetails should return entity name in href link of Change Event Rules
Description:		When performing search on the entity datasetdefinitiondetails, in the response the href link of Change Event Rules should end with the entity name but was null
Resolution:		The resource endpoint was not matching with the entity name, hence getting null in the href. Updated the resource endpoint to match with the entity name Change Event Rules
Backports:		4.23.2.0.1, 4.23.1.0.5
36500910	3-36340300401	POL-15010	Unable to add a new contract period for renewal
Description:		After creating and approving a policy there is no way add a new policy Contract Period
Resolution:		Multiple policy Contract Periods can be added when policy page is in edit mode
Backports:		4.23.2.0.3
36355922		POL-14717	Changes are not saved for the code and description of an existing CMT Set in Jet UI
Description:		When changing the code and description of an existing CMT Set in JET UI the message 'Changes are saved successfully' appears but the changes are not stored.
Resolution:		Code, Description can be updated for an existing CMT Set and changes are saved successfully
Backports:		4.23.1.0.4, 4.23.2.0.2
36409942	3-34612052061	POL-14815	JWT bearer grant type is not working
Description:		OHI supports both client_credentials and urn:ietf:params:oauth:grant-type:jwt-bearer (shortly referred as JWT bearer) grant types in OAuth, however JWT bearer grant type is not working as expected.
Resolution:		Fixed logical issues in code to make it working
Backports:		4.23.2.0.3
36482250	3-36178158771	POL-14984	PII data is not correctly populated when setting corresponding property
Description:		PII data is filled in as NULL when setting property "ohi.baseview.exclude.pii" to false, even though they are not null. This is only the case for entities where certain attributes are only PII if the entity is of a certain subtype. E.g. for Relation of subtype 'PERS', the code columns is seen as PII. When the "ohi.baseview.exclude.pii" property is set to false, this data should be seen.
Resolution:		PII data is now correctly populated when setting property "ohi.baseview.exclude.pii" to false.
Backports:		4.23.1.0.6, 4.23.2.0.4
36614817		POL-15176	It is not possible to set dynamic fields when using predfined method: groupClient.addGroupClientEvent
Description:		According to documentation it should be possible to pass on dynamic fields to the predefined method addGroupClientEvent.
Resolution:		The method groupClient.addGroupClientEvent returns the groupClientEvent created, so it is possible to set any dynamic field possible on it in the dynamic logic that calls this method. Also, documentation is adjusted to reflect the functionality accordingly.
36744101		POL-15329	Unable to apply update trigger on resource 'attachedpolicydata' in Change Event Rules page
Description:		The user is unable to apply Update Trigger on resource 'attachedpolicydata' in changeEventRules page.
Resolution:		The user can now update monitoring fields for the entity 'attachedpolicydata' provided they have the correct access grants.
Backports:		4.23.2.0.5
36302553	3-36983961191	POL-14611	No base views are generated for Insurable entity and Insurable person tables
Description:		Base view generation for OHI_INSURABLE_ENTITIES and OHI_INSURABLE_PERSONS tables was disabled.
Resolution:		Base view generation for OHI_INSURABLE_ENTITIES and OHI_INSURABLE_PERSONS tables has been enabled.
36215677		POL-14432	Saving dynamic record containing a date key field returns null pointer exception
Description:		When adding a dynamic field usage of datatype DATE to a reference sheet record definition as key field, the UI returns a null pointer exception.
Resolution:		For field usages of datatype DATE the length of field is null which results into null pointer exception. Modified the business rule validating length of key field usage for a reference sheet to check the case where length is null.
36377399		POL-14767	Save and Cancel shortcuts aren’t working for create Hierarchical Recursive pages
Description:		Save and Cancel shortcuts aren’t working for create Hierarchical Recursive pages
Resolution:		Save and Cancel shortcuts will work for create Hierarchical Recursive pages also now
Backports:		4.23.2.0.2
36325079		POL-14638	Custom jet fields createdbyjet and lastupdatedbyjet are not working for tab configuration
Description:		The custom JET fields createdByJET and lastUpdatedByJET are not working in the below auditable resources in tab configuration in HRR page. createdByJET and lastUpdatedByJET should show user names
Resolution:		createdByJET and lastUpdatedByJET shows user names in tab configurations in HRR pages
Backports:		4.23.2.0.2
36366909		POL-14733	Preferred language field editable in persons details section though it is readonly
Description:		Preferred language field is nested property of Member field. It should not be editable in Policies page - person details section
Resolution:		Preferred language field is displayed as readonly nested property in persons details section as expected
Backports:		4.23.2.0.2
36350892		POL-14709	Ethinicity and race multivalue select box not working in create mode
Description:		Ethinicity and Race multivalue select box are behaving as a normal dropdown in create mode instead of multivalue.
Resolution:		Multiple values can be selected for Ethinicity and Race select box in Create mode as well
Backports:		4.23.2.0.2
36433094	3-36176430291	POL-14880	Dynamic records ID should be returned as string in the API response
Description:		The ID of dynamic records of resources are returned as number (Long) in the API response, they should be returned as String.
Resolution:		The Dynamic records ID was transformed from Long to String in the API response
Backports:		4.23.1.0.4, 4.23.2.0.2
36591307		POL-15133	Table component: When we select any LOV value from lookup field, and come out of the row, the value selected disappears
Description:		Table component: When we select any LOV value with popup tail configured, and come out of the row, the value selected disappears
Resolution:		When we select any LOV value with popup tail configured, and come out of the row, the value selected is retained.
Backports:		4.23.2.0.4
36341753		POL-14574	Extracting relations returns exception
Description:		When resource name "relations" is used to create an extract, the next exception is raised: ORA-00904: "SELS"."ID": invalid identifier.
Resolution:		The id of the relations resource was not selected in our query mechanism (the same holds true for other supertype tables that have multiple table implementation like activities). This has been corrected.
36195628		POL-14355	Incorrect result shown in Boilerplates Table
Description:		The boilerplate table shows incorrect results after performing the 'ADD' and then 'CANCEL' actions simultaneously. This behavior is generic to other table-based pages.
Resolution:		Correct results are shown after performing the 'ADD' and then 'CANCEL' actions simultaneously in table-based pages
Backports:		4.23.2.0.5
36647156		POL-15498	Record definition fields are displayed in incorrect sequence
Description:		Flexcodes within a record definition do not have display sequence in the metadata. Due to this, fields in record definition are displayed in incorrect sequence.
Resolution:		Display sequence for flexcodes has been added to the metadata, ensuring that fields in the record definition are displayed in the correct order.
36848491	3-37403675211	POL-15507	Accessing reference sheet lines via the post search operation requires more than just retrieve access to the Reference Sheet Lines API.
Description:		Accessing reference sheet lines via the POST search operation requires both retrieve and create permissions on the Reference Sheet Lines API. Simply having retrieve access is insufficient to perform this operation.
Resolution:		Accessing reference sheet lines using the POST search operation now only requires retrieve access.
36668359	3-36890742711	POL-15239	The calculation of adjustments is incorrect for the last calculation period when done through amount function
Description:		The adjustment for the last period of calculation is not retaining the amount already applied for earlier periods and it is adjusting the full amount in the last calculation period
Resolution:		The adjustment amount calculation for the last segment for pro-rated amount function was not handled properly. A check was added to verify pro-rated amount function resulting in correct calculation
36738751		POL-15323	Policy Enrollment Products detail page not opening.
Description:		Policy Enrollment Products detail page when accessed keeps showing processing spinner icon.
Resolution:		Policy Enrollment Products detail page loads without floorplan errors.
36367683	3-35755073101	POL-14739	Integration Point OUTBOUNDINTEGRATIONPOINTS shows incorrect value for authentication feature
Description:		Integration Point OUTBOUNDINTEGRATIONPOINTS shows incorrect value for authentication feature
Resolution:		Authentication feature if set to "OAuth" for clientkey propagates to individual use cases instead of having to manually override and set authentication feature for each use case.
36910690		POL-15641	Column size needs to be updated for Business event Rule entity
Description:		The 'attribute' column size needs to be updated from 50 char to 200 char in Business event Rule entity
Resolution:		Business event Rule entity is modified and 'attribute' column size is updated to 200 char
36880543		POL-15561	Policy Enrollment Products tab - Product details are missing
Description:		After creating a policy with Enrollment Products, in View mode Product details are missing at collapsible level
Resolution:		Enrollment Product Details are now loading as expected
36443612	3-36178016821,3-36314937451,3-36339863591,3-36719019981	POL-14901	Parameter value of type percentage with value 0 is not displayed
Description:		When a parameter on enrollment products of type percentage has a value of 0, it’s not displayed in JET
Resolution:		Parameter Value of type Percentage with value 0 will be displayed in enrollment products section of policies page
Backports:		4.23.2.0.3, 4.23.1.0.5
36484991	3-35901354371	POL-14991	Incorrect value in changelist payload sent by jet ui for integration connector
Description:		The Payload for changelist in Integration Connector sent by JET UI contains incorrect values
Resolution:		The Payload for changelist in Integration Connector sent by JET UI is corrected as per documentation and Integration Connector works fine without issues in payload
Backports:		4.23.2.0.3, 4.23.1.0.5
35686485		POL-13399	BUG-REL-RELI-002: Processing error "Only one enabled relation link is allowed when the link type is defined as auto disable" is popping up when trying to update relation link for the relation as part of member copy & policy compare version
Description:		Processing error, BUG-REL-RELI-002, "Only one enabled relation link is allowed when the link type is defined as auto disable" is thrown when trying to import a policy or relation with relation links and working copy functionality is enabled.
Resolution:		The check on duplicate relation links has been changed: the active person of which the working copy is copied from, is excluded from the list of duplicates.
35874348		POL-13793	Output definitions do not indicate what needs to happen when a condition evaluates to false
Description:		The current design does not specify what happens when the policy does NOT meet the dynamic logic condition of the output definition.
Resolution:		Policy mutations were considered handled (deleted) when a mutation was disregarded due to an output definition dynamic logic.
35939716		POL-13862	Not possible to enter a change event function in the JET UI
Description:		Policy change event rules lead to a function. It then requires the user to specify a dynamic logic function with the signature 'Change Event Rule (Function)'. If a CEV rule leads to e.g. a recalculation, the user has to specify logic with the function 'Change Event Rule (Effective Date)'. In the JET UI, it is not possible to specify logic with the 'Change Event Rule (Function)' signature.
Resolution:		It is possible to specify a logic with the 'Change Event Rule (Function)' signature using JET UI
35960226		POL-13889	Update change event rules on schedule lines - amount function and premium tier not visible
Description:		Premium schedule lines are monitorable by change event rules. Updates allow you to set the attributes that need to be monitored. The ADF UI displays amount function and premium tier as options. The JET UI does not display any options.
Resolution:		Update change event rules on schedule lines - amount function and premium tier are visible
35939831		POL-13863	Policy messages detail dialog should prioritize message text
Description:		The policy messages detail dialog assigns a narrow column to the message text. This is the most important piece of info for a user. Dialog should be more wider.
Resolution:		The policy messages detail dialog is made wider and message text column width is increased
36227266	3-35379874711	POL-14468	SQL execution plan to delete selected financial transactions for large group is inefficient
Description:		SQL execution plan to delete selected financial transactions (at the end of generate financial messages activity) for large group is inefficient
Resolution:		The SQL is optimized
Backports:		3.22.2.0.22, 4.23.2.0.1, 4.23.1.0.3
36150990	3-35320237389	POL-14237	Enrollment IP metadata is invalid
Description:		Metadata returned by GET /enrollments/metadata IP is invalid.
Resolution:		Updated Metadata - Removed data related to get enrollment, and also added schema of enrollment request for post request
Backports:		4.23.2.0.1, 4.23.1.0.3
36361891		POL-14724	Incorrect error code returned for Apply registrations
Description:		When Brand code, Group account code, Function dynamic logic code or Group client code are unknown, an incorrect error code is returned for Apply registrations
Resolution:		Updated messages to return the correct error codes
36416442	3-34612052061	POL-14845	OAuth parameters should be configurable
Description:		OHI product supports only standard OAuth parameters. As its value/name can deviate across OAuth server, OHI application isn’t able to establish connection with OAuth server.
Resolution:		Introduced capability in OHI product to define custom OAuth parameters. These parameters can be reused across different OAuth clients later.
Backports:		4.23.2.0.3
36605151	3-36703332881	POL-15162	Logging feature for Query API requests having expand=all
Description:		A logging feature aimed at identifying and optimizing API requests that use the expand=all parameter excessively is introduced.
Resolution:		This update resolves the issue of inefficient API calls caused by the indiscriminate use of expand=all. By logging these instances, users can proactively replace expand=all with specific fields, thereby optimizing system performance and enhancing API response times. For more details on enabling this logging feature, please refer to the "Influence Resource Representation" section in the user guide.
36134508		POL-13993	Policymedicaretransactionreplyreport properties are shown as concealed when definition is requested from attached policy data definition.
Description:		A request like "<host>/<path>/api/generic/policies/attachedpolicydata/definition#/attachedpolicydata" gives a response with reference to medicare transaction report like: "<host>/<path>/api/generic/policies//policymedicaretransactionreplyreports/definition#/policymedicaretransactionreplyreport". which showed the properties of the policymedicaretransactionreplyreport as concealed.
Resolution:		The attached policy data entity is made extendable so when definition is requested for policymedicaretransactionreplyreport the properties are shown properly.
36020652	3-34751448551	POL-13979	PROCESS_REGISTRATIONS activity takes more than an hour to create child activities
Description:		PROCESS_REGISTRATIONS activity takes more than an hour to create child activities when the volume of policy mutations is high.
Resolution:		PROCESS_REGISTRATIONS activity will now take less time than before to create child activities when the volume of policy mutations is high.
Backports:		4.23.1.0.2, 3.22.2.0.21, 4.23.2.0.1
36462963		POL-13765	Flexcodes API returns value of ID as number instead of String
Description:		Flexcodes API returns the value of id as a number instead of String but the definition defined the type of ID as string
Resolution:		The Flexcodes API now returns value of Id, created by and last updated by as Strings as defined in the definition
Backports:		4.23.1.0.4, 4.23.2.0.2
36846452		POL-15504	The attribute "applicantInterpreterNeeded" on medicare policy enrollment product detail is not updated in Policy IN IP
Description:		When trying to update "applicantInterpreterNeeded" using Policy IN IP, it ignores the update.
Resolution:		Included "applicantInterpreterNeeded" of medicare policy enrollment product detail in Policy IN IP.
36219954		POL-14435	Length of OHI_ID_ARRAY database type is still 14 after upgrading to 4.23.1 release
Description:		Length of OHI_ID_ARRAY database type is still 14 after upgrading to 4.23.1 release
Resolution:		The length of OHI_ID_ARRAY database type is updated to 19
Backports:		4.23.2.0.1, 4.23.1.0.3
36445455	3-36168869491	POL-14917	Adding multiple parameters in Enrollment, Parameter Domain tab ends up in GEN-ORA-01400
Description:		Create a Enrollment Products, along with 'percentage parameter' of Parameter Domains tab. Make sure to added 2 or more using Attach and Next button and when saving getting Error: GEN-ORA-01400: "PARA_ID" column is mandatory for the table "POL_PARAMETER_DOMAINS"
Resolution:		Attach & Next button works properly now. Thus, able to add multiple parameters in Enrollment, Parameter domain tab without any error.
Backports:		4.23.2.0.3, 4.23.1.0.5
36292309	3-35735175271	POL-14588	Policies allowing circular hierarchy during group client creation
Description:		During group client creation or updation, no check was available to verify if there exist cyclic dependency between the group clients. Because of this in some scenario circular hierarchy was getting created and application was becoming unresponsive.
Resolution:		Added a business rule to detect circular dependency during upsert operation. This will prevent formation of circular dependency for all new creation and updation of group clients. This will not detect any previously existing circular dependencies.
36429069		POL-14876	Macro payload that is sent out contains displayName instead of usageName for macro parameters.
Description:		A macro definition that triggers an OIG integration which has 2 fields- 'Usage Name' and 'Display Name'. The resulting payload needs to include the usage name, when sending parameters to OIG. But it includes the display name.
Resolution:		UsageName is included in macro payload instead of displayName for macro parameters in the payload.
Backports:		4.23.2.0.3
36480311	3-31029430181	POL-14973	Policy search by Policy Holder name is case sensitive
Description:		When searching for a policy using POLICYHOLDER NAME with the name captured all in lowercase then no results are returned
Resolution:		Policy search with POLICYHOLDER NAME with the name captured all in lowercase letters works fine
Backports:		4.23.1.0.4, 3.22.2.0.26, 4.23.2.0.2
36343961	3-35475079541	POL-14686	Adding Bank Accounts as configurable entity for Business Event Rules
Description:		Bank Accounts are added as configurable entity for Business Event Rules and are therefore part of the Compare Policy Version functionality.
Resolution:		Bank Accounts are now part of the Compare Policy Version functionality.
Backports:		4.23.1.0.4, 4.23.2.0.2
36464195		POL-14945	Multiple rows for contract period is being added automatically once addNewRow property is removed
Description:		Multiple rows for contract period is being added automatically once addNewRow property is removed from the custom floorplan
Resolution:		Multiple rows for contract period are not added automatically once addNewRow property is removed from the custom floorplan. It gets added on click of Add Row
36809671		POL-15458	Client side error not shown for mandatory fields.
Description:		Multi-value fields with client side errors are not highlighted on save.
Resolution:		A banner is displayed at the top to highlight the multi-value fields with validation errors on performing save.
36299094	3-35637739711	POL-14600	Approved policies linked to group account have a policy enrollment product instead of a group account product.
Description:		The policy should not have the status Approved if the data does not abide by the system rules.
Resolution:		Policies cannot be approved if the data does not abide by the system rules and a POL-POEP-001 is thrown.
36704128		POL-15272	Example Calculation is not showing the correct Calculation period startdate/ enddate
Description:		Example Calculation is not showing the correct Calculation period startdate/ enddate. The startDate and endDate in Run Calculation Example and Show Premium are not getting converted correctly according to the user’s timezone
Resolution:		The startDate and endDate in Run Calculation Example and Show Premium are getting converted according to the user’s timezone and displayed correctly in UI
Backports:		4.23.2.0.4
36584163	3-36171996761	POL-15122	Successively disabling and then enabling a connector within its time interval leads to the creation of duplicate tasks.
Description:		Two tasks of transformation type are spawned when a connector is successively disabled and then enabled within its time interval.
Resolution:		No duplicate tasks are created when a connector is successively disabled and then enabled within its time interval.
36108069		POL-14153	Non-reversible number free fields do not function
Description:		Configure a 3 digit non-reversible number field. Expected behavior is that it allows for values between 0 and 999 but able to enter and store negative values.
Resolution:		Reversible column is removed from UI and it is not possible to store negative values now
36150523		POL-14235	Individual providers - Unable to edit service address configured as deeplink in rendering address tab
Description:		It is not possible to edit resources which are configured as Deeplinks. For example in Individual providers, it is not possible to edit service address in rendering address tab. On click of edit button in service address drawer, its directly navigating back to individual providers page and not possible to edit/save
Resolution:		Edit works fine in Deeplink drawers now and also the values are saved properly on the resource configured as deeplink
Backports:		4.23.2.0.1
36281207		POL-14581	Non-selective criteria in reference objects cause OHI to load too many objects in memory.
Description:		Non-selective criteria in reference objects cause OHI to load too many objects in memory.
Resolution:		Non-selective criteria in reference objects now only load two objects in the memory, which will not cause the memory protector to kick in.
36440946		POL-13153	Template not showing as "System" in HRR page for the seeded widget of template type "System"
Description:		Template not showing as "System" in HRR page for the seeded widget of template type "System"
Resolution:		The system templates display the value for the template field in view mode. In create mode, only data table and pie chart are shown as options for template.
36809234		POL-15285	Columns deselection is not responding in table pages
Description:		The table page functions correctly when deselecting columns initially, but becomes unresponsive when columns are deselected after adding a row for example in the 'Transaction Reply Report Object Navigation' in Policy page.
Resolution:		Table column selection/deselection works properly now using column selector dropdown
36518621		POL-15034	Business Event Rules that monitor the Collection Setting entity never trigger
Description:		When the user configures a Business Event Rule on the Collection Setting Entity, no notifications are generated.
Resolution:		When the user configures a Business Event Rule on the Collection Setting Entity, events are generated for Collecting Setting under Enrollment Events
36555930		POL-15082	Business Event Rules that monitor the assigned broker agent entity never trigge
Description:		Events are not generated when the user defines a Business Event Rule to monitor Assigned Broker Agent.
Resolution:		Events are generated when the user defines a Business Event Rule to monitor Policy Broker Agent.
36719055		POL-15186	Change Event Rule not showing up monitoring fields
Description:		Monitoring fields would not display for a few entities despite giving the required access grants.
Resolution:		Monitoring fields display for all entities in the subject dropdown provided they have the required access grants.
36174524	3-35224413241	POL-14284	Issue with change event rule (function) showing same new/old object for group client - display name
Description:		When updating a translatable entity as per the change event rule dynamic logic, oldEntity binding comes up same as newEntity. Group Client translations shows same new and old values in the change event based on the dynamic logic. Like same old and new display name. It should show the old display name and new display name correctly as per the change.
Resolution:		When updating a translatable entity as per the change event rule dynamic logic, it will now show the old entity bindings and new entity bindings correctly as per the change.
36300123	3-35684326321	POL-14602	Data from technical table is not cleaned up if an extract activity fails which leads to data accumulation
Description:		Data from technical tables were only getting cleaned for activities in 'CO' status which was causing accumulation of huge data.
Resolution:		Along with status 'CO' all other statuses except 'IN', 'IP' and 'QD' are now included as part of cleaning process. This ensures a more cleaner technical table, hence overcoming the issue of data accumulation
Backports:		4.23.2.0.3, 4.23.1.0.5
36908500	3-37567131801	POL-15635	NoClassDefFoundError error is returned when creating a new dynamic logic with trace logging enabled for the logger ohi.dynamiclogic
Description:		A NoClassDefFoundError occurs when attempting to create a new dynamic logic with trace logging enabled for the ohi.dynamiclogic logger, instead of successfully creating the dynamic logic.
Resolution:		After adding the missing third-party dependency, dynamic logic can now be successfully created with trace logging enabled for the ohi.dynamiclogic logger.
36181531		POL-14296	When a policies page is configured with 5 sets, the fields are moved to different sets and only 2 sets are displayed
Description:		Create a Custom Policies floorplan to display fields in one of the section with 5 sets. Load the policies page. 5 sets are not displayed, rather fields are merged into different sets and only 2 sets are displayed.
Resolution:		When a page is configured with 5 sets, the fields are not moved to different sets and displayed properly in 5 sets
36799328	3-37120352731	POL-15428	Select Financial Transaction into Set activity failing with GEN-PROC-ERR
Description:		When Financial Transaction into Set activity is ran with financailTransactionType 'PRE', activity is failing with technical error.
Resolution:		Extra spaces was introduced in dynamic sql query generation which fixed the issue allowing the activity to get successfully completed.
Backports:		4.23.2.0.5
36709437	3-36913840401	POL-15283	Extract requests can have a limited number of characters in the condition
Description:		Extract request with a large query fails with activity message "ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 1". This is because the selection is stored in a variable with a maximum of 32000 characters.
Resolution:		Selection is now stored as a clob of which the maximum size depends on environment settings: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB). Contact database administrator for more details if needed. This change allows for a more extensive query in the extract request and a lesser chance of running into the ORA-06502 error.
36397442		POL-14795	Policy details which are not specific to person are tagged with relation ID for policy version 1 in policy enrollment events
Description:		create a policy with compare version process step. The policy also includes two different enrollments with two different persons and also details like policy collection settings which are not specific to person(common for a policy). After submitting the policy the policy enrollment events contains details like policy collection settings which are common for a policy are now attached to a person
Resolution:		The details like policy collection settings which are common for a policy are now created as a separate event
36870932	3-37446733331	POL-15539	Additional Fields section is not rendering for certain groups in Groups setup page
Description:		When viewing a Group from Group Setup, for a particular subset of groups, the "Additional Fields" link is visible but not "clickable". This seems to be occurring when there is not enough data to fill the left hand tile.
Resolution:		Additional Fields links is visible and clickable for Groups page
36943659	3-37715853681	POL-15679	ID of single value flex code is returned as "null" (String) in the generic API response
Description:		ID of single value flex code is returned as "null" (String) in the generic API response.
Resolution:		ID attribute of single value flex code is now excluded from the generic API response (same behaviour as the previous release).
36392133		POL-14649	Unable to invoke Macros when a macros template is attached to macro definition
Description:		Unable to invoke Macros when a macros template is attached to macro definition, there is a console error
Resolution:		It is possible to invoke macros without errors when a macros template is attached to macro definition
Backports:		4.23.2.0.2
36315306	3-35684326321	POL-14618	Gathering statistics on technical table for every extract activity is inefficient
Description:		Gathering statistics on technical table for every extract activity is inefficient as it was enabled by default for all cases and because of parallel extracts performance was degraded.
Resolution:		A check is added which will ensure statistics are gathered only in certain cases. Hence, improving the efficiency of extract activity.
Backports:		4.23.1.0.4, 4.23.2.0.2, 3.22.2.0.25
36547167	3-34871101921	POL-15061	filename contains diacritics, upload erroneously transforms the filename to some other characters.
Description:		Uploading a file , where the filename contains diacritics, erroneously transforms the filename into different characters.
Resolution:		By incorporating standard encoding for UTF-8 and ISO_8859-1 in multiform requests, filename with diacritics is not getting corrupted.
Backports:		4.23.2.0.3, 4.23.1.0.5
36429032		POL-14875	The Boolean option for the Datatype field is absent in Macro Parameters.
Description:		In Macro Parameters, the Datatype field support for Boolean option was missing.
Resolution:		Boolean option for the Datatype field is added for Macro Parameters.
36195898		POL-14362	Policy version comparison does not ignore dynamic records without a key field
Description:		The specifications indicate that records without a key field are ignored in the policy processing flow - version compare step. This is not the case here. Once a record without a key field is added to the policy enrollment or policy enrollment product. OHI returns Null Pointer Exception
Resolution:		Policy version comparison step ignores dynamic records when dynamic records are added without a key field
36475826		POL-14966	Searching in a reference sheet fails if the string contains a space.
Description:		Searching in a reference sheet fails when string contains a space, returning a 500 error.
Resolution:		Search works properly in reference sheet, if the search string contains space as well
36350847		POL-14707	Preferred language, contact details and address details are not populating in person details section in create mode
Description:		Go to person details section and click on 'Add New?' deep link. Fill all the mandatory details, contact and address details and click on save button. Close the deeplink pop up. Observe Preferred language, contact details and address details are not populating in person details
Resolution:		Only the properties that are mentioned in Persons LOV floorplan will be displayed in create mode. Member Identifiers and Address List are moved to the same region as Members LOV
Backports:		4.23.2.0.2
36481964		POL-14980	Adding more than one policy enrollment product to a policy does not result in adding more than one business event definition.
Description:		When adding two policy enrollment products for the same member, and having a business event rule on policy enrollment product creation, resulted in one policy business event only.
Resolution:		Creation of policy business event stopped after first change in a changeSet (a changeSet is per member and policy, while there can be multiple changes attached). This stop has been removed, so it will continue adding events for each change per member.
36482005		POL-14981	Edit field is present in referencesheet headers even after making the fields non editable in the floorplan
Description:		Edit field is present in REFERENCESHEET headers even after making the fields non editable in the floorplan. Enable the custom floorplan for REFERENCESHEET page and remove edit action from action component. The edit option is still there.
Resolution:		Edit button will not appear if edit action is removed from the floorplan in Reference sheets page
36251413	3-35379874711	POL-14517	Slowness in calculate premium when group client parameter is specified.
Description:		Inserting policy-level child activities was inefficient when the group client parameter is used, resulting in a longer execution time to calculate premiums.
Resolution:		The query inserting policy-level child activities is improved to address the slowness of calculate premium activities
Backports:		3.22.2.0.23, 4.23.2.0.1, 4.23.1.0.3
36426855	3-36090053541	POL-14871	Search results are not shown if search data is selected from lov dropdown in quick search AND mode.
Description:		When a value from LOV is selected from AND mode quick search, in some cases where the selected value has a lot of data, the search results were not loading up with console error.
Resolution:		Fix added to show search results when value is selected from LOV dropdown in Quick Search AND mode.
36547989		POL-15066	Translations not working in few pages
Description:		Following pages/buttons are not translatable: Persons page Actions dropdown, MenuItem for BookMarks GroupClients page - Set Status to Change Dialog text
Resolution:		Persons page Actions dropdown, MenuItem for BookMarks, GroupClients page - Set Status to Change Dialog text are translatable now
36194685		POL-14346	Add new row is shown at last in table pages
Description:		Click Add new in table page. A new row is getting appended in the last visible row of the screen
Resolution:		Table component is modified with the below changes: 1) On click of Add button, a new row will be added to the top of the available rows. It is a sticky row to the table 2) Two new icons are added to a new row. Check icon would add the new row to the table and clicking on Cross icon would discard the new row. 3) User will have to click on Check icon and Save to persist the newly added data
Backports:		4.23.2.0.5
36167108		POL-14246	Deselect all checkbox is not working in table component
Description:		Deselect all checkbox is not working in table component used in pages like claimlines, Enrollment Event Notifications
Resolution:		Deselect all checkbox works as expected in table component and all the rows loaded in the page are deselected
Backports:		4.23.2.0.3
36833471	3-36864108701,3-37393890291	POL-15488	Issue with display of flexcodes in piechart for widget
Description:		Create a piechart widget with grouping criteria set on flex codes. Piechart doesn’t show flexcode names instead shows FlexCodeDomain(..)
Resolution:		PieChart widgets shows flexcode names properly when set as grouping criteria
Backports:		4.23.2.0.5
36305364		POL-14612	Extract status is failure when the associated activity is in 'QD' status
Description:		The notification status is showing 'failure' when it’s associated activity status is in 'QD'. The actual status should be shown is 'InProcess'.
Resolution:		Extract status should be 'InProcess' when the associated activity is in 'QD' status
Backports:		4.23.2.0.1
36363607		POL-14696	Additional Fields at tab level is not retrieving the data.
Description:		The data of extensible fields under the more action drawer in a tab table is not showing up even after save.
Resolution:		The data of extensible fields under the more action drawer in a tab table is displayed properly after the save operation is performed.
Backports:		4.23.2.0.2
36264554	3-35378971011	POL-14531	Ensure that notification is sent only when the datafile creation for output generation activity is complete
Description:		Notification was sent when the output generation activity was complete but the datafile creation was done later in a different transaction. This led to a mismatch in the number of datafiles received in the datafile set at the time of notification.
Resolution:		Notification is only sent when the output generation activity and the datafile creation are complete. This is achieved by handling both processes in a single transaction.
Backports:		4.23.1.0.4, 4.23.2.0.2
36347890		POL-14695	Medicare details are auto populating in new record when there are multiple policy enrollment products
Description:		Medicare Details are auto populating (copied from previous enrollment product) in new records when there are multiple Policy Enrollment Products. Issue doesn’t exist when there are Medicare Details already created through API
Resolution:		Medicare details are not auto populated (from previous enrollment product) in new records when there are multiple policy enrollment products. It would be empty for the user to fill in the details
Backports:		4.23.2.0.2
36403699		POL-14802	Global activities: Business error shown on bulk update invoke
Description:		Invoke a new activity on the global activities page in the JET UI. Pick BULK_UPDATE as the activity type and populate the required fields. Populate the group account from the drop down list. On Invoking the activity, getting business error.
Resolution:		Invoke activity is successful without business error for Bulk update using Group Account
Backports:		4.23.2.0.2, 4.23.1.0.5
36251887		POL-14518	All records are not shown in downloaded file, only 10 records are shown even after scrolling in table page
Description:		When a user scrolls through a set of records and clicks on download action in the table, the downloaded file doesn’t show the correct result.
Resolution:		All the records viewed in the table page is downloaded to the file when clicked on download action
Backports:		4.23.2.0.5
36596194		POL-15145	Money amounts not included in policy version comparison.
Description:		Changes in money attributes like parameter amount, commission amount are not included when versions of policy are compared in the submit for approval process, nor are they listed in the change details of the policy enrollment events.
Resolution:		Money attributes are included in policy change detection.
36823241		POL-15475	Integer field values are shown with separator (12,345 instead of 12345)
Description:		Enter '12345' in integer fields like "house number" or state and country code" in Persons page, it is getting displayed as 12,345
Resolution:		Integer field values are shown without separators now
Backports:		4.23.2.0.5
36209702	3-35379874711	POL-13390	Slowness in calculate premium when group client parameter is specified.
Description:		Inserting policy-level child activities was inefficient when the group client parameter is used, resulting in a longer execution time to calculate premiums.
Resolution:		The query inserting policy-level child activities is improved to address the slowness of calculate premium activities
Backports:		3.22.2.0.22, 4.23.2.0.1, 4.23.1.0.3
36874647	3-37166566681	POL-15552	Policies batch IP fails with optimistic lock failure on (GEN-RULE-020) group client
Description:		When a data file with a large number of policy payloads for the same group account (or group accounts attached to the same group client) and for existing policies (with changes on the policy group account), is processed by the Policy In Batch IP, it runs into an optimistic lock failure on group client: GEN-RULE-020: The entity GroupClientDomain Primary Key>xxx cannot be updated because it has changed or been deleted since it was last read.
Resolution:		When something on the group client set up is changed, the attributes objectLastUpdatedBy and objectLastUpdatedDate (like for instance if group accounts on the group clients are added/updated or removed) are updated. But in this case it also tried to update these attributes for updates on policy group accounts. This is removed as a) it is not part of the setup data and b) causes this optimistic lock as multiple processes are trying to update the same group client.
36900589		POL-15470	Remove icon is removing multiple the multi-value rows.
Description:		When multiple rows of data for multi-value dynamic fields are added and the remove link on clicking the remove link, multiple rows are removed apart from the one with remove.
Resolution:		Clicking on remove link, removes the respective multi-value dynamic field row data and other rows are not removed.
36910554		POL-15639	Currency digit symbol displayed on multiple lines in Members Foldout Page
Description:		Navigate to members and open any member which has value in products. In this Foldout Page the currency symbols SR or US is displayed on two lines one below the other
Resolution:		In Members Foldout Page the currency symbol is displayed before amount value in a single line
36407337		POL-14811	Policy enrollment event page does not show display text for business events
Description:		Create a custom floorplan with the attribute 'descriptionJET'. The descriptionJET attribute shows the display text containing substitution variables. If we remove the businessEventDefinition from the floorplan the descriptionJET attribute only shows 'Business Event'
Resolution:		The field description in Business Event rules page properly shows the display text of a business event definition if the event type is business
35143243		POL-12360	Create configuration migration set overwrites existing sets
Description:		In the JETUI, if a new configuration migration is created and a code is used of a CMT set that already exists, the existing migration set is overwritten with the data of the "new" set. The expectation is that saving that "new" set would fail because there already is an existing set with that code.
Resolution:		Saving a "new" config migration set will fail when there is an existing set already with that code and shows error message
34979905	3-31796002821	POL-11966	Dynamic logic timeout property is ignored when compiling dynamic logic at startup time
Description:		The dynamic logic timeout property (ohi.dynamiclogic.timeout or ohi.dynamiclogic.timeout.{0}) is ignored when the dynamic logic is compiled at system startup time.
Resolution:		Load the system property from the database if the loading of system properties is not completed. If loading of system property is completed then load from cache.
Backports:		3.22.2.0.23, 4.23.2.0.1, 4.23.1.0.3

Issues that were backported in previous Release / Patch

BugDB	Internal	Summary	Backport	BugDB	SR
34979905	POL-11966	Dynamic logic timeout property is ignored when compiling dynamic logic at startup time	3.22.2.0.23	35850636
34979905	POL-11966	Dynamic logic timeout property is ignored when compiling dynamic logic at startup time	4.23.2.0.1	36154640
34979905	POL-11966	Dynamic logic timeout property is ignored when compiling dynamic logic at startup time	4.23.1.0.3	35854454
35608523	POL-13222	All future dated mutations should be deleted when calculate premium activity is executed	4.23.2.0.1	36151850	3-32973122991
35608523	POL-13222	All future dated mutations should be deleted when calculate premium activity is executed	3.22.2.0.23	35608564	3-32973122991
35608523	POL-13222	All future dated mutations should be deleted when calculate premium activity is executed	4.23.1.0.4	36151848	3-32973122991
36209702	POL-13390	Slowness in calculate premium when group client parameter is specified.	3.22.2.0.22	36211596	3-35379874711
36209702	POL-13390	Slowness in calculate premium when group client parameter is specified.	4.23.2.0.1	36211500	3-35379874711
36209702	POL-13390	Slowness in calculate premium when group client parameter is specified.	4.23.1.0.3	36213517	3-35379874711
36462963	POL-13765	Flexcodes API returns value of ID as number instead of String	4.23.1.0.4	36463022
36462963	POL-13765	Flexcodes API returns value of ID as number instead of String	4.23.2.0.2	36462976
36020652	POL-13979	PROCESS_REGISTRATIONS activity takes more than an hour to create child activities	4.23.1.0.2	36020657	3-34751448551
36020652	POL-13979	PROCESS_REGISTRATIONS activity takes more than an hour to create child activities	3.22.2.0.21	36020665	3-34751448551
36020652	POL-13979	PROCESS_REGISTRATIONS activity takes more than an hour to create child activities	4.23.2.0.1	36153617
36059038	POL-14032	Search on Datasetdefinitiondetails should return entity name in href link of Change Event Rules	4.23.2.0.1	36151881
36059038	POL-14032	Search on Datasetdefinitiondetails should return entity name in href link of Change Event Rules	4.23.1.0.5	36589107
36150523	POL-14235	Individual providers - Unable to edit service address configured as deeplink in rendering address tab	4.23.2.0.1	36150543
36150990	POL-14237	Enrollment IP metadata is invalid	4.23.2.0.1	36151889	3-35320237389
36150990	POL-14237	Enrollment IP metadata is invalid	4.23.1.0.3	36151014	3-35320237389
36167108	POL-14246	Deselect all checkbox is not working in table component	4.23.2.0.3	36167114
36194685	POL-14346	Add new row is shown at last in table pages	4.23.2.0.5	36194691
36195628	POL-14355	Incorrect result shown in Boilerplates Table	4.23.2.0.5	36270211
36204006	POL-14385	Dynamic logic byte code is not loaded during server startup on non master nodes after invalidateall API is invoked	3.22.2.0.23	36204035	3-34786906091
36204006	POL-14385	Dynamic logic byte code is not loaded during server startup on non master nodes after invalidateall API is invoked	4.23.2.0.1	36204014	3-34786906091
36204006	POL-14385	Dynamic logic byte code is not loaded during server startup on non master nodes after invalidateall API is invoked	4.23.1.0.3	36204027	3-34786906091
36211313	POL-14418	Adjustment Rules - The amount field is not accepting negative value, also few columns are missing	4.23.2.0.1	36246688
36211313	POL-14418	Adjustment Rules - The amount field is not accepting negative value, also few columns are missing	4.23.1.0.3	36219176
36213029	POL-14421	System unable to offset refund when there is an unapplied amount greater than refund	3.22.2.0.23	36238567	3-35477511858
36213029	POL-14421	System unable to offset refund when there is an unapplied amount greater than refund	4.23.1.0.3	36295837	3-35477511858
36213029	POL-14421	System unable to offset refund when there is an unapplied amount greater than refund	4.23.2.0.1	36295842	3-35477511858
36219954	POL-14435	Length of OHI_ID_ARRAY database type is still 14 after upgrading to 4.23.1 release	4.23.2.0.1	36250604
36219954	POL-14435	Length of OHI_ID_ARRAY database type is still 14 after upgrading to 4.23.1 release	4.23.1.0.3	36250669
36227266	POL-14468	SQL execution plan to delete selected financial transactions for large group is inefficient	3.22.2.0.22	36227311	3-35379874711
36227266	POL-14468	SQL execution plan to delete selected financial transactions for large group is inefficient	4.23.2.0.1	36227529	3-35379874711
36227266	POL-14468	SQL execution plan to delete selected financial transactions for large group is inefficient	4.23.1.0.3	36227371	3-35379874711
36243787	POL-14500	Enrollment Changes are not separated per person in Enrollment Events	4.23.1.0.4	36370881	3-35475079541
36243787	POL-14500	Enrollment Changes are not separated per person in Enrollment Events	4.23.2.0.2	36325054	3-35475079541
36251413	POL-14517	Slowness in calculate premium when group client parameter is specified.	3.22.2.0.23	36275634	3-35379874711
36251413	POL-14517	Slowness in calculate premium when group client parameter is specified.	4.23.2.0.1	36275593	3-35379874711
36251413	POL-14517	Slowness in calculate premium when group client parameter is specified.	4.23.1.0.3	36275603	3-35379874711
36251887	POL-14518	All records are not shown in downloaded file, only 10 records are shown even after scrolling in table page	4.23.2.0.5	36195780
36264554	POL-14531	Ensure that notification is sent only when the datafile creation for output generation activity is complete	4.23.1.0.4	36264589	3-35378971011
36264554	POL-14531	Ensure that notification is sent only when the datafile creation for output generation activity is complete	4.23.2.0.2	36264585	3-35378971011
36276110	POL-14573	Business event is not getting generated due to incorrect parameter(entity name)	4.23.1.0.3	36295784
36276110	POL-14573	Business event is not getting generated due to incorrect parameter(entity name)	4.23.2.0.1	36295733
36300123	POL-14602	Data from technical table is not cleaned up if an extract activity fails which leads to data accumulation	4.23.2.0.3	36393269	3-35684326321
36300123	POL-14602	Data from technical table is not cleaned up if an extract activity fails which leads to data accumulation	4.23.1.0.5	36393276	3-35684326321
36300161	POL-14603	End policy action in view and edit policy page ends inactive time valid records	4.23.1.0.4	36314059	3-35742239861
36300161	POL-14603	End policy action in view and edit policy page ends inactive time valid records	3.22.2.0.23	36313774	3-35742239861
36300161	POL-14603	End policy action in view and edit policy page ends inactive time valid records	4.23.2.0.2	36313847	3-35742239861
36305364	POL-14612	Extract status is failure when the associated activity is in 'QD' status	4.23.2.0.1	36315697
36315306	POL-14618	Gathering statistics on technical table for every extract activity is inefficient	4.23.1.0.4	36414254	3-35684326321
36315306	POL-14618	Gathering statistics on technical table for every extract activity is inefficient	4.23.2.0.2	36414244	3-35684326321
36315306	POL-14618	Gathering statistics on technical table for every extract activity is inefficient	3.22.2.0.25	36414259	3-35684326321
36316992	POL-14623	Generate baseviews fails intermittently with CacheCreationException	4.23.2.0.1	36317048
36316992	POL-14623	Generate baseviews fails intermittently with CacheCreationException	4.23.1.0.4	36317141
36325079	POL-14638	Custom jet fields createdbyjet and lastupdatedbyjet are not working for tab configuration	4.23.2.0.2	36353153	3-35011487731
36392133	POL-14649	Unable to invoke Macros when a macros template is attached to macro definition	4.23.2.0.2	36392137
36343961	POL-14686	Adding Bank Accounts as configurable entity for Business Event Rules	4.23.1.0.4	36355823	3-35475079541
36343961	POL-14686	Adding Bank Accounts as configurable entity for Business Event Rules	4.23.2.0.2	36355819	3-35475079541
36347890	POL-14695	Medicare details are auto populating in new record when there are multiple policy enrollment products	4.23.2.0.2	36347910
36363607	POL-14696	Additional Fields at tab level is not retrieving the data.	4.23.2.0.2	36363652
36350847	POL-14707	Preferred language, contact details and address details are not populating in person details section in create mode	4.23.2.0.2	36350831
36350892	POL-14709	Ethinicity and race multivalue select box not working in create mode	4.23.2.0.2	36350882
36352064	POL-14712	Dynamic field value is getting wiped off and not holding the data upon save and also title is not displayed	4.23.2.0.2	36352074
36355922	POL-14717	Changes are not saved for the code and description of an existing CMT Set in Jet UI	4.23.1.0.4	36355950
36355922	POL-14717	Changes are not saved for the code and description of an existing CMT Set in Jet UI	4.23.2.0.2	36355929
36366909	POL-14733	Preferred language field editable in persons details section though it is readonly	4.23.2.0.2	36366919
36371670	POL-14755	Response time of adding a dynamic record on attached policy data using collection patch is high	4.23.1.0.4	36371684	3-35948698481
36371670	POL-14755	Response time of adding a dynamic record on attached policy data using collection patch is high	3.22.2.0.24	36371683	3-35948698481
36371670	POL-14755	Response time of adding a dynamic record on attached policy data using collection patch is high	4.23.2.0.2	36371685	3-35948698481
36376584	POL-14765	Connector config: spinner shown on create	4.23.2.0.2	36376607
36377399	POL-14767	Save and Cancel shortcuts aren’t working for create Hierarchical Recursive pages	4.23.2.0.2	36377401
36403699	POL-14802	Global activities: Business error shown on bulk update invoke	4.23.2.0.2	36403711
36403699	POL-14802	Global activities: Business error shown on bulk update invoke	4.23.1.0.5	36403712
36409942	POL-14815	JWT bearer grant type is not working	4.23.2.0.3	36410453	3-34612052061
36416442	POL-14845	OAuth parameters should be configurable	4.23.2.0.3	36416431	3-34612052061
36429069	POL-14876	Macro payload that is sent out contains displayName instead of usageName for macro parameters.	4.23.2.0.3	36562440
36433094	POL-14880	Dynamic records ID should be returned as string in the API response	4.23.1.0.4	36433108	3-36176430291
36433094	POL-14880	Dynamic records ID should be returned as string in the API response	4.23.2.0.2	36433105	3-36176430291
36443612	POL-14901	Parameter value of type percentage with value 0 is not displayed	4.23.2.0.3	36463891	3-36178016821,3-36314937451,3-36339863591,3-36719019981
36443612	POL-14901	Parameter value of type percentage with value 0 is not displayed	4.23.1.0.5	36457033	3-36178016821,3-36314937451,3-36339863591,3-36719019981
36445455	POL-14917	Adding multiple parameters in Enrollment, Parameter Domain tab ends up in GEN-ORA-01400	4.23.2.0.3	36445473	3-36168869491
36445455	POL-14917	Adding multiple parameters in Enrollment, Parameter Domain tab ends up in GEN-ORA-01400	4.23.1.0.5	36445475	3-36168869491
36480311	POL-14973	Policy search by Policy Holder name is case sensitive	4.23.1.0.4	36085144	3-31029430181
36480311	POL-14973	Policy search by Policy Holder name is case sensitive	3.22.2.0.26	36085157	3-31029430181
36480311	POL-14973	Policy search by Policy Holder name is case sensitive	4.23.2.0.2	36480308	3-31029430181
36482250	POL-14984	PII data is not correctly populated when setting corresponding property	4.23.1.0.6	36482266	3-36178158771
36482250	POL-14984	PII data is not correctly populated when setting corresponding property	4.23.2.0.4	36482265	3-36178158771,3-36983961191
36484991	POL-14991	Incorrect value in changelist payload sent by jet ui for integration connector	4.23.2.0.3	36485010	3-35901354371
36484991	POL-14991	Incorrect value in changelist payload sent by jet ui for integration connector	4.23.1.0.5	36485011	3-35901354371
36493451	POL-15001	Date Paid To is not reset when enrollment ended and future dated payments exist	4.23.2.0.3	36552243	3-36171988661
36493451	POL-15001	Date Paid To is not reset when enrollment ended and future dated payments exist	4.23.1.0.6	36552245	3-36171988661
36493451	POL-15001	Date Paid To is not reset when enrollment ended and future dated payments exist	3.22.2.0.26	36539825	3-36171988661
36500910	POL-15010	Unable to add a new contract period for renewal	4.23.2.0.3	36508201	3-36340300401
36502537	POL-15011	Access mapping (relation links api) missing for organization/person page	4.23.2.0.2	36502541	3-36334533791
36502537	POL-15011	Access mapping (relation links api) missing for organization/person page	4.23.1.0.5	36502542	3-36334533791
36547167	POL-15061	filename contains diacritics, upload erroneously transforms the filename to some other characters.	4.23.2.0.3	36562913	3-34871101921
36547167	POL-15061	filename contains diacritics, upload erroneously transforms the filename to some other characters.	4.23.1.0.5	36562914	3-34871101921
36591307	POL-15133	Table component: When we select any LOV value from lookup field, and come out of the row, the value selected disappears	4.23.2.0.4	36591308
36593601	POL-15135	Remove the usage of utl_tcp DBMS package in extract functionality	4.23.2.0.4	36593604
36593601	POL-15135	Remove the usage of utl_tcp DBMS package in extract functionality	4.23.1.0.5	36593620
36659255	POL-15209	Generate mutations activity takes disproportionate amount of time to complete in a specific scenario.	4.23.1.0.6	36659297	3-36463843611
36659255	POL-15209	Generate mutations activity takes disproportionate amount of time to complete in a specific scenario.	4.23.2.0.4	36659365	3-36463843611
36704128	POL-15272	Example Calculation is not showing the correct Calculation period startdate/ enddate	4.23.2.0.4	36704153	3-36998302541
36744101	POL-15329	Unable to apply update trigger on resource 'attachedpolicydata' in Change Event Rules page	4.23.2.0.5	36744401
36752259	POL-15339	The page keeps loading while trying to add fields under usage	4.23.2.0.5	36752302	3-37045628421
36767285	POL-15380	Advanced search lov’s for dynamic fields are not loading in referencesheetlines	4.23.1.0.6	36809666	3-36452370811
36767285	POL-15380	Advanced search lov’s for dynamic fields are not loading in referencesheetlines	4.23.2.0.5	36809661	3-36452370811
36799328	POL-15428	Select Financial Transaction into Set activity failing with GEN-PROC-ERR	4.23.2.0.5	36813394	3-37120352731
36823241	POL-15475	Integer field values are shown with separator (12,345 instead of 12345)	4.23.2.0.5	36823254
36833471	POL-15488	Issue with display of flexcodes in piechart for widget	4.23.2.0.5	36833476	3-36864108701,3-37393890291

Known Issues

BugDB	SR	Internal	Summary
33923326		POL-10198	Child activities are still in process when parent activity has the status 'TE'
Description:		When one of the groups of activities fails, the parent activity is marked as 'TE' while the child groups are still running.
34169826		POL-10586	Execution of callout rule dynamic logic fails from test unit
Description:		For callout rule dynamic logic, the endpoint placeholder is set on callout rule code and not dynamic logic code (ohi.{0}.endpoint.request), This leads to execution error in unit test.
34175340		POL-10596	Recent policy holder (formatted name) header/ column is missing in Widgets
Description:		In Policies search page add a widget Application InProgress(Edit) Search results table Recent Policy Holder (formatted name) header/ column is missing.
34401147	3-29621579461	POL-11019	The CMT recovery process fails with a null pointer exception
Description:		During restart, the data set processes for CMT are cleaned up. As a result, the CMT recovery process fails with a null pointer exception.
34543324		POL-11184	Change event rules on person’s maritalStatusList are not triggered via POST request on generic/maritalstatuses
Description:		Given that we have a change event rule configured on update of person. When we add a marital status via a PATCH or PUT request on api/generic/persons, then change event rule correctly gets triggered. However, when we add a marital status via a POST on the child resource itself (that is: api/generic/maritalstatuses), then, the change event rule is incorrectly not triggered. This also affects this update to person (adding a maritalStatus) via JET UI.
36440999		POL-11663	While Rejecting or Accepting an enrollment file, the system does not wait and show if backend process is completed or failed
Description:		No indication to user that activity is completed when Rejecting or Accepting an enrollment file
34871685		POL-11741	Auto Include Extensibility Error Handling
Description:		When there is an error in any multivalue dynamic field or dynamic record the error path is not indicating the particular property along with the index as shown for other multivalue list items present in the metadata.
35685322		POL-11830	When opening the Account Details page from the Policy sub- menu with Edit, the policy code is not displayed.
Description:		When opening the Account Details page from the Policy sub- menu with Edit (pencil), the policy code is not displayed. When opened to view (eye), the policy code is displayed. When in Edit mode the policy accounts page is saved, then the policy code becomes visible.
35541887		POL-13052	Outbound exchange: values are not getting updated after building a data set
Description:		When trying to build a data set, exactVersionMatch and disableDeleteByOmission are not getting updated. Also If we try to update the inclusionDate by passing empty value it is not getting updated.
36977985		POL-13102	Error Message: Generic error message showing instead of actual message
Description:		Generic error message should be shown for relation link type page
35656722		POL-13337	Person LOV - Formatted address JET property is not displayed
Description:		Person LOV should work with formatted address JET property and display the value
35686861		POL-13355	Reset Query Statistics - in Monitor Dynamic Logic Querying
Description:		When we query something in the testunit dynamic logic and then invoke/test another dynamic logic in the same testunit dynamic logic, the value/count for all query parameters displays incorrect
35676529	3-33383356981	POL-13383	Message republish should not happen whereas URI is not set or empty
Description:		For connector configuration if URI is not set or is empty in the configured endpoints and message republishing is ON. The messages keeps on republishing endlessly instead of stopping when not found an endpoint URI.
35691448		POL-13405	Boilerplates not loading when 2 widgets with same resource is added of type data table
Description:		Create 2 widget with same resource of type data table or find any 2 seeded data table widget with same resource. When both widgets are added, boiler plates are not loading for one of the widgets.
36369698		POL-13754	Re-login is blocked when user use the same session by entering the env url
Description:		Logging out from the second tab causes the first tab to become unresponsive when trying to navigate to any other page. This issue is specific to cloud environments
36440901		POL-13757	Header should be right aligned when parameter schedule dimension is added to adjustment rules/schedule lines
Description:		Header should be right aligned when parameter schedule dimension is added to adjustment rules/schedule lines
36285066	3-36042566951	POL-13942	Policies abruptly ending in Technical Error are not clearing the technical flag (TEC_IND_SUBMITTED) used for throttling
Description:		The technical flag (TEC_IND_SUBMITTED) used for activity throttling isn’t getting reset when sometimes activities end in a technical error (abruptly). This results in the queuing of new activities, which aren’t processed timely.
36041732		POL-14010	Business event rules that monitor a person create two policy enrollment events if a person is a member and policyholder on a policy.
Description:		Business event rules that monitor a person create two policy enrollment events if a person is a member and policyholder on a policy instead of one.
36089571		POL-14080	Configuration migration returns error on 'Supported Insurable Entity Type'
Description:		An error is thrown when merging the setup of two enviroments in which an insurance type and an insurable entity type are configured independently.
36112016	3-34938069431	POL-14165	Process policy activity gets stuck when the processing policy is reverted
Description:		Process Policy activity gets stuck in "InProcess" status if we revert one of the policies(In Edit status) that have been queued for the Process Policy activity. The activity must have ended in error (end state) which is not happening.
36424923		POL-14209	Enrollments NewView: When deeplink configured as tab in Policy Enrollments tab, unsaved changes pop up not showing when member is viewed
Description:		When the user navigates out of the Policy Enrollments tab in new view the user does not get an unsaved changes dialog prompting the user to save.
36925389	3-37554577351	POL-14222	Evaluate Conditions not working in Edit Mode
Description:		Evaluate condition in floorplan not working for the first time in edit mode. Its working fine in create mode. initconditions are not used in floorplan, as evaluateconditions are not working as intended when used with initconditions
36181459		POL-14295	POL - Alignment is broken when Single value or multi value field is configured with one of the fields configured with LOV value
Description:		SVNTV / MVNTV dynamic record fields configured in a way that one of the fields is LOV based is breaking Alignment
36195848		POL-14360	Single-value, non time-valid dynamic records cannot be deleted
Description:		In the case of non time-valid record, 'Remove' button does not appear. So once data is entered for the record, the record itself cannot be deleted. Assuming fields are optional, clearing the values for a record does not work. After saving the cleared fields, data appears again.
36301775		POL-14610	NullPointerException occurred during the generation of base views while selecting the referenceSheetLines baseview
Description:		NullPointerException occurred during the generation of base views while selecting the referenceSheetLines baseview.
36315799		POL-14622	Dates not populated when using jet on virtual box
Description:		After upgrading the Virtual Box to 4.23.1 dates are not being populated when using Jet UI. This was discussed with PD and I am being asked to create a OHISD so someone can check what is missing on the Virtual Box
36895410		POL-14634	Advanced search is not working in widgets
Description:		Advanced search is not allowing to select a value when configured in widgets.
36915324		POL-14989	Duplicate data files are being created by recovery activities
Description:		Activities when recovered end in technical error, as the recovery operation on these activities is creating duplicate data files.
36981690		POL-15004	Loading Create page using system specific floorplan is showing error
Description:		When an errored floorplan is active and create page is loaded with non errored floorplan, the page doesn’t load and shows error.
36551305		POL-15065	[Primary bug]multiple issues while translating screens from english to dutch
Description:		multiple issues while translating screens from english to dutch
36600678		POL-15151	Activity is not behaving as expected during testing recovery mechanism
Description:		When submission from processing grid is removed for a InProcess (IP) stuck activity using clearsubmissioncache IP, the activity goes to TechnicalError (TE) state. On recovering activity, it is not immediately completing. It takes some time and often throws timed out error.
36962495		POL-15225	MA Part D Late Enrollment Penalty Ext fields should be shown under Entity LOV
Description:		Business Event Rules page needs update to show the MultiValue fields for medicare entities in the 'Entity' dropdown itself. This is not shown now
36915456		POL-15251	Mandatory check missing for Total Premium Currency field
Description:		Mandatory Check is missing for currency fields
36844414		POL-15483	Display error message for url parameter limit exceeding 1024 characters on search pages
Description:		Console error is showing up when url parameter is exceeding limit. Error message needs to be displayed in UI when parameter limit exceeding 1024 characters on search pages.
36946576		POL-15484	Queued activities remain in QD status when memory protector kicks-in
Description:		The queued activities always remain in QD status when application memory is recovered after breaching the critical memory threshold. Expected: The activities must move to IP status when the application recovers from memory failures and there is enough room available to process the activities
36968809		POL-15503	Policy Search: Few fields are missing on Download
Description:		Create a policy with policy holder, Person, brand and save. Navigate to search policy page and make search with the policy created and click on download button. Few fields are missing like policy holder, person, Agents, Group Account
36855244	3-37088137401	POL-15519	Refund Registrations on terminated policies are causing Processing Errors
Description:		This issue occurs when a policy is terminated in the past, whereas there are applied payments after the termination date. These payments need to be refunded, but the system does not apply refunds when there are no Policy Calculation Periods. These Policy Calculation Periods are non existing because of the policy termination.
36861261		POL-15526	Policy enrollment base view doesn’t have flexcodes as columns.
Description:		Policy enrollment base view doesn’t have flexcodes as columns
36867155		POL-15535	Reference sheet lines - LOV values are not displayed in search option after selecting from lov
Description:		LOV values are not displayed in search option of AND mode quick search after selecting from lov
36867693	3-37391765051	POL-15536	CMT: inclusionDate, exactVersionMatch, disableDeleteByOmission are not applied when building CMT sets
Description:		When building any CMT sets, the values in the dialog are not being applied
36882974	3-37479307981	POL-15567	Decimals are not shown on premium schedule lines for dimensions of datatype number.
Description:		When a premium schedule line with dimensions of datatype number is configured, decimals values cannot be entered and saved.
37004418		POL-15609	No success message or pop up on clicking resend/cancel notification and getting console error
Description:		No success message appears when clicked on send notifications /cancel notifications option
36890553	3-37549087361	POL-15611	Exclude certain attribute options from the business event rule page
Description:		When creating a Business Event Rule, certain non-monitored attributes (e.g., Status, Creation Date, GID) should be excluded from the drop-down menu. This ensures users can only select relevant attributes for monitoring. These exclusions are due to specific reasons, such as consistency across versions.
36919102		POL-15624	MA: Usages added to table are visible in more section
Description:		Usages added to table are visible in more section of the table
37004108		POL-15659	Linking Relation: A relation link is not deleted when a relation is deleted.
Description:		A relation link is not deleted when a relation is deleted., which violates the business rule: GEN-RULE-CEV-001 Cascade Delete
36930049	3-37582942001,3-37641895001,3-37634081651	POL-15668	Large chronicle queue files of size 180GB were created by applicationDBAppender while capturing application log events
Description:		The applicationDBAppender that captures the application log events in DB generated a large chronicle queue files of size 180GB due to an exception that got re-queued in an end-less while loop
36981727		POL-15694	Edit action is not persisting the data
Description:		Edit action is not persisting when we save and come back to the page in medi assist policies
36792770	3-37171703281	POL-15722	Dynamic record is displaying in extensibility when configured to show in floorplan
Description:		When auto-include extensibility is set to 'true' and a dynamic record is configured to show in the floorplan, the documented behavior is that the Dynamic Record or Field would not be shown in the 'Additional Fields' or 'Extensibility' section but it is shown in Extensibility' section
36970155	3-37743857111	POL-15724	Incorrect use of ohi.ws.client.readtimeout propperty to set the entire request/response timeout
Description:		The system property ohi.ws.client.readtimeout is intended to control the time (in milliseconds) that the client will wait for a response from the server after sending a request. However, it is currently being incorrectly applied to set the timeout for the entire request/response conversation, rather than just the response wait time.
36977332		POL-15726	Remove Copy from Global activities details page
Description:		Copy action should not be shown for view only details pages
36975983		POL-15728	NPE is thrown on running sample calculation for Policies having surcharge of type amount
Description:		NullPointerException is thrown on screen on running sample calculation for policies having surcharge of type amount and policy enrollment product ending before the PCP (yearly PCP)/
32477645		POL-7319	No base view generated for reference sheet lines
Description:		Reference sheet line(s) use a different storage structure (JSON) for the dynamic fields. The base view generator does not support that yet. So, the reference sheet line columns can’t be queried using base views.
32637705		POL-7727	Adjustment result amount is incorrect when using separate scoped adjustments in multiple sequences
Description:		When multiple adjustments scoped on different premium schedule types are in multiple sequences, adjustments in the higher sequence may not consider adjustments in earlier sequences if there are no unscoped adjustments. For example, if there are two premium schedules of two different premium schedule types and if an adjustment (based on non-prorated function) is configured scoped on the first premium schedule type in sequence 1, another adjustment (based on non-prorated function) is configured scoped on total in sequence 2 and another adjustment (based on percentage) is configured scoped on the first premium schedule type in sequence 3, then the adjustment amount calculated for the adjustment in sequence 3 is incorrect.
33166667	3-26374448851	POL-8747	Generated dynamic logic signature groovy files contain compilation errors
Description:		Groovy files for dynamic logic signatures can be generated from either the Objects Integration Point or via the Generate Objects button on the View Objects page. Some of these files have compilation errors.
33186031	3-26374448851	POL-8781	Generated dynamic logic signature groovy files do not compile in a Gradle project
Description:		Groovy files for dynamic logic signatures can be generated from either the Objects Integration Point or via the Generate Objects button on the View Objects page. Some of these files have compilation errors specific to Gradle, such as variable names containing a dollar sign or dependencies being added with an @Grab annotation.
33430533		POL-9253	Usages - Add to Floorplan - When same usage is associated in all the sets of a floorplan, the values are not rendered properly on the entity’s page.
Description:		When an usage is added to Floorplan to display the same dynamic field in multiple sets of the entity page, the respective fields are not rendering the values as expected. So there needs to be a reconfiguration check in place to handle this situation.

Deprecated Items

These features will be removed in a future release. Customers are advised to review the documentation and take timely action.

JIRA Key Announced	Release Announced	Summary
NXT-25000	3.22.2.0.0	The use of parameters that influence the resource representation in the 'Accept' header of an HTTP request is deprecated. Reference Document
NXT-25662	3.22.2.0.0	The support to GET operations on Query API calls is deprecated. Reference Document
POL-7669	3.22.2.0.0	The type of the marital statuses of a Person has changed from an enumerated, fixed list of types to a configurable list. Reference Document
POL-13546	4.23.2.0.0	The Attached Data Integration Point is deprecated Reference Document
POL-14578	4.24.1.0.0	ohi.ws.enrollmentresponse.request.lob property is deprecated. This property is added to support backward compatibility for Line Of business to Insurance Type in Policy In (Patch) IP Reference Document
POL-16238	4.24.1.0.0	In the upcoming 4.25.1.0.0 release, we will upgrade the Groovy library from 3.x to 4.x. Several APIs have been deprecated in Groovy 3 and are removed in Groovy 4. For example, classes previously available in both groovy.util and groovy.xml (such as XmlSlurper and XmlParser) are now available only in the groovy.xml package in Groovy 4. Therefore, customers who use classes from groovy.util must update their dynamic logic to use groovy.xml instead to ensure compatibility with Groovy 4. Reference Document