Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Which business rules engine for apex application, dbms_rlmgr ?

PaavoDec 5 2014 — edited Dec 8 2014

Environments 11g and 12c with latest Apex production release with no app.server and Fusion install with Business Rules.

Which business rules mgr you would recommend to be used from Apex application?

The need is to validate page items especially list of values based on business rules so that the valid values for all lov's will change whenever any lov-item is changed.
Cascading lov's are not enough for this purpose, because end-user should be able to select invalid value from the lov which then 'invalidate' some of the lov's due the change of valid values.

Also certain computations could be done with rules which again change the setup and impacts to valid values for selections.

With DBMS_RLMGR it seems to be doable due it is neatly in the database and how about the Fusion Business Rules approach, how hard it would be to integrate with it?


The 12c documentation has e.g. DBMS_RLMGR listed http://docs.oracle.com/database/121/ARPLS/intro.htm#ARPLS65024

but is it use recommended at all? Can it be installed and used?

The application developers documentation can be found as follows, but for 12c it seems that the DBMS_RLMGR is no more supported?

11g https://docs.oracle.com/cd/B28359_01/appdev.111/b31088/exprn_intro.htm

10g http://docs.oracle.com/cd/B19306_01/appdev.102/b14288/exprn_intro.htm

Fusion Business Rules: http://www.oracle.com/technetwork/middleware/business-rules/overview/index.html

And this almost allured me to see apex app with fusion business rules

https://apex.oracle.com/pls/apex/f?p=44785:24:121311104828805::NO::P24_CONTENT_ID%2CP24_PREV_PAGE:7998%2C2

Or step out to drools?

rgrds Paavo

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 5 2015
Added on Dec 5 2014
2 comments
1,424 views