Thursday, January 27, 2011 4 comments

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>


    Friday, January 14, 2011 0 comments

    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;