-
编辑 删除
cost rollup
Indented Bills form,if we choosed the costs, cost type, in the find result form, we will see costed. we found some Assembly the costed has choosed, some didn't. checkec on metalinke with following is...
-
编辑 删除
transaction value is 0 Zero
Issue: the item issued to wip job, some of the transaction value is zero, some of the transaction is not zero.Then I checked the item’s transaction, and found there is no receive for item A to...
-
编辑 删除
請教透過rcv_headers_interface和rcv_transactions_interface進行自動收料的問題
就是这三个,没想法这三个栏位很重要.INSERT INTO rcv_transactions_interface (interface_transaction_id ,header_interface_id ,group_id ,interface_source_code&nbs...
-
编辑 删除
clean interface table
Because of some reason, we need to clean the following interface table: INCOIN: Why Should the Interface Tables Be Truncated [ID 1347604.1]RCV_TRANSACTIONS_INTERFACEMTL_TRANSACTIONS_INTERFACE...
-
编辑 删除
datafix for misc receipt
---receiptINSERT INTO mtl_transactions_interface (transaction_interface_id, transaction_header_id, source_code, source_header_id, source_line_id,&...
-
编辑 删除
datafix for project transfer
INSERT INTO MTL_TRANSACTIONS_INTERFACE (TRANSACTION_HEADER_ID, TRANSACTION_INTERFACE_ID, SOURCE_CODE, SO...
-
编辑 删除
check form personization
select * from apps.FND_FORM_CUSTOM_RULESwhere function_name like '%INVIDITM%'
-
编辑 删除
RMA receive issue
When the user perfomer RMA receive: Cost Of Goods Sold Account Generation Failed with error : Value secured: Wrong Legal Entity!RCV_COGS_ACC_GEN_FAILED (ACCOUNT=.....-0-0-0) We also raise SR fo...
-
编辑 删除
aviable onhan qty
SELECT PAR.ORGANIZATION_CODE ORG, MSI.SEGMENT1 ITEM, MSI.DESCRIPTION, msi.INVENTORY_ITEM_ID...
-
编辑 删除
Transaction Type ‘WIP cost update’
WIP cost update is a transaction that occurs when the component issued to a job and after that the component cost is changed through a standard cost update.. When the component cost is increased, the...
-
编辑 删除
CST_MAT_OVERHEAD
CSTPACIN.COST_INV_TXN:Cannot apply material overhead because this level material overhead subelements already exist.Applies to: Oracle Cost Management - Version: 11.5.8 to 11.5.10.3 - Release: 11.5 t...
-
编辑 删除
cycle count with no adjust value
When the user do cycle count, we found some items adjust value is 0. as worked with oracle for a long time and get this reply:Has customer viewed the item cost history for the item against the ...
-
编辑 删除
Quantity Delivered vs Detailed in Move Order Lines
Quantity Delivered vs Detailed in Move Order Lines (MTL_TXN_REQUEST_LINES) [ID 431479.1]b. What tables are used in the move order process?1) MTL_TXN_REQUEST_HEADERS: Move order headers, this stores t...
-
编辑 删除
Inventory Asset Value
If you want to make costing enabled attribute at organization level, then set this attribute to organization level. Now you can disable Inventory Asset flag Explanation on this Functionalit...
-
编辑 删除
costed error
Check on metalink for this issue. and i gueUncosted Transactions with Error Message CST_MATCH_TXFR_CG_TXFR_ORG [ID 362133.1]6:45:10 PM: Hui Wang: Uncosted transactions with error CST_MATCH_TXFR_CG_OR...
-
编辑 删除
update locator
Sometimes, the user found some items have onhand qty, but without locator.The user provide us the locator, we will do the following update:--------1 row will be updated------------update apps.mtl_ma...
-
编辑 删除
再订购点计划(Reorder Point Planning)概览
转载：http://blog.csdn.net/oraclebs/archive/2008/10/30/3186419.aspx当数量降到预定的再订购点时，可以使用再订购点计划来订购数量。在理想情况下，最好在库存水平降到安全区之前进行再订购。在再订购点之间安全...
