Modifying Default Treasury Symbol Cancellation Date Behavior

Posted on 26-Mar-09. Filed under: Uncategorized | Tags: , |

Recently I’ve been doing a little work with converting a large number of Treasury Symbols on my current project into Fed Admin.  I came up with a quick form personalization to change the default cancellation date logic from ’01-OCT-20XX’ to ’30-Sep-20XX’ and I thought I’d share in case it was helpful to anyone else.

Oracle defaults the ’01-Oct’ as the cancellation date out of the box when creating new treasury symbols.  However,  in order for the standard year-end processes to execute properly for cancelled funds (& apply the Cancelled Fund closing logic), the treasury symbols need to have a cancellation date in the same fiscal year that the closing process is being run for. Thus the need for the date to be 30-September.

Here are a few graphics along with a video demonstrating the new action that the personalization provides and how to do it.

image001

image003

image005

image007

Here is the new default logic to paste into the value field:

=CASE WHEN :FV_FACTS_TREASURY_SYMBOLS.TIME_FRAME = ‘NO_YEAR’ THEN NULL

WHEN :FV_FACTS_TREASURY_SYMBOLS.TIME_FRAME = ‘SINGLE’

THEN TO_DATE(’30-SEP’||TO_CHAR(:FV_FACTS_TREASURY_SYMBOLS.ESTABLISHED_FISCAL_YR+5))

WHEN :FV_FACTS_TREASURY_SYMBOLS.TIME_FRAME = ‘MULTIPLE’

THEN TO_DATE(’30-SEP’|| TO_CHAR(:FV_FACTS_TREASURY_SYMBOLS.ESTABLISHED_FISCAL_YR+

:FV_FACTS_TREASURY_SYMBOLS.YEARS_AVAILABLE+4))

ELSE NULL END

To see a short demo of how the new default functionality works and more info on the setup, I put together a video which can be viewed here.

Hope that helps out anyone who has ever been annoyed by having to change the default cancellation dates when creating new treasury symbols.

Advertisements

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: