Upgrade From 11i To Release12 Receive BISM Errors and ZPB Related Errors (Doc ID 1338580.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Enterprise Planning and Budgeting - Version: 12.1 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Goal

When upgrading from 11i to R12 and receiving failing worker issues on BISM tables or EPB (Zpb) related errors (failed workers), since these products are not in use can they be skipped?

For Example, BISM error:

Executing statement

ALTER TABLE APPLSYS.BISM_ASSOCIATES ADD CONSTRAINT "SYS_C00140651" FOREIGN KEY (SOURCE_ID ) REFERENCES BISM_OBJECTS (OBJECT_ID ) ON DELETE CASCADE

Unable to create the primary key constraint as the primary key name already exists

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms