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 »