My Oracle Support Banner

What Are The Guidelines For Loading Agreement Lines - Spreadsheet Data - In The Buyer Work Center? (Doc ID 1265891.1)

Last updated on FEBRUARY 02, 2018

Applies to:

Oracle Purchasing - Version 12.0.1 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 7-MAR-2015***

Goal

What are the guidelines for uploading Global Blanket Agreement Lines in the Agreements section of the Buyer Work Center?

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.