There are two scenarios for source redirection between Transactional Business Intelligence and Oracle BI Applications use cases.
Transactional Business Intelligence specific subject areas - Queries against these subject areas use the Transactional Business Intelligence transactional source.
Shared subject areas - Queries against these subject areas use the Oracle BI Applications warehouse source by default unless a user explicitly adds a filter on a Transactional Business Intelligence specific attribute to force the query to select the transactional source.
A BI Administrator can assign a logical table source to a particular priority group. If there is a choice between two logical table sources, a logical table source in a higher priority group would always be chosen over the lower priority logical table source.
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).