Catalog Bulkload Readme - Spreadsheet Downloaded from Catalog Bulkload Resources
(Doc ID 2475130.1)
Last updated on JUNE 07, 2021
Applies to:
Oracle Purchasing - Version 12.2 and laterInformation in this document applies to any platform.
Goal
The following is the content included in the Download Bulkload Resources zip file.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| Using a Spreadsheet to Load Catalog Data |
| Introduction to the Catalog Structure |
| Using a Spreadsheet to Load the Catalog Data |
| Opening the Spreadsheet Text Template File |
| Spreadsheet Tips |
| Getting Started |
| Encoding Section |
| Language Section |
| Catalog Section |
| Optional Catalog Information |
| Example 1: Sample #ENCODING, Language, and Catalog Sections |
| Header Section |
| Optional Header Information |
| Example 2: Sample Header Sections |
| Data Section |
| Data Types |
| The data types are listed below. |
| Adding, Updating, and Expiring Items |
| Item Uniqueness |
| Identifying Lines for Update |
| Further Notes |
| Required and Validated Information |
| Determining Shopping Category and Purchasing Category Assignment |
| Example 3: Loading Items |
| Example 4: Updating Items |
| Price Breaks |
| Example 5: Price Break |
| Example 6: Expiring Items |
| Case Sensitivity |
| Blanking Out a Descriptor |
| Example 7: Deleting Information |
| Reclassifying an Item Under Another Category |
| Reviewing and Saving Your Spreadsheet File |
| Loading Your Spreadsheet File |
| Loading the File to a GBPA |
| Loading the File to a BPA or Quotation |
| Error Tolerance |
| Run Time |
| Job Status |
| Resolving Errors |
| Format errors |
| Validation errors |
| Further Notes |
| Handling Special Characters |
| Loading Images |
| Translating Catalogs |
| Descriptors |
| Pricing |