Using Text in PIM Data Hub

A well respected PIM expert provided a real helpful guideline on limitations of using text fields and descriptions in PIM data hub.

I hope this helps you with your design plans.

See below.

Bob

User Defined Attribute Text fields for PIM – two types:

User Defined Attribute Data Type Field Name Size (max) Table
Char C_EXT_ATTR1 to C_EXT_ATTR 40 VARCHAR2(150
BYTE)
EGO_MTL_SY_ITEMS_EXT_B
Translatable Text TL_EXT_ATTR1 to TL_EXT_ATTR40 VARCHAR2(1000 BYTE) EGO_MTL_SY_ITEMS_EXT_TL

Oracle E-Business Suite:

Operational Attributes Field Name Size (max) Table
Description DESCRIPTION VARCHAR2(240 BYTE) MTL_SYSTEM_ITEMS_B and
MTL_SYSTEM_ITEMS_TL
Long Description LONG_DESCRIPTION VARCHAR2(4000 BYTE) MTL_SYSTEM_ITEMS_TL
Advertisements

About oraclepim

Bob Barnett is an authority on the Oracle E-Business Suite and PIMDH. He has been delivering the Oracle manufacturing and product item master functionality for over 15 years.
This entry was posted in Oracle PIM, Oracle PIM Data Hub, Oracle PIM Implementation Activities, Oracle Product MDM, Uncategorized and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s