How to Extract Data from BRM_INSTANCE_TBL (Doc ID 2066688.1)

Last updated on OCTOBER 21, 2015

Applies to:

Oracle Retail Clearance Optimization Engine - Version 13.0.0 and later
Oracle Retail Markdown Optimization - Version 12.0 and later
Information in this document applies to any platform.

Goal

Occasionally, it may be desirable to extract the data from the core BRM_INSTANCE_TBL in the same format as the Business Rule Instances Standard Interface.  This allows rules to be loaded into a different environment or back into the same environment after making changes.  The SQL is provided to pull the data from BRM_INSTANCE_TBL in the same format as the standard interface for the load.

Solution

Sign In with your My Oracle Support account

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

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