Oracle Fusion #23: Generation of OTBI Reports and Working with compound layout (Title, Logo, layout)

-- Oracle Fusion Video Series : Video 23

#SQL
#PLSQL
#Oracle
#ORACLEAPPS
#OracelFusion
#TechTalkswithNaresh
#Naresh
#R12
#EBSConsultant

Join Our Telegram Group:

FOLLOW US :
============

For More details Contact Us:

-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------

1. Create the report: Payable Invoice Transaction Real Time:
List of Columns:
Business Unit:
1. Business unit name
Supplier:
2. Supplier
3. Supplier Number
Supplier Site:
4. Supplier Site
Invoice Details: General Information:
5. Invoice number
6. Invoice Id
7. Invoice Creation Date
Invoice Details: Invoice Amount:
8. Invoice amount
9. Total tax changed
10. Discountable Amount
11. Invoice Currency
Invoice Lines: Invoice Line Amount:
12. Invoice line Amount
13. Tax amount (Line)
14. Original Amount – This Is (Invoice Line amount – Tax amount)

2. Add the filter on Business group column for (US1 Business Group).
3. Add the filter on supplier and select 2 suppliers.
4. Changing the Compound layout name(Rename Compound layout field).
Click on edit at title level and change.
5. Working with titles and Logo.
Click on edit at title level and change.

[rajuthangellapally]

Hi sir how to create from date and to date parameters to get invoices details in OTBI report. Which is using two subject areas