0 Replies Latest reply on Jan 3, 2019 10:26 PM by Salazkin Ann

    FRM-41072 Cannot create group error in Custom.pll

    Salazkin Ann

      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

             ,loc.location_id location_id

             ,loc.state state

             ,loc.country country

             ,loc.postal_code postal_code

             ,site_uses.territory_id territory_id

             ,''Bill To'' business_purpose

      from hz_cust_acct_sites_all acct_site,

           hz_party_sites party_site,

           hz_locations loc,

           hz_cust_site_uses_all site_uses,

           fnd_territories_vl t  

      where acct_site.party_site_id = party_site.party_site_id

        and loc.location_id = party_site.location_id

        and acct_site.cust_acct_site_id = site_uses.cust_acct_site_id

        and loc.country = t.territory_code

        and site_uses.site_use_code=''BILL_TO''

        and acct_site.cust_account_id=26137 and site_uses.site_use_code=''BILL_TO''

         and site_uses.status=''A''

         and acct_site.status=''A''

         and site_uses.location = 79639';

       

      I ran this query in TOAD just fine (using just single quotes)