My Oracle Support Banner

R12.2 Upgrade Step Report - Adzdexrpt.txt UPGRADE_MVIEW Phase Shows Errors for BIL_BI_OPCNV_F (Doc ID 2510639.1)

Last updated on AUGUST 28, 2023

Applies to:

Oracle Sales Intelligence - Version 12 and later
Information in this document applies to any platform.

Goal

On : 12 version, Patch Application Issues

R12.2 Upgrade step report - adzdexrpt.txt UPGRADE_MVIEW phase shows errors

Completed UPGRADE_MVIEW UPGRADE_MVIEW 120 S - Successfully Executed 5 -E Errors
  
The failures appear to be on MV for old Oracle Daily Business Intelligence for Sales 7.0.1 objects
The affected MV are listed below:
BIL_BI_OPCNV_T_MV - Sales Opportunity Conversion by Period Summary
BIL_BI_OPDTL_T_MV - Sales Opportunity and Forecast by Period and Sales Group Summary
BIL_BI_OPFST_G_MV - Sales Opportunity and Forecast by Period and Sales Group Summary
BIL_BI_OPTY_T_MV - Sales Opportunity and Conversion by Period Summary
MRP_COMPANY_USERS_SN

I see MOS document “Enabling Online Patching During 12.2 Upgrade Fails For MRP_COMPANY_USERS_SN (Doc ID 1957323.1)” which says “As per the following internal bug this issue can be safely ignored”.
How do I get these MVs resolved and get to the cleanup phase?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.