-
编辑 删除
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...
-
编辑 删除
xml report issue
these days we met a new case with xml report issue. As we run the report, the report finished with good. but the user run the report, the report finished with warning. As we checked with user, ...
-
编辑 删除
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 qty is negative
met issue: the user can't drop LPN, as check and found the avaible qty is negative. the onhand is 1, so line qty 2pickrelease qty 1but the aviable qty is -1 problem was user had manual...
-
编辑 删除
xml report finished with error
Caused by: java.io.UTFDataFormatException: Invalid UTF8 encoding.The xml page cannot be displayedan invalid character was found in text content When we run the report, only part of the data in...
-
编辑 删除
aviable onhan qty
SELECT PAR.ORGANIZATION_CODE ORG, MSI.SEGMENT1 ITEM, MSI.DESCRIPTION, msi.INVENTORY_ITEM_ID...
-
编辑 删除
2011-09-30
It has been a long time i haven't check my space. Everyday just busy with work. but i can't find any progress during my work. Maybe it is the time for me to think more than just doi...
-
编辑 删除
No discret job created in Oracle
No discret job created in Oracle When the user released item in ASCP but no Discret job has been created in Oracle.The cause is regarding the presence of duplicate items in BOM for the a...
-
编辑 删除
wip test
After the wip pick release;After the load the record(transfer lpn has generated), still can delete the record form. the form(Material Requirements form): after delete the record, the line status of t...
-
编辑 删除
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...
-
编辑 删除
追踪应用程序所执行的sql语句
http://space.itpub.net/23205405/viewspace-701457我们在确定应用程序性能的时候，更多地会关注其中SQL语句的执行情况。通常应用的性能瓶颈会在数据库这边，因此数据库的sql语句是我们优化的重点。 要对sql...
-
编辑 删除
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...
-
编辑 删除
IPR the destination org and source org is the same org
For the user misstake, sometimes the created the IPR with the source org org_A, but for SO shipping org also org_A. The SO can shipped successful, after the SO shipped confrim, the system automatical...
-
编辑 删除
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 ...
-
编辑 删除
Internal Requisition Internal Sales Order Via Receiving Open Interface
ROI - How To Perform. Receipt On Internal Requisition / Internal Sales Order Via Receiving Open Interface? [ID 365200.1] (come from metalink)Applies to: Oracle Inventory Management - Version: 11.5.1 ...
-
编辑 删除
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...
-
编辑 删除
rtf file can't find load xml data
Today we need to change one report, in the rtf file, i can't find the load xml data button. My colleague told me i need to open the TemplateBuilder.dot first, then i add the template with the p...
