Oracle Fusion #20: Print Bar-code In BIP Reports
7.1 هزار بار بازدید -
4 سال پیش
-
-- Oracle Fusion Video Series
-- Oracle Fusion Video Series : Video 20
#SQL
#PLSQL
#Oracle
#ORACLEAPPS
#OracelFusion
#TechTalkswithNaresh
#Naresh
#R12
#EBSConsultant
Join Our Telegram Group:
t.me/techtalkswithnaresh
FOLLOW US :
============
YouTube : youtube.com/c/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.
-------------------------------------------------------------------------------------------------------------------------
1. Create the data Model:
Query:
SELECT
a.po_header_id "PO Header",
b.po_header_id "PO Header Id",
b.po_line_id "PO Line Id",
b.item_id "Item ID",
b.unit_price "Unit Price",
b.quantity "Quantity",
b.base_unit_price "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. Generate the Template.
3. Download the .tft file.
4. Download the .rtf file(Teplate).
5. Change the Font format to BC 3of9 in template.
6. Go to Administration -- Manage BI Publisher -- Font Mappings
7. Upload the .tft file.
8. Add the Font Mappings, give Target Font Type = True Type always.
9. Run the report and check the output.
4 سال پیش
در تاریخ 1399/06/05 منتشر شده
است.
7,152
بـار بازدید شده