ITPub博客

1.Form里查看Last_QuerySYSTEM.LAST_QUERYRepresents the query SELECT statement that Oracle Forms most recently used to populate a block during the current Run form session. The value is always a character string.从上面的Last_Query定义的解读：1.SYSTEM.LAST_QUERY返回的只能是查询(Select)的SQL语句，不会有Update,Insert,Delete SQL语句;2."The current Run form session"说明不同的Form，SYSTEM.LAST_QUERY可以有不同的值的，不会混淆;3."Used to po

Help > Record History

Building Reports Using Oracle\'s Flexfield Support APIReal Time Migration of Oracle Application Setups Done In HouseMigrating from SQL Server 2000 to Oracle 9iOracle 11i Receivables Implementation PrimerOracle 11i Shipping Execution – Interface Trip Stop Trouble ShootingOracle Application Database Management Part I - Take Database Monitoring in Oracle Applications Manager to the Next LevelOracle Application Database Management Part II - Navigating Oracle Applications ManagerOracle Key Fle

WIP > Material Transactions > Work Order-less Completions Work Order less completion(无工单完工入库)，可以不用创建工单(discrete job),就可以完工入库的方法,这个流程里，用户直接输入assembly和生产的数量，提交后，成品数量的库存数量就会立即增加。 Component中指定组件的信息 红色区域为Work Order less completion所引发的成品的WIP Completion事务和组件的WIP Issue事务，可以看到Source为Work Ord

发现菜单里“Close Other Forms”灰显，不允许更改 Solution System Administrator,Navigate to Security > Responsibility > Define. Query the responsibility in which you want to allow to control the Close Other Forms option. In the Menu Exclusions, enter a function Name: Navigator: Disable Multiform Save changes.

WIP_DISCRETE_JOBS.STATUS_TYPE Value Meaning 7 Cancelled 8 Pending Bill Load 9 Failed Bill Load 10 Pending Routing Load 11 Failed Routing Load 12 Closed 13 Pending - Mass Loaded 14 Pending Close 15 Failed Close 1 Unreleased 3 Released 4 Complete 5 Complete - No Charges 6 On Hold

WMS_LICENSE_PLATE_NUMBERS.LPN_CONTEXT LOOKUP_TYPE LOOKUP_CODE MEANING WMS_LPN_CONTEXT 1 In Inventory WMS_LPN_CONTEXT 2 In WIP WMS_LPN_CONTEXT 3 In Receiving WMS_LPN_CONTEXT 4 Issued out of Stores WMS_LPN_CONTEXT 5 Defined but not used WMS_LPN_CONTEXT 6 Intransit WMS_LPN_CONTEXT 7 At Vendor WMS_LPN_CONTEXT 8 Packing context WMS_LPN_CONTEXT 9 Loaded to Dock WMS_LPN_CONTEXT 10 Prepack for WIP WMS_LPN_CONTEXT

WIP_DISCRETE_JOBS.WIP_SUPPLY_TYPE Value Meaning 1 Push 2 Assembly Pull 3 Operation Pull 4 Bulk 5 Supplier 6 Phantom 7 Based on Bill

WIP_ENTITIES.ENTITY_TYPE Value Meaning 1 Discrete job 2 Repetitive assembly 3 Closed discrete job 4 Flow schedule

MTL_TXN_REQUEST_HEADERS.HEADER_STATUS  or MTL_TXN_REQUEST_LINES.LINE_STATUS Value Meaning 1 Incomplete 2 Pending Approval 3 Approved 4 Not Approved 5 Closed 6 Canceled 7 Pre Approved 8 Partially Approved

MTL_TXN_REQUEST_HEADERS.MOVE_ORDER_TYPE LOOKUP_TYPELOOKUP_CODEMEANINGDESCRIPTIONMOVE_ORDER_TYPE1RequisitionMove Order RequisitionMOVE_ORDER_TYPE2ReplenishmentMove Order Type created from replenishmentMOVE_ORDER_TYPE3Pick WaveMove Order Type created for outbound shippingMOVE_ORDER_TYPE4ReceiptMove Order Type for receiving transactionsMOVE_ORDER_TYPE5Manufacturing Component PickMove Order Type created from Component Pick ReleaseMOVE_ORDER_TYPE6Put AwayPut AwayRequisition Move OrdersManually Gene

MTL_SYSTEM_ITEMS_B.LOCATION_CONTROL_CODE LOOKUP_TYPE LOOKUP_CODE MEANING MTL_LOCATION_CONTROL 3 Dynamic entry locator control MTL_LOCATION_CONTROL 5 Locator control determined at item level MTL_LOCATION_CONTROL 4 Locator control determined at subinventory level MTL_LOCATION_CONTROL 1 No locator control MTL_LOCATION_CONTROL 2 Prespecified locator control

MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODE LOOKUP_TYPE LOOKUP_CODE MEANING MTL_SERIAL_NUMBER 1 No serial number control MTL_SERIAL_NUMBER 2 Predefined serial numbers MTL_SERIAL_NUMBER 5 Dynamic entry at inventory receipt MTL_SERIAL_NUMBER 6 Dynamic entry at sales order issue

MTL_SERIAL_NUMBERS.CURRENT_STATUS LOOKUP_TYPE LOOKUP_CODE MEANING SERIAL_NUM_STATUS 1 Defined but not used SERIAL_NUM_STATUS 3 Resides in stores SERIAL_NUM_STATUS 4 Issued out of stores SERIAL_NUM_STATUS 5 Resides in intransit SERIAL_NUM_STATUS 7 Resides in receiving SERIAL_NUM_STATUS 8 Resides in WIP

WSH_DELIVERY_DETAILS.RELEASED_STATUS DeliveryLine Status Description N Not Ready to Release R Ready to Release S Released to Warehouse B Backordered Y Staged X Not Applicable C Shipped/Closed D Cancelled

TRANSACTIONSOURCE TYPE ID TRANSACTIONSOURCE NAME DESCRIPTION 1 Purchase order Purchase order 2 Sales order Sales order 3 Account Account 4 Move order Move order 5 Job or Schedule Job or Schedule 6 Account alias Account alias 7 Internal requisition Internal requisition 8 Internal order Internal order 9 Cycle Count Cycle Count 10 Physical Inventory Physical Inventory 11 Standard cost update Standard cost updat

TRANSCTIONACTION ID  DESCRIPTION 1 Issue from stores 2 Subinventory transfer 3 Direct organization transfer 4 Cycle count adjustment 8 Physical inventory adjustment 12 Intransit receipt 21 Intransit shipment 24 Cost update 27 Receipt into stores 28 Staging transfer 29 Delivery adjustments 30 WIP scrap transaction 31 Assembly completion 32 Assembly return 33 Negative component issue 34

Transaction Type = Transaction Source Type + Transaction Action Type TRANSACTIONTYPE ID TRANSACTIONNAME DESCRIPTION TRANSACTIONSOURCE ID TRANSACTIONACTION ID 1 Account issue Issue material against account 3 1 2 Subinventory Transfer Transfer material betweensubinventories 13 2 3 Direct Org Transfer Direct transfer betweentwo organizations 13 3 4 Cycle Count Adjust Record cycle count adjustments 9 4 5 Cycle

A Cost Group is the set of accounts that hold on hand inventory. Before the advent of Cost Groups, subinventories in an Oracle Inventory organization defined both the physical and accounting attributes of the material. Different subinventories represented functional/processing requirements, packaging/material handling characteristics or storage/control characteristics. In each warehouse zone, different accounts were maintained by creating separate subinventories, and preassigning locators

Material Workbench Form，Inbound选项用于查询，“在途数量”，“采购订单数量”，“ASN数量” x01为Inter Org的shipment编号 6245为采购订单编号