SOA 11g - Updates In DB Are Not Reflected Immediately With Persistence Option In Business Rules Java Facts (Doc ID 1632361.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle SOA Suite - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

Updates in DB are not reflected immediately with persistence option in Business Rules Java facts.

A Business Rules function calls Java facts to retrieve data from the database, while retrieving the values from database, the data is not getting refreshed and is retrieving old data instead.  This is happens intermittently. The use case involves using persistance and Toplink to call the database from a Java class which is called from the Business Rules function.

Steps to replicate the issue

1. Create a Business Rule decision table
2. Call Business Rules function from the decision table
3. Call the Java facts to retrieve data from the database using Toplink and persistance.
4. The issue will occur intermittently

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