FRM-41072 Cannot create group error in Custom.pll
I am trying to change for the custom Request Group using CUSTOM.pll (Forms 10g) and getting a FRM-41072: Cannot create Group DNR_LOC_WITH_COLL. The query is pretty simple, cannot find a problem. Help please.
v_rg_query := 'SELECT site_uses.location location
,loc.address1 ADDRESS
, decode(site_uses.primary_flag,
''Y'', ''Yes'',
''No'') primary
,loc.address1 address1
,loc.address2
,loc.address3 address3
,site_uses.site_use_id site_use_id
,site_uses.cust_acct_site_id address_id
,site_uses.bill_to_site_use_id bill_to_site_use_id
,site_uses.primary_salesrep_id primary_salesrep_id