OraFAQ Forum: Forms » frm-12001 Cannot Create Record group

Home » Developer & Programmer » Forms » frm-12001 Cannot Create Record group

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

frm-12001 Cannot Create Record group [message #158743]

Tue, 14 February 2006 03:17

Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta

Member

HI

I am using forms 6i.
I have a form where I use one LOV and multiple
Record Groups for the same.

Till today I had 6 Record groups.
However now when i wish to add one more Record Group it does not allow.
It says
frm-12001 (Cannot Create the Record Group (Check your Query)

Also if I wish to change the Query for existing record Groups then also the same error comes.
The queries are 100% correct and simple.

however if i change the Query to
"select 1 from dual" it works fine.
Trust me my queries are correct still cannot create or change the Record Groups.

Thks in Advance
Atul P

Report message to a moderator

Re: frm-12001 Cannot Create Record group [message #158756 is a reply to message #158743]

Tue, 14 February 2006 04:22

vban2000
Messages: 207
Registered: March 2005

Senior Member

Hi Atul

No idea at all.. if it work in your privous one, then it should work for any additional one.

Can we see that piece of the code? so to help us into investigating such problem.

Regards
AnDy

Report message to a moderator

Re: frm-12001 Cannot Create Record group [message #158760 is a reply to message #158756]

Tue, 14 February 2006 04:47

Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta

Member

Hi Andy

This is the record Group Query :
-------------------------------------
SELECT GL_SHORT_DESC , GL_CODE
FROM FM_GL_MASTER
WHERE GL_TYPE IN ('CB')
AND NVL(GL_STATUS,'Y') = 'Y'
AND NVL(GL_COMP_CODE,:GLOBAL.COMPANY_CODE) = :GLOBAL.COMPANY_CODE
ORDER BY 2
--------------------------------------
And this exactly Query with "NOT IN" instead of "IN" in
WHERE condition is working u know.

Regards
Atul P

Report message to a moderator

Re: frm-12001 Cannot Create Record group [message #158762 is a reply to message #158743]

Tue, 14 February 2006 04:56

vban2000
Messages: 207
Registered: March 2005

Senior Member

Hi Atul P

Suspecting you should use double single quote ('') instread of one single quote (')

As an example (which I hope it helps..)

-- This is my SQL query
SELECT   ref_desc, ref_code
    FROM REFERENCES
   WHERE ref_type = 'SALE_CAT' AND ref_code = :parameter.p_category
ORDER BY 2

now, to put in the form, this becomes my query

DECLARE
   TEMP    NUMBER;
   rg_id   recordgroup;
BEGIN
   rg_id :=
      CREATE_GROUP_FROM_QUERY ('CGDV$DLRG',
                                  'SELECT REF_DESC, REF_CODE '
                               || 'FROM   REFERENCES '
                               || 'WHERE  REF_TYPE = ''SALE_CAT'' '
                               || 'AND    REF_CODE = '''
                               || :parameter.p_category
                               || ''' '
                               || 'ORDER BY  2'
                              );
   TEMP := POPULATE_GROUP (rg_id);
   POPULATE_LIST ('CTLBLK.CATEGORY', rg_id);
   DELETE_GROUP (rg_id);
END;

Hope this helps...

regards
AnDy

Report message to a moderator

Re: frm-12001 Cannot Create Record group [message #158766 is a reply to message #158762]

Tue, 14 February 2006 05:05

Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta

Member

Hi Andy

Actually I am not creating and populating at runtime.
What I am doing is I am actually making Multiple Record groups in Form at design time.
and at Runtime w.r.t condition i just assign the
Record Group to the LOV.

e.g
------------------------
IF :PARAMETER.P_VOUCHER_TYPE IN ('BPV') THEN SET_LOV_PROPERTY('LOV_GL_CODE',GROUP_NAME,'RG_GL_CODE_BPV');
ELSIF
........
END IF;
------------------------
If no option then may be I will have
to make Record groups with at runtime.

Regards
Atul P

Report message to a moderator

Re: frm-12001 Cannot Create Record group [message #158797 is a reply to message #158743]

Tue, 14 February 2006 08:06

vban2000
Messages: 207
Registered: March 2005

Senior Member

Sorry Atul

My knowledge is limtited (PTY LTD... Wink

)

But I am sure there is a way doing it.. I am sure David (djmartin) knows.. He is very good!

regards
AnDy

Report message to a moderator

Re: frm-12001 Cannot Create Record group [message #158801 is a reply to message #158797]

Tue, 14 February 2006 08:13

Maaher
Messages: 7065
Registered: December 2001

Senior Member

A silly question perhaps, but you did connect as the correct user right? The fact that modifying an existing record group results in the same error is a little bit strange.

MHE

Report message to a moderator

Re: frm-12001 Cannot Create Record group [message #158864 is a reply to message #158801]

Tue, 14 February 2006 16:00

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I agree with Maarten, I think you are signing onto your Oracle database with a userid that does not have the right accesses.

What was the original code and what was the code after you made your changes?

David

Report message to a moderator

Re: frm-12001 Cannot Create Record group [message #158877 is a reply to message #158864]

Tue, 14 February 2006 20:53

Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta

Member

Hi Marteen,Maaher, Andy

I am connected to the database with proper USER Name.
My Original COde for Record Group-Query at Design Time
is

SELECT	GL_SHORT_DESC , GL_CODE
FROM	FM_GL_MASTER
WHERE	GL_TYPE IN ('CB')
AND     NVL(GL_STATUS,'Y')       = 'Y'
AND NVL(GL_COMP_CODE,:GLOBAL.COMPANY_CODE) = :GLOBAL.COMPANY_CODE
ORDER BY  2

Now what I want is to make another record Group with little changes in Query.
I tried to do the same but it gave me the
Error: frm-12001 Cannot Create recordgroup.
SO I assumed soemthing was wrong in my query.
For the same I tried to modify an Existing record group
which was working fine till now.
The query for esixting record group was as above.
In the same query all I tried to change was the
Order by clause replacing 1 with 2.
However it shows me the same error.
It might sound silly to you but thats how it is.
A very very abnormal behaviour.

Rgds
Atul P

Report message to a moderator

Re: frm-12001 Cannot Create Record group [message #158878 is a reply to message #158877]

Tue, 14 February 2006 21:16

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please open a SQL*Plus session to your database using the userid & password you have used for your forms session, and run this query in this new session. Does it work for you?

Do you have write access to the form?

David

Report message to a moderator

Re: frm-12001 Cannot Create Record group - SOLVED [message #158880 is a reply to message #158878]

Tue, 14 February 2006 21:41

Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta

Member

Hi djmartin

Yes the query works in Sql*plus session.
I do have write access to the form.

Howevere I just tried to use the query as

select 'atul',1 from dual;

This way I can make the Recordgroup.
So what I tried to do was write the same sql statement
line by line.
As in adding normal query with no where clause.
It worked
then adding where clause it worked.
then and condition and its working.

I know it might sound sily again but this is how it happened.
anyways Happy that it works.

Is there any Patch which i might need to download and
upgrade my forms version.
I have Forms [32 Bit] Version 6.0.8.8.0 (Production)
using on WIN-XP

Anyways thks for ur support.
trust me it is silly but this is really what happened and how it got solved.

Regards
Atul p

Report message to a moderator

Re: frm-12001 Cannot Create Record group [message #158900 is a reply to message #158743]

Wed, 15 February 2006 00:32

vban2000
Messages: 207
Registered: March 2005

Senior Member

glad it worked.. and a found **strange** BUGs in the Form Builder!

Could it be the OC4J? Sometime ago, I was doing some Math calculation in the Form... However, the result is always wrong? (compare to my manual calculation..). After a very long struggle, I decided to close the OC4J and restart it again. and (magically) the result is correct.. (some kind of bug in OC4J??)

regards
AnDy

Report message to a moderator

Re: frm-12001 Cannot Create Record group [message #184153 is a reply to message #158900]

Tue, 25 July 2006 09:47

Bombi
Messages: 1
Registered: July 2006

Junior Member

I had the same Problem with FRM-12001.

But my querys works, if they are written in the one line without linebreaks. I think this is the Trick! Laughing

Report message to a moderator

Previous Topic:	Connect and Disconnect
Next Topic:	Only one CheckBox should be checked at a time.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:24:58 CDT 2024