Solved

FORMS- FRM-30049: Unable to build column mapping

Posted on 2006-11-09
6
6,478 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What is the version of ojdbc6.jar 2 59
form builder not starting 3 34
Create Index on a Materialized View 5 23
make null the repeated levels 2 21
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

772 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