Blog directory

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

Get Environment Import Export Paths – BSFN

Another BSFN using the jdeGetEnvironmentPaths API to get the physical paths for Import, Export and system folders for a specific environment. This BSFN can be used from 8.11 onwards.

The BSFN input is only the Environment name, and outputs are Import, Export, System and Application folders.

Download the Files here.

B5500029.C B5500029.H

JDE Business Services – Development Tuts Coming Soon

JDE Business Service

Today many organizations are adopting the concept of a Service Oriented Architecture (SOA) as a means to provide greater flexibility to interoperate with external systems and to simplify and standardize integration processes within their IT infrastructure.

JD Edwards EnterpriseOne has come up with Business Services, which was shipped with E1 since 8.97 tools release. From 8.12 onwards Business Services were available, but needed 3rd party tools to enable it.

JDE development has chosen a simpler definition of . . . → Read More: JDE Business Services – Development Tuts Coming Soon

E1 Application Failure Records (P95400)

E1 Tools 8.98 has a new application – P95400. The application can record the transaction failed to see, to help customers manage the failure of the transaction.

If JAS is activated, JAS will detect the failure of the transaction and keep transaction data in the database, through the notification system email administrators and end-users, users on the line, you can view the saved data and can re-submit the transaction.

This program provides an opportunity to enhance the . . . → Read More: E1 Application Failure Records (P95400)

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