目前日期文章:200910 (11)

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

報表的Size

Report Size 單位 A4 (直印) A4 (橫印)
mm 210 x 297 297 x 210
Report Layout Section Width/Height 8.5 x 11 (inches) 11 x 8.5 (inches)
characters 66 x 80 132 x 66

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

Oracle Workflow Builder

認識元件:

  • Store : A Store is the highest level in a workflow and consists of  a number of flow save together.

image

上圖有兩種Store case(one is database , another is a flow stored as local file system)

Save as location filename,filename will be (*.wft)

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

問題:使用Personal Framework 開Workflow List 出現此錯誤

image

Solution: Reference Doc ID: 296470.1

Starting with Oracle Applications 11.5.10, all PL/SQL web cartridge UI has been obsoleted. As a result, please use the Framework version of Portal.  Make sure that the profile option Self Service Personal Home Page is set to FRAMEWORK ONLY at the SITE level and that the Workflow Administrator Web(NEW)  responsibility


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


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

image

image

Enable Uppercase Only (A-Z)

image

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

常用 Table關聯

MTL_MATERIAL_TRANSACTIONS. MOVE_ORDER_LINE_ID = MTL_TXN_REQUEST_LINES. LINE_ID
WSH_DELIVERY_DETAILS. MOVE_ORDER_LINE_ID = MTL_TXN_REQUEST_LINES. LINE_ID
OE_ORDER_HEADERS_ALL HEADER_ID = OE_ORDER_LINES_ALL LINE_ID

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

Responsibility : Inventory Super User

1. Choose Organization to Destination Organization

2. Create Cost Type

Path : Setup > Costs > Cost Types

image

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

1. Create "Cost Type"

Responsibility: Inventory Super User

Path: Setup > Costs > Cost Types

1.1 Choose Inventory Organization

1.2 Entry Cost Type Information

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

找更多相關文章與討論