目前分類:Oracle ERP Concept (11)

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

Reference : http://oracally.blogspot.com/2010/04/oracle-ebs-11i-new-entity-setup.html


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

有用的Metalink documents

WHITE PAPER: Oracle WMS Personalization Framework [ID: 469339.1]
WHITE PAPER: Oracle Order Management Suite White Papers [ID: 113492.1]
WHITE PAPER: Intercompany Invoicing Overview [ID: 336129.1]
Where Is The Best Place To Store Barcodes At Uom Level In Oracle?
Warehouse Management Knowledge Browser Product Page
Troubleshooting: Troubleshooting Grouping Rules In AutoInvoice [ID: 1084554.1]
Troubleshooting: How To Setup And Troubleshoot Freight In AutoInvoice And The Transactions Form [ID: 1096942.1]
Troubleshooting: Auto Sourcing And Auto Create/Release Checklist [ID: 417966.1]
Troubleshooting Oracle XML Publisher For The Oracle E-Business Suite
Script: Receiving Transactions Data Collection Script rcv11i_sa.sql [ID: 402245.1]
Script: Data Collection Scripts for Cost Management [ID: 378348.1]
Sample WMS Open Interface Insert Scripts / Examples howto Insert into Transaction Open Interface
Sales Orders to MRP Data Flow Diagram
Sales Orders to ASCP Data Flow Diagram
Reference: Procurement (Purchasing) Product Documentation [ID: 67108.1]
Reference: Patch Requirements for Extended Support of Oracle E-Business Suite Release 11.5.10 [ID: 883202.1]
Readme: About Web Applications Desktop Integrator Mini-pack 11i.BNE.D [ID: 287080.1]
Readme: About Oracle Receivables in Financials Family Pack G [ID: 290394.1]
Readme: About Oracle Purchasing in Oracle Supply Chain Management Family Pack J [ID: 258521.1]
Problem: Unable to Perform Actions For New WebADI User [ID: 875954.1]
Problem: Unable To Invoice Sales Orders After Lines Are Closed [ID: 754320.1]
Problem: Poor Performance In Scheduling Organizer Querying [ID: 568013.1]
Problem: Pick More Option Is Not Working On Mobile Device [ID: 556331.1]
Problem: Multi Line Requisitions are Created and Some Lines do not Import to OM [ID: 352835.1]
Problem: Error -The Connection to the Server is Unavailable When Upload Web ADI - Interface Columns Integrator [ID: 394680.1]
Problem: End Tag Does Not Match Start Tag 'Fsg:Rptline'. [ID: 390638.1]
Problem: Download WebADI Document Stuck at "Do not close this window until processing completes" [ID: 752760.1]
Problem: Credit Hold Set, But Order Still Booked [ID: 359696.1]
Oracle PO, OM R 11.5.x : OEXOEORD Unable to split Internal Sales Order lines manually from Sales ...
Oracle Inventory News Volume 9, May/June 2007
How To: Vision Demo - How To Use the Cancel PO API [ID: 1077153.1]
How To: ORDER MANAGEMENT SUITE CREDIT CHECK / EXPOSURE SETUP IN ORDER MANAGEMENT LIBRARY [ID: 444837.1]
How To: Multi-Org Credit Checking and Global Exposure [ID: 209479.1]
How To: Manage Global Agreement access setups [ID: 282880.1]
How To: How to use Budget Wizard functionality in WebAdi (step-by-step) [ID: 471044.1]
How To: How To Personalize Columns Names Downloaded On A Spreadsheet From A Compensation Workbench (CWB) Worksheet Via Web ADI? [ID: 389624.1]
How To: How to get a list of Internal Requisition that do not have an associated Sales Order [ID: 397514.1]
How To: How To Find Global Blanket Purchase Agreements From The Standard Purchase Orders or Vice Versa [ID: 578957.1]
How To: How to Create Profile Option GL: Default Desktop Viewer [ID: 556280.1]
How To: How to create a standard Purchase order referencing a Global Purchase Agreement [ID: 261852.1]
How To: How to create a Global Purchase Agreement [ID: 261850.1]
How To: How to Check The Correct Setup of Intercompany Accounts to Avoid the Error16 [ID: 1012982.102]
How To: How to Add 'Kosovo' to FND_TERRITORIES? [ID: 739280.1]
How To: Functionality to Enable Global Blanket Purchase Agreements for All Operating Units in Forms [ID: 745732.1]
How To: FAQ: Inventory Transactions Process Flow? [ID: 741477.1]
How To: FAQ: Inventory Standard Datafixes [ID: 568012.1]
How To: Create a Intercompany invoice AR and AP overviews [ID: 784679.1]
How To: (Pics) What Are The Steps Required To Setup An Internal Requisition In Purchasing? [ID: 406312.1]
How To: (Pics) How Can The Receiving Data Collection Script Be Run From Within The Oracle Application? [ID: 423279.1]
How to investigate printing issues and work towards its resolution ?
How to Create a Link to a Discoverer Workbook in Apps11i
Getting Reports Ouput to MS Excel - Techniques and References
FAQ: FAQ: Receiving Transaction Processor (RTP) [ID: 210188.1]
FAQ: FAQ - PO Document Control [ID: 1261814.1]
ETRM DIRECT ACCESS DOCUMENT
Diagnostics, Tracing and Debug Guide for Oracle Discoverer 4i (4.1)
Cannot Setup Defaulting Rule To Default Pricing Date from Sale...
Bulletin: Using Web ADI with Internet Explorer 7 [ID: 416321.1]
Bulletin: SE-SM: Carrier Ship Method Form - FAQ [ID: 122300.1]
Bulletin: Payables Suppliers Setup and Usage [ID: 204274.1]
Bulletin: Oracle Order Management Product Information Center [ID: 1273931.1]
Bulletin: Oracle Inventory News Current Edition [ID: 205.1]
Bulletin: List of Patches in Web Applications Desktop Integrator (Web ADI) for Releases 11i and 12 [ID: 726989.1]
Bulletin: Inventory Setup for Intercompany Invoicing [ID: 112437.1]
Bulletin: Intercompany Invoicing: Troubleshooting [ID: 112803.1]
Bulletin: Credit Checking Setup in Order Management [ID: 744642.1]
Advanced Barcode Strategies

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

  • Item Status

(N) Setup > Items > Status Codes

image

 

Status Attribute Definitions:

Users may define as many statuses as necessary to represent their business. The attributes and what they mean are given below so that the company implementing the E-Business Suite can decide how they want to use this functionality. The definitions of the attributes used in status control are given below.

Stockable: Allows you to store the item in an asset sub-inventory. (可以儲存在資產倉)

Transactable: Allows you to transact the item Inventory, Order Management, Purchasing and WIP. (可被交易)

Build in WIP: Allows you to build the item on a discrete job and/or a repetitive schedule (可以開工單)

Purchasable: Allows you to place the item on a purchase order (可以開採購單)

Customer Orders Enabled: Allows you to place the item on a sales order. (可以開銷售單)

Internal Orders Enabled: Allows you to create an internal sales order for the item. (可以開內部訂單)

BOM Allowed: Allows you to create a bill of material for the item. (可以建料表)

Invoice Enabled: Allows you to create an invoice for the item. (可以開立發票)

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

Units of Measure are defined once when setting up Oracle Applications

Each Box Dozen (一打)
image image image

 

Factors to consider when defining Units of Measure for your items:

  • What is the lowest Unit of Measure that you stock, cost and plan?
  • What conversions do you want to use for transaction purposes?
  • Are you going to define a default UOM for the primary unit of measure for an item?
  • What is the process to determine the primary UOM?
  • Do you need to define interclass conversions?

Defining Units of Measure encompasses three distinct areas:

Standard Conversions

Conversions that occur within the same class, without regard to the item being transacted are known as Standard conversions. An example of a Standard conversion is one within length, the conversion centimeters into meters.

Intra-class Conversions

A conversion within the same class, that is specific to the item being converted is known as an Intra-class conversion. An example of an Intra-class conversion within the UOM Class of Quantity: The Base UOM for Quantity is Ea. There are two UOMs in the Quantity Class, Each and Case. The Standard conversion for Case to Each is 1 Case = 24 Each. Item A has a mapping of 1 Case = 19 Each. All other items transacted by Case will use the 1:24 ratio, but if Item A is transacted it will use the 1:19 ratio.

Inter-class conversions

Conversions that occur across classes between UOM are known as Inter-class conversions. Inter-class conversions are item specific. For example, an inter-class conversion would be pounds to gallons and requires the identification of which items will use this mapping.

 

 

(R) Inventory Super User

(N) Setup > Units of Measure > Units of Measure

image

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

Enterprise Structure

image

 

  • Structure Example1

image

In this example, if the organizations used different functional currencies, they would have to be set up as separate inventory organizations. Inventory organizations inherit their functional currency from the Set of Books. This is not an updateable option. In this example, if the inventory organizations had different functional currencies, there would also need to be a second Set of Books. Even if the chart of accounts were the same and the calendar were the same, the functional currency difference would preclude these two locations from being one inventory organization.

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

  • Sep 25 Fri 2009 12:26
  • {Tips}

複製上一筆Record column Value : [Shit]+[F5]


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

如果你是繁體的環境

請將個人的Profile: FND: NATIVE CLIENT ENCODING  設成ZHT16BIG5 再重新Login ERP 就可以了


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

ORACLE ERP系統裡面不能複製/貼上問題解決方法

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

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

Oracle ERP提供了幾個Purge資料的Concurrent,供需要的人參考:

  • [AR] Receviables Archive and Purge
    1. Path:Archive and Purge
  • [AP/PO] Purchasing
    1. Path:Management>Purge:

    New 一個Submit Purge,並按[Initiate],再view Concurrent看看執行狀況,會產生報表給你看有哪些資料會被PURGE掉,確認好後,再進來Submit Purge中[Confirm]。

    • 需注意在Submit Purge如果有未完成的Purge Name,那麼你怎麼新增Purge條件,都不會成功的!!
  • [OM] Order Managment Super User
    1. Path:Orders,Returns>Purge>Purge Set
    2. Path:Orders,Returns>Purge>Order Purge Selection
  • [Ship] R12才有,Metalink說,在Ship Menu下

 

Oracle ERP Purge Way Study
(這個是我個人研究成果,歡迎大家參考與交流)

 

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

ERP Module List 

  • GL: General Ledger 總帳管理 
  • AR:Account Receivable 應收帳款管理
  • AP:Account Payable 應付帳款管理
  • FA: Fix Asset 固定資產管理 
  • NM:Notes Management 票據管理 (國內廠商客製產品)
  • GV:Government Uniform Invoice/Value Added Tax 發票及媒體申報系統 (國內廠商客製產品)
  • PO:Purchase Order Management 採購管理
  • OM:Order Management  銷售管理
  • Ship: Shipping 出貨管理
  • BOM : Bill of Material 物料表
  • INV: Inventory 庫存管理
  • WIP :Work in Process 工單管理
  • Treasury :資金管理

 

  • Government Uniform Invoice=>統一發票
  • Value Added Tax=>營業加值稅

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

Version : 11.5.10.2

Oracle ERP擁有以下的系統功能

  • 多幣別
  • 多帳本

但ERP中 一個帳本,只能有一個幣別、一組行事曆(Calendar)

ERP Framwork

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