SAVE TO TABLE Does First Update, Then Insert (Doc ID 1480548.1)

Last updated on AUGUST 22, 2016

Applies to:

Oracle Utilities Meter Data Management - Version 1.6.1.1 and later
Information in this document applies to any platform.

Symptoms

The SAVE TO TABLE statement first tries to update the record and if that fails it tries to insert the record. This is inconsistent with the Rules Language documentation which states that the SAVE TO TABLE statement first tries to add the record and if that fails it tries to update the record.

Steps to Reproduce

1. Enable SQL Logging by placing lsdb.cfg.xml in the \LODESTAR\cfg directory.

 

Cause

Sign In with your My Oracle Support account

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

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