data selection

Hello group! I am making a report, I need to add a new column in the report view, which shows the quantity number of days between the Expiration Date and Order date column. Can you think of how to do it? Thanks in advance.

Hi I have a Custom report which takes 4 mins to run in DV and for the same data selection its taking 16 mins to run in PD. The Data refresh was done on DV recently , So both the PD and DV have the same number of data. The sequencing and everything is same in both PD and DV. The Report's Business...

Hello everyone, I'm developing a report that creates a txt file with multiple lines, I need to separate the report in two sections with the same BSVW because I need to print lines with 2 diferent user selections, I made an example with SQL code: WHERE (DELN = 0 AND DRQJ > TODAY - 30 days)...

Hi, We are on application release 9.1 and tools 9.2.2.5 with windows 2012 servers. JDE job is scheduled using a custom scheduling tool which has feature to override data selection of JDE jobs(UBE). This works fine for all the jobs except a job that is using JDE standard function B4309570-...

Hi, I already know that in a typical situation this is not possible in JDE to just lock down those and give user the option to just enter value. For example DOCO is equalto 123456, here the user only can enter the value. But did anyone was able to lock down left operand and comparison but not...

List, Has anyone had any success running R31410 multi-threaded in JDE? I know Oracle recommends single threaded due to the risk of overlapping components when jobs are submitted at the same time but I am wondering if anyone has used Data Selection to get around this problem? Any insight to...

I have two sections in my report. Both have different business views. The first section ( the parent section) have no CO field in the BV, but the child section have. In the child section, I hard coded the data selection as CO = 00001,00002 etc. Now the user doesn't want hard coding. She wants...

Hi, We are upgrading from JDE 9.0 to 9.2 and doing some testing in 9.2 to make sure everything works fine. with specific role, when I try to open a report Data Selection pops up twice instead of one time. With the same role in our current system (9.0) we don't have this issue. Problem with...

Hi All, I have developed a batch applications whereby its an UBE calling an UBE. In this case, its calling and EDI UBE. My question here is, if i were to change the data selection of the EDI UBE at version level, does it require a re-deployment of the version? Please advise. Thanks...

I have modified the Custom UBE, added few fields. When I run it in FAT Client, the output comes perfectly but when I run it in DV/PY web Client it is coming blank. I thought it may be promotional issue but cnc guy saying there is no promotional issue. Is there any way to troubleshoot this issue?

Howdy, In 9.x, we have the BSFN B01RS056 - which allows us to export a version's Data Selection. It has it limitations, mostly in parameter sizing and abandoned logic (limiting the DS String to 95 characters does not catch those 300 MCUs in the "list"). The function appears to export the...

E1 Pages Error "Versions with Client marked as 'Client Only' cannot be submitted Hello there , I have a second e1 pages error I am encountering and would very definatly appreciate any help from more experienced E1Pages veterans out there . I am trying to get a UBE to prompt...