SLOW INCREMENTAL DATA LOAD IN 12.2.V6 ONT SANDBOX (Doc ID 2202020.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Endeca Integration (v5 and lower)

Endeca OM dashboard not showing updated data

When updating the Order and run the incremental load successfully we are unable to see the updates in OM Endeca dashboard.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Order Number# 11444561
1) We have order with 1779.86 amount and quantity as 2.

2) Now we changed/updated the order quantity as 3 so the order amount has become 2669.79

3) We ran the incremental load again, which successfully completed.

4) But OM endeca dashboard result table still showing 1779.86 amount and quantity as 2 but if I drill down on order number its showing appropriately.

Dashboard with old quantity and amounts:

5) Drill down on Order#:

order quantity as 3, order amount has become 2669.79

Cause

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