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 03, 2019

Applies to:

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

Symptoms

On Oracle Business Intelligence Applications Consumer 11.1.1.9.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

 

 

 

 

 

 

 

Environment Details:

OBIA Version: 11.1.1.9.2.

Source: JD Edwards Version 9.1.

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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