ORA-06512 "APPS.GMF_MTL_ITEM_LOCATIONS_BIUR_TG" Error When Maximum Location Length Has Been Exceeded
(Doc ID 1989134.1)
Last updated on MARCH 08, 2017
Oracle Process Manufacturing Systems - Version 12.2 and later Information in this document applies to any platform.
On : 12.2 version, Migration Issues 11i to R12
Currently in the process of migrating OPM 11i to R12. For all locations that are 13 characters or longer for an OPM warehouse migrated as a subinventory the migration script is prefixing the location with the subinventory code.
Migrate plant AAA as existing organization AA1 Migration OPM warehouse AAA1 as subinventory
Migration script is trying to prefix the OPM location RECEIVING INSP as AAA1 RECEIVING INSP which goes over the 16 max character length in IC_LOCT_MST table and the following error is shown in the migration log:
ERROR ----------------------- Unexpected Location :AAA1 RECEIVING INSP:ORA-20001: OPM-0: Location 'AA1-AAA1 RECEIVING INSP' : value AAA1 RECEIVING INSP for col Location is longer than max 16 ORA-06512: at "APPS.APP_EXCEPTION", line 72 ORA-06512: at "APPS.GMF_MTL_ITEM_LOCATIONS_BIUR_TG", line 290 ORA-04088: error during execution of trigger 'APPS.GMF_MTL_ITEM_LOCATIONS_BIUR_TG' occurred.
STEPS ----------------------- The issue can be reproduced at will with the following steps: 1. Run migration from 11i to R12
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!