Category: Oracle Apps Technical
-
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…
-
Triggers in XML Data Template
Today I wanted to show you how to define triggers in XML Data Template. This is in continuation to my blog on generating XML Report from XML Data Template. Check the same here. So here is my requirement: Populate a temporary table with the data based on the parameters passed to the Concurrent Program Fetch…