Last updated on JULY 09, 2014
Applies to:Oracle Transportation Management - Version: 4.5 to 5.5
This problem can occur on any platform.
-- 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:
List of first 50 Invalid objects after recompile.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms