Skip navigation
1 2 3 Previous Next

JD Edwards World Support Blog

104 posts

attention.jpgPremier Support for release A9.3/A9.3.1 ended on March 31, 2020. While you can remain on JD Edwards A9.3/A9.3.1 and continue to acquire Sustaining Support for access to our Global Services team, as well as access to existing fixes for known A9.3/A9.3.1 issues, we highly recommend you consider migrating to JD Edwards EnterpriseOne 9.2. JD Edwards EnterpriseOne 9.2 is part of the Applications Unlimited commitment to continuous innovation. Oracle JD Edwards provides a commitment to offer Oracle Premier Support through at least 2030. For more information, see Doc ID 2628927.1. http://ora.cl/Bp7bl

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:

 

ApplicationProgram/File(s)
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:

 

Program
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).

JD Edwards World Release A9.3 (including A9.3.1)

  • The last day of Premier Support is March 31, 2020. Release A9.3/A9.3.1 will have ongoing Sustaining Support for access to our Global Services team, as well as access to existing fixes.

 

JD Edwards World Release A9.4

  • Provides Premier Support and updates until 2022 and Extended Support through 2025.

 

Where is this documented for customers?

The Lifetime Support Policy

plan2.jpgJD Edwards World Premier Support for A9.3 and A9.3.1 will end on March 31, 2020. While customers can remain on JD Edwards World A9.3/A93.1 and continue to acquire Sustaining Support for access to our Global Services team, as well as access to existing fixes for known A9.3/A9.3.1 issues, we highly recommend upgrading to JD Edwards EnterpriseOne 9.2. JD Edwards EnterpriseOne 9.2 is part of the Applications Unlimited commitment to continuous innovation. Oracle JD Edwards provides a commitment to offer Oracle Premier Support through at least 2030. You may also choose to upgrade to A9.4 which provides Premier Support and updates until 2022 and Extended Support through 2025. This new KM document provides details and options for customers remaining on release A9.3/A9.3.1. Doc ID 2628927.1. http://ora.cl/Bp7bl

Information for the import/export functionality is stored in the following User Defined Code (UDC) tables:

 

  • 00/BE - Batch Export Enabled Program
  • 00/BI - Batch Import Enabled Program
  • 00/IE - Interactive Export Enabled Program
  • 00/II - Interactive Import Enabled Program

 

For information related to implementing Import/Export in JD Edwards World programs in the JD Edwards World Technical Tools Guide Release A9.4.

All companies that uses JD Edwards software also purchase goods from various suppliers. These could be office supplies used for daily operations or could be raw materials used in a manufacturing process along with a long list of other possibilities.  You may also purchase the same material / item from more than one supplier.

 

But what happens when a supplier you have used in the past is no longer an option for these purchases?  There could be many reasons for this change, such as that supplier no longer carries the item or can no longer deliver the items in a timely fashion and you need to use a more reliable source.

 

Regardless of the reason, you need a way to block entry of new purchase orders for this specific supplier and since you use the JD Edwards World Procurement system for making these purchases you ask:

 

"What are your options for preventing creation of purchase orders from a specific supplier in JD Edwards World?"

 

The answer is dependent on your JD Edwards World release level as functionality related to this has changed.

 

The answers can be found in the following documents:

 

  • FAQ General Procurement (Doc ID 1534609.1) Question/Answer #2 provides the available options and workarounds based on your release level.
  • How to Prevent Creation of an Order for a Specific Customer or Supplier (Doc ID 1177503.1) provides similar information but also discusses prevention of sales orders again based on your release level.
  • How To Prevent Purchase Orders To Unauthorized Vendors? (Doc ID 1303709.1) provides additional detail specific to the functionality added in Release A9.1.

 

As you will see by reviewing these documents, prior to A9.1 the process was more of a workaround whereas in A9.1 and newer releases, you can actually 'deactivate' a supplier by setting the Hold Purchase Order flag in Address Book.

OracleUniversity.pngExplore #JDEdwards World to EnterpriseOne 9.2 migration options for your business with Ward Quarles in this live webinar on October 22. Get insights on how to maximize the value of your software investment and improve performance with 9.2 features. Register here - http://bit.ly/2qlC695

OracleUniversity.pngNow is the time! Migrating from @OracleJDEdwards World to EnterpriseOne 9.2 increases the value of your software investment, leading to optimized operations, clearer analytics, and better regulatory compliance. Join the webinar on October 22 with Ward Quarles to learn more.  http://bit.ly/2pp1MRv

From the JD Edwards World design perspective, whatever you call it on the shop floor, is not necessarily the way it has been named in the software. When reporting a symptom in your Service Request, the product you choose will always be Shop Floor Management, but the program name will depend on the release that you are using. You will see that, for example in A7.3, it is called Rate Base Manufacturing but with release A8.1 and above, it is called Repetitive Manufacturing. The menus across releases are the same, i.e. G3115, G3116, G3141, but the options for the programs are not always named alike. These differences are due to changes in the A8.1 release, when changes were made in the manufacturing accounting program along with some enhancements , added program, and removed programs .

 

Here's a review of differences in menus, per release:

 

G3115 Menu

Menu name: A7.3 - Rate Based Scheduling

  • Rate Based Schedule
  • Enter Change Rate Schedule (P3104). This program populates file F3104, which is used to store rate schedules. As of 8.1, this file has been removed as part of the consolidation of work orders and repetitive functionality.
  • Schedule Review (P31224)
  • Rate Schedule Workbench (P3114)
  • Production History (P31223)

 

Menu name : A8.1 – A9.2 onward - Daily Processing-Repetitive

Rate Processing

  • Enter / Change Rate Schedule (P3109)
  • Completions Workbench (P3119) (invokes many programs including P31422)

 

Line Scheduling (3 new major functions to Rate Schedule added)

  • Line Scheduling Workbench (P3153)
  • Line Schedule Review (P3152)
  • Line Sequencing Workbench (P3156)


Inquiries

  • Production Status (P31226)
  • Production History (P31227)
  • Line Dispatch List (P3159)
  • Work Center Schedule Review (P31224)

 

Kanban Processing

  • Kanban Consumption (P3157 )
  • Kanban Supply (P3158)

 

G3116 Menu

Menu Name : A7.3 - Daily Manufacturing Accounting

  • Rate Based Journal Entries (P31842)

 

Menu Name : A8.1-A9.2 onward – Daily Manufacturing Accounting

  • Rate Schedule Journal Entries (P31802)

 

For more information, refer to the following knowledge documents:

  • WS: 31: Repetitive Manufacturing (A8.1 Onward) (Doc ID 828665.1)
  • WS: 30/31: Setup and Use of Manufacturing Work Centers, Rates and Lines (F30006/F30008) (Doc ID 633456.1)
  • WS: 31: Rate Schedule Overview For A7.3 (Doc ID 627256.1)
  • WS: 31: Upgrade From A7.3; Is There A Rate Schedule Conversion Program for f3104? A8.1/A9.1/A9.2/A9.3/A9.4 (Doc ID 662219.1)

Reader.pngOracle recently announced the general availability of group software updates for #JDEdwards World release A9.4. Read this KM document (Doc ID 2574918.1) to know more about the updates - http://bit.ly/33oSgxh

You are not entering an alternate universe and you are invited!

 

Many of you contact JDE and ask questions about E1 functionality and this opportunity is for you.

 

Any World customers interested may attend an E1 presentation at INFOCUS. If you are wanting to learn and understand more about vouchering or compare functionality for upgrades pertaining to JDE E1 Vouchering AP & Procurement, we invite you to...

 

JD Edwards INFOCUS

Aug 20-22, 2019

Sheraton Downtown Denver - Denver, CO

Thursday, Aug 22 from 8-9am MTN

 

 

Will see you there!!!

You may run into this periodically when running the P470412 and wonder why are you getting error 2475 - PO Line already Matched when the line you are attempting to voucher has not been matched?  You can inquire on the order/receipt in P4314 (with Match Type = 1) and it pulls in the sub-file data verifying the detail lines are available for / ready for voucher creation.  So why do you get this error?

 

There are a few reasons why you may be getting this error.  One of the most common and most missed reasons for this error is you are attempting to create a voucher for a partial receipt and the F47042 field 'No of Lines' (SZNLIN) does not have the correct value.

 

Details on this answer along with the other possible causes are detailed in WS: 47: Troubleshooting Inbound EDI Transaction Sets (Doc ID 1559493.1).

 

If you would like even more information on this and other errors as well as general information on the P470412, use the link below to view the recent Advisor Webcast on World program P470412.

 

Advisor Webcast Recording: JD Edwards World (JDE World) - JD Edwards World SCM Tips for Troubleshooting of P470412 Inbound 810: Invoice with Receipt Match held on April 16, 2019 [Video] (Doc ID 2502711.1).

Beginning with A93.1 and above (A94 and A94.1) when performing a Work Order Material Issue using Inventory Issues (P31113) and changing the Lot and/or Location for an item in the fold of the Issues (V31113) screen, the change is no longer saved. This is reported in BUG 29154442 - INVENTORY ISSUES (P31113) DOES NOT SAVE MANUAL CHANGE TO LOT/LOCATION.

 

Potential work around would involve using option 4 from the Issues screen to call the Multi-location window (P42053) to transact an Issue.

 

For additional information see Inventory Issues (P31113) Not Saving Manual Change to Location or Lot (Doc ID 2489511.1).

How many times during your work day do you think of a quick question that you would like to ask World Manufacturing or World Distribution and do not want to stop to open a new service request? Are you aware that there is a way to us a question without opening a new service request?

 

The tool that is available for you to ask a question is called My Oracle Support Community (MOSC). Document 2266333.1 - FAQ: My Oracle Support Community (MOSC) Information and User Reference is available explaining the steps of how to open a community thread. In addition, when opening a community thread, you can remain anonymous.

 

The space to use to reach Supply Chain Management - JDEW (MOSC). Also, when asking your question, we ask that you please include the World release that you are operating as this information will assist us with answering you in a timely manner.

 

So next time that you have a question, no matter how trival you think it is, open a thread in our Community and we will answer you. Should your question be complicated, we will guide you and make suggestions.

 

Go ahead, ask us a question!

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 https://community.oracle.com/docs/DOC-1022508 for instructions.