Period Column List of Values in Spreadsheet from Currency Rates Manager Is Displayed Opened Period Only (Doc ID 2121427.1)

Last updated on MARCH 29, 2016

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Oracle Web Applications Desktop Integrator - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Period List Of Values(LOV) of create historical rates is different between the Form and Spreadsheet file.

Steps to Reproduce
1.General Ledger Responsibility:
  N)Setup > Currencies > Rates > Historical > Click Period LOV 


  Period LOV
  -------------
  2016-03
  2016-01
  2016-01
  2015-13
  2015-12A
  2015-12

  -> All periods can be searched in the Form

2. General Ledger Responsibility:
  N)Setup > Currencies > Currency Rates Manager > Historical Rates > Select Actions 'Create in Spreadsheet' > Go button
    > Download Spreadsheet file > Click Period column

  Period LOV
  -------------
  2016-01
  2015-13
  2015-12A

  -> Only opened periods can be searched in Spreadsheet file


Current behavior
Period LOV is displayed different values between Historical Rates Form(GLXRTHST) and Spreadsheet file from Currency Rates Manager.
All periods are displayed from Period LOV in Historical Rates Form(GLXRTHST).
Only opened periods are displayed from Period column in Spreadsheet file.

Expected behavior
Period LOV should be displayed all periods in Spreadsheet file from Currency Rates Manager.

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