SOA 11g - Updates In DB Are Not Reflected Immediately With Persistence Option In Business Rules Java Facts
Last updated on NOVEMBER 03, 2016
Applies to:Oracle SOA Suite - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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
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