Stack Overflow
Stack Overflow

Questions tagged [jdedwards]

JD Edwards was a company producing Enterprise Resource Planning (ERP) software.

JD Edwards was a company producing Enterprise Resource Planning (ERP) software. It was acquired first by PeopleSoft and then by Oracle, who continue to support the products. Current software includes JD Edwards EnterpriseOne and JD Edwards World.

83 questions
14
votes
9 answers

What is the precise definition of JDE's Julian Date format?

I am writing code to convert from a Gregorian date to a JDE (J.D.Edwards) Julian date. Note: a JDE Julian date is different from the normal usage of the term Julian date. As far as I can work out from Googling, the definition of a JDE Julian date…
Andy Balaam
  • 6,423
  • 6
  • 34
  • 37
6
votes
4 answers

JD Edwards... call C#?

I know very little about JD Edwards. I have a client asking how to call an API we supply (as COM, C#, REST) from JD Edwards. I'm not getting much in terms of high quality answers from their tech guy... so I thought I'd ask here. Can JD Edwards call…
user53794
  • 3,800
  • 2
  • 30
  • 31
5
votes
6 answers

What might prevent a DLL from loading with LoadLibrary?

I have a JD Edwards business function, which is written in Microsoft Visual C++ as a C module. I'm using LoadLibrary to access a third party DLL. In a standalone test program, the code runs just fine. When I run it from within JDE, LoadLibrary…
Mark Ransom
  • 299,747
  • 42
  • 398
  • 622
5
votes
2 answers

Does JodaTime or Java 8 have special support JD Edwards Date and Time?

The topic at hand is a messy domain-specific problem working with dates in Oracle's ERP software called JD Edwards. Its detail is documented in this question. Before writing wrapper classes for handling the dates and times from JD Edwards, I want to…
solvingJ
  • 1,321
  • 1
  • 19
  • 30
4
votes
1 answer

Oracle JD Edwards EquipementManager Documentation

Where can I find the full API documentation of EquipmentManager? the official/unofficial docs and books keep pointing to the javadoc packages (JP170001,J1700001,J1700002) which I couldn't find. P.S I'm looking for an online documentation (without…
Bassel Shmali
  • 207
  • 2
  • 15
3
votes
3 answers

JD Edwards / IBM iSeries DB2 Julian Date / Calendar Date SQL Conversions

There are still many legacy applications in use from the previous century running on the IBM iSeries. e.g. JD Edwards. Date fields are often stored in a variety of formats collectively and commonly called Julian Date. These formats are a combination…
rtev
  • 1,102
  • 12
  • 24
3
votes
3 answers

Convert Julian Date CYYDDD to DD/MM/YYYY

I have a column in a table in SQL Server which stores date in Julian format (CYYDDD). I'm running a select SQL on the field and would like to convert the date format to DD/MM/YYYY. Have tried few SQLs for the format conversion, but none of them give…
Sam
  • 37
  • 1
  • 6
3
votes
2 answers

JD Edwards REST API with Request response JSON

We are working on customer project, where customer has got JD Edwards Enterprise One. Their installation supports REST API ( I tried defaultConfig API and it worked.) Usually in REST API, developer shares API signature in terms on GET params or…
navaltiger
  • 884
  • 12
  • 27
2
votes
3 answers

JDEdwards XMLInterop

Wondering if anybody out there has any success in using the JDEdwards XMLInterop functionality. I've been using it for a while (with a simple PInvoke, will post code later). I'm looking to see if there's a better and/or more robust way. Thanks.
Jon Dewees
  • 2,957
  • 6
  • 31
  • 38
2
votes
4 answers

What is the learning curve for development on JD Edwards?

On an average, how much time does it take to become proficient in development using JD Edwards? Is it easy to learn? Are there any prerequisites?
sivaramakrishna
  • 666
  • 3
  • 10
  • 16
2
votes
2 answers

Converting a Julian Date to datetime in Visual Studio (SSIS Package)

I am trying to build an SSIS package to allow conversion of a Oracle Julian Date to a datetime field for a SQL server DB in MS Visual Studio 2013. What tool would I use to convert my current Julian field into a datetime? Specifically, I need to…
Geo
  • 336
  • 1
  • 6
  • 20
2
votes
2 answers

import/export CSV in IBM i (AS400) DB2

I'm preparing for an upcoming integration project where I need to import/export some data to/from our ERP into the File System. We run JD Edwards World 9.2 on an IBM iSeries/AS400 V6R1 machine. The software we are integrating with, requires that we…
Dimitri Shukuroglou
  • 363
  • 1
  • 5
  • 13
1
vote
0 answers

Need help understanding why this query is producing these results

Consider the database entries below. The distinguishing identifier is the "short" item number, 89721. Data: F3003 IRKIT IRKITL IRMMCU IRMCU IREFFF IREFFT IRAN8 IRTRT IRUOM 89721 7N74N050046 B20 NXT 12/06/2015 …
Joseph Gagnon
  • 1,731
  • 3
  • 30
  • 63
1
vote
1 answer

Format a JD Edwards number column as HH24:MI:SS

I have a JD Edwards table column with the following value 170443 which represents time. I want to format it as HH:MI:SS but I'm getting an error ORA-01850: hour must be between 0 and 23. What changes do I need to apply to the following code to get…
E. Ogony
  • 87
  • 9
1
vote
0 answers

How do I send navigation keys and extract data from IBM i Access Client Solutions?

At work I must extract data from an AS400 screen using IBM i Access Client Solutions. I used to have code that I could use with PComm; however, they recently replaced the software in my company (without asking) and that is causing delays of up to…
vicsar
  • 301
  • 5
  • 16
1
2 3 4 5 6