Blog directory

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 this guide first, and then go through . . . → Read More: JD Edwards EnterpriseOne 9.0.2 Standalone Installation

Learn JDE Business Services – Part 1

BSSV tools release

About: JD Edwards EnterpriseOne Business Services

E1 Business Services is the alternate name for Web Services. With the world moving towards Service Oriented Architecture (SOA), EnterpriseOne too has implemented Business Services as a gateway that provides native web services capabilities. JD Edwards EnterpriseOne business services enable you to fully capitalize on the benefits of service oriented architecture (SOA) by providing native support of Web services, including the capabilities to develop, publish, consume, and administer Web services directly from JD Edwards EnterpriseOne Tools. Business services are a set of Java-based business functions created to perform discrete units of work. They can interact with external systems in the form of a Web service.

Business Services – A set of Self-contained, stateless Business Functions that accept one or more requests and returns one of more responses through a well-defined, standards based interface. These services perform discrete units of work such as editing and processing a transaction (e.g. Price Lookup, Currency conversion, Add Order, Weather check etc.)

Web Services & WSDL Overview

Interoperability has Highest Priority with respect to EnterpriseOne, where all major platforms can access the Web using Web browsers, different platforms can interact. For these platforms to work together, Web-applications are developed. Web-applications are simple applications that run on the web. These are built around the Web browser standards and can be used by any browser on any platform.

Web Services take Web-applications to the Next Level. By using Web services, your application can publish its function or message to the rest of the world. Web services use XML to code and to decode data, and SOAP to transport it (using open protocols). Continue reading Learn JDE Business Services – Part 1

Using Complex Database Views on EnterpriseOne

Database View Diagram

A Database View is a subset of the database sorted and displayed in a particular way. For example, in an Invoice database, perhaps you only wish to display the Vendors stored in the database.
Database View Diagram
EnterpriseOne Views are similar in nature, where it sits on top on JD Edwards Tables, to retrieve data, or a subset of data.

With Business Views, we can join tables using Left outer, Right outer, Union, Intersect joins. One can usually join up to 5 tables in a Business View if using Simple joins. If one uses a Complex join, then number of tables is limited to 3.

What if you need to use more than 5 tables? What if you need to do some complex joins? And What if you need a column which would give you a Count of records for the group?
For e.g. if you have a need to display the number of items on Open orders and quantities shipped, with the order details, you may have to do the following SQL

SELECT sddoco, sdkcoo, sddcto, count(*), sum(sduopn)
FROM F0411
WHERE sdnxtr <=540
GROUP BY sddoco,sdkcoo,sddcto

To accomplish this in current JD Edwards EnterpriseOne Reporting, you will need to do a little more programming. Continue reading Using Complex Database Views on EnterpriseOne

JDE Source is Live…

JDE Source

JDESOURCE is an online portal for JD Edwards EnterpriseOne community to share and learn. You are welcome to share all information regarding JD Edwards, and related softwares, for your own journaling purposes. . . . → Read More: JDE Source is Live…

Troubleshooting JD Edwards EnterpriseOne 9.0 Demo Installation

Troubleshoot

Read this article to answer all questions on different problems/errors one encounters during the Oracle JD Edwards EnterpriseOne 9.0 Standalone/Demo Installation. Based on suggestion from Chris Koloszar, I thought of putting all the issues we’ve replied/commented and solved, into a single article. . . . → Read More: Troubleshooting JD Edwards EnterpriseOne 9.0 Demo Installation