Create Standard Purchase Orders

Please become familiar with the current Integrator limitations. These will be resolved over time as Oracle improves the underlying web services and we add additional functionality to this product.

To create standard purchase orders, the Header Upload Action column value should be Create or Create records. Create records causing all related child components to default to the same action, while Create will only create that section.

Prior to upload, also ensure an Approval Action has been chosen. If you do not, the Oracle web service will default the purchase order status to ‘Submit for Approval’.

Sheet Structure Examples

The scenarios below illustrate single and multiple purchase orders with associated Lines, Schedules and Distributions. Examples do not include all critical columns. Note, the ‘Create records’ action at the header for each purchase order.

Scenario 1

A purchase order with two Lines, and associated Schedules and Distributions:

Header Action	Header Details	Line Action	Line Details	Schedule Action	Schedule Details	Distribution Action	Distribution Details
Create records	...	-	1	-	1	-	1
		-	2	-	1	-	1

Once validated the sheet will automatically update to:

Header Action	Header Details	Line Action	Line Details	Schedule Action	Schedule Details	Distribution Action	Distribution Details
Create records	...	Create records	1	Create records	1	Create records	1
		Create records	2	Create records	1	Create records	1

Scenario 2

Two purchase orders with associated Lines, Schedules, and Distributions:

Header Action	Header Details	Line Action	Line Details	Schedule Action	Schedule Details	Distribution Action	Distribution Details
Create records	...	-	1	-	1	-	1
		-	2	-	1	-	1
Create records	...	-	1	-	1	-	1
				-	2	-	1
						-	2
		-	2	-	1	-	1

Again, once validated Create records will be added to the sheet automatically.