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

Last updated on DECEMBER 20, 2023

Applies to:

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

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