My Oracle Support Banner

OBIA 11g: Invoice Amount Is Not Matching between Source (JDE) and Data Warehouse (JDE Decimal Shift Issue) (Doc ID 2192172.1)

Last updated on DECEMBER 11, 2019

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


On Oracle Business Intelligence Applications Consumer version,

In OBI reports (Sales - Invoice Lines Subject Area), Invoice amount is not matching with Source - JDE.


The following table shows the Invoice Amount observed in Source & Data Warehouse -

Application Company Month Order Type Invoice Number Invoice Amount (Foreign Currency) Invoice Amount (in AED)
JDE (Source) <Company Id> 2015 / 07 CO <Invoice Number> 555.040 KWD 6740
OBI (DW) <Company Id> 2015 / 07 CO <Invoice Number> 5550.40 KWD 67400


Environment Details:

OBIA Version:

Source: JD Edwards Version 9.1.

Modules: Finance, Procurement & Spend, Supply Chain & Order Management. 




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.