OBIA 11g W_PRODUCT_XACT_F.BASE_QTY Incorrectly Populated (Doc ID 1605683.1)

Last updated on JULY 17, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 to 11.1.1.7.1 [Release 11g]
Information in this document applies to any platform.

Symptoms

In 11g W_PRODUCT_XACT_F.BASE_QTY is mapping from W_PRODUCT_LOT_XACT_F.BASE_QTY

When a product transaction is split across multiple lots the BASE_QTY is incorrectly aggregated into W_PRODUCT_XACT_F to give a higher number.

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