SCM VOs missing in BICC & OTBI - SCM OM and INV tables mapping not available

User_0NZKD

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

Yasmine Boutin-Oracle

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 !

Christine Mink-189236

Data elements need to be added to PVO in BICC to enable access via ADW reporting

Brendan J. Doyle-Oracle

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