How to recreate the ZPBANNOT AW?

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:


We have damaged ZPBANNOZ beyond repair .
According to Note 795247.1 it may not be necessary to create it at all and simply drop it


Explanation:


The ZPB.ZPBANNOT AW is a shared AW used to store the annotations created in EPB. If you cannot attach it, the only way is recreating it. I think you have not used EPB or, at least, a new ZPB.ZPBANNOT AW has not been created.
For each Business Area (BA) created, you should have the following AWs associated to a BA with id 240.

ZPBDATA240 (data)
ZPBANNOT240 (annotations)
ZPB1008068A240 (personal)
ZPBCODE (code) is the same for all business areas

If you had already created annotations, they will be lost

Below you can see the full Note 795247.1.


DETAILS
=========
Note 795247.1: EPB AW's Cannot Be Attached Or Do Not Exist
--------------------------------------


Applies to:
------------
Oracle Enterprise Planning and Budgeting - Version: 12.0.6
This problem can occur on any platform.
Symptoms
After installing R12, three EPB AW's:

1. ZPBCODE
2. ZPBDATA
3. ZPBANNOT

cannot be opened.

Attempts to attach the AW's in SQLPlus returns the following error:

SQL> exec dbms_aw.execute('aw attach ZPB.ZPBCODE');

BEGIN dbms_aw.execute('aw attach ZPB.ZPBCODE'); END;
*
ERROR at line 1:
ORA-33272: Analytic workspace ZPB.ZPBCODE cannot be opened.
ORA-00600: internal error code, arguments: [xschkmk:!dict], [], [], [], [], [],
[], []
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122
ORA-06512: at line 1

Cause
------
Exact cause is unknown
.
Solution
---------

Delete and recreate the AW's.

1. Delete the existing, unusable, aw's by executing the following commands in SQL Plus:
set serveroutput on
exec dbms_aw.execute('aw delete zpb.zpbcode')
exec dbms_aw.execute('aw delete zpb.zpbdata')
exec dbms_aw.execute('aw delete zpb.zpbannot')

2. Run the SQL script, zpbmakeaws.sql, to create the aw's.

This script is located in appl_top/zpb/11.5.0/patch/115/sql directory.


Please note that only the ZPBCODE AW will be created as both ZPBDATA or ZPBANNOT are obsolete objects.

Also if the error message is:

BEGIN dbms_aw.execute('aw attach xx'); END;

*
ERROR at line 1:
ORA-33262: (DBERR01) Analytic workspace ZPB.ZPBCODE does not exist.
ORA-06512: at "SYS.DBMS_AW", line 18
ORA-06512: at "SYS.DBMS_AW", line 138
ORA-06512: at line 1

Run only the zpbmakeaws.sql can to create the missing AW.




Solution:


The ZPB.ZPBANNOT is one Analytic Workspace (AW) used by Oracle Enterprise Budgeting and Planning (EPB) tool, that it is integrated in Oracle Applications. If you are not using EPB, you just need to run the step 1 in the Note 795247.1:

1. Delete the existing, unusable, aw's by executing the following commands in SQL Plus:
set serveroutput on
exec dbms_aw.execute('aw delete zpb.zpbcode')
exec dbms_aw.execute('aw delete zpb.zpbdata')
exec dbms_aw.execute('aw delete zpb.zpbannot')

If you are using EPB, you should run the other point 2. to recreate the ZPB.ZPBANNOT AW

Get Oracle Certifications for all Exams
Free Online Exams.com