R12: Journal Wizard Unable to Switch Between Spreadsheet Documents (Doc ID 1345081.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle General Ledger - Version: 12.0.0 and later   [Release: 12.0 and later ]
Oracle Web Applications Desktop Integrator - Version: 12.0.0 to 12.1.3   [Release: 12 to 12.1]
Information in this document applies to any platform.
General Ledger - Journal wizard
Web applications Desktop Integrator - Create Journal

Symptoms

Using Excel 2010 is not possible to switch between 2 ADI spreadsheets in the following conditions:
  1. Launch Journal wizard from General Ledger
  2. Opens webADI spreadsheet, enter data and save that Spreadsheet as Doc-1 on desktop .
  3. Log off applications and log back in Launch Journal wizard again
  4. Create a new spreadsheet, now open the saved Doc-1 from step 2 from desktop copy the data and  paste in the current Spreadsheet .
  5. After step 4 if If any of the options like the flexfield window, period or any other header information is accessed in the current Spreadsheet, after that only the current Spreadsheet is accessible and you are unable to access the Excel Doc-1 using the Mouse .
    At the bottom of the Main PC window, it shows the 2 Excel icons with the 2 spreadsheets but nothing happens when the mouse is used to access the Doc-1 .

Changes

Upgrade to Excel 2010

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