Oracle Metalink Notes Collection

INV

Note 123456.1 Latest 11i Applications Recommended Patch List

Note 568012.1:FAQ: Inventory Standard Datafixes
Note 438787.1: What are the events passed using Custom library and when do they fire?
Note 438920.1 How To Customize Standard Oracle Application Using Custom Library
Note 402245.1 -  "Receiving Transactions Data Collection Script rcv11i_sa.sql".
Note 729265.1:How To Process Move Orders Using INV_MOVE_ORDER_PUB.
Note 29012.1 - TK Prof Different Useages
Note 141278.1 - Raw Trace and TKPROF
Note 295179.1 - To create MTI records
Note 338291.1 - Howto Enable WMS / MSCA Logging
Note 191477.1 - INV: Genealogy Prefix or Suffix
Note.357535.1 - Sample WMS Open Interface Insert Scripts / Examples howto Insert into Transaction Open Interface
Note.259673.1 - "Q: Physical inventory Open Interface or APIs? No.
Note.286755.1 - Debug Issues with Inventory Supply/Demand form
Note.141149.1 - Important INV profile option explainations
Note 398699.1 - Inventory Pending Transactions in MMTT Data Collection Test
Note 402574.1 - MOQD MSN mismatch
Note 279205.1 - MOQD MMT mismatch
Note:401220.1 - Unsuccessful row construction in MSCA for Subinventory field
Note 168083.1 - Simple Drop Shipment Flow
NOTE:406390.1,364738.1,365454.1,387882.1,420999.1 - Consigned Inventory
NOTE:190028.1 - Flow for ATO Configurations
Note:179661.1-中包含了诊断工具的11.5.9之后版本的所有信息，也有库存和采购的，如果可能的话，在TAR的用户数据获取时尽量采用这些标准模板。
Note 402574.1 - Onhand Quantity Mismatch MTL_SERIAL_NUMBERS And 
MTL_ONHAND_QUANTITIES_DETAIL
Note 223702.1 - Inventory Item Setup Data Collection Tool
Note 279205.1 -  Find Mismatch Between MTL_MATERIAL_TRANSACTIONS (MMT) and 
MTL_ONHAND_QUANTITIES_DETAIL (MOQD)
Note 132629.1 - How to know which row is locked by what user.
Note 166650.1 - Working Effectively With Global Customer Support
Note 268973.1-To Find Duplicate Records in MMT , MMTT and MTI (Sales Orders/Internal Orders)
Note.737442.1-Int/Arc FAQ Work in Process (WIP) Standard Datafixes
Note 268974.1-To Review The Stock Picture For An Item in a Given Organization / Subinventory
Note 737157.1- FAQ: Costing Standard Datafixes
Note 601623.1 - How To Diagnose Issues Related To Inter-Organization Transfers
726226.1-INV/WMS/RCV Family Patch Release History / Patchsets / RUPs
Note 726226.1

Data Collection
Note 205049.1 - 11i : Oracle Inventory General Setup Test
Note 223702.1 - Item Diagnostics(Inventory Item Setup Data Collection Tool)
Note 148651.1-INV DEBUG: How to get Debug Information for Inventory 
Note 299497.1 - RCV debug
Note 402245.1 - RCV11i
Note 316142.1-Discrete Job Diagnostic script wipjob11i.sql
Note 207398.1  - Duplicate WIP Component Issue Check Diagnostic Script
Note 276207.1 - Diagnostics : Apps Check
Note.133464.1 - OMSE11i
Note 150168.1 - FRD Trace
Note 373548.1 - FRD Trace in 
Note 148651.1,Note 210188.1 - INV/Debug log file
Note 290432.1 - Shipping Log File
Note 277655.1 - Mobile Trace
Note 276211.1 - Shipping Transactions Diagnostic Report (wshord11i.sql)
Note 463601.1 - Inventory Organization Data Collection Setup Test
Note 378348.1 - Data Collection Scripts for Cost Management
Note 206576.1 - Oracle Inventory Period Closing Activity Test
Note 398700.1 -Oracle Inventory Open Interface Transactions (MTI) Data
Note 463579.1  - Inventory Serial Number Information Setup Test

Cycle Count
Note 732843.1 - R12 and 11i Troubleshooting Guide for All Cycle Count  issues: No Data Returned or Cycle Count Not Picking Up Enough Items
MetalinkNote 458727.1 Cycle Count ITAR Template Metalink Note 66634.1 - Cycle Count - How To" to create a new ABC Compile, ABC Class, ABC Assignment Group, and cycle count.
Metalink Note 199620.1 - Schedule and Perform Full Cycle Count
Metalink Note 76805.1 - Steps to Compile an ABC to Use for Cycle Counting
Metalink Note 76804.1 - Steps to Define and Complete a Cycle Count
Metalink Note 199639.1 - Approving Cycle Count Corrections
Metalink Note 199636.1 - Entering Cycle Counts in Release 11i INV-115
Metalink Note 199619.1 - Define Cycle Count and Set Cycle Count Classes
Metalink Note 199638.1 - Approving Cycle Counts Held for Approval and Approving Cycle Count Adjustments
Metalink Note 76807.1 - How the Cycle Count Process Determines which Items are Due for Cycle Counting
Metalink Note 1043388.6 - CYCLE COUNTING COUNTS ITEM MORE THE REQUESTED TIMES
Metalink Note 102488.1 - Inventory Current Issues: Cycle Count
Metalink Note 416149.1 - 11i FAQ How Cycle Counting Works and how to ensure that cycle counts are scheduled based on setup class and frequency to meet audit requirements
Note 342741.1 11i Cycle Counting: Items That Should Be Counted In The Quarter Have Not Come Up For Count 

ROI Documentation
Note 559956.1: ROI Features + Transactions supported in various releases
Note 437587.1: ROI in R12
Note 290489.1- 11510 ROI transactions supported

ROI transactions against PO
Note:467037.1 - How Do We Create A Roi Receipt For Po Line That Is Fixed Price Or Rate Type? 
Note:368811.1 - 11.5.10 ROI How To Perform Purchase Order Receipt For Lot and Serial Controlled Item ?
Note:461928.1 - How Is ASN_TYPE Field In RCV_HEADERS_INTERFACE Used?
Note:549609.1 - 11.5.10 ROI How To Create ASN / Perform Receipt For ASN Already Created Via ROI?
Note 301624.1 - How to Receive and Deliver Against ASBN by ROI (partially)
Note 445274.1 - 11.5.10: Which Interface Tables are Used by ROI to Process ASNs With LPNs?
Note 374162.1 - PO Receipt & Deliver for Expense/Inventory destinations, Plain/Lot/Serial/Lot-Serial Items.

ROI transactions against RMA
Note 435275.1, 270760.1 & 339835.1 - RMA thru ROI (not supported before 11510)
Note 302987.1 - How to create DELIVER transaction against RMA with lot/serial controlled item by ROI

ROI transactions against Internal shipments: ISO & IOT
Note 336924.1 - How to Receive Intransit Shipment (Inter-organization Transfer) using ROI - 11.5.10
Note:342610.1 - Receive Intransit Shipment (Inter-org transfer) for Lot / Serial Controlled Items via Receiving
Note:365200.1 - 11.5.10 ROI How To Perform Receipt On Internal Requisition / Internal Sales Order Via Receiving Open Interface?

Generic scripts for various receiving transactions
Note:335699.1 - 11.5.10 ROI How to Correct Receiving Transaction with Receiving Open Interface?
Note:360340.1 - 11.5.10 ROI How to Return Receiving Transaction with Receiving Open Interface?
Note 60340.1  - Return txns thru ROI
Note 301281.1: 11.5.10/R12: Which Interface Tables are Used by ROI to Process Serial and Lot Controlled Items?


Note 29012.1 - TK Prof Different Useages
Note 295179.1 - To create MTI records
Note 148651.1 - INV/Debug log file
Note 290432.1 - How to Create a Debug File in Shipping Execution
Note 150168.1 - FRD Trace
Note 438652.1 - FRD Trace R12
Note 373548.1 - FRD Trace R12
Note 338291.1 - Howto Enable WMS / MSCA Logging?
Note 277655.1 - SQL*Trace with WMS-MWA: Mobile Applications (Tracing SQL via Database Trace to allow for TKPROF of results of user actions)
Note 190893.1 - Oracle Inventory Support Service Request Instrumentation for Organization Setup
Note 251415.1 - SQLTXPLAIN.SQL - Enhanced Explain Plan and related diagnostic info for one SQL statement
Note 305404.1 - Oracle Inventory Item Information Data Collection Test
Note 223702.1 - Inventory Item Setup Data Collection Tool
Note 191477.1 - INV: Genealogy Prefix or Suffix
Note.357535.1 - Sample WMS Open Interface Insert Scripts / Examples howto Insert into Transaction Open Interface:
Note.259673.1 - "Q: Physical inventory Open Interface or APIs? No.
Note.286755.1 - Debug Issues with Inventory Supply/Demand form
Note.141149.1 - Important INV profile option explainations
Note.395981.1 - Cost Manager Not Processing Because of Error CST_INVALID_INTERORG
Note.356771.1 - Cost Manager Not Processing Because of Error CST_INVALID_INTERORG
Note.273922.1 - INCTPC -Cannot Close Accounting Period Due to Status = Processing
Note.133464.1 - Sales Order Diagnostics patch (omse11i)
Note:415537.1 - Physical Inventory Adjustments ends in error
Note:221211.1 - Inventory Move Orders diagnostics patch
Note:60647.1 - About Physical Inentory
Note:135389.1 - Using profile option 'Initialization SQL Statement - Custom'
Note:301524.1 - Receiving Transactions Fails With RVTTH-115F / RVTTH-115D Error (Missing Move Order Datafix)
Note 387838.1 - Serial Number &TOKEN Does Not Exist For The Given Item Leading/Trailing Spaces
Note 413174.1 - Miscellaneous Receipt Getting App-Inv-05011: Cannot Convert Quantities To Ea In Routine UE:XACT_QTY0
Note 283740.1 - Inventory Java Versions Data Collection Script
Note 282480.1 - Cannot Issue Locator Controlled Item - Locator and Onhand Subinventory Do Not Match
Note 279205.1 - Find Mismatch Between MTL_MATERIAL_TRANSACTIONS (MMT) and MTL_ONHAND_QUANTITIES_DETAIL (MOQD)
Note 298250.1 - Troubleshooting WMS / MSCA Label Printing
Note 377205.1 - Cst_match_date_ Period The Txn Date Is Not Within The Acct Period When Costing Transactions
Note 306173.1 - Subinventory Priority While Allocating A Move Order In A Move Order Requisition
Note 200066.1 - Transactions are Stuck in MTL_TRANSACTIONS_INTERFACE Table With Invalid Serial Number Status
Note 398700.1 - Inventory Open Interface Transactions (MTI) Data Collection Test
Note 239627.1 - How To Obtain the CSE/CSI Log and Debug Files For Your Oracle Support Analyst
Note 186472.1 - Diagnostic Scripts: 11i - Hanging SQL - Find the Statement Causing Process to Hang
Note 249669.1 - How To Collect Apache and Jserv Debugging Details For Applications 11i
Note 461611.1 - Tag Counts In Physical Inventory Do Not Allow Duplicate Serials Across Items
Note 317412.1 - How To Override Cross Docking Suggestion
Note 375282.1 - There Must Be A Valid Blanket Purchase Agreement In Effect For The Item You Wish To Transact
Note 336778.1 - Consignment Transactions Error With Must Be A Valid Blanket Purchase Agreement
Note 416678.1 - R12 : Deferred COGS account
Note 120183.1 - How To Investigate Mtl_demand_interface Errors
Note 249738.1 - 11i - Intercompany Invoicing Does Not Work Properly
Note 316365.1 - Oracle Applications Release 11.5.10.2 Maintenance Pack Installation Instructions
Note 462174.1 - Problems With View On-Hand Quantities Form
Note 402245.1 - Receiving Transactions Data Collection Script rcv11i_sa.sql
Note 277655.1 - SQL*Trace with WMS-MWA: Mobile Applications (Tracing SQL via Database Trace to allow for TKPROF of results of user actions)
Note 398700.1 - Inventory Open Interface Transactions (MTI) Data Collection Test.
Note 398699.1 - Inventory Pending Transactions in MMTT Data Collection Test
NOTE:406390.1,364738.1,365454.1,387882.1,420999.1 - Consigned Inventory
NOTE:190028.1 - Flow for ATO Configurations
Note 402245.1 - RCV11i
Note 136098.1 - User_id, responsibility_id, RESPONSIBILITY_APPLICATION_ID
Note 400088.1 - Distribution_account_id
Note 353345.1 - Consolidate inventory onhand
Note 223702.1 - Item Diagnostics
Note 166923.1 - COMMON ISSUES FOR RECORDS STUCK IN INVENTORY PENDING TRANSACTIONS
Note 404336.1 - How Many Processes Should Be Set For The Receiving Transaction Manager (RTM)?
Note 168083.1 - Simple Drop Shipment Flow
Note 276207.1 - Diagnostics : Apps Check
Note 402574.1 - MOQD MSN mismatch
Note 279205.1 - MOQD MMT mismatch
Note:401220.1 - Unsuccessful row construction in MSCA for Subinventory field
Note 337325.1 - Intercompany Transactions
Note 336129.1 - Intercompany Invoicing Overview
Note 417875.1 - Serial Number FAQ
Note 332697.1 - 11.5.10 RCVRCERC - Internal Sales Order Receipts Fail with 'rvtptcontrol failed' and 'WMSINB-22192:Lot/Serial
Note 376505.1 - Unable to Receive Inter-Organization Transfers "rvtptcontrol failed"
Note 141118.1 - How To Relink Forms Library Files Using Adadmin
Note 414943.1 - R: Xml Output Getting Emsg: Signal 11-Glibcdetected Corrupted Double-Linked List
Note 315741.1 - Basic Setup To Achieve Skip Lot Inspection Functionality In Receiving Quality Inspection
Note 405632.1 - Item Definition with Chargeable Subcontracting
Note 273044.1 - FLEXFIELD: Validate on Server Profile Option
Note 363377.1 - WMSINB-23178 - Lot/Serial Validation Fail Error For Receipt
Note 303365.1 - POXRQSDD: Internal Requisitions/Deliveries Discrepancy Report Not Displaying Correct Information
Note 303088.1 - 11.5.10 - Only First Line is Split When Performing Partial Receipt for Multiple Line RMA
Note 391554.1 - Oracle Application Framework Documentation Resources
Note 11.1 - "Demo It To Oracle" (DITO) - CamStudio Help
Note 203238.1 - Using Parallel Executio