Oracle Transportation Management - Errors Running DBPATCH_45 - P_BID_AFTER_STATEMENT (Doc ID 429313.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 4.5 to 5.5
This problem can occur on any platform.

Symptoms

-- Problem Statement:
The following errors were reported by Oracle Hosting when they were testing the migration from 4.5 to 5.5:

When attempting to run the first step in the migration process, which is to install the latest 4.5 SR and run  dbpatch_45.sql, the following error occurs:

ERROR
List of first 50 Invalid objects after recompile.
================================================
P_BID_AFTER_STATEMENT TRIGGER
P_BID_BEFORE_STATEMENT TRIGGER
P_BID_IU TRIGGER

Errors for TRIGGER P_BID_AFTER_STATEMENT:
2/4 PLS-00201: identifier 'PROCUREMENT.CHECK_BIDS' must be declared


Errors for TRIGGER P_BID_BEFORE_STATEMENT:
2/4 PLS-00201: identifier 'PROCUREMENT.CLEAR_BID_LIST' must be declared


Errors for TRIGGER P_BID_IU:
52/1 PLS-00201: identifier 'PROCUREMENT.ADD_BID_LIST' must be declared



-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Install the latest 4.5 SR
2. Run dbpatch_45.sql as instructed in the SR installation notes
3. Check dbpatch_45 log for reported error

-- Business Impact:
The issue has the following business impact:
Due to this issue, admin's are unsure if they can continue with the migration to 5.5.


Cause

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