BI Publisher (MOSC)

MOSC Banner

Date math in NACHA rtf for output to etext file

edited Jun 4, 2012 10:49AM in BI Publisher (MOSC) 3 commentsAnswered
We are using IBYDE_N1US_en.rtf template and have modified it to our bank's specs.  We are using position 70 in record 5 as our "Settlement" date.  Our policy is to make that date 1 day past the payment date.  The following code has worked fine until May 31, 2012 when the output should have been 120601 (June 1, 2012.)  However it is 201205 in the output.  The code works fine in Toad or sqlplus.  What's wrong with this: DECODE(substr(to_char(OutboundPayment/PaymentDate+1,’DY’),1,1),’S’, OutboundPayment/PaymentDate+3, OutboundPayment/PaymentDate+1)?  Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center