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
0
votes
3 answers

PHP Julian Date for JDE Oracle

i'm trying to convert a date like 2022-08-09 to a julian date for send it to JDE. The problem is that default php functions like juliantojd() return a different result. The result i expected was something like…
user18182496
0
votes
1 answer

JD Edwards error "Unknown JAS error has occurred. Please contact your system administrator."

I created a new enviroment, but when I'm trying to login on the web it shows me this error "Unknown JAS error has occurred. Please contact your system administrator." I have restarted all the servers and services and verified the JDK version and…
msl
  • 1
  • 1
  • 2
0
votes
2 answers

Should I use an SQL full outer join for this?

Consider the following tables: Table A: DOC_NUM DOC_TYPE RELATED_DOC_NUM NEXT_STATUS ... Table B: DOC_NUM DOC_TYPE RELATED_DOC_NUM NEXT_STATUS ... The DOC_TYPE and NEXT_STATUS columns have different meanings between the two tables, although a…
Joseph Gagnon
  • 1,731
  • 3
  • 30
  • 63
0
votes
0 answers

How to pass external data to a Vaadin application

Background I am attempting to develop a Spring Boot/Vaadin application that will be used to collect user input and pass the data on to another application via REST. The Vaadin app sits in the middle of the process flow, with an external application…
Joseph Gagnon
  • 1,731
  • 3
  • 30
  • 63
0
votes
1 answer

BI publisher Bursting Issue

I am having an issue when running a report with BIP bursting. Without bursting 1 pdf generated. Pdf displays 2 pages with page#1 and Page#2 that's fine. but when bursting getting 2 output pdf. 2nd pdf page number is page#2. I want both page numbers…
0
votes
1 answer

Duplicate Variable Definition Inside Choose Block

I think the code below should work in a Word BI Publisher template, but it's not. When I use the BI Publisher Template Viewer app to test, it is showing Duplicate variable 'branch' definition. If only the matching block should be…
eljefejb
  • 297
  • 3
  • 12
0
votes
1 answer

How to use inside image url function in BI Publisher template

I'm totally new at BI Publisher and XML templates. I'm trying to update a template to add the logo for a new company/organization. The same templates will be used for 3 separate branches/organizations within JD Edwards. I'm having trouble trying to…
eljefejb
  • 297
  • 3
  • 12
0
votes
3 answers

Why doesn't this SQL work? [JD Edwards DB2]

I am attempting to write some SQL that will be used to select data for a report. The data is coming from JD Edwards, using the DB2 database on AS/400. I have written the following SQL query: SELECT F3112.WLDOCO AS DOC_NO, F3112.WLDCTO AS…
Joseph Gagnon
  • 1,731
  • 3
  • 30
  • 63
0
votes
1 answer

Is this the correct SQL for what I need? [JDE, DB2]

Consider the following JD Edwards database tables: Work Order Routing (actual name: F3112) Work Order Time Transactions (actual name: F31122) The tables are linked by a common field: document number (DOCO). There may be zero or more records in…
Joseph Gagnon
  • 1,731
  • 3
  • 30
  • 63
0
votes
1 answer

Java empty stack exception - JD Edwards BI Publisher subtemplate

I have been trying to conditionally import logos onto my main template. The logos are stored in an external rtf file Some logo here In my main template I am importing the logo using
user2792941
  • 331
  • 1
  • 3
  • 9
0
votes
2 answers

DB2: Can you write a function or macro emedded in the SQL to simplify a complex query?

I know enough about SQL to do basic and slightly more advanced queries, but that's about where my knowledge ends. I have a query that involves a complex sequence of function calls to convert a JD Edwards ERP application "Julian" date to a…
Joseph Gagnon
  • 1,731
  • 3
  • 30
  • 63
0
votes
1 answer

Complicated SQL query help for JD Edwards E1 (DB2)

Let me preface this with the admission that I am not a database or SQL expert by any stretch. I know basic queries and have done some slightly more involved queries, but this is beyond my ken. Background My company uses JD Edwards Enterprise One for…
Joseph Gagnon
  • 1,731
  • 3
  • 30
  • 63
0
votes
2 answers

SSL Certs for single IP- two ports, same URL website

We've a project that is to go live very soon and we ran into this issue when dealing with developers. This is two JDEdwards (ERP) website which are hosted on a single IBM WebSphere webserver, currently using a FQDN, and different ports assignment…
Mani
  • 1
0
votes
1 answer

SQL Query Join Tables

I am trying to join tables based on the primary key of address no, 1. However, the issue below creates duplicate record for the same address no. 003 78057911 (wpphtp !=F) and 003 78057922 (wpphtp = F) are the same fields in the database, however I…
Synetrix
  • 59
  • 2
  • 12
0
votes
2 answers

Dynamic JDE Connector Issue of Increasing Handles Count leads to OutOfMemory and after resolving it gives NullPointerException

We’re trying to use dynamic java connector for JDE9.0 and facing issue of increased Handles count for the process. Scenario: Calling Dynamic JDE connector in parallel with multiple calls simultaneously. The implementation process of executing BSFN…