My Oracle Support Banner

Troubleshooting Issues With The Inventory Supply/Demand Form - INVDVDSD (Doc ID 1161717.1)

Last updated on APRIL 09, 2019

Applies to:

Oracle Materials Requirement Planning - Version 11.5.9 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 22-MAY-2014***
Form:INVDVDSD.FMB - View Item Supply/Demand Information


Purpose

The Item Supply/Demand form is accessed through Inventory responsibilities, but the code for this form is owned by Core Manufacturing support and development.
The data displayed in the form comes from many products, including Inventory, Work In Process, Order Management, and Purchasing.
Many issues arise when data from these different products is displayed incorrectly or not at all.
It may be determined that a data fix is needed to address the display issues in the form.
In these situations, the corresponding product group will handle the data fix.
The purpose of this note is to help support and customers get detailed information about this issue and provide solutions as quickly as possible.

Issues for this form generally fall into 3 categories and below are Action Plans for each type:
1. No data displayed or form error
2. Dates or other data displayed is not correct
3. Performance issues with the form

How the Data is Gathered to be Displayed in the Form

The Form code is responsible only for passing the information about the item to a concurrent manager and then displaying the returned values, so tracing of the form is unlikely to reveal any issue with data or performance.
When the information is passed by the form, it calls the INV Remote Procedure Manager (INV RPC Mgr), which in turn calls a worker to execute the ProC code contained in $INV_TOP/bin/INCTM. The ProC code executes a number of queries (currently 20+) to ascertain the current status of an item from all areas of the transactional system. This information is loaded into the MTL_SUPPLY_DEMAND_TEMP table where it is used by the form to display the data. After the form is closed the data is removed from the table.

INV Remote Procedure Manager

Since each request for data uses a worker from the INV Remote Procedure Manager, it is recommended that most customers have a minimum of 3 workshifts defined for the manager. Many customers with heavy usage of this form will have a higher setting (5 to 10) so that user’s will not experience wait times caused by a lack of available workers to execute their request for information.
The Sleep Seconds for Workshifts defaults to 30. This can be reduced to help performance as noted in Performance Issues section below.
Understanding the Troubleshooting Steps for the Form
Troubleshooting and tracing issues in the Core code of the form requires special steps to gather the necessary information since most of the critical processing occurs in the INV Remote Procedure Manager as described above.
Since these steps can be involved, we have done the following:
Development is now releasing Rollup Patches that target only this form and functionality, plus related Inventory Statistical Forecast functionality. These patches are for customers on 11.5.7 - 11.5.10 and resolve many issues discovered over the last 3+ years. The patch readme lists the various fixes included.
We now have scripts to check the data for problems in several areas and can offer resolution to the issue by running standard scripts.
OR these scripts return information required for data fix scripts to be delivered by the respective teams responsible for the data.
We have developed a script in Note 404459.1 to run the entire latest C code in SQL and provide the output for review if the above steps do not resolve the issue.
This does require that the latest patch be applied to return fully correct results, since the changes to views to correct data issues would not be present unless the patch is applied.
Finally, we have the standard debug steps, which provide all the required information for Support and Development to debug the issue.


Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
 How the Data is Gathered to be Displayed in the Form
 INV Remote Procedure Manager
Questions and Answers
 How the Data is Gathered to be Displayed in the Form
 INV Remote Procedure Manager
 Understanding the Troubleshooting Steps for the Form
 Rollup Patches for INV Supply Demand
 Troubleshooting Issues with Data Displayed by the Form
 Data Displayed in the Form is Incorrect - Using the Data Check Script to isolate Data Corruption
 Data Cleanup for Sales Order Display Issues
 Data Corruption for Purchase Order or Requisition Display Issues
 Data Cleanup for MTL_ATP_RULES table
 Other Data Issues or Errors
 Form Does Not Display Any Data - APP-INV-05647 OR APP-INV-05649
 WIP Supply Reservation Still Showing For Closed Sales Order Line
 Why would a requirement for a WIP job still be present in the Item Supply/Demand Screen when the job is in status = Complete?
 Why do I have many rows in MTL_SUPPLY_DEMAND_TEMP with old dates for LAST_UPDATE_DATE column?
 The Post-Processing Lead Time for a PO Receipt is not calculated correctly. How can I correct this Date problem?
 Performance Issues
 Setup to Generate the Log and Trace Files
 FIRST STEP:
 IF REQUIRED/REQUESTED BY SUPPORT:
 Retrieving the Log and Trace Files
 How to Get the File Version information
 Output Checklist for Upload to the SR
 First Steps
 Advanced Debugging Checklist
 Keywords
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.