Query Re-direction

Subject areas can be shared between Transactional Business Intelligence and Oracle BI Applications. When selecting these subject areas to create queries, there may be a need to perform a query re-direction. In addition to subject areas that may be shared, there are logical facts that are also shared.

For additional information on query re-direction for Transactional Business Intelligence, see the Oracle® Fusion Transactional Business Intelligence Administrator's Guide RELEASE 1.0 which contains detailed information on how query re-direction is used for the Transactional Business Intelligence product.

For the Transactional Business Intelligence - Oracle BI Applications source redirection use case, logical table sources for Oracle BI Applications have a lower priority whenever another logical table source should be queried first. Oracle BI Applications have an order of 2 when Transactional Business Intelligence is installed. For more information on setting and using priorities for logical table sources, see the Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition, 11g Release 1 (11.1.1).