Business Rules : Points To Remember

You may find business rule really difficult to implement at first if you are not aware of business rule modelling rules. Listing here some points useful while implementing business rules. I will try to keep this list progressive as and when I discover new points.

Oracle BR matches the fact by types and not by their names. If there are multiple fact of the same type available in the working memory then it will not be able to resolve the fact to update and will throw below exception.

The RL function getFactByType found more than one instance of the fact type

Input facts are asserted by rule engine. Rest all facts needs to be asserted explicitly by assert or assert new expressions. Without asserting a fact you cannot work/perform any function on fact for e.g. modify or assign. There is one other way to make the output fact available in then condition. Assert output fact in initial tab of decision service and use advanced mode and declare variable as shown in image below.

Reclaim Space From SOA Tablespace

Below command is the way to reclaim the tablespace from SOA schemas.

alter table audit_trail deallocate unused;
alter table audit_trail enable row movement;
alter table audit_trail shrink space compact;
alter table audit_trail shrink space;
alter table audit_trail disable row movement;

alter table audit_details deallocate unused;
alter table audit_details enable row movement;
alter table audit_details shrink space compact;
alter table audit_details shrink space;
alter table audit_details disable row movement;

alter table cube_instance deallocate unused;
alter table cube_instance enable row movement;
alter table cube_instance shrink space compact;
alter table cube_instance shrink space;
alter table cube_instance disable row movement;

alter table cube_scope deallocate unused;
alter table cube_scope enable row movement;
alter table cube_scope shrink space compact;
alter table cube_scope shrink space;
alter table cube_scope disable row movement;

alter table dlv_message deallocate unused;
alter table dlv_message enable row movement;
alter table dlv_message shrink space compact;
alter table dlv_message shrink space;
alter table dlv_message disable row movement;

alter table dlv_subscription deallocate unused;
alter table dlv_subscription enable row movement;
alter table dlv_subscription shrink space compact;
alter table dlv_subscription shrink space;
alter table dlv_subscription disable row movement;

alter table document_ci_ref deallocate unused;
alter table document_ci_ref enable row movement;
alter table document_ci_ref shrink space compact;
alter table document_ci_ref shrink space;
alter table document_ci_ref disable row movement;

alter table document_dlv_msg_ref deallocate unused;
alter table document_dlv_msg_ref enable row movement;
alter table document_dlv_msg_ref shrink space compact;
alter table document_dlv_msg_ref shrink space;
alter table document_dlv_msg_ref disable row movement;

alter table headers_properties deallocate unused;
alter table headers_properties enable row movement;
alter table headers_properties shrink space compact;
alter table headers_properties shrink space;
alter table headers_properties disable row movement;

alter table work_item deallocate unused;
alter table work_item enable row movement;
alter table work_item shrink space compact;
alter table work_item shrink space;
alter table work_item disable row movement;

alter table wi_fault deallocate unused;
alter table wi_fault enable row movement;
alter table wi_fault shrink space compact;
alter table wi_fault shrink space;
alter table wi_fault disable row movement;

alter table xml_document deallocate unused;
alter table xml_document enable row movement;
alter table xml_document shrink space compact;
alter table xml_document shrink space;
alter table xml_document disable row movement;