Oracle Form FRM-15004: Error while parsing join condition

跳跃生命线

于 2023-03-28 11:08:21 发布

阅读量916

点赞数

分类专栏：技术类 #Form 开发文章标签： FRM-15004

本文链接：https://blog.csdn.net/AlexLiu_2019/article/details/129811967

版权

技术类同时被 2 个专栏收录

152 篇文章 2 订阅

订阅专栏

#Form 开发

37 篇文章 1 订阅

订阅专栏

当在MasterBlock和DetailBlock之间创建链接时遇到FRM-15004错误，可能是由于连接条件问题。解决方案包括检查QueryDataSourceType和QueryDataSourceName的属性设置，以及更改DetailBlock中的INVOICE_ID项名为LINE_INVOICE_ID，然后使用INVOICE_ID=LINE_INVOICE_ID作为新的连接条件。

摘要由CSDN通过智能技术生成

Oracle Form FRM-15004: Error while parsing join condition

Cause:
While creating a link between Master and Detail Block when the join details are provided
this error pop's up.

eg:
Master Block: QUERY_HEADER

Detail Block: QUERY_LINE

common column: INVOICE_ID

all the below join conditions I got the frm-15004 error

QUERY_HEADER.INVOICE_ID = QUERY_LINE.INVOICE_ID

INVOICE_ID = INVOICE_ID

:QUERY_HEADER.INVOICE_ID = :QUERY_LINE.INVOICE_ID

Solution:

1. Go to Master and Detail Block Property Palette and check if the below properties have
correct values

Query Data Source Type:

Query Data Source Name:

This may not be required if your Blocks are based on views

2. Change the name of the Item in Detail block from INVOICE_ID to LINE_INVOICE_ID and now provide
the below join condition

INVOICE_ID = LINE_INVOICE_ID

-- 刘轶鹤