List of joins between ERP Tables

Shivakumar Biradar

Organization Name

Western Digital

Description

User can provide a set of tables as input to a UI.

The return from the UI should be list of tables and join conditions that should be used, to use the provided list of tables successfully without cross joins, and with right set of joins.

Use Case and Business Need

To create a new BIPublisher report with any two or more ERP Tables.

We don't know the right set of joins to use.

We don't know the right set of intermediate tables and the right set of joins that can be used along with these intermediate tables.

Oracle has to provide an UI, where user will provide a list of tables. 

Then this UI has to return the list of joins conditions to be used, along with intermediate tables and joins if any.

And also on the right hand side, the UI can display the Unique, Surrogate and Primary Key of all the tables involved in the joins.

More details

This will help on all the joins in the ERP modules.

Oracle users can say that they are using the right joins in the ERP tables.

There are multiple ways in which the joins can be achieved, but the oracle recommended approach in an UI will add a high value addition as a trust on the data retrieval approach.

Original Idea Number: 3ede74126a

Shivakumar Biradar

It will help users to create the desired BIPublisher reports with the right set of joins and conditions, in less time.

Delight on the join trust.

User can create a report with GL, AP, AR, Inventory, OM, Procurement related columns in one report and he will get to know on what are the right set of joins. And if multiple records are observed then he will get to know on the place where the cross join is happening or how it is affecting he measures (multiplied or null).

Sreekanth Mukalla

This would be of great help for developing Custom reports