Web-ADI Template Settings for Microsoft Excel

Often times, WebADI can be very confusing to work with. There are just too many issues if it is not properly set up. Sometimes you may encounter VBProject Runtime Error when trying to open Web-ADI template file, or sometimes the Excel spreadsheet just hangs up, or can't be opened.

There are few steps you will have to take before WebADI can be properly used:

• Microsoft Office Version
• Microsoft Excel Settings
• Internet Explorer Settings

Follow the steps below given in the screenshots and apply the settings exactly as they are depicted. The screenshots are from Excel 2010, however the settings should also work for 2000, 2003, 2007 versions.

A)  Check the Microsoft Office Version

Make sure you are using 32-bit version of Microsoft Office. Click on Excel --> File --> Help. If you are running 64-bit version, you may want to uninstall 64-bit and re-install the 32-bit version of Microsoft Office.

B)  Open Microsoft Excel --> File --> Options --> Trust Center --> Trust Center Settings

B-1)  Trusted Documents:

Make sure to check "Allow documents on a network to be trusted".

B-2)  Add-Ins:

Make sure to uncheck all the options.

B-3)  ActiveX Settings:

Check only "Enable all controls without restrictions and without prompting". All other options should be unchecked.

B-4)  Macro Settings:

Check "Enable all macros" and "Trust access to the VBA project object model" options.

B-5)  Protected View:

Check only "Enable Protected View for Outlook attachments" and "Enable Data Execution Prevention mode" options. All other options should be unchecked.

In case the WebADI still does not work, then keep all the options unchecked, and retry.

B-6)  Message Bar:

Check "Show the Message Bar in all applications when achieve content, such as ActiveX controls and macros, has been blocked".

B-7)  External Content:

Check the "Enable all Data Connections" and "Enable automatic update for all Workbook Links" options only.

C)  Internet Explorer Settings:

Open Internet Explorer --> Tools --> Internet Options --> Security Tab --> Custom Level.

C-1)  Downloads

Scroll down to Downloads section, and make sure File Download is Enabled.

C-2)  Miscellaneous: 

Scroll down to Miscellaneous section, and make sure to match the following setting.

C-3)  Scripting: 

Scroll down to Scripting section, and make sure to match the following setting. Then press OK.

Now log out from your Oracle Applications and re-log back in. Retry the Web-ADI upload.

References:
Web ADI Errors & Solutions
R12 Web ADI: Make it work with MS Office 2010
Troubleshooting user issues with Oracle Web ADI

Oracle AIM 3.0 Implementation Documentation

Following are the list of standard documentation that needs to be prepared for Oracle Applications Implementation.

You can download the documentation templates from http://www.lexerdgroup.com/oracle/265498.EXE (23.8 mb). After the installation, you can find the templates in C:\Method\OM30\AIM30\AIM30FND\Wordlib directory.

Business Process Architecture (BP)

BP.010    Define Business and Process Strategy
BP.020    Catalog and Analyze Potential Changes
BP.030    Determine Data Gathering Requirements
BP.040    Develop Current Process Model
BP.050    Review Leading Practices
BP.060    Develop High-Level Process Vision
BP.070    Develop High-Level Process Design
BP.080    Develop Future Process Model
BP.090    Document Business Procedure

Business Requirements Definition (RD)

RD.010    Identify Current Financial and Operating Structure
RD.020    Conduct Current Business Baseline
RD.030    Establish Process and Mapping Summary
RD.040    Gather Business Volumes and Metrics
RD.050    Gather Business Requirements
RD.060    Determine Audit and Control Requirements
RD.070    Identify Business Availability Requirements
RD.080    Identify Reporting and Information Access Requirements

Business Requirements Mapping (BR)

BR.010    Analyze High-Level Gaps
BR.020    Prepare mapping environment
BR.030    Map Business requirements
BR.040    Map Business Data
BR.050    Conduct Integration Fit Analysis
BR.060    Create Information Model
BR.070    Create Reporting Fit Analysis
BR.080    Test Business Solutions
BR.090    Confirm Integrated Business Solutions
BR.100    Define Applications Setup
BR.110    Define security Profiles

Application and Technical Architecture (TA)

TA.010     Define Architecture Requirements and Strategy
TA.020     Identify Current Technical Architecture
TA.030     Develop Preliminary Conceptual Architecture
TA.040     Define Application Architecture
TA.050     Define System Availability Strategy
TA.060     Define Reporting and Information Access Strategy
TA.070     Revise Conceptual Architecture
TA.080     Define Application Security Architecture
TA.090     Define Application and Database Server Architecture
TA.100     Define and Propose Architecture Subsystems
TA.110     Define System Capacity Plan
TA.120     Define Platform and Network Architecture
TA.130     Define Application Deployment Plan
TA.140     Assess Performance Risks
TA.150     Define System Management Procedures

Module Design and Build (MD)

MD.010    Define Application Extension Strategy
MD.020    Define and estimate application extensions
MD.030    Define design standards
MD.040    Define Build Standards
MD.050    Create Application extensions functional design
MD.060    Design Database extensions
MD.070    Create Application extensions technical design
MD.080    Review functional and Technical designs
MD.090    Prepare Development environment
MD.100    Create Database extensions
MD.110    Create Application extension modules
MD.120    Create Installation routines

Data Conversion (CV)

CV.010    Define data conversion requirements and strategy
CV.020    Define Conversion standards
CV.030    Prepare conversion environment
CV.040    Perform conversion data mapping
CV.050    Define manual conversion procedures
CV.060    Design conversion programs
CV.070    Prepare conversion test plans
CV.080    Develop conversion programs
CV.090    Perform conversion unit tests
CV.100    Perform conversion business objects
CV.110    Perform conversion validation tests
CV.120    Install conversion programs
CV.130    Convert and verify data

Documentation (DO)

DO.010    Define documentation requirements and strategy
DO.020    Define Documentation standards and procedures
DO.030    Prepare glossary
DO.040    Prepare documentation environment
DO.050    Produce documentation prototypes and templates
DO.060    Publish user reference manual
DO.070    Publish user guide
DO.080    Publish technical reference manual
DO.090    Publish system management guide

Business System Testing (TE)

TE.010     Define testing requirements and strategy
TE.020     Develop unit test script
TE.030     Develop link test script
TE.040     Develop system test script
TE.050     Develop systems integration test script
TE.060     Prepare testing environments
TE.070     Perform unit test
TE.080     Perform link test
TE.090     perform installation test
TE.100     Prepare key users for testing
TE.110     Perform system test
TE.120     Perform systems integration test
TE.130     Perform Acceptance test

Performance Testing (PT)

PT.010     Define Performance Testing Strategy
PT.020     Identify Performance Test Scenarios
PT.030     Identify Performance Test Transaction
PT.040     Create Performance Test Scripts
PT.050     Design Performance Test Transaction Programs
PT.060     Design Performance Test Data
PT.070     Design Test Database Load Programs
PT.080     Create Performance Test Transaction Programs
PT.090     Create Test Database Load Programs
PT.100     Construct Performance Test Database
PT.110     Prepare Performance Test Environment
PT.120     Execute Performance Test

Adoption and Learning (AP)

AP.010    Define Executive Project Strategy
AP.020    Conduct Initial Project Team Orientation
AP.030    Develop Project Team Learning Plan
AP.040    Prepare Project Team Learning Environment
AP.050    Conduct Project Team Learning Events
AP.060    Develop Business Unit Managers’ Readiness Plan
AP.070    Develop Project Readiness Roadmap
AP.080    Develop and Execute Communication Campaign
AP.090    Develop Managers’ Readiness Plan
AP.100    Identify Business Process Impact on Organization
AP.110    Align Human Performance Support Systems
AP.120    Align Information Technology Groups
AP.130    Conduct User Learning Needs Analysis
AP.140    Develop User Learning Plan
AP.150    Develop User Learning ware
AP.160    Prepare User Learning Environment
AP.170    Conduct User Learning Events
AP.180    Conduct Effectiveness Assessment

Production Migration (PM)

PM.010    Define Transition Strategy
PM.020    Design Production Support Infrastructure
PM.030    Develop Transition and Contingency Plan
PM.040    Prepare Production Environment
PM.050    Set Up Applications
PM.060    Implement Production Support Infrastructure
PM.070    Verify Production Readiness
PM.080    Begin Production
PM.090    Measure System Performance
PM.100    Maintain System
PM.110    Refine Production System
PM.120    Decommission Former Systems
PM.130    Propose Future Business Direction
PM.140    Propose Future Technical Direction

Query to find Oracle Alert

The following query finds all enabled custom alerts. You can comment out the very last two lines (alr.enabled_flag and alr.created_by) to display all both enabled and disabled alerts.

-------------------------------------------------------------------------------

-- Query to find Custom Oracle Alert

-------------------------------------------------------------------------------

SELECT alr.application_id,

       alr.alert_id,

       alr.alert_name,

       alr.start_date_active,

       alr.description,

       alr.sql_statement_text

  FROM ALR.ALR_ALERTS  alr

 WHERE alr.created_by <> 1      -- show only custom alerts

   AND alr.enabled_flag = 'Y';  -- show only enabled alerts

Query to find Concurrent Program related information

The following query takes the concurrent program name (for example, "Active Users") and returns its related information (i.e. Reports, Created By, etc.).

Note: Mr. Rajkumar Reddy had pointed out that I could use the "lookup" as opposed to my previous hard-coded "decode" for finding the Execution Method (or program type), which is very efficient. I thank Mr. Raj for sharing this.

--------------------------------------------------------------------------

-- Query to find Concurrent Program related information

--------------------------------------------------------------------------

SELECT cpv.user_concurrent_program_name  "Concurrent Program Name",

       cpv.concurrent_program_name       "Program Short Name",

       efv.application_name              "Application Name",

       cpv.enabled_flag                  "Enabled Flag",

       cpv.output_file_type              "Output Format",

       fu.user_name                      "Created By (userid)",

       (SELECT meaning

          FROM FND_LOOKUP_VALUES_VL flv

         WHERE UPPER (flv.lookup_type) = 'CP_EXECUTION_METHOD_CODE'

           AND flv.Lookup_code = efv.execution_method_code

       )                                 "Execution Method",

       efv.executable_name               "Executable Name",

       efv.execution_file_name           "Execution Filename"

  FROM FND_CONCURRENT_PROGRAMS_VL  cpv,

       FND_EXECUTABLES_FORM_V      efv,

       FND_USER                    fu

 WHERE efv.executable_id  = cpv.executable_id

   AND efv.application_id = cpv.application_id

   AND cpv.created_by     = fu.user_id

   AND cpv.user_concurrent_program_name = 'Active Users' -- // change it

 ORDER BY cpv.user_concurrent_program_name;

Oracle Applications Modules

Taken from Oracle eBusiness Suite Electronic Technical Reference Manual (eTRM), following are the application modules in Oracle R12.


AD  - Applications DBA
AHL - Complex Maintenance Repair and Overhaul
AK  - Common Modules-AK
ALR - Alert
AME - Approvals Management
AMS - Marketing
AMV - Marketing Encyclopedia System
AMW - Internal Controls Manager
AN  - Sales Analysis
AP  - Payables
AR  - Receivables
AS  - Sales Foundation
ASF - Sales Online
ASG - CRM Gateway for Mobile Devices
ASL - Sales Offline
ASN - Sales
ASO - Order Capture
ASP - Oracle Sales for Handhelds
AST - TeleSales
AU  - Application Utilities
AX  - Global Accounting Engine
AZ  - Application Implementation
BEN - Advanced Benefits
BIE - eCommerce Intelligence
BIL - Sales Intelligence
BIM - Marketing Intelligence
BIN - Communications Intelligence
BIS - Applications BIS
BIV - Service Intelligence
BIX - Interaction Center Intelligence
BIY - Systems Intelligence
BLC - Utility Billing
BNE - Web Applications Desktop Integrator
BOM - Bills of Material
BSC - Balanced Scorecard
CCT - Telephony Manager
CDR - Oracle Clinical Data Repository
CE  - Cash Management
CHV - Supplier Scheduling
CLA - APAC Consulting Localizations
CLE - EMEA Consulting Localizations
CLJ - Japan Consulting Localizations
CLL - LAD Consulting Localizations
CLN - Supply Chain Trading Connector for RosettaNet
CN  - Incentive Compensation
CRP - Capacity
CS  - Service
CSC - Customer Care
CSD - Depot Repair
CSE - Asset Tracking
CSF - Field Service
CSI - Install Base
CSL - Field Service/Laptop
CSM - Field Service/Palm
CSN - Call Center
CSP - Spares Management
CSR - Scheduler
CST - Cost Management
CTB - Clinical Transaction Base
CUA - Capital Resource Logistics - Assets
CUC - Revenue Accounting
CUF - Capital Resource Logistics - Financials
CUG - Citizen Interaction Center
CUI - Network Logistics - Inventory
CUP - Network Logistics - Purchasing
CUR - Mass Market Receivables for Comms
CUS - Network Logistics
CZ  - Configurator
DDD - CADView-3D
DDR - Demand Signal Repository
DNA - Development
DOM - Document Managment and Collaboration
DPP - Oracle Price Protection
DT  - DateTrack
EAM - Enterprise Asset Management
EC  - e-Commerce Gateway
ECX - XML Gateway
EDR - E-Records
EGO - Advanced Product Catalog
EMS - Environment Management System
ENG - Engineering
ENI - Product Intelligence
EVM - Value Based Management
FEM - Enterprise Performance Foundation
FF  - FastFormula
FII - Financial Intelligence
FLM - Flow Manufacturing
FND - Application Object Library
FPA - Project Portfolio Analysis
FRM - Report Manager
FTE - Transportation Execution
FTP - Transfer Pricing
FUN - Financials Common Modules
FV  - Federal Financials
GCS - Financial Consolidation Hub
GHR - US Federal Human Resources
GL  - General Ledger
GMA - Process Manufacturing Systems
GMD - Process Manufacturing Product Development
GME - Process Manufacturing Process Execution
GMF - Process Manufacturing Financials
GMI - Process Manufacturing Inventory
GML - Process Manufacturing Logistics
GMO - Manufacturing Execution System for Process Manufacturing
GMP - Process Manufacturing Process Planning
GMS - Grants Accounting
GMW - Process Manufacturing Portal
GNI - Genealogy Intelligence
GR  - Process Manufacturing Regulatory Management
HCA - Healthcare
HCC - iHCConnect
HCN - iHCIntegrate
HCP - Healthcare Intelligence
HCT - Healthcare Terminology Server
HRI - Human Resources Intelligence
HXC - Time and Labor Engine
HXT - Time and Labor
IA  - iAssets
IAM - Digital Asset Management
IBC - Content Manager
IBE - iStore
IBP - Bill Presentment & Payment
IBT - iAuction
IBU - iSupport
IBW - Oracle Web Analytics
IBY - Payments
ICX - Oracle iProcurement
IEB - Interaction Blending
IEC - Advanced Outbound Telephony
IEM - Email Center
IEO - Interaction Center Technology
IEP - Predictive
IES - Scripting
IET - Call Center Connectors
IEU - Universal Work Queue
IEV - IVR Integrator
IEX - Collections
IGC - Contract Commitment
IGF - Financial Aid
IGI - Public Sector Financials International
IGS - Student System
IGW - Grants Proposal
IMC - Customers Online
INL - Oracle Landed Cost Management
INV - Inventory
IPA - Capital Resource Logistics - Projects
IPM - Oracle Imaging Process Management
IRC - iRecruitment
ISC - Supply Chain Intelligence
ISX - iSettlement
ITA - Information Technology Audit
ITG - Internet Procurement Enterprise Connector
IZU - Oracle E-Business Suite Diagnostics
JA  - Asia/Pacific Localizations
JE  - European Localizations
JG  - Regional Localizations
JL  - Latin America Localizations
JMF - Supply Chain Localizations
JTF - CRM Foundation
JTM - Mobile Application Foundation
JTS - CRM Self Service Administration
LNS - Loans
MFG - Manufacturing
MIA - Mobile Applications for Inventory Management
MIV - Media Interactive
MQA - Mobile Quality Applications
MRP - Master Scheduling/MRP
MSC - Advanced Supply Chain Planning
MSD - Demand Planning
MSO - Constraint Based Optimization
MSR - Inventory Optimization
MST - Transportation Planning
MTH - Oracle Manufacturing Operations Center
MWA - Mobile Applications
OAM - Oracle Applications Manager
ODQ - Data Query
OE  - Order Entry
OFA - Assets
OKC - Contracts Core
OKE - Project Contracts
OKI - Contracts Intelligence
OKL - Leasing and Finance Management
OKS - Service Contracts
OKT - Royalty Management
OKX - Contracts Integration
ONT - Order Management
OPI - Operations Intelligence
OTA - Learning Management
OUC - University Curriculum
OZF - Trade Management
PA  - Projects
PAY - Payroll
PBR - Budgeting and Planning
PER - Human Resources
PFT - Oracle Profitability Manager
PJI - Project Intelligence
PJM - Project Manufacturing
PMI - Process Manufacturing Intelligence
PN  - Property Manager
PO  - Purchasing
POA - Purchasing Intelligence
POM - Exchange
PON - Sourcing
POS - iSupplier Portal
PQH - Public Sector HR
PQP - Public Sector Payroll
PRP - Proposals
PSA - Public Sector Financials
PSB - Public Sector Budgeting
PSP - Labor Distribution
PSR - Public Sector Receivables
PTX - Patch Tracking System
PV  - Partner Management
QA  - Quality
QOT - Quoting
QP  - Advanced Pricing
QPR - Oracle Deal Management
QRM - Risk Management
RG  - Application Report Generator
RLM - Release Management
RMG - Risk Manager
RRC - Retail Core
RRS - Site Management
SHT - Applications Shared Technology
SSP - SSP
SYSADMIN - System Administration
VEA - Automotive
WIP - Work in Process
WMA - Manufacturing Mobile Applications
WMS - Warehouse Management
WPS - Manufacturing Scheduling
WSH - Shipping Execution
WSM - Shop Floor Management
XDO - XML Publisher
XDP - Provisioning
XLA - Subledger Accounting
XLE - Legal Entity Configurator
XNA - Service Assurance for Communications
XNB - Oracle Telecommunications Billing Integrator
XNP - Number Portability
XNT - TeleBusiness for Telecom/Utilities
XTR - Treasury
ZFA - Financial Analyzer
ZPB - Enterprise Planning and Budgeting
ZSA - Sales Analyzer
ZX  - E-Business Tax