- 11月 21 週一 201111:58
支票字軌設定
- 8月 04 週四 201110:02
x_conc_util_pkg(資通的公用程式)
PROCEDURE common_info (
p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE
, p_conc_request_id IN fnd_concurrent_requests.request_id%TYPE
, p_set_of_books_name OUT gl_sets_of_books.NAME%TYPE
, p_chart_of_accounts_id OUT gl_sets_of_books.chart_of_accounts_id%TYPE
, p_currency_code OUT gl_sets_of_books.currency_code%TYPE
, p_user_name OUT fnd_user.user_name%TYPE
, p_conc_pro_name OUT fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE);
END x_conc_util_pkg;
- 2月 09 週三 201111:29
AR: 設定子公司款項可由母公司收取
- 5月 26 週三 201010:15
記錄使用者login的狀況
- 2月 25 週四 201013:33
APP-AR-96983 : User Write-off limit does not exist
- 11月 26 週四 200913:50
MTL_SUPPLY table 異動變化
- 10月 02 週五 200911:33
採購請購單介面檔範例 (PR Created by interface table importing)(轉)
PR請購單導入需分兩步進行:
先準備接口表數據, 通過SQLLoader或其他三方軟件將數據插入接口表, 然後在系統中提交標準PR導入請求, 完成PR生成.
1, insert into PR interface table:
INSERT INTO PO_REQUISITIONS_INTERFACE_ALL
(INTERFACE_SOURCE_CODE,
DESTINATION_TYPE_CODE,
AUTHORIZATION_STATUS,
REQUISITION_TYPE,
PREPARER_ID,
PREPARER_NAME,
QUANTITY,
CHARGE_ACCOUNT_ID,
DESTINATION_ORGANIZATION_ID,
DESTINATION_SUBINVENTORY,
SOURCE_TYPE_CODE,
UNIT_PRICE,
DELIVER_TO_LOCATION_ID,
DELIVER_TO_REQUESTOR_ID,
ITEM_ID,
UNIT_OF_MEASURE,
UOM_CODE,
NEED_BY_DATE,
CREATION_DATE,
ITEM_DESCRIPTION,
LINE_TYPE,
HEADER_DESCRIPTION,
LINE_TYPE_ID,
SUGGESTED_VENDOR_ID,
SUGGESTED_VENDOR_SITE_ID)
VALUES( 'EXTERNAL', 'INVENTORY', 'INCOMPLETE', 'PURCHASE', 25, 'Stock, Ms Pat', 10, 13401, 204, 'Stores', 'VENDOR', 23, 204, 25, 63, 'Each', 'Ea', sysdate, sysdate, 'Sentinal Multimedia', 'GOODS', 'Test Requisitions', 1, 21, 41);
2, Log in as user: operations/welcome
resp: Purchasing, Vision Operations (USA)
Submit request: Requisition Import
Parameter:
source: external
- 9月 21 週一 200915:52
Oracle軟體安裝順序
