How to create Master Detail Report in Oracle Fusion Business Intelligence using single dataset

 New --> Data Model --> Properties --> Data set --> Diagram --> Click on Plus icon

SQL Query

Name: cust_master_detail_qry

Data Source: ApplicationDB_FSCM

Type of SQL: Standard SQL

SQL QUERY:

select rctla.interface_line_attribute1 so, rctla.customer_trx_line_id, rctla.customer_trx_id cust_id, rctla.line_number, rctla.inventory_item_id, rcta.trx_number, rcta.customer_trx_id  from a_customer_trx_lines_all rctla, ra_customer_trx_all rcta where rctla.customer_trx_id = cta.customer_trx_id order by 1 asc

Press Button --> OK

Now we will view the data either query is returning any data or not.

Click on Tab --> Data --> View --> Table View 

Now we will change default display name to custom display name

Click on Tab --> Structure

Change display name as

TRX_NUMBER --> Transaction No.

CUSTOMER_TRX_ID --> Customer Transaction Id

INTERFACE_LINE_ATTRIBUTE1 --> SO

CUSTOMER_TRX_LINE_ID --> Customer Transaction Line Id

CUSTOMER_TRX_ID --> Customer Transaction Id

LINE_NUMBER --> Line Code

INVENTORY_ITEM_ID --> Inventory Item Code

Press Button --> Save

Name: Cusomter_Master_Detail_single_dataset_DM

Press Button --> OK

G_1 --> trx_customer --> click on settings icon --> Group By

Any additional column we will drag and drop in grouped section.

Now we will drag and drop the columns --> Customer_trx_id 

Click on Button --> Save as Sample Data

New Window will appear --> Press Button --> OK

Now we will create report

Click on Button --> Create Report --> New Dialog will display --> Press Button --> Cancel 

New Window will appear to confirm --> Press button  --> OK

Click on button Search to Get required Data Model --> Cusomter_Master_Detail_single_dataset_DM

Now Press Button --> Generate RTF Template

Name: MyBusiness_Temp

Press Button --> Generate

Press Button --> Save

Name: Cusomter_Master_detail_Layout 

Press Button --> OK

Click on Button --> View Report

Now we will download the template and will edit as per required format

New window will appear --> Press hyper link --> Edit

It will download the template

Open the template in MS word and edit it as you required.

Now go back to template

Press Button Delete Template as we need to upload the altered RTF file

Catalog --> Cusomter_Master_detail_Layout --> Edit

New Window will appear --> Click on button --> Upload

New Dialog Box will appear and fill the below details

Layout Name: MyBusiness_Cust_Temp

Click on Button --> Choose File 

Type: RTF Template

Locale: English

Press Button --> Upload

Press Button --> Save

Now let us check the changes whether it impacted or not

Press Button -->  View Report.

That is it.