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 MARCH 08, 2017

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.