Latest YouTube Videos
Learn how to install Oracle Database 23ai Free on Windows. This is a great way to explore the features of Oracle 23ai Database.
——————
SQL Harmony allows you to connect to your fusion instance and execute SQL Queries. Check out the igh level features of the tool.
——————
Data Pipeline enables you to orchestrate end to end processes in EPM. Learn how to invoke a Pipeline from Groovy.
——————
Dependent List of Values helps you to control the BI Publisher Report parameters based on value of another parameter while exeucuting the reports.
——————
Learn how to attach a list of values to a BI Publisher report parameter. This helps the user to select from a pre-defined list rather than type the value in.
——————
Data Pipeline enables you to perform cross pod file operations easily. There are in-built job types available to move, copy, unzip, rename and delete files.
——————
Latest Blogs
Check out the latest blogs on Oracle ERP, EPM and other related topics.
-
XML Bursting in Oracle Apps
XML Bursting XML Bursting can be used to split one XML File into multiple XML Blocks. These individual xml blocks can then be used to generate reports and even use different layouts. You can also deliver the reports to multiple destinations based on a XML Element. The steps involved are…
-
Create XML Using SQL Statements
In this post we will take a look at how to create XML using SQL Statements. The following functions will be used to generate the output in XML Format. XMLElement () XMLForest () XMLSequence () XMLAgg () The combination of the above three functions will let us create some very fancy…
-
Create XML Using DBMS_XMLDOM
DBMS_XMLDOM The DBMS_XMLDOM package is used to access XMLType objects, and implements the Document Object Model (DOM), an application programming interface for HTML and XML documents. The Document Object Model (DOM) is an application programming interface (API) for HTML and XML documents. It defines the logical structure of documents, and the manner…
-
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…
-
webMethods – Add Custom soapHeader in soapRequest
Lot of time webservice host applications don’t define soapHeader specifications in WSDL. However applications require consumers (in this case wM) to send values at soapHeaders level. This post describes two different methods on how to add custom header to WSD consumer request. There are two ways which I tested to get job done.…
-
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…
-
webMethods – Adding UsernameToken to soapHeaders with Pre8.2 Compatibility
In this post we will see how to setup UsernameToken in webMethods webservice consumer connector. We will be covering only username/password based WS-Security. There are other ways also to secure consumer like signature, encryption using certificates. Username Token is a standard WS-Security feature which is not associated in webservice consumer…
-
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…
-
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…
-
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…