Oracle order import
Use the Oracle order import option to import Oracle orders in bulk from Microsoft Excel or .csv files.
Note
When you navigate to Home > Import data and then select Oracle order import, you land on the Oracle overview page's Upload your Oracle orders view.
Important: The Oracle order import functionality has no way to validate the uniqueness of licenses in an order, so you need to ensure that the entitlements that are imported are not yet in the system; otherwise, this could result in having duplicate licenses.
Imported orders are displayed in the Oracle order list view on the Oracle overview > Orders & Licenses tab.
Destination field name in the import view | Data type | Required | Description | Example | Field name in the user interface | Location in the user interface |
|---|---|---|---|---|---|---|
Agreement name | Text | Yes | Name of the Oracle agreement associated with the Oracle product(s) in this order. If this is a new agreement, it will be created using this field—Agreement name—as well as the fields Agreement number, Agreement valid from and Agreement valid to. | Oracle Support Agreement CSI 12345678 | Agreement | Edit Oracle Order | Products Tab | Edit Product |
Agreement number | Text | Yes | Number of the Oracle agreement associated with the Oracle product(s) in this order. | ORACLE2296055 | Agreement | Edit Oracle Order | Products Tab | Edit Product |
Agreement valid from | Date | Yes | Valid start date of the Oracle agreement associated with the Oracle product(s) in this order. | 2019-03-10 | Agreement | Agreements | Agreements Details | Agreements periods tab |
Agreement valid to | Date | Yes | Valid end date of the Oracle agreement associated with the Oracle product(s) in this order. | 2020-03-10 | Agreement | Agreements | Agreements Details | Agreements periods tab |
Order date | Date | Yes | Date of this Oracle order. | 2019-03-02 | Order date | Edit Oracle Order & Oracle Order Details |
Order name | Text | Yes | Name of this Oracle order. | March 2019 Order for production environments | Order name | Edit Oracle Order & Oracle Order Details |
Order number | Text | Yes | Number of this Oracle order. | 53197 | Order number | Edit Oracle Order & Oracle Order Details |
Reseller order number | Text | No | Reseller's order number of this Oracle order. | N/A | Reseller order number | Edit Oracle Order & Oracle Order Details |
Internal reference number | Text | No | Internal reference number of this Oracle order. | N/A | Internal reference number | Edit Oracle Order & Oracle Order Details |
OLSA | Text | No | Oracle License and Services Agreement (OLSA) reference for this Oracle order. | N/A | Oracle Master Agreement (OMA), Oracle License and Services Agreement (OLSA) reference | Edit Oracle Order & Oracle Order Details |
Purchase currency | Text | No | Monetary currency used for the purchase of the Oracle product(s) in this order. | USD | License Cost, Agreement | Edit Oracle Order & Oracle Order Details |
Area of use | Text | No | Optional field describing the area or purpose to which the Oracle product(s) in this order are to be used. | Licensing | Area of use | Edit Oracle Order & Oracle Order Details |
Notes | Text | No | Optional remarks or notes related to this order. | March 2019 production environments | Description | Edit Oracle Order & Oracle Order Details |
Organisation | Text | Yes | The organizational entity to which this Oracle order belongs. For .csv import files, the delimiter character between multiple organization IDs must match the Import settings option. For Snow License Manager, use the Organization Name in Snow Management and Configuration Center and not the Friendly name. For SAM Core on Snow Atlas: If the import is unable to map to the organization, find the identities for each organization node and add the identities to the import file. To find the Organization ID, also called GUID do the following:
| ROOT,IT 5d0ed580-e3e9-4377-a944-9845e8fd6e54 | Organisation | Edit Oracle Order & Oracle Order Details |
Contact name | Text | No | Contact name of the person who placed this Oracle order. | Janice Doe | Contact name | Edit Oracle Order & Oracle Order Details |
Contact email | Text | No | Email address of the person who placed this Oracle order. | janice.doe@amegacorp.com | E-mail address | Edit Oracle Order & Oracle Order Details |
Contact phone | Text | No | Telephone number of the person who placed this Oracle order. | +1 (402) 867-5309 | Phone | Edit Oracle Order & Oracle Order Details |
Vendor name | Text | No | Name of the vendor to which this Oracle order was placed. | Delphi Oracle | Name | Edit Oracle Order & Oracle Order Details |
Vendor address | Text | No | Address of the vendor to which this Oracle order was placed. | 515 W. 27th St., Kearney, NE 68847 | Address | Edit Oracle Order & Oracle Order Details |
Vendor contact | Text | No | Vendor contact person through whom this Oracle order was placed. | Hal Boman | Contact | Edit Oracle Order & Oracle Order Details |
Vendor email | Text | No | Email address of the vendor contact person through whom this Oracle order was placed. | harold.boman@delphioracle.com | E-mail address | Edit Oracle Order & Oracle Order Details |
Vendor phone | Text | No | Telephone number of the vendor contact person through whom this Oracle order was placed. | +1 (308) 433-5709 | Phone | Edit Oracle Order & Oracle Order Details |
Order status | Text | No | Status of the Oracle order (Valid or Terminated). | Valid | Status | Edit Oracle Order & Oracle Order Details |
Lic status | Text | No | Type of license (Normal, Upgrade, or Migration). | Normal | Type | Edit Oracle Order | Products Tab | Edit Product |
Product name | Text | No | Official Oracle product name. When a single order is created manually in the user interface, the Product category is selected first, followed by Product type, and then Product, with the latter only required here in this Product name column header if this Oracle order file import function is used. For a list of all supported Oracle products, see Oracle product names, categories, and types. | Oracle Database Enterprise Edition | Product category & Product type & Product | Edit Oracle Order | Products Tab | Edit Product |
License type | Text | No | License type (Full Use, Application Specific Full Use, Application Specific, Embedded, Limited Use Other, or Runtime). | Full Use | License type | Edit Oracle Order | Products Tab | Edit Product |
Metric | Text | No | Licensing metric as defined by Oracle: Named User Plus | Processor | Collaboration Program User | Concurrent Device - Network License | Concurrent Device - Order Form | Concurrent User - Network License | Concurrent User - Order Form | Developer - Network License | Developer - Order Form | Named User | Named User - Multi Server | Named User - Network License | Named User - Order Form | Named User - Single Server | Power Unit | Power Unit - Intel | Power Unit - Risc | Universal Power Unit. | Processor | Metric | Edit Oracle Order | Products Tab | Edit Product |
Period type | Text | No | Period for the license agreement (Perpetual, 1 Year, 2 Year, 3 Year, 4 Year, 5 Year). | Perpetual | Period type | Edit Oracle Order | Products Tab | Edit Product |
Quantity | Numeric | No | Product purchase quantity. Must be a numeric positive value. | 100 | Quantity | Edit Oracle Order | Products Tab | Edit Product |
License cost | Currency | No | Cost of the purchase. Must be a positive currency value. The value is assumed to be expressed in the purchase currency. | 12453.00 | License cost | Edit Oracle Order | Products Tab | Edit Product |
Support cost | Currency | No | Support cost that is intended for the first year of software usage. Must be a positive currency value. The value is assumed to be expressed in purchase currency. | 3652.99 | Agreement | Edit Oracle Order | Products Tab | Edit Product |
CSI | Text | No | Customer Support Identifier number. | 89457720 | CSI | Edit Oracle Order | Products Tab | Edit Product |