Oracle Web Applications Desktop Integrator (Web ADI) Tips for Troubleshooting (Doc ID 390476.1)

Oracle Web Applications Desktop Integrator (Web ADI) Tips for Troubleshooting (Doc ID 390476.1) To Bottom In this Document Purpose Troubleshooting Steps References APPLIES TO: Oracle Web Applications Desktop Integrator - Version 11.5.10.0 to 12.1.3 [Release 11.5 to 12.1] Information in this document applies to any platform. PURPOSE This document is to help better understand Web ADI setup and configuration with Oracle Applications, and touch on the key issues seen within ATG Web ADI Support. Section 1: Overview Section 2: Trouble Shooting Section 3: Web ADI Patches Section 4 Client PC Configuration Section 5 Work Around Section 6 Web ADI Debug Section 7 When to Create New Templates Section 8 Further BNE Resources TROUBLESHOOTING STEPS Section 1 Web ADI Overview: Web Applications Desktop(Web ADI) is a tool for Users which allows the upload and export of data to and from Oracle Applications using standard desktop office products. This is done though the standard desktop products, such as Microsoft Word and Excel Web ADI is becoming a more popular product for the Users as they become more experienced with the standard Word and Excel functionality, and the ease of using Cut and Paste or Dragging information directly to Excel and hitting the upload function. Web ADI is integrated into almost every functional product, and overlaps with the standard Export functionality seen in Core Forms. Release 12 Desktop Integrator Responsibility Official script for BNE responsibilities is: $BNE_TOP/patch/115/import/US/bneresp.ldt For Release 12.x, this ldt does just have 'Desktop Integration' responsibility, and it has had just that one in all versions for 120.x and 120.x.1200000.x Integrators: -An Integrator is a Web ADI term used to encapsulate all of the information required to move data to/from a desktop application into Oracle Applications. An Integrator definition may include information about open interface tables, validation, business rules, and data that can be downloaded. -System Administrator > Application > Function > create a new function           similar to the Web ADI Create Document function, but change the bne:page=BneCreateDoc -URL Call BneApplicationService?bne:page=BneCreateDoc -A list of currently installed integrators can be seen with the following SQL query : select user_name from bne_integrators_tl order by 1; -This query lists the integrator name and product and can be used to just see what integrators are available for a particular Product SELECT biv.integrator_code, biv.user_name, fa.application_id, fa.application_short_name FROM bne_integrators_vl biv, fnd_application fa, fnd_application_tl fat WHERE biv.application_id = fa.application_id AND fa.application_id = fat.application_id /* The next line can be commented out to return all products */ AND fa.application_short_name = '&ApplicationShortNameApplicationShortName' AND fat.language = 'US' ORDER BY fa.application_short_name, biv.user_name; -To allow a Integrator to be removed from the list or enabled, update the enabled_flag on the bne_integrators_b table to "Y" or "N" for the desired : integrator_code/application_id combination. UPDATE bne_integrators_b SET enabled_flag='N'  WHERE integrator_name='<Integrator name>'; Viewers: -A Viewer is a Web ADI term for the desktop application in which a document will be generated. -A customer can select Excel 97 from the list and still generate a spreadsheet successfully on Excel 2007. The BNE .ldt file which creates the Viewer List is the bnevw.ldt. For example, the Version 115.59.1013.4 Will deliver the Excel 2007 for 11i Applications. $BNE_TOP/patch/import/US/bnevw.ldt FNDLOAD APPS/APPS 0 Y UPLOAD $BNE_TOP/admin/import/bnevw.lct $BNE_TOP/patch/115/import/US/bnevw.ldt Layouts: -A Layout tells Web ADI which columns will be displayed in the Desktop Application document and how those columns will be displayed, including formatting. Web ADI provides a set of screens that users and Integrator Developers can use to create their own Layouts. Integrator Developers are able to provide Layouts as seed data. FNDLOAD APPS/APPS 0 Y UPLOAD $BNE_TOP/admin/import/bnelay.lct $BNE_TOP/patch/115/import/US/bnelay.ldt Tables related to Layout definition: -select count(1) from BNE.BNE_LAYOUTS_B; -select count(1) from BNE.BNE_LAYOUTS_TL; -select count(1) from BNE.BNE_LAYOUT_BLOCKS_B; -select count(1) from BNE.BNE_LAYOUT_COLS; -select count(1) from BNE.BNE_LAYOUT_LOBS; select lt.user_name, lc.layout_code, lc.block_id, lc.interface_seq_num from bne_layout_cols lc, bne_layouts_b lb, bne_layouts_tl lt where lb.application_id = lt.application_id and lb.layout_code = lt.layout_code and lb.integrator_app_id = 231 and lb.integrator_code = 'JOURNALS_115' and lc.application_id = lt.application_id and lc.layout_code = lt.layout_code and lt.language = 'US' and lc.application_id = 231 and lc.interface_app_id = 231 and lc.interface_code = 'GL_INTERFACE_115' order by lc.layout_code, lc.block_id, lc.interface_seq_num; Content: -This is the information that will be downloaded into the Viewer. Content definitions is to identify the data to be downloaded, and any required parameters. The Content that is passed to or selected in the Create Document page flow determines the Content that will be used to derive the Content data. Can be a Text File or Java Class for Content. -Tables related: BNE_CONTENTS_TL BNE_CONTENTS_B BNE_CONTENT_COLS_TL The Login URL for the BNE when attempting to Upload. oracle.apps.bne.webui.pageflow.BneOALoginPage.class calls the cancelUrl and successUrl How BNE pulls the Responsibilities: Bne Responsibilities web page is oracle.apps.bne.webui.pageflow.BneOALoginPage2.java Which, gets the resp list from oracle.apps.bne.utilities.oa.BneOASessionUtils.java Which uses these queries: sqlQuery = "SELECT RT.RESPONSIBILITY_NAME, UR.RESPONSIBILITY_APPLICATION_ID, UR.RESPONSIBILITY_ID " + "FROM FND_RESPONSIBILITY_TL RT, FND_RESPONSIBILITY R, FND_USER_RESP_GROUPS UR " + "WHERE UR.USER_ID = :1 " + "AND SYSDATE BETWEEN UR.START_DATE AND NVL(UR.END_DATE, SYSDATE) " + "AND R.APPLICATION_ID = UR.RESPONSIBILITY_APPLICATION_ID " + "AND R.RESPONSIBILITY_ID = UR.RESPONSIBILITY_ID " + "AND SYSDATE BETWEEN R.START_DATE AND NVL(R.END_DATE, SYSDATE) " + "AND R.APPLICATION_ID = RT.APPLICATION_ID " + "AND R.RESPONSIBILITY_ID = RT.RESPONSIBILITY_ID " + "AND RT.LANGUAGE = :2 "; if ( version != null ) { sqlQuery += "AND NVL(R.VERSION, '0') = :3 "; } sqlQuery += "ORDER BY 1 "; OR String sqlQuery = "SELECT RT.RESPONSIBILITY_NAME, UR.RESPONSIBILITY_APPLICATION_ID, UR.RESPONSIBILITY_ID, S.SECURITY_GROUP_NAME, S.SECURITY_GROUP_ID " + "FROM FND_RESPONSIBILITY_TL RT, FND_RESPONSIBILITY R, FND_USER_RESP_GROUPS UR, FND_SECURITY_GROUPS_VL S " + "WHERE UR.USER_ID = :1 " + "AND SYSDATE BETWEEN UR.START_DATE AND NVL(UR.END_DATE, SYSDATE) " + "AND R.APPLICATION_ID = UR.RESPONSIBILITY_APPLICATION_ID " + "AND R.RESPONSIBILITY_ID = UR.RESPONSIBILITY_ID " + "AND SYSDATE BETWEEN R.START_DATE AND NVL(R.END_DATE, SYSDATE) " + "AND R.APPLICATION_ID = RT.APPLICATION_ID " + "AND R.RESPONSIBILITY_ID = RT.RESPONSIBILITY_ID " + "AND UR.SECURITY_GROUP_ID = S.SECURITY_GROUP_ID " + "AND RT.LANGUAGE = :2 "; if ( version != null ) { sqlQuery += "AND NVL(R.VERSION, '0') = :3 "; BNE Servlets: The Release 12 BNE Servlets can be found under following location: $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml Note: Don't confuse '$IAS_ORACLE_HOME' with '$ORA_CONFIG_HOME' as the $IAS_ORACLE_HOME will point you to the wrong orion-web.xml. <!-- WEBADI Servlets --> <servlet> <servlet-name>BneApplicationService</servlet-name> <servlet-class>oracle.apps.bne.webui.BneApplicationService</servlet-class> </servlet> Description: Application Service is a re-implementation of a simple UIX ( CABO ) Page Broker. Its primary purpose is to deliver UIX ( CABO ) pages and flows ( including menus ) via a BneBasePage Controller and BneBasePage which retains UIX ( MARILN ) nodes and event handling. <servlet> <servlet-name>BneComponentServiceBneComponentService</servlet-name> <servlet-class>oracle.apps.bne.integrator.component.BneComponentService</servlet-class> </servlet> Description: BneComponentServiceBneComponentService - Calls Component Classes passing all parameters. This is one of the three Web ADI servlets. It is concerned with the running of Web ADI components - most typically LOVs. It runs in secure (non GUEST) authentication mode. If a user is not logged in with a non GUEST account, it will force them to log in. <servlet> <servlet-name>BneDocumentServiceBneDocumentService</servlet-name> <servlet-class>oracle.apps.bne.integrator.document.BneDocumentService</servlet-class> </servlet> Description: BneDocumentServiceBneDocumentService - servlet used for launching Bne Viewers. This servlet is deprecated in favor of using the Create Document page flow which will use the BneTemplateService to stream viewers. This will give transparent cross browser support on the windows platform, whereas this service relies on Internet Explorer functionality. As of R12, this servlet has been changed to take advantage of Document Parameters stored in the database. The core viewer parameters are now sourced from here and not the servlet request/parameter list in the servlet session. <servlet> <servlet-name>BneViewerXMLServiceBneViewerXMLService</servlet-name> <servlet-class>oracle.apps.bne.integrator.document.BneViewerXMLService</servlet-class> </servlet> Description: BneViewerXMLServiceBneViewerXMLService extends BneAbstractXMLServletBneAbstractXMLServlet. Its main steps are to Perform Validation, Load Viewer Class, Run Viewer Creation and Stream XML. <servlet> <servlet-name>BneDownloadServiceBneDownloadService</servlet-name> <servlet-class>oracle.apps.bne.integrator.download.BneDownloadService</servlet-class> </servlet> Description: BneDownloadServiceBneDownloadService extends BneAbstractXMLServletBneAbstractXMLServlet. <servlet> <servlet-name>BneOfflineLOVServiceBneOfflineLOVService</servlet-name> <servlet-class>oracle.apps.bne.integrator.download.BneOfflineLOVService</servlet-class> </servlet> Description: BneOfflineLOVServiceBneOfflineLOVService extends BneAbstractXMLServletBneAbstractXMLServlet. <servlet> <servlet-name>BneUploaderService</servlet-name> <servlet-class>oracle.apps.bne.integrator.upload.BneUploaderService</servlet-class> </servlet> Description: Web Interface for Web ADI Uploads. An upload is the process of receiving an xml file of data from the viewer (excel, word, project, etc), parsing the xml, validating the data and either loading it into database tables or passing the data values to an API, either pl/sql (currently) or java (in the future) Upload functionality is accomplished at a high level by three classes. BneUploaderService (which takes the handleRequest (from BneAbstractXMLServletBneAbstractXMLServlet, which is a wrapper over the doGet/doPost from HttpServlet) into a call to....) BneUploader (which handles calling the main upload functionality via SAX) BneSAXUploader</li> BneUploaderService is the web interface to the BneUploader class. All of the significant functionality of the upload is accomplished by the BneUploader class, refer to the javadoc for BneUploader for details about the upload functionality. Effectively this makes BneUploaderService a web wrapper for the BneUploader class. As such, there are four main functions carried out by BneUploaderService. 1st, obtain the upload file (and any http request parameters) from the servlet request 2nd, ensure that the request is made within a self service applications session 3rd, call the processUpload method of the BneUploader class 4th, return any messages to the calling environment, in xml format <servlet> <servlet-name>BneTemplateRedirectServiceBneTemplateRedirectService</servlet-name> <servlet-class>oracle.apps.bne.integrator.document.template.BneTemplateRedirectService</servlet-class> </servlet> Description: BneTemplateRedirectServiceBneTemplateRedirectService extends BneHTMLServletBneHTMLServlet. <servlet> <servlet-name>BneTemplateService</servlet-name> <servlet-class>oracle.apps.bne.integrator.document.template.BneTemplateService</servlet-class> </servlet> Description: This class is a part of the Web ADI framework used to stream Template (or Bootstrap) viewers to the client. It requires only the bne:documentId parameter sent on the http request. <servlet> <servlet-name>BneAdminServletBneAdminServlet</servlet-name> <servlet-class>oracle.apps.bne.framework.BneAdminServlet</servlet-class> </servlet> Description: This servlet is a facility to help administer Web ADI. It acts as a service to: -get log file information -change your log level -various middle tier information -reset internal caches <servlet> <servlet-name>BneCaboTestServletBneCaboTestServlet</servlet-name> <servlet-class>oracle.apps.bne.framework.BneCaboTestServlet</servlet-class> </servlet> Description: This servlet is for testing Web ADI UIX configuration settings. It creates four pages, the first is a default form which is used to call 2 explanation pages and 2 test pages:UIXsimple or UIXcomplex. The form parameter "showpage" determines which of these pages is shown, if there is no value for showpage, a form is displayed giving the user various choices. Otherwise the appropriate html or UIX page is shown. <servlet> <servlet-name>BneSnoopServletBneSnoopServlet</servlet-name> <servlet-class>oracle.apps.bne.framework.BneSnoopServlet</servlet-class> </servlet> Description: This servlet is used to test the configuration of a Bne Servlet, shows the java properties and servlet properties. Release 11.5.10 BNE Servlets can be found under following location: $IAS_ORACLE_HOME/Apache/Jserv/etc/zone.properties # ----- WEBADI Servlet ----- # servlet.BneSnoopServlet.code=oracle.apps.bne.framework.BneSnoopServlet servlet.BneProxy.code=oracle.apps.bne.share.BneProxy servlet.BneComponentService.code=oracle.apps.bne.integrator.component.BneComponentService servlet.BneDocumentService.code=oracle.apps.bne.integrator.document.BneDocumentService servlet.BneApplicationService.code=oracle.apps.bne.webui.BneApplicationService servlet.BneCaboTestServlet.code=oracle.apps.bne.framework.BneCaboTestServlet servlet.BneUploaderService.code=oracle.apps.bne.integrator.upload.BneUploaderService You may see references to BNE in the jserv.properties, however this parameter is no longer used as of 11.5.9 and higher. wrapper.classpath=/u02/oracle/visappl/bne/11.5.0/conf This relates to $BNE_TOP/conf/webadi.properties. This file is also no longer used but still exists on the 11.5.10 file system. This properties file was replaced by the Profiles and zone.properties file. The main tables in ADI are as follows: BNE_CONTENTS_TL BNE_INTEGRATORS_TL BNE_INTERFACES_TL BNE_INTERFACE_COLS_TL BNE_LAYOUTS_TL BNE_LAYOUT_COLS BNE_MAPPINGS_TL Section 2 Trouble Shooting: 1. Functional Setup Test through BNE Admin Servlet: BNE Admin Servlet. http://<server_name>:<server_port>/oa_servlets/oracle.apps.bne.framework.BneAdminServlet Please note down the BNE Code Level, Java Version and Log Information sections. Provide this information to Support. At this point Clear the BNE Cache, by clicking on the Link. At the bottom of the page you should see 'Cache Cleared' 2. Upload the Journal Import Request 'View Output' to the SR, if the issue reported is related to the Upload functionality. 3. To enable Debug, set the BNE Profiles: BNE Server Log Filename = <provide name> BNE Server Log Level = TRACE BNE Server Log Path = <set to the value of the $APPLTMP> OR <match the value given in the webadi.properties for 11i. 4. Log in to the Applications as the System Administrator and navigate to Applications - Function. Query the %BNE% Check the Function BNE_CREATE_DOCUMENT and make sure the correct Web HTML call is to the Servlet BneApplicationService and that the Web Host is set to the correct host. 5. Check if BNE is Installed: select application_short_name, application_name, product_version,status from FND_PRODUCT_INSTALLATIONS , fnd_application,fnd_application_tl where fnd_product_installations.application_id = fnd_application.application_id and fnd_product_installations.application_id = fnd_application_tl.application_id and language = 'US' and application_short_name = 'BNE'; COL app_s_name FORMAT a16 COL inst_status FORMAT a15 COL product_version FORMAT a12 COL patchset FORMAT a15 COL appl_id FORMAT 99999 select fav.application_id APPL_ID, fav.application_short_name app_s_name, decode(fpi.status,'I','Installed','S','Shared','N','No', fpi.status) inst_status, fpi.product_version, nvl(fpi.patch_level, 'Not Available') patchset from fnd_application_vl fav, fnd_product_installations fpi where fav.application_id = fpi.application_id and fav.application_short_name = 'BNE'; For a more comprehensive picture, run the AD Configuration Report ($AD_TOP/sql/adutconf.sql) to document the status of an Oracle E-Business Suite system, and provide information about all installed products (including shared and dependent products). If a shared product is present in the shared products list of any installed products (you can verify this from the $APPL_TOP/admin/applprod.txt file) 6. What patchset level do you have for Web ADI? select substr(aa.application_short_name,1,20) "Product", a.patch_level "Patch Level" from fnd_product_installations a, fnd_application aa where a.application_id = aa.application_id and aa.application_short_name = 'BNE'; Section 3 Web ADI Patches: NOTE: Many Web ADI code fixes are delivered within ATG Rup patches.  Please ensure to apply the more recent ATG Rup patch to obtain the latest ADI code fixes. Please review Note 726989.1 List of Patches in Web Applications Desktop Integrator (Web ADI) for Releases 11i and 12, for all the latest BNE Patchs. Note that there are a number of Patches labeled as BNE A and each BNE A Patch(set) is different. Pay attention to the release date and patch number. The same for BNE B Patch(set). For Release 12, BNE A typically go with the R12.0.x and the BNE B typically go with 12.1.x version. Section 4 Client PC Configuration: The main issues are related to the Microsoft Office or the Browsers not configured correctly to meet the Web ADI requirements. For the Browsers, to create an excel spreadsheet on your desktop through Web ADI, the 'Initialize and script Active X controls not marked as safe' setting must be set to 'Prompt'. This is only defaulted to this value on a 'Low' security setting', therefore you will probably need to alter this setting through Internet Explorers Custom Settings option as follows; Select Tools -> Internet Options -> Security tab from the Internet Explorer Menu Bar. Select the zone that you are running Oracle E-Business Suite through and click the 'Custom Level' button. You can then set the value as recommended above. Changing Macro Security Settings for Excel XP/2003 For Web ADI to work with Microsoft Excel 2002/2003, you must change the macro settings for Excel 2002/2003. To do so: 1. In Excel, from the Tools menu, select Macro, then Security, then Security Level. 2. Select the "Medium" option. 3. Select the Trusted Sources tab. 4. Select the "Trust access to Visual Basic Project" option. Changing Macro Security Settings for Excel 2007 For Web ADI to work with Microsoft Excel 2007, you must change the macro settings for Excel 2007. To do so: 1. Click the Office Button (top-left button in the window) 2. Click the 'Excel Options' button. 3. Click 'Trust Center' link from the menu on the left. 4. Click 'Trust Center Settings...' button. 5. In the 'Trust Center' window click 'Macro Settings' link from the menu on the left. 6. Under 'Macro Settings' check 'Disable all macros with notification'. 7. Under 'Developer Macro Settings' check 'Trust Access to the VBA project object model'. 8. Click 'OK' button to close the 'Trust Center' window. 9. Click 'OK' button to return to the spreadsheet. Changing Macro Security Settings for Excel 2010 1. Click File -> Options 2. Click 'Trust Center' link in the 'Excel Options' window. 3. Click 'Trust Center Settings...' button. 4. In the 'Trust Center' window click 'Macro Settings' link from the menu on the left. 5. Under 'Macro Settings' check 'Disable all macros with notification'. 6. Under 'Developer Macro Settings' check 'Trust Access to the VBA project object model'. 7. Click 'OK' button to close the 'Trust Center' window. 8. Click 'OK' button to return to the spreadsheet. Make sure the Browsers are configured per the following documents in order for the Web ADI to function correctly. Note 285218.1 Recommended Browsers for Oracle E-Business Suite 11i Note 389422.1 Recommended Browsers for Oracle E-Business Suite Release 12 Is Safari for Mac supported for WebADI on EBS R12? As documented in the known issues section of Note 864552.1, the following Oracle E-Business Suite Release 12 products are not certified for Mac OS X:     * Oracle E-Business Suite Release 12 ADI and Web ADI. Section 5 Work Around: Web ADI is a Reporting Tool, that has all the product specific reports under a central location. Each Product will still have there own reports located somewhere within that products functionality, so its just a matter of locating the equivalent report. Each product offers Export functionality for another method of manipulating the Data with Microsoft Office products. Note: Web ADI support issues cannot be Severity 1 or Severity 2P1. The highest any ADI issue can be is Severity 2. Web ADI is a tool that replicates functions that can be performed under each Product within the Oracle Applications. There is always a work around to the Web ADI though product specific Reports and Export functionality. Section 6 Web ADI Debug: Gathering BNE RDA for 11i and R12 will provide all the BNE Class files and there versions, Profiles, BNE Tables along with other Key Information. Since the old BNETEST is no longer supported or used, the RDA has basically become the replacement. 1. Login to E-Business Suite using your username/password 2. Select the "Application Diagnostics" or the "Oracle Diagnostics Tool" responsibility 3. Click on the Registered Test linked to Web Applications Desktop Integrator. 4. Enter: Responsibility ID = 24076 Application Shortname = BNE Your apps username and password. Click on the Run Test button. 5. Upload results to SR OR Basic Test Quick Test Run this basic WebADI test to see if WebADI is functioning: 1. Make sure that to have  the Oracle Web ADI Responsibility added to the sysadmin user. Security > User > Define Query up the Sysadmin user. Add the Oracle Web ADI Responsibility Save Changes. 2. Verify the Menu associated with the Oracle Web ADI responsibility is "Web ADI Menu (1)" Security > Responsibility Query up the Oracle Web ADI responsibility and verify that the menu associted with this responsibility is "Web ADI Menu (1)". 3. Add the function "Daily Rates Web-ADI Spreadsheet" to the "Web ADI Menu (1)" menu. Application > Function Give it a name/prompt and add the function "Daily Rates Web-ADI Spreadsheet". Save the changes. Check the concurrent request and verify that the menus recompiled successfully. 4. Logout and back in, then run this WebADI Test: Responsibility = Oracle Web ADI  > Create Document > Viewer = Excel 2000 Next Integrator = General Ledger - Daily Rates Next Continue to accept the defaults and click on Next until the document is created. Does this complete successfully? To enable Debug, set the profiles under System Administrator - System Profiles Example: BNE Server Log Filename : <create name> (make sure name doesn't exist already and if it does, delete it) BNE Server Log Level : TRACE BNE Server Log Path : (free to choose, eg. in the $LOG_HOME/bne.log) (use the full path to the $LOG_HOME) BNE profile options are only valid at the Site Level. If you make changes to any of the profile options, you will need to bounce the web services before the changes will take effect. If this is a Multi-Node environment, make sure the BNE Log is being created on the Middle tier that the BNE is running on. Reproduce the issue. Once the issue was reproduced, turn off Trace by setting BNE Server Log Level back to Detail. Upload the Trace to Support Section 7 When to Create New Templates: Their will be some cases that Customers Pre-Saved Web ADI Templates no longer work or fail to upload. The major reason for this is due to Architectural changes with the environment using the Web ADI. In some cases Web ADI is on an environment that goes though Architectural changes, such as moving to SSL, SSO or Load Balancer Configurations, the Web ADI Pre-Saved Integrators will need to be recreated due to Server URL and and other various information being Hard Coded in the Excel Macro's. For SSO, Load Balancer the Issue will be related to the Arcitecural change with the Login URL being incorrect. For SSL, it will be a combination for Server URL along with SSL Certificate Keys. Web ADI is a Web Server based application that uses Apache Servlets. If you look into the Functions under Sysadmin Responsibility -> Responsibility and lookup Web ADI you will see all the Functions set up are calling Servlets to luanch the particular Menu call. This will be set under the HTTP Tab. If the URL Call set in this Function changes, the Pre-Saved Templates will fail due to the Macro passing a invalid or particular authentication to the Oracle Applications. Due to this, the Templates will no longer work and will need to be re-created. Other reasons to create New Templates: - Upgrade of Applications. Example: Customer has upgraded from R11.5.10 to R12.1.3 or even 12.1.2 to 12.1.3 - Upgrade of Database. Example: Upgraded from RDBMS version 11.1.0.4 to 12.1.0.1 - Upgrade of Excel. Example: Upgraded from Excel 2007 to Excel 2013 - Upgrade of Apps Server. - In addition, old workbooks/templates tend to get corrupted over a period of time and could cause errors. You will need to Recreate the Template using the Web ADI Create Document flow. Select the Cells you want to copy from the Old Template and click Copy. Select the Cell in the Upper left and copy the data to the new Template created using the Edit Menu, click Paste Special to paste to the cells. Click Values. This copies the values to the new Template. Section 8 Further BNE Resources: Oracle® Web Applications Desktop Integrator Implementation and Administration Guide Release 12 Part No. B31411-01 http://download.oracle.com/docs/cd/B40089_10/current/acrobat/120bneig.pdf Oracle® Web ADI Implementation and Administration Guide Release 11i Part No. B15518-01 http://download.oracle.com/docs/cd/B25516_18/current/acrobat/115bneig.pdf Note 726989.1 List of Patches in Web Applications Desktop Integrator(Web ADI) for Releases 11i and 12 Note 285218.1 Recommended Browsers for Oracle E-Business Suite 11i Note 389422.1 Recommended Browsers for Oracle E-Business Suite Release 12 Note 106528.1 Application Desktop Integrator - Product Documentation Note 1077728.1 Using Microsoft Office 2007 and 2010 with Oracle E-Business Suite 11i and R12 Note 1251224.1 FAQ: Certification Information For Client ADI And Webadi REFERENCES NOTE:285218.1 - Recommended Browsers for Oracle E-Business Suite 11i NOTE:106528.1 - Application Desktop Integrator - Product Documentation NOTE:389422.1 - R12: Recommended Browsers for Oracle E-Business Suite NOTE:726989.1 - Web Applications Desktop Integrator (Web ADI) List of Patches NOTE:1077728.1 - Microsoft Office Integration with Oracle E-Business Suite 11i and R12 NOTE:1251224.1 - FAQ: Certification Information For Client ADI And Webadi