Oracle Fusion #12: Use of Aggregate Functions (Count, Min, Max, Avg, Sum, First, Last) in BIP Report

Описание: -- Oracle Fusion Video Series : Video 12

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

Join Our Telegram Group:
https://t.me/techtalkswithnaresh

FOLLOW US :
============
YouTube :    / techtalkwithnaresh  

For More details Contact Us:

Email: [email protected]
--------------------------------------------------------------------------------------------------------------------------------------------------------------

In this Playlist I had uploaded all the videos which help you to learn the Oracle Fusion BI Reports and Oracle Fusion OTBI Reports which will help you to improve your skills. If you have any doubt's regarding any of the uploaded videos you can write in comment section. If you need more videos on other topics or training in Oracle fusion you can reach out me at [email protected]. Please do like, share and Subscribe the channel to get latest videos.
---------------------------------------------------------------------------------------------------------------------------
STEPS:
1. Create the Data Model.
Query:
SELECT
a.po_header_id Po_header,
b.po_header_id,
b.po_line_id,
b.item_id,
b.unit_price,
b.quantity,
b.base_unit_price
FROM
po_headers_all a,
po_lines_all b
WHERE
a.po_header_id = b.po_header_id
AND a.segment1 = '162352';

2. Drag the Element from Group to Group Level Function. Sequence of Operation is,
SUM
MAX
MIN
COUNT
FIRST
LAST
AVG

3. Create Layout and Template.

4. Run The report.