如何使用Oracle FND_LOAD工具在不同Instance間同步資料(Example)

FNDLOAD是Oracle官方提供資料同步工具(Data Synchronization)，一般情況下，我們通過FNDLOAD工具把DEV Instance的客戶化AOL資料下載到一個文字檔中，然後同樣使用FNDLOAD上傳到PROD Instance中去。

什麼樣的情況下，需要使用FNDLOAD來同步

我們在測試環境開發了一些客戶化程式(Personalization)，Concurrent Program,Message....想要同步到正式的環境中去，這時我們可以使用FNDLOAD同步工具。

哪些資料可以使用FNDLOAD來同步？

* Concurrent Programs, Executables
* Request Groups, Request Sets
* Profile Options
* Key and Descriptive Flexfields
* Menus and Responsibilities
* Forms and Form Functions
* Attachments
* Messages
* Value Sets and Values
* Lookup Types
* User Responsibilities
* Printer Definitions
* FND Dictionary
* Help Configuration
* Document Sequences
* Concurrent Manager Schedules

FNDLOAD的使用文法

FNDLOAD apps/appspwd 0 Y mode configfile datafile entity [parameter1|..]
The mode is either DOWNLOAD or UPLOAD.
The configfile is the file that Fndload needs to download on upload data.
The data file is the output file, in which the downloaded data is written
The entity is the entity you want to download,
Parameters van is passed to download a certain Alert

A Example How to download Personalization Code

我在測試環境給Move Order form寫了一個簡單的Personalization代碼,這個Function Name為INV_INVTOMAI

1 2 3 下一頁