How to add DDMMYY and a sequence number for that date in an ACH and Positive Pay file name in Oracle

Hello,

I'm implementing ACHs and Positive Pay with direct transmission with SVB and one of the requirements is to name the files transmitted directly as ACHPMMDDYY## for ACHs and CHKI_DTDMMDD## for Positive Pay.

From SVB:

"ACH Files must adhere to the file-naming convention of ACHPMMDDYY##.

•         ACHP identifies the file as an ACH Transfer transaction file

•         MMDDYY = file date

•         ## = file sequence number for that date

•         For example, the file named ACHP01281401 represents the first ACH transaction file for January 28, 2014

Positive Pay Files must adhere to the file-naming convention of CHKI_DTDMMDD##.

•              CHKI_DTD* identifies the file as Positive Pay / Payee transaction Delimited file