-- Oracle Fusion Video Series : Video 15
#SQL
#PLSQL
#Oracle
#ORACLEAPPS
#OracelFusion
#TechTalkswithNaresh
#Naresh
#R12
#EBSConsultant
Join Our Telegram Group:
t.me/techtalks...
FOLLOW US :
============
KZitem : / techtalkwithnaresh
For More details Contact Us:
Email: nareshtech21@gmail.com
--------------------------------------------------------------------------------------------------------------------------------------------------------------
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 nareshtech21@gmail.com. Please do like, share and Subscribe the channel to get latest videos.
------------------------------------------------------------------------------------------------------------------------------------------------------------------
STEPS:
Oracle Fusion working with Table Value Set.
1. Create 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 = :segment1
2. Create List of Value(LOV/Value set).
3. Assign LOV to Parameter
4. Save the Data Model and Sample data.
5. Create the Layout and Template.
6. Run the Report.
Негізгі бет Oracle Fusion #15: Working with Dependent List of Values (LOV)
Пікірлер: 15