Lift and Shift of Oracle BIAPPS Artifacts to Oracle Analytics Cloud

Authors: Swathi Singamareddygari , Anand Sadaiyan

Table of Contents

Disclaimer
Section:1 Deliverables
Section: 2 Lifting and shifting Application Roles and Web Catalogue
Section: 3 Lifting and Shifting Repository
Section: 4 FAQ
Section: 5 Limitations

Disclaimer

This document does not replace the Oracle Analytics Cloud Service Documentation Library or other Cloud Services documents. It serves as a supplement for Lifting and Shifting Business Intelligence Applications Artifacts (BIAPPS / OBIA) to Oracle Analytics Cloud (OAC).

This document is written based on the Oracle Analytics cloud version 17.2.1.0.0 Screenshots included in this document might differ slightly from what you see on your screen.

Note:  It is always a good practice to take a snapshot of the current environment in Oracle Analytics Cloud, before lifting and shifting the artifacts. Ensure that you create a snapshot before proceeding. 

Section:1 Deliverables

Download the Oracle Analytics Cloud Deliverables Zip file (BIAPPS_10.2.0_OACV1.zip) from the ARU21167611. (Download this patch 21167611 from Oracle Support) . The deliverables are based on BIAPPS 10.2 release.

Zip file consists of
1) OracleBIApps_10.2.0_OACV1.rpd (Password: welcome1)
2) BIAPPS_10.2.0_OACV1.bar (Password: Admin123)


Section:2 Lifting and shifting Application Roles and Web Catalogue

Uploading the Application Roles and web catalogue

From the Oracle Analytics Cloud home page navigate to console and click on snapshots.

  1. Login to the Oracle Analytics Cloud VA page.
  2. From the Oracle Analytics Cloud home page, navigate to the Console and click Snapshots.
  3. Click Upload Snapshot to upload the delivered BAR file. See Uploading Snapshots.
  4. If Virus scanner is not configured, Kindly click “Proceed without a virus scanner”

  1. Select the delivered BAR file and enter “Admin123” as password.

  1. Select the uploaded snapshot, and click the Restore action, and in Restore Snapshot popup, select Application Roles and Catalog and click Restore to restore the snapshot for Application Roles and Web catalogue. See Restoring Snapshots.

  1. Verify the imported Application Roles in Application Role Management page (Console> Users and Roles-> Application Roles).
                  
  1. Verify the Webcat Artifacts by Clicking on dashboard menu from Classic Home.

 

Section:3 Lifting and Shifting Repository

Note: Any modifications to the repository should be done in the On premise environment. No modifications are allowed in the Oracle Analytics Cloud. Allow 5 minutes of time for the Oracle Analytics Cloud environment to get refreshed after the Repository Upload.

Oracle BI Applications Repository is delivered along with the Oracle Analytics Cloud deliverables zip file.

Uploading the Repository:

  1. Modify the delivered repository with proper connection details (Connection pools and Schema variables OLAPTBO, CM_TBO etc)
  1. Login into Oracle Analytics Cloud environment.
  1. Navigate to Console from the home page and click on Snapshots.

  1. Replace the Oracle Analytics Cloud data model with on-premises repository using “Replace Data model” option. If Virus scanner is not configured, Kindly click “Proceed without a virus scanner”

  1. Choose the on-premises repository and provide the repository password ("welcome1" without quotes).

  1. Verify the Uploaded RPD by Navigating to Analyses and clicking “Create Analysis. You see the available subject areas. For more details on repository Lifting and Shifting refer to  Uploading an On-Premises Data Model to Oracle Cloud Service

Section:4 FAQ

  1. Custom application roles permissions are not getting applied on the Repository objects.
    Solution: Create the custom application roles in VA first and the then upload the Repository.
     
  2. Not able to change permissions for Webcat object and getting Assertion Failure error.



Solution: Delete any unresolved accounts available in the webcat object and then change the permissions.

Section:5 Limitations

Following features which are used in Oracle BI Applications are not supported in Oracle Analytics Cloud environment.

Group
KPI
KPI Watchlist
List Format
Segment
Scorecard

Name

Path

Signature

Campaign Members Load Format

/shared/Marketing/Segmentation/List Formats/Campaign Members Load Format

Campaign Load

Campaign Members Suspects Load Format

/shared/Marketing/Segmentation/List Formats/Campaign Members Suspects Load Format

Campaign Load

Consumer Campaign Members Load Format

/shared/Marketing/Segmentation/List Formats/Consumer Campaign Members Load Format

Campaign Load

Consumer Leads Import Load Format

/shared/Marketing/Segmentation/List Formats/Consumer Leads Import Load Format

Campaign Load

Leads Import Load Format

/shared/Marketing/Segmentation/List Formats/Leads Import Load Format

Campaign Load

Campaign Load - Contacts and Prospects Example

/shared/Marketing/Segmentation/List Formats/Siebel List Formats/Campaign Load - Contacts and Prospects Example

Campaign Load

Campaign Load - Database Writeback Example

/shared/Marketing/Segmentation/List Formats/Siebel List Formats/Campaign Load - Database Writeback Example

Campaign Load

Mutual Exclusion Campaign Load - Contacts and Prospects Example

/shared/Marketing/Segmentation/List Formats/Siebel List Formats/Mutual Exclusion Campaign Load - Contacts and Prospects Example

Campaign Load

Suspects Import Load Format

/shared/Marketing/Segmentation/List Formats/Suspects Import Load Format

Campaign Load

All Groups

/shared/Human Capital Management/_filters/Human Resources - Workforce Deployment/Role Dashboards/All Groups

Group

Below Top Performance

/shared/Human Capital Management/_filters/Human Resources - Workforce Deployment/Role Dashboards/Below Top Performance

Group

Global

/shared/Human Capital Management/_filters/Human Resources - Workforce Deployment/Role Dashboards/Global

Group

Top Performers

/shared/Human Capital Management/_filters/Human Resources - Workforce Deployment/Role Dashboards/Top Performers

Group

Average Negotiation Cycle Time

/shared/Procurement/Procurement Scorecard/KPIs/Customer/Average Negotiation Cycle Time

KPI

Fulfilled Requisition Lines past expected date

/shared/Procurement/Procurement Scorecard/KPIs/Customer/Fulfilled Requisition Lines past expected date

KPI

Late Receipts

/shared/Procurement/Procurement Scorecard/KPIs/Customer/Late Receipts

KPI

Processed Requisition Lines past expected date

/shared/Procurement/Procurement Scorecard/KPIs/Customer/Processed Requisition Lines past expected date

KPI

Procurement Cycle Time

/shared/Procurement/Procurement Scorecard/KPIs/Customer/Procurement Cycle Time

KPI

Unfulfilled Requisition Lines past expected date

/shared/Procurement/Procurement Scorecard/KPIs/Customer/Unfulfilled Requisition Lines past expected date

KPI

Off-Contract Spend

/shared/Procurement/Procurement Scorecard/KPIs/Financial/Off-Contract Spend

KPI

Perfect invoices

/shared/Procurement/Procurement Scorecard/KPIs/Financial/Perfect invoices

KPI

Realized Cost Savings

/shared/Procurement/Procurement Scorecard/KPIs/Financial/Realized Cost Savings

KPI

Invoice Automation

/shared/Procurement/Procurement Scorecard/KPIs/Operations/Invoice Automation

KPI

Manual Requisition Lines Rate

/shared/Procurement/Procurement Scorecard/KPIs/Operations/Manual Requisition Lines Rate

KPI

PO Transactions per Buyer

/shared/Procurement/Procurement Scorecard/KPIs/Operations/PO Transactions per Buyer

KPI

Processed Negotiation Lines

/shared/Procurement/Procurement Scorecard/KPIs/Operations/Processed Negotiation Lines

KPI

# of Suppliers per Category

/shared/Procurement/Procurement Scorecard/KPIs/Supplier/# of Suppliers per Category

KPI

% of Spend By Diversified Suppliers

/shared/Procurement/Procurement Scorecard/KPIs/Supplier/% of Spend By Diversified Suppliers

KPI

On-Time Delivery performance

/shared/Procurement/Procurement Scorecard/KPIs/Supplier/On-Time Delivery performance

KPI

Quality Performance

/shared/Procurement/Procurement Scorecard/KPIs/Supplier/Quality Performance

KPI

Returns

/shared/Procurement/Procurement Scorecard/KPIs/Supplier/Returns

KPI

Exact Match Rate

/shared/Supply Chain Management/Analytic Library/Embedded Content/Logistics/KPIs/Exact Match Rate

KPI

Hit/Miss Accuracy

/shared/Supply Chain Management/Analytic Library/Embedded Content/Logistics/KPIs/Hit\/Miss Accuracy

KPI

Inventory Value

/shared/Supply Chain Management/Analytic Library/Embedded Content/Logistics/KPIs/Inventory Value

KPI

Average Change Order Approval Time

/shared/Supply Chain Management/Analytic Library/Embedded Content/PIM/KPIs/Average Change Order Approval Time

KPI

Average Change Order Cycle Time

/shared/Supply Chain Management/Analytic Library/Embedded Content/PIM/KPIs/Average Change Order Cycle Time

KPI

Average New Item Creation Approval Time

/shared/Supply Chain Management/Analytic Library/Embedded Content/PIM/KPIs/Average New Item Creation Approval Time

KPI

Average New Item Creation Cycle Time

/shared/Supply Chain Management/Analytic Library/Embedded Content/PIM/KPIs/Average New Item Creation Cycle Time

KPI

Percentage of Shared Categories

/shared/Supply Chain Management/Analytic Library/Embedded Content/PIM/KPIs/Percentage of Shared Categories

KPI

List Export - Contacts Example

/shared/Marketing/Segmentation/List Formats/Siebel List Formats/List Export - Contacts Example

List Export

Analytics Data Load - Leads Example

/shared/Marketing/Segmentation/List Formats/Siebel List Formats/Analytics Data Load - Leads Example

Marketing BI Data Load

Analytics Data Load - Responses Example

/shared/Marketing/Segmentation/List Formats/Siebel List Formats/Analytics Data Load - Responses Example

Marketing BI Data Load

Campaign Members Export Format

/shared/Marketing/Segmentation/List Formats/Campaign Members Export Format

Marketing Email Server

Email Personalization - Contacts - OLTP Example

/shared/Marketing/Segmentation/List Formats/Siebel List Formats/Email Personalization - Contacts - OLTP Example

Marketing Email Server

_CauseAndEffectLinkages

/shared/Procurement/Procurement Scorecard/_CauseAndEffectLinkages

Scorecard Cause And Effect Linkages

Cause & Effect Map: Improve Response Time

/shared/Procurement/Procurement Scorecard/Cause & Effect Map: Improve Response Time

Scorecard Causes And Effects View

Automate Invoice Processing

/shared/Procurement/Procurement Scorecard/Automate Invoice Processing

Scorecard Initiative

Consolidate Supplier Base

/shared/Procurement/Procurement Scorecard/Consolidate Supplier Base

Scorecard Initiative

Develop and Implement New policies to support Contract compliance

/shared/Procurement/Procurement Scorecard/Develop and Implement New policies to support Contract compliance

Scorecard Initiative

Establish and Monitor SLAs

/shared/Procurement/Procurement Scorecard/Establish and Monitor SLAs

Scorecard Initiative

Implement Internet Supplier Portal

/shared/Procurement/Procurement Scorecard/Implement Internet Supplier Portal

Scorecard Initiative

Implement Self Service Procurement Application

/shared/Procurement/Procurement Scorecard/Implement Self Service Procurement Application

Scorecard Initiative

Implement Spend Analytics

/shared/Procurement/Procurement Scorecard/Implement Spend Analytics

Scorecard Initiative

Initiatives

/shared/Procurement/Procurement Scorecard/Initiatives

Scorecard Initiative

Monitor Performance and provide regular feedback on quarterly basis

/shared/Procurement/Procurement Scorecard/Monitor Performance and provide regular feedback on quarterly basis

Scorecard Initiative

Monitor Spend and Savings on Monthly Basis

/shared/Procurement/Procurement Scorecard/Monitor Spend and Savings on Monthly Basis

Scorecard Initiative

Monitor Spend by Diversified Suppliers on monthly basis

/shared/Procurement/Procurement Scorecard/Monitor Spend by Diversified Suppliers on monthly basis

Scorecard Initiative

Reward high performing employees

/shared/Procurement/Procurement Scorecard/Reward high performing employees

Scorecard Initiative

_initiativeTree

/shared/Procurement/Procurement Scorecard/_initiativeTree

Scorecard Initiative Tree

Mission

/shared/Procurement/Procurement Scorecard/Mission

Scorecard Mission

Control Spend

/shared/Procurement/Procurement Scorecard/Control Spend

Scorecard Objective

Develop and Retain Strategic Suppliers

/shared/Procurement/Procurement Scorecard/Develop and Retain Strategic Suppliers

Scorecard Objective

Improve Response Time

/shared/Procurement/Procurement Scorecard/Improve Response Time

Scorecard Objective

Improve Supplier Performance

/shared/Procurement/Procurement Scorecard/Improve Supplier Performance

Scorecard Objective

Increase Productivity

/shared/Procurement/Procurement Scorecard/Increase Productivity

Scorecard Objective

New Objective

/shared/Procurement/Procurement Scorecard/New Objective

Scorecard Objective

New Objective 1

/shared/Procurement/Procurement Scorecard/New Objective 1

Scorecard Objective

Procurement Scorecard

/shared/Procurement/Procurement Scorecard/Procurement Scorecard

Scorecard Objective

Promote Supplier Diversity

/shared/Procurement/Procurement Scorecard/Promote Supplier Diversity

Scorecard Objective

Reduce Operational Costs

/shared/Procurement/Procurement Scorecard/Reduce Operational Costs

Scorecard Objective

Reduce Out-of-process Spend

/shared/Procurement/Procurement Scorecard/Reduce Out-of-process Spend

Scorecard Objective

Customer

/shared/Procurement/Procurement Scorecard/Customer

Scorecard Perspective

Financial

/shared/Procurement/Procurement Scorecard/Financial

Scorecard Perspective

Operations

/shared/Procurement/Procurement Scorecard/Operations

Scorecard Perspective

Supplier

/shared/Procurement/Procurement Scorecard/Supplier

Scorecard Perspective

_Perspectives

/shared/Procurement/Procurement Scorecard/_Perspectives

Scorecard Perspective List

_scorecardSettings

/shared/Procurement/Procurement Scorecard/_scorecardSettings

Scorecard Settings

Strategy Map

/shared/Procurement/Procurement Scorecard/Strategy Map

Scorecard Strategy Map View

_strategyTree

/shared/Procurement/Procurement Scorecard/_strategyTree

Scorecard Strategy Tree

Strategy Tree

/shared/Procurement/Procurement Scorecard/Strategy Tree

Scorecard Strategy Tree View

Vision

/shared/Procurement/Procurement Scorecard/Vision

Scorecard Vision

Suspect Sync Segment

/shared/Marketing/Segmentation/Segments/Suspect Sync Segment

Segment

Logistics KPI Watchlist

/shared/Supply Chain Management/Analytic Library/Embedded Content/Logistics/KPIs/Logistics KPI Watchlist

Watchlist

PIM KPI Watchlist

/shared/Supply Chain Management/Analytic Library/Embedded Content/PIM/KPIs/PIM KPI Watchlist

Watchlist

 

All blogs related to BIAPPS on PAAS

Join the discussion

Comments ( 2 )
  • Jai G Tuesday, July 11, 2017
    The link mentioned in the following statement seems to be an internal link: Download the Oracle Analytics Cloud Deliverables Zip file (BIAPPS_10.2.0_OACV1.zip) from the ARU21167611.

    Can you either update the post or provide the public link here?
  • Anand Tuesday, July 11, 2017
    To download the ARU 21167611, kindly visit "https://support.oracle.com" and search for 21167611. It will result you the download link.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha
Oracle

Integrated Cloud Applications & Platform Services