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.

ROOT,IT

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 Appendix - 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