Hot Fix

A Hot Fix for imbalances has been released in your Opera version.

This patch will improve the Imbalance Analysis tool in order to cover more scenarios to be fixed by the tool.

The main benefit from this patch is that data correction won't have to be done manually (via scripts) anymore, and the tool will fix them directly.

Therefore, this will improve drastically the resolution time of these imbalances (current and future).

In order to benefit from the new Imbalance Fix tool, and improve drastically resolution for future imbalances, this Hot Fix now needs to be tested on your Test environment, then implemented in your Production environment.
For the implementation, you have different options:
- download the Hot Fix from our portal and implement it yourself (please see our article 2521004.1 to see which Patch numbers are relevant accordingly to your version, and links on how to implement them)

- Request our Consulting team to do it for you. To do so, please connect to our Store (URL below) and buy 3 hours. The Part Number is B87423. Please make sure to select the correct Country at the top right.

https://shop.oracle.com/apex/f?p=DSTORE:2:::NO:RIR,RP,2:PROD_HIER_ID:128016537132070991130337

- Otherwise, please contact your Sales Representative.

Please let us know the outcome.

Thank you.
Kind regards,"

Reference of Applicable OPERA versions for Freedom Fix

Step 1: From the OPERA PMS Application

Step by Step to Replicate:

1. Log into OPERA
2. Select Utilities
3. Navigate to Utilities Menu

4. Select Imbalance Analysis

If the form 'Imbalance Analysis Log details' appears similar to the below image, this confirms that 'Freedom Fix' has been applied at the Property.

It will display a value for 'Log ID' as a reference indicator.

It will display a value for 'Log Desc' which will link to the SR reference number or relevant information.

However, if the form imbalance Analysis appears similar to the below image, immediately after selecting imbalance Analysis in Step 4, this implies that 'Freedom Fix' has Not been applied at the Property.

This image below is the Imbalance Analysis form also known as balance.fmx

Imbalance Form Freedom Fix Identification

5.04.01 E03 -> 5.04.01 E30

5.04.02 E5 to 5.04.02 E27

5.5.0.8 to 5.5.0.24

5.5.1.0 to 5.5.1.7

N.B. For any 5.5.1.X OPERA version it is absolutely necessary to capture if the Log ID Details exists or not.

Step 2 : From SQL Query in the OPERA Schema - Please proceed when user permission & required knowledge exists to execute the below SQL statement

Connect to the OPERA Schema in a SQL prompt.

(Alternatively, if accessible the select statement may be performed in OPERA SQL.)

Execute the following command:

select * from REG_SQL_SCRIPT where UPPER (script_name) like '%FREEDOMFIX%'

Review the output to determine what 'Freedom Fixes' are implemented in the OPERA Environment at that time.
Note: If 0 results are returned by the execution of the select statement, this is an indicator of no 'Freedom Fixes' installed in the environment at that time.
Where capturing this information for logging a Service Request - Export the output of the select statement, including the select statement the output corresponds to and attach to the SR for follow up.