Skip navigation
1 2 3 Previous Next

JD Edwards World Support Blog

99 posts

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!

What makes these two versions different is the purpose of its running within the business established process in manufacturing accounting. For example, if you are processing  work orders  before reaching the status of full completion or your work order, this action is commonly called ‘Work In Process’ or WIP, denoting that the order it is not yet fully completed on the shop floor but that journal entries are been generated progressively before reaching the completed status.

 

Then, when the work order reaches the final status reflecting that all inventory and routing activity has been fully completed, therefore, ready to run P31802  in final mode for the last time (right before generating variances) this step is known as P31802 Completions or manufacturing accounting completion.


This is a user defined process, as it is not mandatory to run one version or the other or both. The definition of the business process can accommodate both runs, or only one.  One of the most important keys for WIP and Completions versions is the work order status defined by user and that will be data selected and/or updated for the work orders that are been processed.  User can define if there will be or not a status for WIP and a different status for final completion in UDC 00/SS, or use the same for both.  The other key is the Variance Flag (PPFG) that resides in the Work Order Header.

 

For more details on P31802 program setup and information on (PPFG), review Knowledge Document Creating Manufacturing (WIP) Journal Entries (Document ID 1579651.1) and Purpose of the Variance Flag (PPFG) In Manufacturing (Document ID 661187.1).

Pricing, Pricing Pricing in JD Edwards World. It's on always on the to do list as must always evolve and maintenance your pricing to keep up with the business.

It is not always easy to search on all the related pricing topics to learn set up, FAQ's and Troubleshooting.
To help with searching and to jump start your research, see the list below of the main documents related to pricing.

 

  • Overview of Base Pricing in Sales (Doc ID 626798.1)
  • Base Pricing and Units of Measure in Sales Orders (Doc ID 1125196.1)
  • Comparison of Base, Standard, and Advanced Pricing (Doc ID 626661.1)
  • Advanced Pricing for Markups and Discounts (Doc ID 626729.1)
  • FAQ Advanced Pricing (Doc ID 1573202.1)
  • Troubleshooting Advanced Pricing (Doc ID 1573469.1)
  • World A9.3 Enhancements to Advanced Pricing (Doc ID 1451682.1)
  • Basket and Order Repricing in Advanced Pricing (Doc ID 636432.1)
  • Preference Profiles in Sales (Doc ID 626656.1) - Review for Pricing Information (Pricing UOM, Price Codes 1,2,3, Adjustment Schedule)
  • Credit Orders and Advanced Pricing (Doc ID 626770.1)
  • Free Goods In Advanced Pricing (Doc ID 626677.1)
  • Rebate Adjustments in Advanced Pricing (Doc ID 626768.1)
  • Accruals in Advanced Pricing (Doc ID 626740.1)
  • Automatic Accounting Instructions for Distribution (AAI DMAAI) (Doc ID 626758.1)
  • Advisor Webcast: JD Edwards World -Troubleshooting Advanced Pricing [Video] (Doc ID 2172903.1)
  • Advisor Webcast: Advanced Pricing Free Good & Reprice Adjustment Enhancements in Release A9.3 (Doc ID 1477352.1)
  • Information Center: JD Edwards World Advanced Pricing (Doc ID 1590104.2)
  • Troubleshooting Pricing Problems (Doc ID 626705.1)

Documentation Guide

 

If you find more is needed, we are here to help. Call Global Customer Support for assistance.

Does JD Edwards E1 / Electronic Commerce (EDI) function the same as World EDI? Are the programs and files the same? Does E1 have Flex Accounting and how does it differ from JDE World? Does the World A/R post program differ from E1?

What about all those files and fields? Do they all migrate from World to E1? Can you tell me if something will not migrate?

 

It is hard to know all the differences and pertinent information between World and E1. Just when you think you have got it, oops, there is one you have missed inadvertently. If you have gone searching in My Oracle Support (MOS) and come up dry, try these options for more assistance.

  • World Upgrade Resources / Oracle Technical Catalog 
    • Be sure to accept the disclaimer and navigate between World and E1 in the catalog to review what may be different by objects and system codes and create reports of the information.
  • Call Oracle Global Customer Support - 1.800.223.1711 or create a SR online.
    • Remember: You may be questioning functionality in any system from Supply Chain, Tech to Financials. State the exact program, files, and fields in the SR. Support can assist you as more efficiently with the specific information.
    • Each Support area can discuss what exists or does not exist in each software. If you need more technical assistance on how data is migrated from any World JDE system to E1, contact World Tech. They can always ask their counterparts in Applications for assistance on specific system information.

 

The best part... Contact us anytime; we are here to help!

Lease Accounting Prior to 9.1 and all Releases of World (Doc ID 2420929.1) is intended to outline our general product direction for Lessee Accounting for customers using World Software.  The document contains suggested workarounds which may or may not be a solution for every customer. The document outlines how JD Edwards’ customers might leverage JD Edwards Fixed Assets, General Accounting and Accounts Payable modules to meet the change in Lease Accounting Standards (for Finance and Operating Leases).

 

It is recommended that you seek professional advice to follow accounting entries through from a local certification, compliance and verification perspective before implementing.

Approval of purchase orders is a common, highly used process in World Procurement with many companies using multiple differing Approval Routes to establish and direct the approval requests to the appropriate levels / persons for approval.

 

Occasionally, due to attrition, change of responsibilities or changes in the level of approval needed, you may find you need to make changes to the 'approvers' on an approval route or may even need to delete an existing approval route as it is no longer needed.

When these changes/deletions are attempted, you may run into error 2788 - Delete Not Allowed, blocking you from making this change.

 

The Data Dictionary defines the 2788 error as follows:

Cause. . . . The person that you have attempted to remove from the approval table has pending orders which require his/her approval or rejection.
Resolution . . Either change the person responsible for the pending orders, or wait until the orders have been approved or rejected.

 

Note :  The "Orders Awaiting Approval" screen (P43081) is a helpful tool in determining which orders are awaiting approval by a specific approver.

 

So how do you resolve this error and continue on with you updates/changes/deletions to these approval routes?

 

As stated in the error text, this error is generated because the person or route you are attempting to change/delete has orders pending approval.  An Approval Route cannot be deleted, nor can an approver be removed from an Approval Route when the approver has orders pending their approval.

 

Troubleshooting Approval Processing Issues (Doc ID 1547635.1) addresses the 2788 error and provides options for making the desired changes or deleting the approval route.

 

The first step is to identify the approver who has a pending approval request and as the Data Dictionary error information states, the Orders Awaiting Approval screen (P43081) is a helpful tool in determining which orders are awaiting approval by a specific approver.  Another option for identifying these approvers is to review the data in the F4209 – Held Orders file.  A record in this file designating approval is pending from a specific approver is identified by a value of 2N in HOASTS - Approval Status field.

 

Once you have identified which approvers have orders awaiting their approval (App Sts = 2N), you have the following options:

  1. Have this approver actually approve or reject any pending approvals for the related route.
  2. Use the Approval Delegation process/program P43280 so that all orders pending this person’s approval can be delegated to a different approver.  The new approver can then approve or reject any orders that are pending their approval.
  3. If your intent is to delete the entire approval route, you will need to use one of the first two methods to approve / reject all orders that are pending approval for this route.  The existing approver must approve or reject all pending orders before you can remove him or her from the route or delete the entire route.   An Approval Route cannot be deleted, nor can an approver be removed from an Approval Route when the approver has orders pending their approval.

 

Once all pending approvals have been acted upon so that there are no pending approval records (F4209 HOASTS = 2N for this route), you can go to the P43008 - Approval Level Revisions, Inquire on the Order Type & Approval Route Code to pull the Approval Route record into the video and then delete it using the D Action Code. 

Full details on the set up and use of Approval Processing can be found in Approval Processing (Doc ID 626779.1) with additional topics discussed in FAQ: Approval Processing (Doc ID 1535323.1).

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.