目前日期文章:200908 (8)

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

測試環境 流程測試前需確認的設定 (Just for myself reference)

1. Open Inventory Period

  • Responsibility: Cost Managment Super user
  • Path: Accounting Close Cycle --> Inventory Accounting Periods 
  • image

2. Open Purchasing Period

3. Open Payable Period

4. Open GL Period

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

[Profile] OM: Invoice Numbering Method


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

4.1 運輸

transportation
用設備和工具,將物品從一地點向另一地點運送的物流活動。其中包括集貨、分發、搬運、中轉、裝入、卸下、分散等一系列操作。 [GB/T 4122.1-1996中4.17]

4.2 聯合運輸

combined transport

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) 人氣()

In the past, Oracle E-Business Suite Customers seldom used outputs of the seeded Oracle reports because they were unfriendly, and frankly, hard to use. Unfriendly because the generated output was always fixed width courier only font, contained no graphics, and could only be in black and white. Hard to use because the only output was text. In the business world, we all know how important the final output is and text only is not even an option. Businesses require PDF and XLS output that support tables, charts, graphics, color, etc.

Today, Oracle offers a solution that enables our Oracle E-Business Suite Customers to turn the once unfriendly and useless Oracle seeded reports into PDF and XLS outputs of color, graphics, and tables. The solution is XML Publisher. XML Publisher is a java based reporting tool that is bundled for free within the technology stack of the Oracle E-Business Suite. The concept is similar to that of “mail-merge” where the data and template are maintained separately until the two are “married” to generate the desired document. XML Publisher separates a report’s data and layout component into two manageable pieces while it supports the desired outputs of PDF, HTML, XLS and RTF. The prerequisites to use XML Publisher include:

  • XML Data
  • Report Template
  • Registration of Data Definition and Template at XML Publisher

How does XML Publisher leverage on Oracle seeded reports? An Oracle seeded report is a report definition file that integrates both the data query and the report layout into one file. XML Publisher will use Oracle Reports for only the data query portion and will ignore the defined report layout. This will fulfill one of XML Publisher’s prerequisites: XML Data. So the question is, how do you set up the Oracle system to only use the data query portion of the Oracle report?

  • Log into Oracle with System Administrator Responsibility
  • Navigate to > Concurrent > Program > Define
  • Search for the desired Oracle Report
  • Change the Output Format from the default ‘Text’ to ‘XML’
  • Take special note of the Program Short Name (you’ll need it later to register the data at XML Publisher)
image001

 

How does it benefit Oracle E-Business Suite customers? XML Publisher provides full control of the layout and look and feel of the report to the Customers. This means the Customer will fulfill the second prerequisite, the Report Layout. Customers will leverage on familiar tools like Microsoft Word and Adobe Acrobat to create the report layout with reference to the XML Data Tags. So the question is, how does the Customer create the Report Layout? PDF Forms template are intended for Customers that require a fixed look and feel such as completed IRS forms and are created in Adobe Acrobat. RTF templates are intended for all other purposes and are created in Microsoft Word. In this example, we’ll go over how to create an RTF Template.To create an RTF Template, you’ll want to download the XML Publisher Desktop Utility and its prerequisite Java Runtime Environment. This enables you to create and test your Report Template in a localized environment, your computer, before registering it at Oracle XML Publisher. So where to download the XML Publisher Desktop Utility?

  • Navigate to Oracle eDelivery Site
  • Select Product Pack: Oracle Application Server Products
  • Select Platform: MS 32 bit
  • Click on the GO Button
  • Select and Download Oracle XML Publisher Release 5.6.2 Media Pack for Microsoft Windows

 image001

image001

The XML Publisher Desktop Utility is a plug-in to Microsoft Word. To create the RTF template, you must first load the XML Data File by clicking on the Data button and selecting Load XML Data. To get a sample XML data file, you can run the Oracle seeded report and download the output. Once the data file is loaded, you can make references to the XML Data elements. For example, if you want to reference the ‘Project_Number’ XML Data Element, the format you would type would be … The common used tags include:

  • for-each | end for-each
  • if | end if
  • choose | when | end when | otherwise | end otherwise | end choose

Alternatively, you can use the Desktop Wizard functionality by clicking the Insert button and selecting Table/Form to drag and drop the desired XML Data Elements into the Template window. This will automatically generate a table for you.
You can test your RTF template with the loaded XML Data File by click on the Preview button and selecting one of the supported output formats. Once satisfied with the created RTF Template, the final steps is to register both the Data Definition and the Template at XML Publisher. The steps are:
Register the Data Definition:

  • Log into Oracle with XML Publisher Administrator responsibility
  • Navigate to > Home > Data Definitions
  • Click on the Create Data Definition button
  • The Code must be the Concurrent Program Shortname from above

image001

Register the Template

  • From Data Definitions, Navigate to > Templates
  • Click on the Create Template button
  • The Data Definition value should be the Data Definition you registered above

image005

When the Customer runs this configured report through the Concurrent Manager, the Customer will follow the same steps to run the standard Oracle Report by selecting the report in the Single Request Screen and entering the desired run parameters. Now, the Customer has one additional option to select the desired output format of the report. From the Single Request Screen, click on the Options button and select the desired output.

image001


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

故障現象:操作oracle系統時,不能把復制的文本粘貼到系統裡面,Paste菜單是灰色的。同時剛開啟oralce的時候,oracle畫面下面有黃色的條幅-錯誤畫面沒有抓下來。

解決方法:到一個正常的oracle系統安裝路徑裡面搜索identitydb.obj文件,取代掉有問題電腦的這個文件,就可以了。

資料來源:http://www.itpub.net/showthread.php?s=8a3c0ddb1ba1ded55b0ea6dfcbe8a727&threadid=168393&perpage=15&pagenumber=1


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

找更多相關文章與討論