BI Publisher: Formatting Date

We can format dates in BI Publishes in the following three different ways,

1. Formatting Date using Microsoft Word’s native date format mask.
2. Formatting Date using Oracle’s format-date function.
3. Formatting Date using Oracle’s abstract date format masks.
4. Format with Calendar.

Lets me now explain little details about the above three ways, and below is the XML I am going to use in the below examples,
<ROWSET>
    <NORMAL_DATE>2011-01-26</NORMAL_DATE>
    <DATE_UTC>2011-01-26T18:00:00-08:00</DATE_UTC>
    <DATE_TEXT>26/Jan/2011</DATE_TEXT>
</ROWSET>

Read more »

OAF: Error testing toolbox.jws

Today I connect my Jdeveloper 10.1.3.3.0.3 to a R12.0.6 instance and tried to test the connectivity using toolbox.jws from myproject folder.

But unfortunately I got the error oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.lang.NullPointerException;

Read more »

BI Publisher: Conditional Formatting

Conditional formatting can be used in the layout builder for various scenarios. Some of the scenario I could think of is,
1. Display/hide layout regions based on condition.
2. Display/hide boilerplate text based on condition.
3. Apply visual attributes based on condition.
4. Hide table row or column based on condition.

In the below paragraphs we will see how above scenarios can he achieved in BI Publisher.

Read more »

How-TO: Get XML file for AP Check Print Program

Here in this post I would like to tell my way of getting the XML for a Format Payment Instruction Program or other words AP Check Print Program.

For every new Format Payment Instruction program run, the XML is getting stored in IBY_TRXN_DOCUMENTS table (at least in R12.0.6). We need to either query this table and get the last created record column DOCUMENT to get the XML or if you know the payment instruction ID, then you can query by payment instruction ID.

Read more »

How-To: Configure New Font On BI Desktop Publisher

In most of the projects we will come across building a report having Barcode or MICR font.

So once you install your new font under Windows/Fonts/ directory you will still not be seeing that font when you preview PDF output.

What to do in that case?
Here are the steps to follow on installing new font on your PC/Laptop.

Read more »