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 03, 2019
Applies to:Business Intelligence Applications Consumer - Version 188.8.131.52.2 and later
Information in this document applies to any platform.
On Oracle Business Intelligence Applications Consumer 184.108.40.206.2 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|
OBIA Version: 220.127.116.11.2.
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