OraFAQ Forum: Forms » FRM-30049: Unable to build column mapping.

Home » Developer & Programmer » Forms » FRM-30049: Unable to build column mapping.

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

FRM-30049: Unable to build column mapping. [message #349507]

Mon, 22 September 2008 02:07

Shevnan
Messages: 22
Registered: September 2008

Junior Member

Hi,
I migrated a form from 6i to 10g successfully and when tried to compile i am getting the following error

Column Mapping ACTVTY_CD
FRM-30049: Unable to build column mapping.
LOV LV_TRANS_ACTVTY_LIST
Form: NP26010F
FRM-30085: Unable to adjust form for output.

I saw the record group which had no query initially so i gave
"select 'x a,'y'b,'z' c from dual" ,alos i ensured that the column mapping property of the LOV is set accordingly.Still getting the same error.

Please help me and thank in advance

Report message to a moderator

Re: FRM-30049: Unable to build column mapping. [message #349547 is a reply to message #349507]

Mon, 22 September 2008 03:17

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This

Quote:

"select 'x a,'y'b,'z' c from dual"

is an invalid query. So, for the beginning, show us what you really did (if you expect some help).

Otherwise, delete both Record Group and its List of Values objects and create new ones from scratch. Make sure you do it properly.

Report message to a moderator

Re: FRM-30049: Unable to build column mapping. [message #349579 is a reply to message #349547]

Mon, 22 September 2008 04:55

Shevnan
Messages: 22
Registered: September 2008

Junior Member

Thanks for your timely reply.

Actually in the record group we couldn't find any query and we got the FRM-30049 error.We thought that it requires some query in the record group thats why we added a dummy query. Razz

Please help me how to bypass the error.

Report message to a moderator

Re: FRM-30049: Unable to build column mapping. [message #349607 is a reply to message #349579]

Mon, 22 September 2008 06:18

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That's what I am saying: your "dummy" query is invalid:

SQL> select 'x a,'y'b,'z' c from dual;
ERROR:
ORA-01756: quoted string not properly terminated


SQL>

If you don't need this list of values (and its record group), DELETE THEM! It will, hopefully, eliminate the error. (Don't forget to remove LoV from data block item, if Forms wouldn't do it automatically).

Report message to a moderator

Re: FRM-30049: Unable to build column mapping. [message #349612 is a reply to message #349607]

Mon, 22 September 2008 06:25

Shevnan
Messages: 22
Registered: September 2008

Junior Member

Boss while printing there we placed wrongly.Ok ignore them.Even the query is not placed in the record group we are getting the same error.Please let me know the root cause of that as we need to have the record group and LOV.

Report message to a moderator

Re: FRM-30049: Unable to build column mapping. [message #349616 is a reply to message #349612]

Mon, 22 September 2008 06:40

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I still think that the best option you have is to save record group's query (if possible), delete all objects related to this LoV and rewrite it from scratch. I believe you'll do it much faster than fixing something you don't even know what it is.

The root cause? According to Oracle

Quote:

FRM-30049: Unable to build column mapping.

Cause:��Reference to record group columns within the LOV object cannot be found.

Action:��Check the column names specified within the LOV object

Report message to a moderator

Re: FRM-30049: Unable to build column mapping. [message #349618 is a reply to message #349616]

Mon, 22 September 2008 06:42

Shevnan
Messages: 22
Registered: September 2008

Junior Member

I resolved it as i did some work around.THe problem was with the column and LOV to which it was mapped and not the record group anyhow thanks for spending your valuable time in it.Have a nice day Razz

Report message to a moderator

Re: FRM-30049: Unable to build column mapping. [message #349625 is a reply to message #349618]

Mon, 22 September 2008 07:19

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Even better! I'm glad you have solved the problem!

Report message to a moderator

Previous Topic:	key-delrec
Next Topic:	Enabling/Disabling checkboxes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 17:01:56 CST 2024