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 FEBRUARY 15, 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) 150 2015 / 07 CO 15000039 555.040 KWD 6740
OBI (DW) 150 2015 / 07 CO 15000039 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.