E1 Tips The Tips & Tricks of a CNC Administrator on Oracle JDEdwards EnterpriseOne

Web Only Version Pain

We seem to be having an issue with old “web only” versions.  There are times when the “web only” version causes the other version to not egen correctly.  So, below is the SQL that can be used to select the “web only” versions.

SELECT count(*)
FROM COPD811/F983051
WHERE VRVCC2='1'

If you want to be more precise, you can grab the “web only” versions that have been executed prior to a certain date by using the VRVED field and the six digit date which can be found on the e1 dates page.

pf button Web Only Version Pain
evernote Web Only Version Paindigg Web Only Version Painshare save 171 16 Web Only Version Pain

2 Responses to “Web Only Version Pain”

  1. Just found your Blog as a fellow CNC would like to say thanks :)

Leave a Reply