My Oracle Support Banner

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 NOVEMBER 21, 2019

Applies to:

Oracle Retail Merchandising System - Version 11.0.6 and later
Information in this document applies to any platform.


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.




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.