My Oracle Support Banner

"FRM-41072 Cannot create group APPCORE_RG_QUERY" Error In Forms Personalizations Builtin Create Group From Query When SQL Statement Exceeds 2000 Characters (Doc ID 1532518.1)

Last updated on OCTOBER 14, 2023

Applies to:

Oracle Application Object Library - Version to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.


On :  and 12.1 version, Transactions Workbench - Form Personalizations Related

Attempting to create a Form Personalization for Transactions Workbench from Oracle Receivables and entering a SQL statement in 'Argument' field for Create Record Group from Query builtin type.

If the length of the SQL statement is more than 2000 characters, after pressing 'Apply now' button, the following error is returned:
"FRM-41072 Cannot create group APPCORE_RG_QUERY"
If the length of the SQL statement in 'Argument' field is below 2000 characters.

If the record group is created successfully.

Note:  This applies to other forms where the SQL statement exceeds 2000 characters.
"FRM-41072 Cannot create group APPCORE_RG_QUERY"

The issue can be reproduced at will with the following steps:
1.  Create a builtin type from personalizations action.
2.  Select 'Create Record Group from Query' builtin type.
3.  Enter a SQL statement with a length larger than 2000 characters in the 'Argument' field.
4.  It returns the error: "FRM-41072 Cannot create group APPCORE_RG_QUERY" error.




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.