Home » Developer & Programmer » Forms » FRM-30049: Unable to build column mapping.
FRM-30049: Unable to build column mapping. [message #349507] Mon, 22 September 2008 02:07 Go to next message
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
Re: FRM-30049: Unable to build column mapping. [message #349547 is a reply to message #349507] Mon, 22 September 2008 03:17 Go to previous messageGo to next message
Littlefoot
Messages: 19335
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.
Re: FRM-30049: Unable to build column mapping. [message #349579 is a reply to message #349547] Mon, 22 September 2008 04:55 Go to previous messageGo to next message
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.
Re: FRM-30049: Unable to build column mapping. [message #349607 is a reply to message #349579] Mon, 22 September 2008 06:18 Go to previous messageGo to next message
Littlefoot
Messages: 19335
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).
Re: FRM-30049: Unable to build column mapping. [message #349612 is a reply to message #349607] Mon, 22 September 2008 06:25 Go to previous messageGo to next message
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.
Re: FRM-30049: Unable to build column mapping. [message #349616 is a reply to message #349612] Mon, 22 September 2008 06:40 Go to previous messageGo to next message
Littlefoot
Messages: 19335
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
Re: FRM-30049: Unable to build column mapping. [message #349618 is a reply to message #349616] Mon, 22 September 2008 06:42 Go to previous messageGo to next message
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
Re: FRM-30049: Unable to build column mapping. [message #349625 is a reply to message #349618] Mon, 22 September 2008 07:19 Go to previous message
Littlefoot
Messages: 19335
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Even better! I'm glad you have solved the problem!
Previous Topic: key-delrec
Next Topic: Enabling/Disabling checkboxes
Goto Forum:
  


Current Time: Wed Jul 30 16:17:55 CDT 2014

Total time taken to generate the page: 0.10278 seconds