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

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