GTT_DEALINC_DEALS Table Cannot Support Value Larger Than 12 Digits; Income Generation Fails for Large Turnover Deals (Doc ID 1396789.1)

Last updated on APRIL 04, 2017

Applies to:

Oracle Retail Merchandising System - Version 11.0.6 and later
Information in this document applies to any platform.
Checked for Relevance on 19-May-2014

Symptoms

GTT_DEALINC_DEALS table cannot support the value larger than 12 digits.

Column precision for GTT_DEALINC_DEALS.ACT_FOR_TURNOVER_TOTAL is not big enough to hold the accumulated turnover of some large deals.  It is a NUMBER(12,4) field, while the column precision for DEAL_ACTUALS_FORECAST.ACTUAL_FORECAST_TURNOVER, from which the GTT gets populated in dealinc, is a NUMBER(20,4) field.

Hence, larger deal turnovers are failing.

Steps to Reproduce:
1.  Create a deal.
2.  Run deal batches.
3.  After passing deal active date, create a PO with TOTAL_COST values greater than 12 digits.
4.  Receive PO.
5.  Ensure that there is a record in TRAN_DATA.
6.  Run all the batches until dealinc and notice that the thread is not processed.

Changes

 

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