Converting Data from Excel to Oracle - Signatures

Part
01
of one
Part
01

Converting Data from Excel to Oracle - Signatures

To adjust the settings for unsigned spreadsheets using Microsoft Excel or to identify the settings for digitally signed spreadsheets using Oracle, someone must use Oracle Web Applications Desktop Integrator and Office Open XML Microsoft Excel format.

Using Oracle Web Applications Desktop Integrator

  • The key features of Oracle Web Applications Desktop Integrator include works via internet, presents Oracle E-Business Suite Data in a spreadsheet interface, validates data, enables customization, and automatically imports data. The data is modified in Excel, validated, and uploaded to the Oracle E-Business Suite.
  • The Oracle E-Business Suite task someone performs on the desktop is determined by the integrator he/she select in Oracle Web Applications Desktop Integrator. Here, each seeded integrator is delivered with the Oracle E-Business Suite product, which provides functionality being integrated with the desktop.

Using the Office Open XML Format

  • Here, someone can choose Oracle Web Applications Desktop Integrator spreadsheets according to the Office Open XML (OOXML) standard.
  • OOXML is a format developed by Microsoft company to represent spreadsheets, among other types of documents. When using this format, Oracle Web Applications Desktop Integrator creates the spreadsheet on the Oracle E-Business Suite server, which is then downloaded to the desktop once it's completed. Also, this server can upload spreadsheets.
  • During the document development, no macros (a series of instructions) are used, and during the uploading process, limited macros are used.
  • Spreadsheets downloaded from Oracle Application Framework tables are usually created as OOXML documents.

Selecting Macro Security Settings in Microsoft Excel

  • When using Excel, someone must select the macro security settings that he/she wants in order to enable the macros used by Oracle Web Applications Desktop Integrator.
  • The Oracle Web Applications Desktop Integrator creates an initial document called WebADI.xls on the server if someone does not use the OOXML format. After this document has been downloaded on the desktop, it creates the actual integrator document using VBA macros. Also, macros are used for lists of values and features in the Oracle ribbon tab, including upload.
  • The Oracle Web Applications Desktop Integrator creates the document on the server without using macros if someone uses the OOXML format. Here, the limited macros are utilized for lists of values and features in the Oracle ribbon tab, including upload.
  • Also, someone can set a medium macro security level, but he/she must activate the macros each time he/she opens an Oracle Web Applications Desktop Integrator spreadsheet. In contrast, when using a high macro security level, he/she must set the "BNE Enable Digital Signature profile" option in Oracle E-Business Suite to have Oracle Web Applications Desktop Integrator attach a digital signature to the spreadsheets he/she creates.
  • Someone should download Oracle Web Applications Desktop Integrator macros from a trusted source so that they can run automatically on Microsoft Excel.
  • If someone does not enable macros with the appropriate setting, according to whether he/she uses digital signatures or not, then the Oracle Web Applications Desktop Integrator features which use macros won't work.
  • Also, if he/she does not use Office Open XML (OOXML) and do not enable macros, then Oracle Web Applications Desktop Integrator cannot create the spreadsheet. In contrast, if he/she does use OOXML, but do not enable macros, then Oracle Web Applications Desktop Integrator can create spreadsheets in the OOXML format on the server. However, he/she cannot use lists of values or the Oracle ribbon tab features, such as upload, when working with those spreadsheets.

Step by Step Process When Adjusting Settings

Settings for Unsigned Spreadsheets Using Microsoft Excel

  • If someone does not use digital signatures in Oracle Web Applications Desktop Integrator, then he/she must set his/her Microsoft Excel macro security to let him/her enable macros on a case by case basis.
  • The procedure to adjust settings varies depending on someone's version of Microsoft Excel. For example:

Procedure When Using Microsoft Excel 2007, 2010, 2013, or 2016

  • 1. Choose the "File tab"> "Options" > "Trust Center"> "Trust Center Settings", and finally choose "Macro Settings".
  • 2. Select the "Disable all macros with notification" option.
  • 3. If he/she is not using OOXML, then he/she must select the "Trust access to the VBA project object model" option. However, this option is not required if he/she is using OOXML.

Procedure When Using Microsoft Excel 2002 or 2003

  • 1. From the "Tools Menu", select "Macro", then "Security", and finally "Security Level".
  • 2. In the "Security Level" tab, select the "Medium" option.
  • 3. In the "Trusted Sources" tab, select the "Trust access to Visual Basic Project" option.


Settings for Digitally Signed Spreadsheets Using Oracle

Procedure When Using Microsoft Excel 2007, 2010, 2013, or 2016

  • 1. Choose the "File tab"> "Options" > "Trust Center"> "Trust Center Settings", and finally choose "Macro Settings".
  • 2. Select the "Disable all macros except digitally signed macros" option.
  • 3. If he/she is not using OOXML, then he/she must select the "Trust access to the VBA project object model" option. However, this option is not required if he/she is using OOXML.

Procedure When Using Microsoft Excel 2002 or 2003

  • 1. From the "Tools Menu", select "Macro", then "Security", and finally "Security Level"
  • 2. In the "Security Level" tab, select the "High" option.
  • 3. In the "Trusted Sources" tab, select the "Trust access to Visual Basic Project" option.


Research Strategy

To find data pertaining to the request, your research team scanned through various publicly available sources, such as the industry-related reports. Fortunately, from this source, Documents Oracle, we could find all the data needed to answer the research questions. Additionally, we have used a source from 2010 because it provides step by step on how to adjust the settings for unsigned spreadsheets using Microsoft Excel, or to identify the settings for digitally signed spreadsheets using Oracle for Microsoft 2002 or 2003.

Sources
Sources