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