MIGRATION from 11i to R12: Edit Text Migration Into Attachments. Error: "Attachment cannot be created .."

(Doc ID 1958365.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Process Manufacturing Systems - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.X version, Migration Issues 11i to R12

ACTUAL BEHAVIOR
---------------
Edit Text migration into Attachments

As part of the Migration from OPM R11.5.10-2 to R12.1.3 one of the last post-migration 12.1.1. steps is the migration of Edit Text into Attachments.
This process seems to be working fine (technically) for the following entities Lot, Grade, Action, Reason Codes and Organizations.

For item texts however (text paragraph defined on OPM IC_ITEM_MST) an error occurs (same error occurs per item).
Error message: Attachment cannot be created in %FORM_NAME, Due to no paragraph exist in SY_PARA_CDS_TL for TABLE_NAME= %TABLE_NAME (FORM_NAME=INVIDITM) (TABLE_NAME=IC_ITEM_MST)

Reading this error message it seems that the system tries to recreate the Edit Text from the IC_ITEM_MST as EDIT TEXT under the ODM Master Item table.
You are expecting these OPM item related texts to be migrated as attachments.

 
Error
-----------------------
Attachment cannot be created in %FORM_NAME, Due to no paragraph exist in SY_PARA_CDS_TL for TABLE_NAME= %TABLE_NAME (FORM_NAME=INVIDITM) (TABLE_NAME=IC_ITEM_MST)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Migration from OPM R11.5.10-2 to R12.1.3 : run one of the last post-migration 12.1.1. steps is the migration of Edit Text into Attachments.
2. See error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot migrate text associated to OPM items

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