Egp Catalog Import Template

Oracle Supply Chain Management Cloud
Product Information Management: Catalogs Import
Overview
This template is used for the file-based import process to import catalog and category data, into the Product Information
The interface tables used are:
EGP_CATEGORY_SETS_INT: This is the table that defines the catalog header information and descriptive flexfields for the
EGP_CATEGORY_SETS_TL_INT: This is the table that defines the translated content for the catalog.
EGP_CATEGORIES_INT: This is the table that defines the categories in the catalog. the category hierarchy information an
EGP_CATEGORIES_TL_INT: This is the table that defines the translated content for the categories in the catalog.
EGP_CATALOG_CAT_ATTACH_INT: This is the table that defines the attachments for the catalogs and categories.
Preparing the Data

1. Prepare the data for each interface table using the corresponding worksheet in this template.
2. Refer to the text above each column header either for detailed instructions on preparing the data in that column or fo
3. The Batch_ID column must contain a random number; this number is only used for tracking purposes and does not ha
4. Catalogs are defined by a combination of code and name values. Both of these values should be provided in the appro
5. The Start Date value is required for creating new catalogs.
Loading the Data

Click the Generate CSV File button to generate a ZIP file that contains the CSV files.
Generate CSV File
For information about preparing the data and loading the CSV files into the interface tables, see:
Import Items: Explained in the Implementing Product Management guide
Revision History
Date Software Release
3/2/2018 R13 (update 18B)
ply Chain Management Cloud
ormation Management: Catalogs Import
process to import catalog and category data, into the Product Information Management tables.
at defines the catalog header information and descriptive flexfields for the catalog.
e that defines the translated content for the catalog.
efines the categories in the catalog. the category hierarchy information and descriptive flexfields for the categories.
at defines the translated content for the categories in the catalog.
table that defines the attachments for the catalogs and categories.
ng the corresponding worksheet in this template.

either for detailed instructions on preparing the data in that column or for a description of the data and data type that the column req
m number; this number is only used for tracking purposes and does not have to be an item batch created in the Manage Item Batches u
de and name values. Both of these values should be provided in the appropriate spreadsheet.
new catalogs.
a ZIP file that contains the CSV files.
loading the CSV files into the interface tables, see:

Product Management guide
Description
Initial release.
that the column requires.
nage Item Batches user interface.
Technical Name TRANSACTION_TYPE BATCH_ID CATALOG_NAME
Description Type of action: select Batch identifier for Name of the catalog.
CREATE, UPDATE, or the data load.
SYNC. Required only for the new
catalog records.
Data Type VARCHAR2(10) NUMBER VARCHAR2(30)

Name Transaction Type Batch ID Catalog Name
CATALOG_CODE NEW_CATALOG_CODE DESCRIPTION DEFAULT_CATEGORY_CODE
Unique identifier for a Updated value of the catalog code. Description of the catalog. Default Category of the Catalog
catalog.
Required only for the new
catalog records.
VARCHAR2(30) VARCHAR2(30) VARCHAR2(240) VARCHAR2(820)

Catalog Code New Catalog Code Description Default Category Code
CONTROL_LEVEL START_DATE END_DATE
Attribute that controls category Description: Date the Description: Date the catalog
assignment to an item. Select "Y" or catalog will become will become inactive.
"N," which will be translated into an active.
internal numberic value.
Y - The catalog can be assigned at Required only for the
Master Org Items only. new catalog records.
N - The catalog can be assigned at
both Master Org Items and Child
Org Items.
Required only for the new catalog
records.
NUMBER DATE(YYYY/MM/DD) DATE(YYYY/MM/DD)

Controlled at Master Level Start Date End Date
CATALOG_CONTENT_CODE MULT_ITEM_CAT_ASSIGN_FLAG PUBLIC_CATALOG
Value that controls the Attribute that controls if an item can be assigned to Public Catalog
configuration of the catalog multiple categories in a catalog. Select "Y" or "N".
content. Select "Y" or "N".
Required only for the new catalog records.
Required only for the new
catalog records.
VARCHAR2(30) VARCHAR2(1) VARCHAR2(1)

Assign Items to Leaf-Level Allow Multiple Item Category Assignments Public Catalog
Categories Only
ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3
Descriptive flexfield: Descriptive flexfield: Segment Descriptive flexfield: Descriptive flexfield:
Structure definition of the of the user descriptive Segment of the user Segment of the user
user descriptive flexfield. flexfield. descriptive flexfield. descriptive flexfield.

Attribute Category Attribute1 Attribute2 Attribute3
ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7
Descriptive flexfield: Descriptive flexfield: Descriptive Descriptive flexfield:
Segment of the user Segment of the user flexfield: Segment Segment of the user
descriptive flexfield. descriptive flexfield. of the user descriptive flexfield.
descriptive
flexfield.

Attribute4 Attribute5 Attribute6 Attribute7
Descriptive flexfield: Segment of the Descriptive flexfield: Segment of Descriptive flexfield: Descriptive flexfield:
user descriptive flexfield. the user descriptive flexfield. Segment of the user Segment of the user
descriptive flexfield. descriptive flexfield.

Descriptive flexfield: Descriptive flexfield: Segment of Descriptive flexfield: Descriptive flexfield:
Segment of the user the user descriptive flexfield. Segment of the user Segment of the user
descriptive flexfield. descriptive flexfield. descriptive flexfield.

ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4
Descriptive flexfield: Descriptive flexfield: Descriptive flexfield: Descriptive flexfield:
Segment of the user Segment of the user Segment of the user Segment of the user
descriptive flexfield. descriptive flexfield. descriptive flexfield. descriptive flexfield.
NUMBER NUMBER NUMBER NUMBER

Attribute Number1 Attribute Number2 Attribute Number3 Attribute Number4
Descriptive flexfield: Segment Descriptive flexfield: Descriptive flexfield: Segment of Descriptive flexfield: Segment
of the user descriptive Segment of the user the user descriptive flexfield. of the user descriptive
flexfield. descriptive flexfield. flexfield.

ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1
Descriptive flexfield: Descriptive flexfield: Segment of Descriptive flexfield: Segment of
Segment of the user the user descriptive flexfield. the user descriptive flexfield.
descriptive flexfield.
NUMBER NUMBER DATE(YYYY/MM/DD)

Attribute Number9 Attribute Number10 Attribute Date1
ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4
Descriptive flexfield: Segment of the Descriptive flexfield: Descriptive flexfield: Segment of
user descriptive flexfield. Segment of the user the user descriptive flexfield.
DATE(YYYY/MM/DD) DATE(YYYY/MM/DD) DATE(YYYY/MM/DD)

Attribute Date2 Attribute Date3 Attribute Date4
ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2
Descriptive flexfield: Descriptive flexfield: Segment of the Descriptive flexfield: Segment of the user
Segment of the user user descriptive flexfield. descriptive flexfield.
DATE(YYYY/MM/DD) TIMESTAMP TIMESTAMP(YYYY/MM/DD HH24:MI:SS:FF)

Attribute Date5 Attribute Timestamp1 Attribute Timestamp2
ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5
Descriptive flexfield: Segment of Descriptive flexfield: Segment of Descriptive flexfield: Segment of
the user descriptive flexfield. the user descriptive flexfield. the user descriptive flexfield.
TIMESTAMP(YYYY/MM/DD HH24:MI
TIMESTAMP(YYYY/MM/DD HH24:MI:S
TIMESTAMP(YYYY/MM/DD HH24:MI:SS:FF)
Attribute Timestamp3 Attribute Timestamp4 Attribute Timestamp5
Technical Name TRANSACTION_TYPE BATCH_ID
Description Type of action: select Batch identifier for data load.
CREATE, UPDATE, or
SYNC.
Data Type Varchar2(30) NUMBER

Name Transaction Type Batch ID
CATALOG_CODE CATALOG_NAME DESCRIPTION LANGUAGE
Unique identifier for a Name of the catalog. Description of the catalog. Indicates the code of
catalog. the language into
which the contents of
the translatable
columns are
translated.

Catalog Code Catalog Name Description Language
Description Type of action: select Batch identifier for the data load.
CREATE, UPDATE, SYNC,
or SHARE.
Data Type VARCHAR2(30) NUMBER

CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
CREATE 1000199981
PARENT_CATEGORY_CODE CATALOG_CODE CATEGORY_NAME
Code of the parent category Catalog code of the catalog, to which this Translatable name of the
record. category belongs. category.
Required only for the new category records. Required only for the new
category records.

Parent Category Code Catalog Code Category Name
Purchasing ME.Office Supplies
Purchasing ME.Travel Expenses
Purchasing ME.Professional Services
Purchasing ME.Marketing and Advertisin
Purchasing ME.IT Equipment
Purchasing ME.Software Licenses
Purchasing ME.Telecommunications
Purchasing ME.Facility Maintenance
Purchasing ME.Furniture and Fixtures
Purchasing ME.Printing Services
Purchasing ME.Utilities
Purchasing ME.Janitorial Supplies
Purchasing ME.Packaging Materials
Purchasing ME.Raw Materials
Purchasing ME.Production Supplies
Purchasing ME.Safety Equipment
Purchasing ME.Uniforms
Purchasing ME.Medical Supplies
Purchasing ME.Consulting Services
Purchasing ME.Legal Services
Purchasing ME.Training and Developmen
Purchasing ME.Recruitment Services
Purchasing ME.Temporary Labor
Purchasing ME.Insurance
Purchasing ME.Employee Benefits
Purchasing ME.Research and Developme
Purchasing ME.Subscriptions and Membe
Purchasing ME.Transportation and Logist
Purchasing ME.Storage Services
Purchasing ME.Catering Services
Purchasing ME.Event Management
Purchasing ME.Financial Services
Purchasing ME.Auditing Services
Purchasing ME.Real Estate
Purchasing ME.Construction Services
Purchasing ME.Environmental Services
Purchasing ME.Waste Management
Purchasing ME.Security Services
Purchasing ME.Pest Control
Purchasing ME.HVAC Services
Purchasing ME.Travel Accommodation
Purchasing ME.Books and Periodicals
Purchasing ME.Gifts and Awards
Purchasing ME.Corporate Entertainment
Purchasing ME.Promotional Items
Purchasing ME.Vehicle Leasing
Purchasing ME.Fuel
Purchasing ME.Maintenance Repair and
Purchasing ME.Shipping Supplies
Purchasing ME.Customer Service Outsour
CATEGORY_CODE NEW_CATEGORY_CODE DESCRIPTION
Unique identifier for the New value to be provided for Description of the
category. category code. category.
Required only for the

new category records.

Category Code New Category Code Description
ME.Office Supplies ME.Office Supplies
ME.Travel Expenses ME.Travel Expenses
ME.Professional Services ME.Professional Servi
ME.Marketing and Advertising ME.Marketing and Adv
ME.IT Equipment ME.IT Equipment
ME.Software Licenses ME.Software Licenses
ME.Telecommunications ME.Telecommunicatio
ME.Facility Maintenance ME.Facility Maintena
ME.Furniture and Fixtures ME.Furniture and Fixt
ME.Printing Services ME.Printing Services
ME.Utilities ME.Utilities
ME.Janitorial Supplies ME.Janitorial Supplies
ME.Packaging Materials ME.Packaging Materia
ME.Raw Materials ME.Raw Materials
ME.Production Supplies ME.Production Suppli
ME.Safety Equipment ME.Safety Equipment
ME.Uniforms ME.Uniforms
ME.Medical Supplies ME.Medical Supplies
ME.Consulting Services ME.Consulting Service
ME.Legal Services ME.Legal Services
ME.Training and Development ME.Training and Dev
ME.Recruitment Services ME.Recruitment Servi
ME.Temporary Labor ME.Temporary Labor
ME.Insurance ME.Insurance
ME.Employee Benefits ME.Employee Benefit
ME.Research and Development ME.Research and Dev
ME.Subscriptions and Memberships ME.Subscriptions an
ME.Transportation and Logistics ME.Transportation and
ME.Storage Services ME.Storage Services
ME.Catering Services ME.Catering Services
ME.Event Management ME.Event Managemen
ME.Financial Services ME.Financial Services
ME.Auditing Services ME.Auditing Services
ME.Real Estate ME.Real Estate
ME.Construction Services ME.Construction Servi
ME.Environmental Services ME.Environmental Ser
ME.Waste Management ME.Waste Manageme
ME.Security Services ME.Security Services
ME.Pest Control ME.Pest Control
ME.HVAC Services ME.HVAC Services
ME.Travel Accommodation ME.Travel Accommoda
ME.Books and Periodicals ME.Books and Periodi
ME.Gifts and Awards ME.Gifts and Awards
ME.Corporate Entertainment ME.Corporate Entert
ME.Promotional Items ME.Promotional Item
ME.Vehicle Leasing ME.Vehicle Leasing
ME.Fuel ME.Fuel
ME.Maintenance Repair and Operations ME.Maintenance Repai
ME.Shipping Supplies ME.Shipping Supplies
ME.Customer Service Outsourcing ME.Customer Service
START_DATE_ACTIVE END_DATE_ACTIVE
Date the category will become active. Date the category will become inactive.
Required only for the new category records.
DATE(YYYY/MM/DD) DATE(YYYY/MM/DD)
Start Date End Date
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
2020/01/01
CATEGORY_CONTENT_CODE SOURCE_CATALOG_CODE
Attribute that indicates if the category contains only items or items and
categories. Select "Y" or "N".
Required only for the new category records.
VARCHAR2(30) VARCHAR2(30)
Restrict category to item assignment only Source Catalog Code
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
COPY_OPTIONS ATTRIBUTE_CATEGORY
Descriptive flexfield: Structure definition of the user
Copy Options Attribute Category
ATTRIBUTE1 ATTRIBUTE2
Descriptive flexfield: Segment of the Descriptive flexfield: Segment of the user
user descriptive flexfield. descriptive flexfield.
Attribute1 Attribute2
Descriptive flexfield: Segment of the Descriptive flexfield: Segment of the
user descriptive flexfield. user descriptive flexfield.
Descriptive flexfield: Segment of the user Descriptive flexfield: Segment of
descriptive flexfield. the user descriptive flexfield.
ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9
Descriptive flexfield: Segment of Descriptive flexfield: Segment of Descriptive flexfield: Segment of
the user descriptive flexfield. the user descriptive flexfield. the user descriptive flexfield.

Attribute7 Attribute8 Attribute9
Descriptive flexfield: Segment of the Descriptive flexfield: Segment of Descriptive flexfield: Segment of the
user descriptive flexfield. the user descriptive flexfield. user descriptive flexfield.

Descriptive flexfield: Segment of Descriptive flexfield: Segment of the user
the user descriptive flexfield. descriptive flexfield.
ATTRIBUTE15 ATTRIBUTE_NUMBER1
Descriptive flexfield: Segment of the user Descriptive flexfield: Segment of the user descriptive
descriptive flexfield. flexfield.
VARCHAR2(150) NUMBER
Attribute15 Attrbute Number1
ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3
Descriptive flexfield: Segment of the user Descriptive flexfield: Segment of the user descriptive
descriptive flexfield. flexfield.
NUMBER NUMBER
Attrbute Number2 Attrbute Number3
Descriptive flexfield: Segment of the Descriptive flexfield: Segment of the user
user descriptive flexfield. descriptive flexfield.
NUMBER NUMBER
ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8
Descriptive flexfield: Segment of the user Descriptive flexfield: Segment of Descriptive flexfield: Segment of the
descriptive flexfield. the user descriptive flexfield. user descriptive flexfield.
NUMBER NUMBER NUMBER

Attrbute Number6 Attrbute Number7 Attrbute Number8
Descriptive flexfield: Segment of the Descriptive flexfield: Segment of the user descriptive
user descriptive flexfield. flexfield.
NUMBER NUMBER
ATTRIBUTE_DATE1 ATTRIBUTE_DATE2
Descriptive flexfield: Segment of the user Descriptive flexfield: Segment of the user
descriptive flexfield. descriptive flexfield.
Attribute Date1 Attribute Date2
ATTRIBUTE_DATE3 ATTRIBUTE_DATE4
Descriptive flexfield: Segment of the user descriptive Descriptive flexfield:
flexfield. Segment of the user
Attribute Date3 Attribute Date4
ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2
Descriptive flexfield: Segment of the user Descriptive flexfield: Segment of Descriptive flexfield: Segment of
descriptive flexfield. the user descriptive flexfield. the user descriptive flexfield.
DATE(YYYY/MM/DD) TIMESTAMP(YYYY/MM/DD HH24:M

Attribute Date5 Attribute Timestamp1 Attribute Timestamp2
ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5
Descriptive flexfield: Segment Descriptive flexfield: Segment of Descriptive flexfield: Segment of
of the user descriptive the user descriptive flexfield. the user descriptive flexfield.
flexfield.
TIMESTAMP(YYYY/MM/DD HH24
Attribute Timestamp3 Attribute Timestamp4 Attribute Timestamp5
SUPPLIER_ENABLED_FLAG
Attribute that controls if a
category will be displayed
as part of the Supplier
Profile.
VARCHAR2(1)
Display in Supplier Profile
Description Type of action: select Batch identifier for the data load.
CREATE, UPDATE, or
SYNC.
Data Type VARCHAR2(10) NUMBER

CATEGORY_CODE CATEGORY_NAME DESCRIPTION LANGUAGE
Unique identifier for the Translatable name of Description of the category. Indicates the code of
category. the category. the language into
which the contents of
the translatable
columns are
translated.

Category Code Category Name Description Language
Technical Name TRANSACTION_TYPE BATCH_ID ENTITY_TYPE
Description Type of action: CREATE, Batch Identifier for Data Entity Type of Record -
UPDATE, DELETE or SYNC Load. Catalog/Category
Data Type VARCHAR2(10) NUMBER VARCHAR2(100)

Name Transaction Type Batch ID Entity Type
CATALOG_CODE CATEGORY_CODE BATCH_DOC_NAME ATTACHMENT_CATEGORY
Unique identifier for a catalog. Updated value of the Attachment File Name for the Category of the attachment.
Catalog Code. file uploaded to UCM

Catalog Code Category Code Batch Doc Name Attachment Category
FILE_TYPE_NAME FILE_URL_TEXT TITLE SHARED
Value of Attachment File Attachment File Name or Title of the attachment. Indicates if the attachment is
Type Name URL or Text shared.
VARCHAR2(80) CLOB VARCHAR2(80) VARCHAR2(1)

File Type File URL Text Title Shared
DECRIPTION PARENT_CATEGORY_FLAGATTRIBUTE_CATEGORY ATTRIBUTE1
Description of the Sets the current row as the Descriptive Flexfield: Descriptive Flexfield: segment of the
attachment. primary attachment for the structure definition of the user descriptive flexfield.
catalog/category. user descriptive flexfield.

Description Primary Category Flag Attribute Category Attribute1
Descriptive Flexfield: segment of the user Descriptive Flexfield: segment of the Descriptive Flexfield: segment of
descriptive flexfield. user descriptive flexfield. the user descriptive flexfield.

Descriptive Flexfield: Descriptive Flexfield: Descriptive Flexfield: Descriptive Flexfield:
segment of the user segment of the user segment of the user segment of the user

Descriptive Flexfield: Descriptive Flexfield: segment Descriptive Flexfield: Descriptive Flexfield: segment
segment of the user of the user descriptive segment of the user of the user descriptive
descriptive flexfield. flexfield. descriptive flexfield. flexfield.

Descriptive Flexfield: segment Descriptive Flexfield: Descriptive Flexfield: Descriptive Flexfield:
of the user descriptive flexfield. segment of the user segment of the user segment of the user






















ATTRIBUTE_NUMBER1ATTRIBUTE_NUMBERATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBERATTRIBUTE_NUMBER5
Descriptive Flexfield: Descriptive Flexfield: Descriptive Flexfield: Descriptive Flexfield: Descriptive Flexfield:
segment of the user segment of the user segment of the user segment of the user segment of the user
descriptive flexfield. descriptive flexfield. descriptive flexfield. descriptive flexfield. descriptive flexfield.
NUMBER NUMBER NUMBER NUMBER NUMBER

Attribute Number1 Attribute Number2 Attribute Number3 Attribute Number4 Attribute Number5
Descriptive Flexfield: Descriptive Flexfield: Descriptive Flexfield: Descriptive Flexfield: segment
segment of the user segment of the user segment of the user of the user descriptive flexfield.

ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3
of the user descriptive segment of the user segment of the user segment of the user
flexfield. descriptive flexfield. descriptive flexfield. descriptive flexfield.
NUMBER DATE(YYYY/MM/DD) DATE(YYYY/MM/DD) DATE(YYYY/MM/DD)

Attribute Number10 Attribute Date1 Attribute Date2 Attribute Date3
ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7
of the user descriptive segment of the user segment of the user segment of the user
flexfield. descriptive flexfield. descriptive flexfield. descriptive flexfield.
DATE(YYYY/MM/DD) DATE(YYYY/MM/DD) DATE(YYYY/MM/DD) DATE(YYYY/MM/DD)

Attribute Date4 Attribute Date5 Attribute Date6 Attribute Date7
ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_TIMESTAMP1
DATE(YYYY/MM/DD) DATE(YYYY/MM/DD) DATE(YYYY/MM/DD) TIMESTAMP

Attribute Date8 Attribute Date9 Attribute Date10 Attribute Timestamp1
ATTRIBUTE_TIMESTAMPATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAM ATTRIBUTE_TIMESTAMP
Descriptive Flexfield: Descriptive Flexfield: segment Descriptive Flexfield: Descriptive Flexfield:
segment of the user of the user descriptive segment of the user segment of the user
descriptive flexfield. flexfield. descriptive flexfield. descriptive flexfield.
TIMESTAMP(YYYY/MM/DD TIMESTAMP(YYYY/MM/DD
H HH24:
TIMESTAMP(YYYY/MM/DDTIMESTAMP(YYYY/MM/DD H
Attribute Timestamp2 Attribute Timestamp3 Attribute Timestamp4 Attribute Timestamp5
ATTRIBUTE_TIMESTAMP NEW_ATTACHMENT_CATNEW_FILE_URL_TEXT NEW_TITLE
Descriptive Flexfield: New Category of the New Attachment File New Title of the
segment of the user attachment. Name or URL or Text attachment.
TIMESTAMP(YYYY/MM/DD V
HARCHAR2(30) CLOB VARCHAR2(80)
Attribute Timestamp5 New Attachment Category New File URL Text New Title

Egp Catalog Import Template

Uploaded by

Copyright:

Available Formats

Egp Catalog Import Template

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Egp Catalog Import Template

Uploaded by

Copyright:

Available Formats

Oracle Supply Chain Management Cloud

Product Information Management: Catalogs Import

Preparing the Data

Loading the Data

Generate CSV File

ng the corresponding worksheet in this template.

a ZIP file that contains the CSV files.

loading the CSV files into the interface tables, see:

Data Type VARCHAR2(10) NUMBER VARCHAR2(30)

VARCHAR2(30) VARCHAR2(30) VARCHAR2(240) VARCHAR2(820)

NUMBER DATE(YYYY/MM/DD) DATE(YYYY/MM/DD)

VARCHAR2(30) VARCHAR2(1) VARCHAR2(1)

VARCHAR2(30) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

NUMBER NUMBER NUMBER NUMBER

NUMBER NUMBER NUMBER NUMBER

NUMBER NUMBER DATE(YYYY/MM/DD)

DATE(YYYY/MM/DD) DATE(YYYY/MM/DD) DATE(YYYY/MM/DD)

DATE(YYYY/MM/DD) TIMESTAMP TIMESTAMP(YYYY/MM/DD HH24:MI:SS:FF)

Data Type Varchar2(30) NUMBER

VARCHAR2(30) VARCHAR2(30) VARCHAR2(240) VARCHAR2(4)

Data Type VARCHAR2(30) NUMBER

VARCHAR2(820) VARCHAR2(30) VARCHAR2(250)

Required only for the

VARCHAR2(820) VARCHAR2(820) VARCHAR2(240)

Required only for the new category records.

Required only for the new category records.

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

NUMBER NUMBER NUMBER

DATE(YYYY/MM/DD) TIMESTAMP(YYYY/MM/DD HH24:M

Data Type VARCHAR2(10) NUMBER

VARCHAR2(820) VARCHAR2(250) VARCHAR2(240) VARCHAR2(4)

Data Type VARCHAR2(10) NUMBER VARCHAR2(100)

VARCHAR2(30) VARCHAR2(820) VARCHAR2(2000) VARCHAR2(30)

VARCHAR2(80) CLOB VARCHAR2(80) VARCHAR2(1)

VARCHAR2(255) VARCHAR2(1) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)

VARCHAR2(150) VARCHAR2(150) VARCHAR2(150) VARCHAR2(150)