Top Metalink Notes for Inventory

General

• 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 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
• Note 726226.1-INV/WMS/RCV Family Patch Release History / Patchsets / RUPs

Inventory 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
• Note 458727.1 Cycle Count ITAR Template  Note 66634.1 - Cycle Count - How To" to create a new ABC Compile, ABC Class, ABC Assignment Group, and cycle count.
•  Note 199620.1 - Schedule and Perform Full Cycle Count
•  Note 76805.1 - Steps to Compile an ABC to Use for Cycle Counting
•  Note 76804.1 - Steps to Define and Complete a Cycle Count
•  Note 199639.1 - Approving Cycle Count Corrections
•  Note 199636.1 - Entering Cycle Counts in Release 11i INV-115
•  Note 199619.1 - Define Cycle Count and Set Cycle Count Classes
•  Note 199638.1 - Approving Cycle Counts Held for Approval and Approving Cycle Count Adjustments
•  Note 76807.1 - How the Cycle Count Process Determines which Items are Due for Cycle Counting
•  Note 1043388.6 - CYCLE COUNTING COUNTS ITEM MORE THE REQUESTED TIMES
•  Note 102488.1 - Inventory Current Issues: Cycle Count
•  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 Execution
• Note 605248.1 - Inventory Suite Patching Strategy For One-Off Requests and RUPs
• Note 294670.1 - Oracle Mobile Applications (MSCA/WMS) Graphical User Interface
• Note 277332.1 - Receipts For Drop Ship Purchase Orders Fail With Rvtii-060 - Subroutine inltpu() returned error
• Note 372432.1 - How to Trace the Receiving Transactions
• Note 66634.1 - Cycle Count - How To" to create a new ABC Compile, ABC Class, ABC Assignment Group, and cycle count.
• Note 199620.1 - Schedule and Perform Full Cycle Count
• Note 76805.1 - Steps to Compile an ABC to Use for Cycle Counting
• Note 76804.1 - Steps to Define and Complete a Cycle Count
• Note 199639.1 - Approving Cycle Count Corrections
• Note 199636.1 - Entering Cycle Counts in Release 11i INV-115
• Note 199619.1 - Define Cycle Count and Set Cycle Count Classes
• Note 199638.1 - Approving Cycle Counts Held for Approval and Approving Cycle Count Adjustments
• Note 76807.1 - How the Cycle Count Process Determines which Items are Due for Cycle Counting
• Note 1043388.6 - CYCLE COUNTING COUNTS ITEM MORE THE REQUESTED TIMES
• Note 102488.1 - Inventory Current Issues: Cycle Count
• 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 406312.1 - ISO cycle
• Note 301372.1 - Concurrent program database trace with Binds and waits
• Note 420787.1 - Oracle Applications Multiple Organizations Access Control for Custom Code

Autoconfig

• 218089.1  Autoconfig FAQ
• 165195.1  Using AutoConfig to Manage System Configurations with Oracle Applications 11i
• 387859.1  Using AutoConfig to Manage System Configurations in Oracle Applications Release 12 
• 270519.1  Customizing an AutoConfig Environment
• 364927.1 How To Run Autoconfig On Database Tier (DB-Tier)
• 341322.1 How to change the hostname of an Applications Tier using AutoConfig
• 338003.1 How to change the hostname and/or port of the Database Tier using AutoConfig
• 315674.1 How To Verify if Autoconfig is Enabled on 11.5.x
• 391406.1 How to get a clean Autoconfig Environment

Read More»