<div>
FRM-30064: &nbsp;Unable to parse statement %s.<br />
<br />
Cause: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A syntax error occurred in the SELECT statement within an LOV or record group. <br />
<br />
Action: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Check the statement, and add the FROM clause.<br />
<br />
You can try to change the record group query to this:<br />
<br />
select am.customer, am.name1, am.phone from armaster am where 0 &lt;&nbsp;(select sum(nvl(as2.balance,0)) from arsumbal as2 where as2.customer=am.customer) order by am.name1.
</div>


FRM-30064:  Unable to parse statement %s.

Cause:      A syntax error occurred in the SELECT statement within an LOV or record group.

Action:      Check the statement, and add the FROM clause.

You can try to change the record group query to this:

select am.customer, am.name1, am.phone from armaster am where 0 < (select sum(nvl(as2.balance,0)) from arsumbal as2 where as2.customer=am.customer) order by am.name1.

<div>
Simple check whether the tables &quot;armaster&quot; and &quot;arsumbal&quot; exist in your schema....One or both might be missing or the name might have been given wrong.
</div>


Simple check whether the tables "armaster" and "arsumbal" exist in your schema....One or both might be missing or the name might have been given wrong.

<div>
Hello,<br />
<br />
Yes, I checked and the tables armaster and arsumbal do exist in the ORacle 9i database.<br />
<br />
1) Your toughts ...<br />
<br />
PT<br />

</div>


Hello,

Yes, I checked and the tables armaster and arsumbal do exist in the ORacle 9i database.

1) Your toughts ...

PT


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Here is the error message that I get after compiling one of my forms:<br />
---<br />
FRM-30064: Unable to parse statement select am.customer, am.name1, am.phone from armaster am where 0 &lt;&nbsp;(select sum(nvl(balance,0)) from arsumbal as2 where as2.customer = am.customer) order by name1.<br />
ORA-00942: table or view does not exist<br />
Record Group REC_CUST_GROUP<br />
Form: ACC_REC<br />
&nbsp;<br />
FRM-30085: Unable to adjust form for output.<br />
&nbsp;<br />
&nbsp;<br />
Form not created<br />
----<br />
<br />
1) How can I resolve this issue ?<br />
<br />
PT<br />

</div>
</div>


Hello,

Here is the error message that I get after compiling one of my forms:
---
FRM-30064: Unable to parse statement select am.customer, am.name1, am.phone from armaster am where 0 < (select sum(nvl(balance,0)) from arsumbal as2 where as2.customer = am.customer) order by name1.
ORA-00942: table or view does not exist
Record Group REC_CUST_GROUP
Form: ACC_REC
 
FRM-30085: Unable to adjust form for output.
 
 
Form not created
----

1) How can I resolve this issue ?

PT


FRM-30064 / FRM-30085 + ORA-00942 Errors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.