Category: Oracle Apps
-
Password Protect PDF Output
In this post, we will explore how we can password protect PDF output generated by a Oracle XML Publisher Report. Check out my earlier posts on XML Publisher for more details on XML Data Template, RTF Template, Triggers etc. Now lets take a look at what we are planning to build today. You can download…
-
Submit XML Publisher Report from PL/SQL
Today, let us look at how we can submit XML Publisher report from PL/SQL. Now you might think that I already know how to use “fnd_request.submit_request” to submit a concurrent program. Right? Well, things are a little different when it comes to XML Publisher Report / Concurrent Program. First, let us see what happens when you submit a XML…
-
Oracle BI Publisher Desktop Tool
Today we will take a look at the Oracle BI Publisher Desktop Tool. This is one tool that I love. If you are working on XML Publisher Reports, this is a must have tool. This tool allows you to test your RTF Template on your local system (desktop / laptop) and make any changes necessary before uploading…
-
XML Publisher Report from XML Data Template – Part 3
This is the 3rd in a series of blogs on XML Publisher Reports from XML Data Template. Today we are going to look at a few nifty tricks that we can achieve using the XML Data Template. Also check out the Part 1 and Part 2 of this blog to get more details. Group under a Group in the…
-
Interesting SQL and PLSQL Tips and Tricks
This blog covers some interesting SQL and PLSQL Tips and Tricks. I will try to include some interesting functions and plsql solutions to some interesting requirements. Find Last Day of the Month SQL Function :- LAST_DAY() SELECT LAST_DAY(SYSDATE) FROM DUAL Find First Day of the Current Month SQL Function:- Combination of LAST_DAY () and ADD_MONTHS…