ReSA Restriction Field In The UI Does Not Allow The Correct Value For The Store_Hierarchy.AREA Field (Doc ID 2915161.1)

Last updated on DECEMBER 15, 2022

Applies to:

Symptoms

The Area field within the STORE_HIERARCHY table allows for 10 characters. The retailer has an area value of 5 digits. when trying to add the restriction for an area with > 4 characters, an error occurs.

ERROR
-----------------------
"The length of 65000 is too long. For this field, you are limited to 4 precision length and 0 scale length.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) Go into ReSA
2) Go to Tasks>Create Total Definition
3) Enter total Overview data – Total Category – Sales, Miscellaneous Total, Raw Data
4) Enter total characteristics – No, No, No, Yes, Sum, Store, Yes, No, Display group – 1
5) Add Realms –V V_SA_TRAN_ITEM_NET_ROLLED, SA_TRAN_ITEM, SA_TRAN_HEAD, STORE_HIERARCHY, SA_STORE_DAY
6) Joins are added automatically
7) Enter Parameters

Realm Alias Parameter Name Parameter Alias
Sa_Store_Day STORE_DAY_SEQ_NO Store_Day_Seq_No
Sa_Tran_Head STATUS Status
Sa_Tran_Head ERROR_IND th_Error_Ind
Sa_Tran_Head REGISTER Register
Sa_Tran_Item ERROR_IND ti.Error_Ind
Sa_Tran_Item ITEM Item
Sa_Tran_Item ITEM_STATUS Item_Status
Sa_Tran_Item ITEM_TYPE Item_Type
V_Sa_Tran_Item_Net_Rolled NET_RETAIL Net_Retail
Store_Hierarchy AREA Area

8) Enter Parameter to be totaled - V_Sa_Tran_Item_Net_Rolled. NET_RETAIL
9) Enter Restrict Results by Constant Values

Parameter Operator Constant
Name Value
Status = P
th_Error_Ind = N
ti.Error_Ind = N
Item_Type in 'ITEM','REF'
Item_Status in 'S','R'
Area >= 65003

10) Error appears

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.