EPM Data Exchange – Dynamic File Naming in File Operations (MMM_YYYY) Limitation

Summary:

I am working with EPM Data Exchange pipelines using File Operations (copy) and observed a limitation around dynamic file name generation.

Content (please ensure you mask any confidential information):

Requirement

Generate monthly output file names dynamically in the following format:

TGT_TEST_MMM_YYYY.TXT

Example:

TGT_TEST_Jun_2026.TXT

Observed Behavior

The Target File Name property in File Operation appears to accept only literal values.

Attempts made:

1. Expression syntax:

#formatDate($CURRENT_DATE,'MMM_yyyy')#

1. SQL-style expression:

'TGT_TEST_' || to_char(CURRENT_DATE,'Mon_YYYY') || '.TXT'

1. Parameter substitution:

${p_file_name}

:p_file_name

1. Shell-style command:

TGT_TEST_$(date +%b_%Y).TXT