月結作業 - INV 庫存管理系統

Step 1. Enter All Transactions(處理完成所有交易)

Inventory->Transactions->Miscellaneous Transactions, Subinventory Transfer, Inter-Org Transfer…...

OM->Shipping->Transactions->[Action] Ship Confirm

Inventory->Receiving->Receipts (Customer Return, RMA)

WIP->Material Transaction->WIP Material Transactions

PO-> Receiving->Receipts (Internal & Supplier) &Receiving Transactions

Step 2. Check Transaction Interface

確保 Interface Manager 開啟且運作正常

Material Transaction (INV Module)

Cost Manager (INV Module)

Move Transaction (INV Module)

Inventory Manager (SYSADMIN Module)

Receiving Transaction Manager (SYSADMIN Module)

查詢出未處理(pending or no process) transactions 並重新submit

執行Inv->Transaction-> Pending Transactions 與 Transaction Open

Interface

查詢出ERROR transaction並處理ERROR原因.

Step 3. Check OM Transaction Processes

Unconfirmed Shipment

針對已出貨Ship Conform，但尚未扣庫存者，需執行Inventory interface and Receivable interface transfer 扣庫存及補立AR。

查詢出ERROR transaction並處理ERROR原因--Inventory Interface

Inv->Transaction->Open Interface

查詢出ERROR transaction並處理ERROR原因--Receivable Interface

AR->Transaction->Interface Line

Step 4. Review Inventory Transactions

Correcting Incorrect Account Charges(檢核會計科目)

檢核資料庫中 Material Transaction 中的cost 部份是否有計算，Material Distribution 是否正確產生

Step 5. Balance the perpetual Inventory

以日常印出並簽核之Transactions Register Report核對月底印出之 Transactions Register Report, 總數須相同 , 依據transaction_type 印出資料

若有誤, 須追出原始單據, 修正或補輸入transactions,然後重回上步驟

使用Material Account Distribution Summary Report 檢核期末金額或數量正確性

核對庫存金額與會計科目之正確性: (N) (Report->Costs->All->)

Inventory Value Report

Material Account Distribution Detail Report

Material Account Distribution Summary Report

Step 6. Transfer Summary or Detail Trans To GL

Inventory->Accounting Close Cycle ->General Ledger Transfer (By Org)

G/L Batch sequence

Step 7-8. Close AP, PO, AR, GL, INV

月結作業 - OM 訂單管理系統

Step 1: Complete All Transaction for Current Period

Confirm Transaction had been Completed

A. Enter all S/O Transactions

B. Enter all RMA Order Transactions

C. Confirm Shipment Transactions

D. Confirm RMA Receipt/Receiving Transactions

E. Response to Workflow Approval Notifications

Step 2: Complete S/O Import Transactions for Current Period (Options)

External S/O Import Interface (Like EDI or XML Order)

A. Run “Order Import Request” in Oracle Order Management.

B. If have Error, Use “Import Order Collection” to review Import S/O

Oracle Internal S/O Import Interface (Like EDI or XML Order)

A. Run “Create Internal S/O” in Oracle Purchasing

B. Run “Order Import Request” in Oracle Order Management

C. If have Error, Use “Import Order Collection” to correct Import S/O.

Step 3: Review Held Order

Review Hold Order

1. Run “Orders on Credit Check Hold Report”

2. If have Held Order, following SOP to Process.

Step 4: Review Backorders

Review BackOrder Report

1. Run “Backorder Detail Report “ in Oracle Shipping

2. If have some urgent Shipment need to do, following SOP to do the Picking and Shipping process.

Step 5: Reconcile to Oracle Inventory (Inv)

Confirm all Shipment Interface to Oracle Interface

1. Check there is no any Delivery in “Interface Trip Stop”.

2. If have some Delivery, following SOP to do the Shipment process.

在Vista平台下安裝 Oracle JInitiator

在Vista平台下一直無法直接用IE7 執行Oracle ERP, 最近看了Oracle出的解決方式https://metalink.oracle.com/metalink/plsql/f?p=130:3:63729454575069701::::p3_database_id,p3_docid,p3_show_header,p3_show_help,p3_black_frame,p3_font:NOT,290807.1,1,0,1,helvetica

有些繁瑣, 後來參考網友的作法很快就可以使用了:
1.先檢查JDK是否已安裝至6.0以上
請到此下載 http://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_Developer-Site/en_US/-/USD/VerifyItem-Start/jre-6u4-windows-i586-p.exe?BundledLineItemUUID=i0dIBe.pR3AAAAEYeUoUszqx&OrderID=QrBIBe.pWfkAAAEYakoUszqx&ProductID=lr9IBe.nFxoAAAEWAhINQrEN&FileName=/jre-6u4-windows-i586-p.exe

2.在JDK安裝完後，請至 C:\Program Files\Java\jre1.6.0_XX\bin\client\ 複製jvm.dll
覆蓋至 C:\Program Files\Oracle\JInitiator 1.3.1.XX\bin\hotspot

3.修改兩個資料夾名稱請至 C:\Program Files\Oracle\JInitiator 1.3.1.XX\lib\
將 font.properties.zh.5.0 改成 font.properties.zh.6.0
將 font.properties.zh.5.1 改成 font.properties.zh.6.1

4.改字型請至 C:\Program Files\Oracle\JInitiator 1.3.1.XX\lib\
用記事本開啟font.properties將# for Simplified Chinese下字串
filename.\u5b8b\u4f53=SIMSUN.TTF 改成
filename.\u5b8b\u4f53=SIMSUN.TTC
(簡體中文才做)

存檔完工.

月結作業 - PO 採購管理系統

PO 採購管理系統

Step 1. Optionally Review the Current and Future Commitments

執行Purchase Order Commitment by Period Report

Step 2. Optionally Review the Outstanding and Overdue Purchase Orders

執行 Purchase Order Detail Report

執行 Open Purchase Orders(by Buyer) Report

執行 Open Purchase Orders(by Cost Center) Report

Step 3. Follow Up Receipts - Check With Vendors

根據 Purchase Order Detail Report 由相關部門與Vendors Check未收料之採購單. 若有已收料但未輸入之資料則需補輸入

Step 4. Identify and Review Uninvoiced Receipts

執行 Uninvoiced Receipts Report

Step 5. Follow Up Invoices

相關部門根據 Uninvoiced Receipts Report 與Vendor Check 已收料但未收到發票(應付帳款未立帳)之收料資料

Step 6. Complete the Oracle Payables Period-End Process

Step 7: Run PO 之Receipt Accrual - Period End

Step 8: Complete AP Period End

Step 9: Optionally Perform Year-End Encumbrance Processing

Step 10: Close PO Period

Step 11: Open Next PO Period

Step 12: Close GL Period

Step 13: Optionally Run PO Reports

Vendors Report

檢核供應商資料, 並檢視是否有重覆之供應商.

Vendors Audit Report

列印可能為重覆之供應商地址資料, 可以Vendor Merge作業合併重覆之供應商地址.

Vendor Quality Performance Analysis Report

供應商之送貨品質分析 - Accepted, Rejected, Returned之比率.

Vendor Service Performance Analysis Report

Vendor Volume Analysis Report

Requisition Activity Register

Blanket and Planned PO Status Report

Saving Analysis Report (by Category)

Saving Analysis Report (by Buyer)

執行Accrual Reconciliation Report

分析並確認錯誤之Accruals, 並於Accrual Write-Offs Form中輸入

執行Accrual Write-Off Reports 根據Accrual Write-Off Report於GL中人工輸入調整傳票