目前分類:開發技術 (24)

瀏覽方式: 標題列表 簡短摘要

Using Message Dictionary in PL/SQL

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


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

Please refer the Doc : Unable To Default The Output Format In The Bi Publisher Template [ID 835609.1]

After applying the patch 5612820 ==> We can see the default function now.

1. Setup the default output type

image

2. Run “XML Publisher Template Re-Generator”.

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

When I create Data Link between two sql query , I got below error message.

image

< Root Cause >

==Query Group : Q_DELIVERY_DETAIL_ID==

/*PICKED*/

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

These steps are my way , I am not following oracle coding standard guide.

For you all reference.

Step 1 : New Report

image

Step 2 : Build a new report manually

, ,

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

At Pre-Form Trigger

置中

app_window.set_window_position('MAIN', 'CENTER');


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

Using Regular Expressions in Oracle

<Example>

=======================================

select regexp_substr('@@/231@@_3253/ABc','@*[[:alnum:]]+',1,2) from dual;

image

=======================================

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

If you want to send the output report when you submit concurrent program.

You can use the standard function.

image

image

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

Personalizations are stored in tables, separate
from the forms they alter:

FND_FORM_CUSTOM_RULES
FND_FORM_CUSTOM_ACTIONS
FND_FORM_CUSTOM_SCOPES
FND_FORM_CUSTOM_PROP_LIST

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

If we need write Oracle PL/SQL Program for concurrent program using.

We need create procedure (ex. xx_procedure)

This xx_procedure need has base two parameter.(errbuf out varchar2,retcode out number).

 

  • Errbuf : Errbuf is one the paramter which will define in pl/sql to store procedure to get error messges into log file.
    • Retcode: this parameter will be used to get the status of the concurrent program. It will give the values

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

1.FND_GLOBAL.USERID --Returns userid

2.FND_GLOBAL.APPS_INTIALIZE procedure

  •    APPS_INITIALIZE(user_id in number,resp_id in number,resp_appl_id in number);
       This is used to set the values userid and responsibilityid for a session
    3.FND_GLOBAL.LOGIN_ID -Gives login id
    4.FND_GLOBAL.CONC_LOGIN_ID--Not sure how to use this

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

資料來源: OTN

This tip comes from Navroz Kapadia, DBA, Economics & Business Cluster in Toronto, Ontario, Canada.

This script will generate a SQL*Loader control file for any specified table, which can then be customized as per individual needs. Ensure it is run by a user with SELECT_CATALOG_ROLE. Parameter 1 is the owner of the table. Parameter 2 is the tablename.


set verify off

set heading off

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

這個Case 是為了讓User 於收料畫面方便 Submit Report Request.

設定方式如下:

1. Create New Rule : Trigger Event = When-New-Form-Instance

image

2. Menu Entry :選擇Special16 (Sepcial 16 ~30是”Report”選項)

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

 

Oracle Form Personalize 提供1~45的Special Menu for us to using.

Each has the name SPECIAL#

–SPECIAL1 though 15: under ‘Tools’

–SPECIAL16 though 30: under ‘Reports’

–SPECIAL31 though 45: under ‘Actions

image

如果要啟用Menu ,Must be activated in a Rule based on the WHEN-NEW-FORM-INSTANCE event

image

image

So you can see new item in your Menu List.

image


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

常用 Table關聯

MTL_MATERIAL_TRANSACTIONS. MOVE_ORDER_LINE_ID = MTL_TXN_REQUEST_LINES. LINE_ID
WSH_DELIVERY_DETAILS. MOVE_ORDER_LINE_ID = MTL_TXN_REQUEST_LINES. LINE_ID
OE_ORDER_HEADERS_ALL HEADER_ID = OE_ORDER_LINES_ALL LINE_ID

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

資料來源:Symplik

 

 

How to do that
Assuming the original login page is

http(s)://[APPL_TOP Server]:[port]/OA_HTML/AppsLocalLogin.jsp
For simplicity, this URL is represented by
[Apps URL]/OA_HTML/AppsLocalLogin.jsp
To goto the Apps Home Page (i.e. Navigator Page) without entering the username and password, you can use the URL:
[Apps URL]/OA_HTML/fndvald.jsp?username=[login name]&password=[password]
If you want to create another Login Page rather than using the the one provided by Oracle, you can include this HTML code in your page:
<form method="post" action="[Apps URL]/OA_HTML/fndvald.jsp">

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

連接方式可以分為透明閘道和通用連接兩種。
透明閘道(Transparent Gateways) 透明閘道使用Oracle提供的特定閘道程式來設置代理,例如連接SQL Server則必須要有SQL Transparent Gateway for SQL Server。
通用連接(Generic Connectivity) 通用連接又分為ODBC連接和OLE DB連接兩種,其連接方法和透明閘道沒有本質區別,只不過通用連接是和資料庫一起提供的功能,你不需要向Oracle購買相關的透明閘道程式

1. 安裝軟體 transparent gateway

Oracle 9i在自定義,點選Transparent Gateway for MS SQL Server安裝,安裝完在oracle10下有一個 tg4msql文件夾

2. 設定listerner.ora

在D:\oracle\oracle10\NETWORK\ADMIN\listener.ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = D:\oracle\oracle10)

(PROGRAM = extproc))

(SID_DESC=

(SID_NAME=hrdb)

(ORACLE_HOME=D:\oracle\oracle10)

(PROGRAM=tg4msql)

))

3. 設定tnsnames.ora

在D:\oracle\oracle10\NETWORK\ADMIN\tnsnames.ora

hrdb =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = WJ-BPM)(PORT = 1521))

)

(CONNECT_DATA =

(SID = hrdb)

)

(HS=OK)

)

4. Copy D:\oracle\oracle10\tg4msql\admin\inittg4msql.ora 成inithrdb.ora

temp2

temp1

D:\oracle\oracle10\tg4msql\admin\inithrdb.ora

HS_FDS_CONNECT_INFO=SZ-ARIMACOMM-HR(SQL Server主機名稱).hrdb(DB Name)

HS_FDS_TRACE_LEVEL=OFF

HS_FDS_RECOVERY_ACCOUNT=RECOVER

HS_FDS_RECOVERY_PWD=RECOVER

5. 建DB LINK

create public database link HRDB

connect to KAZHONG

identified by KAZHONG

using hrdb

 

「注意事項」

查看init.ora文件,將global_names 值改成 false,之后啟起DB,(不重啟DB,也可執行alter system set global_names=false)

在sql server建帳號

temp1

temp2

temp3

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

Form Builder Basic Development


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

使用fnd_file Package

輸出到Log       ==> Fnd_file.put_line(fnd_file.log,'xxxxx');

image

輸出到Output ==> Fnd_file.put_line(fnd_file.output,'xxxxx');

image

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

Metalink Doc ID:743490.1

In this Document
Purpose
Scope and Application
Customization in Oracle Applications

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

如何依據User 於參數輸入的資料,限制帶出另一個參數值,建立Parameter 相依性

:$FLEX$.<VALUE_SET_Name>

image

<Parameter 15>

image

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

1 2