My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.