My Oracle Support Banner

Cannot Activate CFAs - "Error ORA-06502: PL/SQL: numeric or value error" (Doc ID 2909543.1)

Last updated on NOVEMBER 17, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 to 19.3 [Release 19.3]
Information in this document applies to any platform.


All attempts to activate CFAs failed with the following message: 'Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small returned by program unit CFA_GEN_SQL.GEN_VIEW_GRP_SET.'

Steps To Recreate:
1 - Go to Application Administration > Custom Flex Attributes, the Custom Flex Attributes page opens
2 - At the Custom Flex Attributes page, select / fill in the following fields:
2.1 Application Table -> ITEM_MASTER
2.2 Group Set -> Primary Packaging
3 - Push button 'Display Attributes'
4 - Push button 'Activate'
5 - Error Msg is displayed


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.