GTT_DEALINC_DEALS Table Cannot Support Value Larger Than 12 Digits; Income Generation Fails for Large Turnover Deals
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
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.
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