My Oracle Support Banner

E1: DB: Why does Databrowser not Display Negative Sign on Some Negative Amounts (Doc ID 2085090.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 to 9.2 [Release 9.1 to 9.2]
Information in this document applies to any platform.

Goal

Discover why there is a discrepancy between the displayed values in some fields of Databrowser with UTB and other SQL Tools.

For example When you browse (F43090) Supplier/Item Relationships Table with the Databrowser the Average Lead Time (ALTD) Field sometimes has negative values stored in it, but the negative values display without a sign. It can be queried for values < 0 and return records, but they display without a minus sign.

Solution

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.