Issue : 如圖

image 

Root cause

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

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

文章標籤

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

<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,

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

==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


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

Using Message Dictionary in PL/SQL

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


文章標籤

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

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

Please check “APP_CUSTOM”. You maybe forget to modify this statement.

Put correct winodw name replace  <your first window > string.

image

eg.

文章標籤

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