My Oracle Support Banner

ADI:Default Format Of Excel Spreadsheet For Journal Entry (Doc ID 259714.1)

Last updated on SEPTEMBER 05, 2019

Applies to:

Oracle Applications Desktop Integrator - Version 11.5.2 to 11.5.9 [Release 11.5]
Information in this document applies to any platform.


 One of the segments in COA is table validated. When you enter a journal and the value for that segment starts with a zero it takes away the zero and you have to unprotect the sheet, change the format of the column and enter the zero in front of the value.

Example: The Value you are entering in Journal worksheet looks like


When in Interface, it looks like this





To view full details, 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 a vibrant support community of peers and Oracle experts.