Skip navigation

As many of you already know, the Supply/Demand Inquiry (a.k.a. S&D Inquiry) screen is used frequently. Many MRP users rely on S&D Inquiry more than they do the MRP Time Series. However, how many people really look at all of the functionality that S&D Inquiry can perform?


For example:


Supply & Demand Inquiry displays data input from six major applications:


MRPP3482 or P3483 and F3411, F3412 and F3413
ForecastingP3460 and F3460
Purchase OrdersP4311 and F4311
Sales OrdersP4211 and F4211
Work OrdersP48013 and F4801, WO Parts List (P3111) and F3111
Rate SchedulesP3109 and F3109


Accessing these applications is as easy as inquiring on an item number and branch plant. From there, the following selection options are displayed:


Selection Option
Work Order Header1
Work Order Detail2
Sales Order Entry3
Purchase Order Entry4
Customer Service Inquiry5
Purchase Order Inquiry6
Enter/Change Rate Schedule7
Return Promise Delivery Date8
Transfer Orders9


Several function keys also work within S&D Inquiry as well. They are:


Header 1Header 2
Part AvailabilityF9
Scheduling WorkbenchF10
Message DetailF14
Time Series / ATP InquiryF15
Pegging InquiryF16
Item AvailabilityF17
Manufacturing ValuesF18


Several requests have been received to see if the sort can be changed within this inquiry program. However, there is no processing option or other type of setting that will allow you to change the sequence or order in which records display in the P4021. The records, both supply and demand, that appear in the P4021 are displayed in the video because those order lines have reached a "Selected" status value as defined in the Supply/Demand Inclusion Rules (P34004) for the related order type/line type.


Note: In order to determine which Supply/Demand Inclusion Rule is used in your inquiry, processing option 6 in the P4021 tells you.


Best Practice for MRP Users:

When analyzing MRP data, users should focus on the Time Series (P3413) and use the S&D Inquiry to obtain details such as order numbers.  The Time Series will display both adjusted and unadjusted values while S&D Inquiry uses unadjusted values only.  “Unadjusted” means that the user has not acted on (or processed) any of the MRP messages that are displayed in the MRP Detail Message screen (P3411).  In other words, users would be looking at a ‘worst-case scenario’.  “Adjusted”, on the other hand, means that the user has processed some or all MRP messages and that as a result, the beginning - and ending - available inventory, as well as the planning for future WOs or POs will be affected.


For additional information about Supply/Demand Inquiry see Understanding Supply & Demand Inquiry P4021 (Doc ID 1933828.1).

How many times have you looked at your frozen standard cost and asked yourself why does this cost look so high? Or, for that matter, why does the cost look so low?


Beginning with A9.3.0.2 and above, the capability to display cost changes in history is now available.  A new video ‘Item Cost Component History’ (V30026H) has been added and if you prefer, you can also print out these changes in a report.


The file storing the cost changes is the Cost Component Add-Ons History (F30026H) which was also added as of A9.3.0.2 in an enhancement for the manufacturing costing module in order to help Cost Accountants keep a history of standard cost changes.


To access the history display, from the Enter/Change Cost Components screen (2/G3014) inquire on an item and press the function key F9. The Item Cost Component History (P30026H) displays which includes a column for action code types such as A for a cost addition or new cost, C for a cost change or D for cost deleted. The data displayed is in descending date order (newest date first) and is sorted alphabetically by cost type.  If user selects option 1 from the P30026H the audit information window for each transaction listed is shown, as well as the program ID of the record that made the update, work station id, address book number of person making the change along with the time and date that the change was made.


If you prefer to print the history information, pressing function key F21 from the Item Cost Component History creates the spool file J30026HS where the R30026HP may be selected for print or review for the specific item being inquired upon.  In addition, a new batch report resides for the Item Cost Component History. This report is located on the menu Periodic Product Costing, menu G3023 and menu item 7 - Item Cost Component History (P30026HP).

Welcome to the My Oracle Support Community! We highly encourage you to personalize your community display name to make your activity more memorable. Please see for instructions.