Web ADI Excel Template, After Unprotecting Sheet, Does Not Retain "text" Cell Format (Doc ID 1586829.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 11.5.10.2 version, WebADI Templates

ACTUAL BEHAVIOR
---------------
AFter modifying the Excel Layout for General Ledger-Journals, Functional Actuals - Single by adding additional fields at header and an additional field at line levels, the excel template behavior has changed. After unprotecting the worksheet, the cell format does not retain its TEXT format, but changes all numeric characters to number format.
For instance, entering 003 becomes 3.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. After modifying the Excel Layout for General Ledger-Journals, Functional Actuals - Single by adding additional fields at header and an additional field at line levels, the excel template behavior has changed.
2. The earlier template in use did not include Journal Header or Line Description, and Oracle created Header information was defaulted in upon import.
After import, the accountants had to manually update both Header and Line descriptive fields.
Since the new, revised template converts numeric characters to numbers and manually setting the excel cell formats is somehow overriden,
the accountants are forced to use the earlier template.



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