Technology Stack - EBS (MOSC)

MOSC Banner

FRM-41072 Cannot create group error in Custom.pll

edited Aug 20, 2021 11:05AM in Technology Stack - EBS (MOSC) 19 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center