Skip navigation

The Journal Entry (P0911) application functionality has been enhanced such that now users have a choice to allow or restrict JX journal entries that are created for accounts with Posting Edit Code as 'M'(PEC=M). The new functionality brings gives more flexibility to the users for creating adjustment journals.

 

Upon further review by Oracle Support and Development teams, Enhancement Bug 25169318 will now be implemented as a Code Bug and the ESU is expected to be available by March, 2017.

 

Prior to the change, JX journal entries can be created for accounts with the Posting Edit Code as "M".

 

Now when creating JX journal entries users will have a choice whether to restrict entries for accounts with Posting Edit Code as "M".

 

The revised functionality is included in the following bugs:

9.0 Bug 25169318

9.1 Bug 25436948

9.2 Bug 25436956

 

In P0911 JX Entries Are Allowed For An Account With Posting Edit Code M (Doc ID 2208531.1) has more information on this change.

An enhancement is available for JD Edwards EnterpriseOne 9.2 customers using the distribution modules.  Refresh Inventory Commitments (R42990) refreshes any inventory commitments in F41021 (Item Location File) where the item does not have any active sales orders associated with it. The existing program, Repost Active Sales Orders (R42995) refreshes the commitments for only those items that have an active sales order. There may be a case where the sales orders are all completed for an item but for some reason there is still an outstanding commitment recorded in F41021 that needs to be cleared out. R42995 will not update this item in F41021.

 

Prior to the enhancement, if no active sales orders exist prior to running the Repost Active Sales Orders (R42995), when R42995 was run for locations that have hard/soft committed buckets filled but no open orders in the Sales Order Detail (F4211) exist, commitments would not be cleared for those Item Locations in the F41021 file. One workaround involved creating a 'dummy' order for the specific item so that R42995 would correctly repost the order. The 'dummy' order would then need to be cancelled after running the Repost Active Sales Orders (R42995) program. Another workaround involved using a database utility program such as SQL to clear the commitment buckets in the Item Location (F41021) prior to running the Repost Active Sales Orders (R42995). This process was more efficient if numerous items need to have the quantities and amounts reposted but do not have an open order in the Sales Order Detail (F4211). This process eliminated the need to create and delete what could be many individual "dummy" orders.

 

For complete information on the enhancement, see Refresh Inventory Commitments (R42990) (Doc ID 2230896.1).

To facilitate the implementation of UX One roles, MyOracle Support now provides a cross-reference of rules and all the objects you can use for a role-based page, for example, Watchlists, queries, E1 pages, and so on. Find all these resources in Oracle Support Document 2227250.1 (UX One E1 Page/Object Cross Reference).

Is it possible to integrate collaboration tools with JD Edwards EnterpriseOne. You can explore this question in several sessions at Collaborate17, including Content and Social Collaboration in the Cloud: Now available out of the box for JD Edwards.

 

Watch this video to learn about the potential of social collaboration within JD Edwards.

Propose an innovative solution for business challenges for the JD Edwards Ideathon at Collaborate17 and win a chance to have your solution considered for future JD Edwards releases.  http://bit.ly/2kv8VZx 

Announcement.pngIn this latest release, JD Edwards delivers enhancements that cover the spectrum of innovation from user experience to critical industry-focused enhancements to certifications. The details in the GA announcement shows all of the new functionality.

ActiveX Overview

 

ActiveX is a Microsoft technology made up of small programs that are used within Microsoft products. Within JD Edwards EnterpriseOne, we have used this technology in Internet Explorer (IE) to provide specific enhanced functionality since the first web release of E1.

 

At the time E1 was first released to the web, Internet Explorer was the only supported browser. Having been the most stable and widest spread, this made the selection to use ActiveX easy as the enhanced functionality could be controlled through these small programs.  When working with the grid and media objects, the specific areas affected are shown (images are with ActiveX enabled):

 

  • Grid - Import / Export, Copy / Paste

      ImportExportActiveX.png
  • Media Object – Text, OLE

    MOBJActiveX.png

Fast forward many years down the road and now we have multiple strong browsers which provide alternatives to customers.  No longer is Internet Explorer (IE) the dominant browser, with Chrome, Firefox, and Safari all competing in this space.  Now, the question comes, what alternative options can Oracle provide customers to the Microsoft Internet Explorer (IE) only ActiveX controls?

 

Further, what alternatives can be provided before Microsoft support for ActiveX ends?  Although JD Edwards EnterpriseOne supports the new Microsoft Edge browser with Windows 10, ActiveX controls are not supported with the Edge browser by Microsoft.  Instead, they have chosen to end support with the IE11 release.  Further, Microsoft has indicated IE11 support will end with Windows 10, making Windows 10 the last officially supported OS release for IE11.

 

Alternative Solution

 

Starting as far back as 8.98.3, Oracle JD Edwards has been providing a non-ActiveX solution to customers.

 

Grid

 

When first moving from the ActiveX to non-ActiveX, the grid functionality for copy / paste and export / import did not provide the same level of functionality as the ActiveX controls. This is mainly because the functionality was provided to us in the ActiveX control to work with Excel.  This functionality is not inherent in html or java code.

 

Over time, this functionality has been enhanced and now, the grid, with ActiveX and non-ActiveX provide the same functionality for copy / paste and export / import, with the following exceptions (images are with ActiveX disabled).

 

  • Import from Excel is not available

    ImportNone.png
  • Cannot Export to an existing file

    ExportNone.png

Alternatively, an import is done from either CSV or the Clipboard.  An import from the clipboard is similar to a copy / paste.

 

The export options included are the same as ActiveX, however, there is no option to select a specific file or worksheet in the Excel export as there is with ActiveX.

 

Media Object (MOBJ)

 

Text

 

This change in functionality allows for Text attachments to be created using an ADF HTML editor instead of the ActiveX rtf editor.  This change requires the files to be stored in a different format in the database. With the 9.2 release, they are referred to as etxt attachment types.

Due to the change in storage, there is a conversion available to move the attachment types from the ActiveX rtf storage into the new etxt attachment type.

 

Please note, once you create an attachment in the ADF editor or run the conversion over the data to convert to this type, there is no method of moving the data back to the ActiveX format.

In the following image, you can see how the toolbar is different when ActiveX is disabled as well as no OLE option.

 

MOBJNone.png

 

Troubleshooting Tip – If ActiveX is enabled, the option to work with a text attachment will not show in any browser other than Internet Explorer.  As we have learned, this is because ActiveX is Microsoft’s technology and only works with IE.  If ActiveX is disabled, the text editor will display in all browsers.  Below is a screen shot where ActiveX controls are enabled and the user logged in with the Chrome browser.  Notice, both the Text and OLE options are missing from the toolbar in the following image.

 

MOBJActiveXMissing.png

 

OLE

 

Object Linking and Embedding (OLE) is another Microsoft product.  Basically, OLE is a file management container, which allows for embedding the attachment into the file and then retrieving the file for viewing. Other functionality exists within the OLE container, which has been utilized, but since this interaction is entirely built around ActiveX functionality, it is only available with Internet Explorer.

 

There are two options in Server Manager which will enable the OLE functionality.  True for ActiveX and OLE only.  The OLE only option will turn off ActiveX functionality for text attachments and grid, but will enable it for the OLE MOBJ storage.  This allows any customers who have used OLE to still access these attachments while still being able to go browser independent for text and grid functionality. 

 

ActiveXSettings.png

 

Please note, when ActiveX or OLE-Only is enabled, the ability to access the Advanced Media Object functionality with 9.2 is disabled.  Further, Bug 25495854 - ADD A NOTE IN SUPPORTACTIVEXIE JAS.INI was added requesting a pop-up message in Server Manager when changes are made. 

 

Selecting ActiveX or non-ActiveX

 

From the paragraphs above, we understand there is business justification for either using or not using ActiveX controls. This is a business decision which will have to be made by each company.  Below is a summary of attributes for each.

 

ActiveX

  • Stores text in ActiveX RTF mode

 

Pros

  • Able to export to a specific Excel file / workbook
  • Able to import from a specific Excel file / workbook

 

Cons

  • Requires Internet Explorer
    • Only supported up to IE11
    • Support for IE11 has a set end of life
  • Cannot use Advanced Media Object functionality

 

Non-ActiveX

  • Stores text in etxt format

 

Pros

  • Browser Independent (Internet Explorer, Chrome, Firefox, Safari)
    • Do not have to worry about end of life support
  • Can convert existing ActiveX RTF to etxt
    • Once you go to etxt, there is not an option to go back to ActiveX RTF
  • OLE – Optional
  • Use Advanced Media Object functionality (only with OLE and ActiveX disabled)

Cons

  • Export / Import functionality the same except
    • Import from Excel is not available
    • Cannot Export to an existing file

 

Resources

 

EOL Microsoft support for ActiveX controls

  • Has the Web Browser EDGE or Windows 10 been Certified for E1? (Doc ID 2040422.1)

 

In Your Face Message when Changing ActiveX settings

 

Add import from Excel with ActiveX off

  • Bug 18399260 : IMPORT FROM EXCEL WITH ACTIVEX TURNED OFF
  • For members of Quest, you can vote on this bug to move it up the list. See Enhancement Requests via Quest User Groups (Doc ID 1192883.1) for details.

 

ActiveX turned off

  • Non-ActiveX Controls (HTML) for EnterpriseOne Grid Import / Export and Media Object Attachments for all browsers Firefox, Chrome, Internet Explorer (IE), Safari (Doc ID 780761.1)

 

ActiveX enabled

  • Working with E1 Web Client ActiveX Controls for Media Object and Grid Export / Import with Internet Explorer (Doc ID 1056203.1)

 

Advanced Media Object Functionality (Tools Release 9.2)

  • Understanding Advanced Media Object (MOBJ) functionality available in 9.2.1 and newer (Doc ID 2199562.1)

Filter Blog

By date: By tag:

Welcome to the My Oracle Support Community! We highly encourage you to personalize your community display name to make your activity more memorable. Please see https://community.oracle.com/docs/DOC-1022508 for instructions.