Dynamic Destination File Name Using Date Expression Doesn't Work For SFTP Delivery Option

(Doc ID 2413727.1)

Last updated on JUNE 21, 2018

Applies to:

BI Publisher (formerly XML Publisher) - Version 12c and later
Information in this document applies to any platform.

Symptoms

On : OACS environment Oracle BI Publisher 12.2.4.1.0 (build:20180215.1950).


ACTUAL BEHAVIOR
----------------------

Dynamic destination file name using date expression doesn't work for SFTP delivery option.
Instead of creating file name with dynamic date value, file gets created with name 'LeadStatus_%y%m%d.csv'.


EXPECTED BEHAVIOR
-------------------------

When Dynamic destination file name with date expression option is used, the resultant file should
be with actual date value instead of '%y%m%d' expressions.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Define schedule job with file name with dynamic option with date expression.
2. Upon completion, verify the file in the destination and find that file created with 'LeadStatus_%y%m%d.csv' name
  instead of actual date appended to file name.

WHAT IS WORKING?
-----------------------------

This method used to work in 11g and 12c (12.2.1.2.0). But does not work in release 12.2.4.x



Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms