Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
SCM VOs missing in BICC & OTBI - SCM OM and INV tables mapping not available

Organization Name
Archrock Services LP
Description
The below SCM and OM tables do not have the related VOs mapping in OTBI. They are required for creating SCM reports with the corresponding VOs.
DOO_HEADERS_EFF_B
EGO_ITEM_EFF_B
CST_ORGANIZATION_DEFINITIONS_V
Use Case and Business Need
We are working on a project of converting our EBS reports and data warehouse reports to cloud with ADW & BICC. In order to create reports on OM and INV, we need to find the above mentioned tables VOs in 20 C or 20 D.
FSCM https://cloudcustomerconnect.oracle.com/posts/c6614f9d47
Original Idea Number: 3c0f3690d8
Comments
-
We have the same business need.
We have used a custom BI Pub query to do the export, but it would be much better to have it included in BICC datastores.
Thanks !0 -
Data elements need to be added to PVO in BICC to enable access via ADW reporting
0 -
Hi there,
Thank you for your idea. I am relocating it to our Transactional Reporting (OTBI) Idea Lab for proper review: https://cloudcustomerconnect.oracle.com/resources/b2df648d2a/summary
Best,
Brendan J. Doyle
0