Issue : 如圖

image 

Root cause

我設了一個Query_find block.該block的query allowed attribute is No,造成的。

當cursor 走到QUERY_FIND block , 手電筒就會被關掉了…

image

Solution

image

這樣就解決了…

文章標籤
find button grey oracle find button disable

Somebaby 發表在 痞客邦 留言(0) 人氣()

▲top

<Issue Description>

設定Record group 並指定LOV，都正常，Compile 也ok

但Open form 並下拉選單選值會發生下列錯誤

ORA-00904: "DOCUMENT_NO": invalid identifier

--------------------------------------------------------------
FRM-40502: ORACLE error: unable to read list of values.

 

Record group sql 如下

SELECT distinct wnd.name as document_no,
       wnd.delivery_id as document_id,
       wdd.org_id as org_id
  FROM wsh_new_deliveries wnd,
  wsh_delivery_assignments wda,
  wsh_delivery_details wdd
WHERE wnd.organization_id = 374
   and wda.delivery_id= wnd.delivery_id
   and wdd.delivery_detail_id= wda.delivery_detail_id
   and wdd.source_code ='OE'
   and wda.delivery_detail_id is not null
   AND wnd.initial_pickup_date >= add_months(:DOCUMENTS_HEADER.ESTIMATE_CARRY_DATE,-6)

找到這篇文章才知道，原來這一個bug.

It looks like this is caused by bug 725059:
"FILTER BEFORE DISPLAY" DOESN'T WORK IF LOV HAS COLUMN ALIASES (TRIAGE1098)

Oracle的說明是…

AVAILABLE WORKAROUNDS:
Don't use column aliases in the LOV select statement.
However if a form is generated via Designer/2000, all lookup columns
automatically use column aliases in the LOV select statement.
This would mean that Des2k users have to change all their forms.

 

 

將Record Group SQL 修改下面這樣後就正常了

select document_no,document_id,org_id from (SELECT distinct wnd.name as document_no,
       wnd.delivery_id as document_id,
       wdd.org_id as org_id
  FROM wsh_new_deliveries wnd,
  wsh_delivery_assignments wda,
  wsh_delivery_details wdd
WHERE wnd.organization_id = 374
   and wda.delivery_id= wnd.delivery_id
   and wdd.delivery_detail_id= wda.delivery_detail_id
   and wdd.source_code ='OE'
   and wda.delivery_detail_id is not null
   AND wnd.initial_pickup_date >= add_months(:DOCUMENTS_HEADER.ESTIMATE_CARRY_DATE,-6))

Somebaby 發表在 痞客邦 留言(0) 人氣()

▲top

==PL/SQL==

FND_MESSAGE.SET_STRING ('You have no freight data access authority .You need to get it first.Please contact local IT');
FND_MESSAGE.SHOW;

image

Somebaby 發表在 痞客邦 留言(0) 人氣()

▲top

Using Message Dictionary in PL/SQL

Document reference ..http://oraclemaniac.com/2012/03/12/using-fnd_message-to-show-formatted-text/

文章標籤
FND_MESSAGE Oracle eBS函式

Somebaby 發表在 痞客邦 留言(0) 人氣()

▲top

When you close [x] a form , but popup a Progress window .image

(繼續閱讀...)
文章標籤
Oracle Form Builder EBS

Somebaby 發表在 痞客邦 留言(0) 人氣()

▲top
«1...456 78...62