Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Building BOM using analysis — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Building BOM using analysis

13
Views
2
Comments
edited Jan 3, 2020 10:53AM in General Transactional Reporting (OTBI) 2 comments

Summary

How to build a hierarchical BOM analysis showing on-hand quantity and item cost all for components in all levels

Content

In OBIEE, pre-built analysis "BOM" and "Where Used" did not produce any results, thereby is there a way to manually built a BOM analysis? 

The output information will need to undergo further processing, so Schedule Report function in Oracle Cloud (Fusion) is not an option because information doesn't get output in excel or .cvs formats.

The analysis would need to include the following information:
• Finished product Item Name
• Finished product on-hand quantity
• Finished product ordered (sold) quantity
• Components (For all levels) Item Name

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!