R04572 Check Printing

I created a new version for the check Printing report (R04572) so how would I update the system so that the new version is run whenever i call from application P04571 & P0413M?

I defined the custom version in P0417 application still while running R04572 Form P0413M or P04517 it is by default taking standard version.
Is there any way around this? Thanks in advance.....

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1LI71AK
via IFTTT

Custom ube issue

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?

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1RjaKE2
via IFTTT

Text Search

I am trying to determine the best way to search through a string stored in a custom table. I was able to write an application that does that using the wildcard search and a runtime select filter but I'm not thrilled with the performance.

I started looking into using Text Search but I seem to be stuck. I created a business view, checked the Text Search checkbox and added Generic Text data structure to it. I added the business view to P95820A. When I try to run a full build in P95800A, the record turns to 3 (In Error). Also, I'm getting a JAS error in my application that is using a Text Search control. Any ideas? Thanks in advance!


JDE E1 9.0/9.1.4.7
IBM iSeries V7R1

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1S1T1hM
via IFTTT

Read/Write/Update to MS SQL database from E1

We have an external MS MVC app that our customer use to view order/invoice etc etc info. It uses data from ms sql that gets updated from multiple systems. We have some RPG pushing stuff from E1 DB2 stuff (invoicing) to this SQL. We are converting a section of the business from a legacy app to jde sales order entry. Rather than learn some new fangled RPG,or maintain the RPG stuff, I'm wondering if it's possible to create a UBE that could read/write/update this external sql. In my mind I know that E1 can use different RDMS(s).

Please advise. I've done some searching through the KG but it's just not clear cut.

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1Mx76Sz
via IFTTT

JDE 9.2 Demo and JDeveloper

Hello,
Anyone had success with installing and using 9.2 DEMO and Jdeveloper for BSSV development? Please share your experience.
I got the VS 2013 Community edition working for bsfn builds but not for Jdeveloper/WLS 12.1.3

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1nStz6i
via IFTTT

'Disconnected' Mobile Applications

OK - let's challenge what we know about the whole MAF/IAS and all those other new (or recent) acronyms that OracleJDE has been sending to us.

Current Process: We have 'Secret Agents' that go out to the 'Far and Remote Locations' and 'do their thing'. They report these 'things' into a Visual Basic Application. When they return to the office, they export their 'report of things' to a CSV - and email that CSV to 'someone' with JDE Access. That 'someone', then, imports the 'report of things' into JDE.

Wanted Process: We have 'Secret Agents' that go out to the 'Far and Remote Locations' and 'do their thing'. They open their tablet, Click and fill-out forms to 'report of things' that occurred. The 'report of things' magically appear in JDE.

Conceptually - this would be done through Oracle/JDE's Mobile Application Framework. BUT, there is an unknown - what happens when the Mobile Application is not connected. You see, not all of our 'Secret Agent' 'Far and Remote Locations' are within Cell Range. Some of the 'Far and Remote Locations' have to kept 'secret' - so the other venues have no idea they exist.

That said - when a Mobile Application is outside of Cell Range - do you hear the tree fall in the forest (look, a squirrel)... I mean, does the Mobile Application Store, then forward - once it is 'Connected'?

So many of our sites are on the Disconnected Fringes, I'm hesitant to pursue the JDE Mobile - without knowledge of what happens when disconnected.

(db)

Look, another squirrel!

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1U8RT2l
via IFTTT

Yearly Monthly Comparison Report

Can any one give an idea of making the following report format in RDA.

LOB Total Monthly Sale(AEXP) Total Yearly Sale(AEXP)



thanks

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/254N7X5
via IFTTT

Monthly Yearly Comparison Report (RDA)

Dear all,
Can any body give me any idea to make the following report format in RDA.

Business View = V4211A

LOB Total Monthly Sale Total Yearly Sale
RT 100,0000 1000,0000
FS 150,000 1500,000

thanks

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1R3NI1q
via IFTTT

Purge data from custom table

Hello,

I have a custom table that is being growing exponentially, we need to create a purge process that will delete data based in date calculations(anything that is less than this x date will be deleted). Anybody could recommend the best approach to take in this regard?

Thank you,

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1Wp0uLK
via IFTTT

Power Form Parent Child Connection

Hello All,

I have developed a Power Browse form. The Parent form Grid is join of F4101 + F41829. User opens the power form and enters a Search Text like "Oxygen" and clicks find. The Parent form displays all the items which have description "Oxygen". The child form (F4102) shows the details of only Item branch records for 1 items the first one on parent form . When user clicks on second row on parent form the relevant items details are shown in Child form. This works.

But is it possible that if the "Oxygen" search gave a match of 10 items then these 10 items are shown in both Parent and Child form at same time. i.e without firing the Row is Selected Event on Parent form. The screen dump displays my current design form.

Thanks. Appreciate your suggestions. Let me know if any details required. If such a thing is not possible, let me know if I need to pivot the idea.

Regards,
coolkl

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1P9evr4
via IFTTT

9.2 Dev Client with SQL Server JDBC

Hi folks,

I'm starting in the dev forum understanding that tech may be appropriate as well and I'll try there next.

OK, 9.2.0.2 install. SQL Server DB setting up the dev workstation. Everything is smooth, full package built. WLS 12.1.3 installed, web dev feature installs fine but get "not suitable driver" message when running. No prob, missing sqljdbc4.jar in ..\misc. Added jar and still no luck. Copied the driver to ..\JAS\EA_JAS_80.ear\webclient.war\WEB-INF\lib and it works but far from ideal. So I'm missing some setup on local WLS to "register" that driver. On server managed instances (non dev workstations) this is simple. Note the oracle JDBC driver (used for local specs) is in \misc, but it also maybe classpathed in from somewhere else.

Anyone know the right place to get it in the classpath? just the startup parms?

thanks
Craig

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1XroKwT
via IFTTT

RDA RV Variables Wrap Text

From (Doc ID 626624.1) "Report variables (alpha variable or based data dictionary item) are always initialized and print at the display length specified. They will never result in wrapped text."

Is there any way around this? I'd like to have a columnar report with a concatenated string word wrap in a report variable.

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1QSPg1U
via IFTTT

Link objects in PDF report output in E1 8.12, TR 8.96.40

As far as I know, the PDF generated in E1 8.12, TR 8.96.40 is just holds data.

Can I generate pdf/excel files with links to comments, attachments etc.

In detail,

Unfortunately, the requirement is little bit hard to implement in JDE.

One of our user (from higher management) need the following:


- They will attach number of documents to a Company record. The custom Company have lot of documents related with it, such as Company Registration document etc.

- They need to submit these documents to government on regular basis.

- They need to generate an Excel sheet with information (stored in JDE tables) and a link to the attached Media Object. They were doing this with Microsoft Access, and they are expecting much more from JDE

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/22d0jtU
via IFTTT

Install fat client

How to install fat client for release 9.0
appreciate your help

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1phFmvS
via IFTTT

FAT Client and Web Client giving different output.

Dear All,

I am struggling since many days for resolving this issue.

I have modified the Custom UBE, added few fields and changed position of few fields.
When I run it in FAT Client, the output comes perfectly OK. but when I run it in DV/PY web Client it is not coming same as coming in FAT Client .


Below steps I have taken till date for troubleshooting
I thought it promotional issue so I checked out the object on another project and get it promoted but same issue.
I copied the report to another report and prompted it but same issue.
I run the report in local web (FAT Client's) but same issue is over there
I deleted the version and recreated but same issue is there.


Attached image file for reference
Please guide.


Attachment 18258Attachment 18257

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1pcJMnJ
via IFTTT

BSSV development, how to convert mathnumeric and integers?

Hi All,

I am trying to develop a custom BSSV that makes use of a standard BSFN. The BSFN needs to be passed a mathnumeric value.

I have created the internal and published components but am having trouble assigning this value between the internal and published components. I read the JDE BSSV guide and they mentioned overloading the set method of the internal value object using something like this:
---------------MathNumeric to Integer-----------------------
public void setNumberField(MathNumeric numberField){
if(numberField!= null)
this.numberField= new Integer(numberField.intValue());
}

This doesn't work for me. jDeveloper still complains about trying to set a MathNumeric to an Integer. I thought I could get around it by just changing the data type to Integer but the BSSV does not like this when run and complains about trying to cast integers to mathnumerics.

How do people get around this? I am sure I am missing something simple here?

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1Ty1v69
via IFTTT

Auto Upload Exchange Rate From Bloomberg

Hi,

Anyone know how to extract the FX rate from Blomberg and upload to JDE?

I can think of using webservice. But I cannot find any.

Please suggest

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1RSo7uJ
via IFTTT

First Post

I have a work file table which contains the information of FY,MCU,DOCO,DCT,MN,WOD1,WOD2.In this work we are storing the value as 15,xyz,S4,RI,1,56NQ01,56NA01 Like that for all 12 months bucket. Similarly for Purchase Items with value change in WOD1 as 56PQ01,56PA01 for all 12 months.
WOD1,WOD2 actually stores the alias name of jde which we are using in another custom table.

Based on this Work File we have to write a report reading the record from f4111 and store the information in another custom table
Structured as
ihfy,ihmcu,ihitm,ihlitm,ih56nq01 up ihnq12,ihna01 to ihna12,ihpq01 to ihpq12,ihpa01 to ihpa12.
How we can map the value which we are getting in Work File WOD1,WOD2 with another custom table field and update the value of f4111.

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1TY6NXc
via IFTTT

P42101 Form not closing after OK Button

Hello Group,

Thanks for reading. I am working on P42101. We have requirement to update F4211 and custom table just after Order is committed. So in P42101 on "OK" button from Event Post Button Async , I commented the "Sales Order Application Controller - External (B4210900)"and moved it to OK Button click event. Now after this BSFN I execute my custom code and update the F4211 and Custom table. Updation works. But the P42101 form does not close and it stays with the data. However the cache is committed to database and record is created in F4211. If we again Press "Submit & Close" it gives error. I even tried to use Set Behavior but still form does not close.

I used the link below to update F4211 after End Doc in Power forms. All works but the form does not close.
http://ift.tt/1Tt3FEm

Attached is the error after clicking "Submit Close" second time.

Any idea why form P42101 does not close. Thanks for your help.

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1QPkKS6
via IFTTT

Rotate a Chart Control in EnterpriseOne

Hi All,


I am currently developing PowerForms in EnterpriseOne that have Chart Controls on them. The process of creating the forms has so far been very straightforward. In one of my forms I have created a Stacked Bar graph that renders perfectly but I would like to rotate the graph so that the bars are showed horizontally as opposed to vertically. Has anyone managed to do this? I have looked on the Oracle Support website and Google'd but I cannot find out how to do it. I have the feeling it is an unsupported feature although I would welcome anyone correcting me. Thank you in advance to anyone that might be able to help.


Richard

from JDELIST - JD Edwards® EnterpriseOne Developers http://ift.tt/1LuKI18
via IFTTT