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.

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

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

%d bloggers like this: