Oracle eBS經驗分享

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

有用的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

• Item Status

(N) Setup > Items > Status Codes

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. （可以開立發票）

Units of Measure are defined once when setting up Oracle Applications

Each	Box	Dozen (一打)

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?

Enterprise Structure

• Structure Example1

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.

ps. 3C : Currency , Calendar , Chart of Accounts

• Structure Example 2

Consider a second scenario:

• Facility 1 - located in Florida
• Facility 2 - located in California

Would this situation be better as one inventory organization or two?

Assume that the functional currency issue for both organizations is the same and the decision has been made for them to report to the same set of books. The same question has to be asked again, would this be better as one inventory organization or two?

A few questions to ask:

• Do they use the same costing method?
• Is the inventory going to be co-mingled within a sub-inventory for both locations? If so, how is the physical quantity going to be controlled?
• Are there going to be physical shipments from one organization to another? Do they plan to use locator control?

If there are going to be physical shipments from one location to another, these will have to be modeled as sub-inventory transfers or locator to locator transfers within Oracle Inventory. If the physical distance is such the physical update is not real time, the company may want to consider separate inventory organizations. Sub-inventory and locator to locator transfers update the on hand balances real time and the transaction does not allow for intransit time. If two inventory organizations were created to model the physical locations, then intransit time could be modeled using inter-organization transfers.

•Assume the answer to question 1 is no, the two locations want to use different costing methods. In this scenario, the two facilities would have to be separate inventory organizations because there is only one costing method per organization.

•Assume the answers to questions 1 and 2 are no and yes respectively but the answer to question 3 is yes. Although it would not be required, the company may want to consider two inventory organizations in this scenario. If the company were to implement only one inventory organization it would require very strong internal control in order maintain integrity in inventory reporting. Locator control may be an option for two facilities in different locations but the physical difference and the resulting intransit time would make this option more challenging. Again, internal control and process control would have to be very strong in order to make this work.

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

如果你是繁體的環境

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

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下

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 :資金管理

Version : 11.5.10.2

Oracle ERP擁有以下的系統功能

• 多幣別
• 多帳本

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