Attribute set with value xxx for AAA_c in OpportunityAM.oracle_apps_sales_opptyMgmt_opportunities_opportunityService_applicationModule_OpportunityAM.Opportunity has invalid precision/scale (Doc ID 1680011.1)

Last updated on JANUARY 27, 2015

Applies to:

Oracle Fusion Opportunity Management - Version 11.1.7.0.0 and later
Oracle Fusion Opportunity Management Cloud Service - Version 11.1.7.0.0 and later
Oracle Fusion CRM Application Composer Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms


The following issue happens with a custom Percentage type field in the Opportunity page

When attempting to enter value like 29 into this field the value changes to 28.99% and displays an error



ERROR

"Error
  Attribute set with value 0.29 for testPercentageField_c in OpportunityAM.oracle_apps_sales_opptyMgmt_opportunities_opportunityService_applicationModule_OpportunityAM.Opportunity has invalid precision/scale"




STEPS TO REPRODUCE

1. login to applications
2. Navigator > Tools > Application Composer > Sales > Opportunities > Fields > Custom >
create new custom field - Type = Percentage
Name = testPercentageField
Decimal Places = 3
save the field

3. Navigator > Tools > Application Composer > Sales > Opportunities > Pages > Detailed Summary section >
add this field to the detailed summary section


4. now go to Navigator > Sales > Opportunities > create a new or open an existing opportunity >
the "testPercentageField" is currently blank

5. enter some value like following, for some values it is allowed normally, for couple of values this gives an error

 

type in value = 17, tab out, value changes as 17%
type in value = 28, tab out, value changes as 28.000000000%, and error message on the field
  "Error
  Attribute set with value 0.28 for testPercentageField_c in OpportunityAM.oracle_apps_sales_opptyMgmt_opportunities_opportunityService_applicationModule_OpportunityAM.Opportunity has invalid precision/scale"
type in value = 29, tab out, value changes as 28.999999999%, and error message
  "Error
  Attribute set with value 0.29 for testPercentageField_c in OpportunityAM.oracle_apps_sales_opptyMgmt_opportunities_opportunityService_applicationModule_OpportunityAM.Opportunity has invalid precision/scale"
type in value = 889 tab out, value changes as 889%
type in value = 889.9, tab out, value changes as 889.899999999% and error message
  "Error
  Attribute set with value 8.899 for testPercentageField_c in OpportunityAM.oracle_apps_sales_opptyMgmt_opportunities_opportunityService_applicationModule_OpportunityAM.Opportunity has invalid precision/scale"
type in value = 899.9, tab out, value changes as 899.900000000% and error message
  "Error
  Attribute set with value 8.999 for testPercentageField_c in OpportunityAM.oracle_apps_sales_opptyMgmt_opportunities_opportunityService_applicationModule_OpportunityAM.Opportunity has invalid precision/scale"
type in value = 886.9, tab out, value changes as 886.9%

 














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