R12.2 Upgrade Step Report - Adzdexrpt.txt UPGRADE_MVIEW Phase Shows Errors for BIL_BI_OPCNV_F
(Doc ID 2510639.1)
Last updated on DECEMBER 19, 2022
Applies to:
Oracle Sales Intelligence - Version 12 and laterInformation 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 |