My Oracle Support Banner

Data in W_INVENTORY_MONTHLY_BAL_F contains only one month's data after ETL. How to load previous month's data e.g 3 months data (Doc ID 752271.1)

Last updated on SEPTEMBER 05, 2019

Applies to:

Siebel CRM Analytics - Version 7.9.0 [AA 0724] to [Release V7]
Information in this document applies to any platform.


The requirement is to store data for previous months in the the Inventory Monthly Balance Table(W_INVENTORY_MONTHLY_BAL_F).

Below is the configuration made for Inventory Monthly Balance Table in parameterfileDW.txt file:

PLP_InventoryMonthlyBalance $$GRAIN 'MONTH'
PLP_InventoryDailyBalance_Trim $$KEEP_PERIOD 'MONTH'
PLP_InventoryDailyBalance_Trim $$NUM_OF_PERIOD 3

according to the following documentation:

Oracle Business Intelligence Applications Configuration Guide for Informatica PowerCenter Users > How to Configure the Inventory Monthly Balance

The current behavior is that, in Oracle Business Intelligence Applications Warehouse, the Inventory Monthly Balance Table(W_INVENTORY_MONTHLY_BAL_F) is populated with one month's data i.e Oct 10, 2008 which corresponds to value in the INV_BALANCE_DT_WID column that is populated with 20081010.

When the report "Inventory Key Metrics" from dashboard Inventory-Overview tab, is run, it shows only one month data i.e October, 2008


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.