Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Convert output data

edited Apr 26, 2016 5:08AM in Design Tools & Output Technologies - JDE1 (MOSC) 5 commentsAnswered


I created an ube in jde 9.1. The column item number although its 25 char long field in jde, there are some records in this columns that are stored in numeric.When the report is run in csv we notice that the field has some strange character like 9.21E+..

I researched and found that this is how the excel cells are designed "Default number format in Excel  is General  therefore you can display up to 11 digits in a cell." Is there any workaround available to get the full value of item number other than prefixing it with some special character?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center