My Oracle Support Banner

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

Last updated on JANUARY 31, 2020

Applies to:

Oracle General Ledger - Version 12.0.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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
 Still Have Questions?


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.