November 2007 Newsletter
SQL Server Support Ends April 2008
Oracle will no longer be supporting installations running Microsoft SQL Server 2000 from April 2008 onwards. To continue being supported, it will be necessary to upgrade to SQL Server 2005 or migrate to one of the other supported databases.
Please refer to the following links for further details:
Xe and ERP8: http://www.peoplesoft.com/corp/en/iou/platforms/enterpriseone.jsp?doc=8f6092e5ccb27fd98825722800025c39/$FILE/xe-erp8-database-tr.htm.
8.9 onwards: http://www.peoplesoft.com/corp/en/iou/platforms/enterpriseone.jsp?doc=fa9ca34ea9293fb588256ebe0027e519/$FILE/erp9-database-tr.htm.
Visit us at the UKOUG Conference 2007
DWS is exhibiting again at this year's UKOUG conference being held at the Birmingham ICC from Dec 3rd to the 6th. We have a couple of speaking slots at this year's event on Web Services Gateway for JDE and a Developers' Corner session. You can book these on the online agenda at: http://conference.ukoug.org/default.asp?p=690.
Please do drop by stand 95 to say hello!
DWSDimension gathers pace
DWS officially launched DWSDimension to the UK market at the JD Edwards partner day event held at the Heathrow Marriot during September. We have received very positive feedback on the product from both customers and Oracle themselves.
Please call us to find out more or click here for an online demo.
DWSDimension is a more scientific approach to appraising the scale, effort and cost involved in uplifting modifications and extensions from a current release to a higher target release as well as giving you vital information on how your system is running.
So whether you want to:
- Perform a professional and accurate audit of your modified EnterpriseOne system
- Estimate the effort in man days required to upgrade from your current to the new release
- Estimate the effort required and impact of deploying a large ESU into a modified system
- Post upgrade analysis to ensure that the upgrade is complete and nothing has been overlooked
- Perform a utilisation analysis on custom reports to ensure that only reports that are being used are upgraded
DWSDimension can help!
DWS & QAS re-ignite the JD Edwards EnterpriseOne market place
DWS has been an alliance partner to QAS since 2001. We created an integration written with the E1 tools that allows the JD Edwards product to retrieve and validate address data from the QAS product back into JD Edwards.
We are pleased to announce that a new and improved integration is now available at the 8.11 and 8.12 release levels. This integration works with the latest Pro Web V5 release of the QAS product.
Please visit here for more information or just call us at DWS:
http://www.qas.co.uk/products/capture-name-and-address-data/pro-web.htm
DWS & Bottomline Technologies - a winning team
DWS has had a long and successful partner relationship with FormScape. DWS is now delighted to be part of the Bottomline Technologies partner network as a result of their acquisition of FormScape. Bottomline see the JD Edwards market place as a key to their global growth plans and as such have invested heavily in the ongoing enhancement of their JD Edwards pre-built integrations. The latest of which is TransForm AP for EnterpriseOne.
TransForm AP from Bottomline Technologies combines supplier invoice approval, coding and storage with an integrated JD Edwards EnterpriseOne user experience. The result is an AP process that is transparent and accessible from within EnterpriseOne or online via a web browser. TransForm AP automates the whole supplier invoice process, from capturing paper invoices through online approval and onto invoice matching.
More information can be found at: www.bottomline.co.uk or just call us at DWS.
DWS & The GL Company combine to help Oracle EBS customers
DWS and The GL Company are working together to help EBS customers to unlock the value of 'Alternative Flexfields'. DWS has developed a new EBS product called Attribute Loader that essentially takes advantage of hundreds of spare data columns that can be used to build additional reporting dimensions. With The GL Company's RRTIS (Really Real Time® Inquiry Suite), end users have a way to access the data stored in the Attribute columns instantaneously, alongside the other dimensions.
More information can be found at http://www.oracleattributes.com or just call us at DWS.
Developers' Corner
Set Selection Group (8.96 onwards)
Enable complex filtering of grids by using the new Set Selection Group system function.
The Set Selection Group system function enables you to group together fetching criteria by introducing brackets to the SQL Select; this is the only characteristic of this system function that makes it different from the Set Selection system function.
Example 1 - Set Selection (existing SysFunc)
A form has a filter field called Alpha Name (ALPH), which is associated with the Alpha Name column in the F0101 table. In addition, there are two Set Selection system functions under the Find Button Clicked event. These two system functions are as follows:
Set Selection (FC Grid,F0101,AT1,
Set Selection (FC Grid,F0101,AT1,
When a user enters ABC in the filter field and then clicks the Find button, the following conceptual WHERE clause is created:
WHERE ALPH=ABC AND AT1=E OR AT1=C
The result is that all employee records with the name ABC and all customer records are fetched (the QBE line is ignored for Customers)
Example 2 - Set Selection Group
Same scenario as above. Under the Find Button Clicked event, two system functions as follows:
Set Selection Group (FC Grid,F0101,AT1,
Set Selection Group (FC Grid, F0101,AT1,
When a user enters ABC in the filter field and then clicks the Find button, the following conceptual WHERE clause is created:
WHERE ALPH=ABC AND (AT1=E OR AT1=C)
The result is that all employee and all customer records with the name ABC are fetched.
Example 3 - Set Selection and Set Selection Group
Same scenario as above. Under the Find Button Clicked event there are two Set Selection system functions and two Set Selection Group system functions. These are as follows:
Set Selection (FC Grid,F0101,AN8,
Set Selection Group (FC Grid,F0101,AT1,
Set Selection (FC Grid,F0101,AN8,
Set Selection Group (FC Grid,F0101,AT1,
When a user enters ABC in the filter field and then clicks the Find button, the following conceptual WHERE clause is created:
WHERE ALPH=ABC AND AN8>100 AND AN8<200 AND (AT1=E OR AT1=C)
Note: Although shown in this example, the usage of mixed Set Selection and Set Selection Group is not good practice. The purpose of this example is to show the runtime behavior - Set Selection Group system functions are grouped and appended to the WHERE clause at the end.