Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Adding Trading Partner Item columns to an OTBI Subject Area limits the records to Master Org
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):
Atrium Health
Description (Required):
When adding Trading Partner Item Details columns to an OTBI Report, it limits the records to Master Org. We would like to be able to have the TP related fields show for all the Child Organizations of the item as well.
As we checked nqquery, we observed that the Master Organization Id is used to join the EGP SYSTEM ITEMS B V and EGP ITEM RELATIONSHIPS B V tables in the outer query where clause (here, the Master Organization id is taken from the V228609011 inline query in which the EGP ITEM RELATIONSHIPS B V and EGP TRADING PARTNER ITEMS tables are joined). As a result, it allows only the Master organization items to be displayed along with their TP Numbers. (More information can be found in the SR listed below.)
Use Case and Business Need (Required)
Need an OTBI report (Instead of BIP) to track information about the trading partners of the Master and Child Organizations.
Enhancement Request / Service Request:
SR - 3-30543642471