Oracle eBS經驗分享

如何將Custom Code 上傳正式環境    Created By: tina 李湘婷 lee 2007/02/07 - 05:25:30

一、 前言:

Oracle 11.5.10 提供開發人員一個可以依據不同的Form客製特殊需求，設定需要修改的畫面呈現或其他控制(即Custom Code>Personalize)，該設定需要從AP UI上設定需要APPS帳號權限，因為我們公司於正式環境並不開放APPS權限給一般開發人員，僅有DBA有該帳號權限，由此緣故筆者撰寫此文件提供開發者瞭解如何於測試環境中匯出已設定/測試完成的Custom Form Code Rule。

Ps. DBA雖有APPS權限，但其無其他模組權限，故無法協助開發人員進系統設定。

二、 操作說明(匯出):

1) Telnet 登入Test AP主機

2) cd $FND_TOP

3) NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5; export NLS_LANG

4) FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct \ PO_POXPOEPO.ldt FND_FORM_CUSTOM_RULES function_name='PO_POXPOEPO'

5) ls 確認一下該ldt檔案(ex. PO_POXPOEPO.ldt 參圖 二)有無產生，如果沒有請查看 log檔(ex.O2424133.log)

6) 用FTP將 PO_POXPOEPO.ldt 檔案 Download 到你的電腦,注意:請用ASCII 方式下載

7) Download下來後，將 PO_POXPOEPO.ldt交由DBA，請DBA import 到正式環境中

三、 操作說明(匯入):

1) Telnet 登入Prod AP主機

2) 輸入 cd $FND_TOP

3) 輸入 NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5; export NLS_LANG

4) FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct \ PO_POXPOEPO.ldt (ps. 記得把此Command提供給DBA upload)

5) 進系統看看是否有程式註冊成功

四、 資料來源

1) 前進國際 –周惠君小姐提供資訊

2) Oracle Document->System Administrator's Guide - Conguration

今天第一次遇到 view ADI  Request  Output發生問題...

詭異的  狀況，大概查了三個小時，Metalink 說ADI Application 是hardcode 所以可能會有以下這個狀況，

所以呢  需要加一個tns 到你的tnsnames.ora中，結果 我怎麼加 怎麼不行...

真是給我氣死了 ～ 後來 去看一個可以正常使用的User電腦，發現  原來我們File Server的Port 不是1521...

為了避免大家跟我一樣...

Solution 提供大家參考囉  .. Oracle Metalink 也有很多相關的文章   Key word: "adi","nodename"

<<Solution>> or you can reference oracle Doc ID: 2108008.6  or Doc ID=70669.1

-- SQLNET.ORA --

AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES, HOSTNAME)
name.default_zone = world
names.default_domain=world

-- TNSNAMES.ORA --

Please add this string....as below..

FNDFS_PRODDB.world =
  (DESCRIPTION =
        (ADDRESS =
          (COMMUNITY = TCP)
          (PROTOCOL = TCP)
          (Host = PRODDB)  =>Nodename (就是hostname)
          (Port = 1626)   --> remember check the port of file sever (ask DBA)
        )
    (CONNECT_DATA = (SID = FNDFS) 

        (GLOBAL_NAME = FNDFS_PRODDB)
    )
  )

ADI 是oracle 提供的一個可以從client 用excel 將資料上傳到資料庫interface的工具

但是因為ADI 開發版本較舊(目前版本7.2)，因此它在安裝上比較不人性化，

為避免大家花了很多時間在安裝ADI上，故撰寫此文件，避免你在安裝時花了很多不必要的時間在解決問題。

常見問題如下:

1. 無法安裝ADI

2. TNSname 無法辨識

---------------------------------------------------------------

說明

---------------------------------------------------------------

1> 無法安裝的原因:

    一般是出現在安裝時發生錯誤，因為ADI 要安裝在Oracle default home,

    所以如果安裝時發生錯誤，那可能是你先前安裝的oracle 佔據的default home

    solution: 移除掉所有oracle 產品，重新安裝ADI

    注意:完整的移除程序請參附件 Uninstall ADI.txt

2> TNSname 無法辨識

    tnsname 的設定要透過SQL Net Easy Configuration 去設定。

    到 C:\orant\NET80\ADMIN\TNSNAMES.ORA

       C:\orant\NETWORK\ADMIN\TNSNAMES.ORA

    確認NET80 與NETWORK Configuration 是否都有設定

    請不要用oracle 8i 的tnsname.ora configuration覆蓋掉，會有問題。

Doc ID:106513.1     Type: BULLETIN

Overview
--------

The UTL_SMTP package is a new package included in the Oracle8i Release 2
(8.1.6).  This package allows PL/SQL to generate e-mail messages using the 
UTL_SMTP package.  UTL_SMTP is discussed in the documentation 
'PL/SQL Packages and Types Reference'. 

When using Oracle 8i (8.1.5 to 8.1.7) it is required to install the Oracle JVM 
inside the database, because the UTL_SMTP is implemented by usage of mapped 
JVM libraries - i.e. JAVA classes. See Note 132936.1

Beginning with Oracle 9i (9.0.1) and higher, the UTL_SMTP is using library 
functions implemented in C for gaining performance and enabling databases 
to use these packages without installed JVM.

To install the UTL_SMTP package, use SQL*Plus and run as user "SYS" 
the following files located in ORACLE_HOME/rdbms/admin

utlsmtp.sql
prvtsmtp.plb

additionally in 10g it is possible to use UTL_MAIL 

utlmail.sql
prvtmail.plb

See also Note 369777.1


Generating E-mail Using UTL_SMTP
--------------------------------

Perform the following steps to generate e-mail messages using the UTL_SMTP 
package:

  1) Establish a connection with the SMTP server (usually port 25).  This is
     done through a UTL_SMTP.OPEN_CONNECTION() function call.  This function
     returns the connection record to be used in subsequent calls.

  2) Perform the initial handshake with the SMTP server.  This is done through
     a UTL_SMTP.HELO() call, or optionally through the UTL_SMTP.EHLO() call.

  3) Start the mail message by specifying the 'From' mail ID.  This is done
     through a UTL_SMTP.MAIL() call.

  4) Specify the recipients for the e-mail message.  This can be done through
     the UTL_SMTP.RCPT() call.

  5) Assemble the body of the e-mail message with the redundant recipient list.
     If the body of the e-mail does not contain this information, it will not
     be received in the resulting e-mail.  

     When assembling the body, RFC 821 requires that the lines to be terminated
     by <CR><LF> which is a character 13 and character 10 (accomplished in 
     PL/SQL by using: CHR(13)||CHAR(10)).

  6) Pass the body of the message into the UTL_SMTP buffer by calling the
     UTL_SMTP.DATA().  

     Note:  This function performs the RFC specified termination of 
            <CR><LF>.<CR><LF> to denote the end of the data.

  7) Close the SMTP connection through the UTL_SMTP.QUIT() call.

Subject:  Simple Example of Sending Attachments Using UTL_SMTP

Doc ID:  414062.1

Modified Date: 15-MAY-2008

Applies to:

PL/SQL - Version: 9.2.0.1 to 10.2.0.1
Information in this document applies to any platform.

Goal

How to send attachments using the PL/SQL package UTL_SMTP.  The sample code uses the DBMS_LOB package to open and read the external file.

Solution