OracleFormFRM-15004:Errorwhileparsingjoincondition_跳跃生命线

个人资料

微博

正文字体大小：大中小

OracleFormFRM-15004:Errorwhileparsingjoincondition

(2023-03-28 11:10:03)

标签：

分类：技术类

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

-- 刘轶鹤

阅读┊ 收藏 ┊ 喜欢 ▼ ┊打印┊举报/Report