Blog directory

Update Your Primary Keys from JDE

1 Table

Does that title sound funny? Can you update your Primary Keys of a record in a table too? Ofcourse you can, SQL does allow it. But does that work in an ERP?

Yes ERP’s are supposed to keep their data integrity well, and secure it too. But in JD Edwards you have an option to update the Primary Keys. Actually – Change the primary key values. You can achieve this feat by . . . → Read More: Update Your Primary Keys from JDE

JD Edwards EnterpriseOne 9.0.2 Standalone Installation

The JD Edwards Demo installation has got even easier. Thanks to Oracle, who has brought in Oracle Universal Installer (OUI) to the scene.

We have tested the installation on Windows XP, Vista and Windows 7 too (all 32bit versions, please do let know if it went well for 64bit OS’s). All of them work great. I’ve mostly re-written the steps from the Oracle supporting documents. But it would be better to read . . . → Read More: JD Edwards EnterpriseOne 9.0.2 Standalone Installation

How Event Rule Dataselection Works in JDE Tools

*The article is rated Must read for Beginners/Novice

There has been many a confusion with JDE freshers, on how to use the Internal Data selection, or called as ER Data selection and how to use them.

Following are our assumptions for the scenarios (for REPORT DESIGN AID (RDA)) -

There’s a Processing Option which takes inputs of Date range (F4201.DRQJ) for internal data selection. Scenario 1

Suppose we need to select all Sales orders (F4201) entered between (DRQJ=) 7/1/2011 and 7/31/2011

. . . → Read More: How Event Rule Dataselection Works in JDE Tools

JD Edwards Terminologies

Original Content is from – http://oneworldxe.blogspot.com/2009/02/erp-terminology.html

Application Server – Server where ERP logic is executed. A distributed ERP installation can have more than one Application Server.

Application Developers – Also known as App Developers. These developers use the ERP tools to develop ERP business application packages such as Financials, Manufacturing, Distribution, Human Resources, etc.

ASCII – American Standard Code for Information Interchange – Character set used by UNIX & Windows.

BDA – Business view Design . . . → Read More: JD Edwards Terminologies

Change FileNames in Table Conversion or Business View in UBE

JDE Object Save Restore

Many a times we need to change the Business view of a Report/UBE, which requires re-validating the event rules code. Worse, if you had to change the input file name in a Table Conversion? You will have to actually re-write the whole code.

Usually, for such table conversions, what we do is write wrapper UBE’s which would rename the input file to the path/file name of the table conversion, and then trigger the TC to run. All these options take huge amount . . . → Read More: Change FileNames in Table Conversion or Business View in UBE