Solved

FORMS- FRM-30049: Unable to build column mapping

Posted on 2006-11-09
6
6,566 Views
Last Modified: 2008-01-09
What else coudl cause this error message besides not mapping to the proper fields?

I am mapping to the columns in the block and have selected the column names form the drop-don list so it can't be a mistake in spellign the column names.
 
0
Comment
Question by:joekeri
6 Comments
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 17908609
Maybe this happening in an LOV?  Do you have any LOVs in the form?  If yes, have you modified a record group that an LOV uses?
0
 

Author Comment

by:joekeri
ID: 17909431
I have only  one record Group and one LOV.... and there are only 2 columns in the LOV. I have deleted, recreated and double-checked the fieldnames. I just can't find it.
0
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 25 total points
ID: 17910153
Then do a "save as" and give this *.fmb another name, delete the LOV and record group, and see if it compiles that way.  If so, you need to recreate the record group and LOV.  If it still give the error, then you either need to delete and recreate the block, or go back to an earlier version of the *.fmb that doesn't have the error.

I hope that you when you work with Oracle Forms you regularly save your work, with slightly different file names or in different directories, so that you can go back to a previous version of the *.fmb if you have to.  File corruption happens fairly frequently with Oracle Forms.
1
 
LVL 6

Assisted Solution

by:Ritesh_Garg
Ritesh_Garg earned 25 total points
ID: 17912218
I would suggest check the datatype / length of values in datamapping.
Also try compiling the form complete (ctl+shift+K) before you run / create fmx.
0
 
LVL 1

Expert Comment

by:Computer101
ID: 20296225
Forced accept.

Computer101
EE Admin
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to recover a database from a user managed backup

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question