Import Requisitions

When to Use

Use this process periodically when you want to import requisitions from other Oracle applications or external systems into Oracle Fusion Cloud Procurement. Submit the scheduled process from the Purchasing work area.

Privileges Required

Import Requisition (POR_IMPORT_REQUISITION_PRIV)
Import Approved Requisition (POR_IMPORT_APPROVED_REQUISITION_PRIV)

Specifications

Review the following before setting up this scheduled process:

Specification	Description
Job Type	Scheduled.
Frequency	Run as frequently as required by the business. Typically, businesses like to import requisitions on a daily, weekly, monthly, or quarterly as per business needs.
Time of Day	Any time.
Duration	The runtime of this job varies considerably with the number of transactions available for import. For example, if run every 2 weeks and the volume of requisition entities such as headers, lines, and distributions being imported is less than 100,000, then the run time is expected to be less than 60 minutes. For higher volumes, it may go up to a couple of hours.
Compatibility	There should be only 1 instance of the job running at any one time.

Parameters

Parameter	Optional or Required	Description	Parameter Values	Special Combinations Required	Notes
Import Source	Optional	Use to match against the records in the interface tables to retrieve the right set of records for processing.	Free Text	No	N/A
Import Batch ID	Optional	Use to match against the records in the interface tables to retrieve the right set of records for processing.	Free Text	No	N/A
Maximum Batch Size	Optional	Use to limit the number of requisition lines that are batch processed. If the parameter isn't specified, the value of 2500 (default) is used as the maximum batch size.	Numerical value not exceeding 2500.	No	N/A
Requisitioning BU	Required	Use to ensure only the records with the specified requisitioning business unit (BU) are processed.	Choice List	No	System defaults the first value in the choice list. Change selection to the desired business unit.
Group By	Required	Use to specify grouping of requisition lines. Choices include: Item, Buyer, Category, Location, Supplier, and None. None means to group all requisition lines together.This field is dependent on the Requisitioning BU field. When you select a requisitioning BU, the value from the business unit's Group Requisition Import By field is displayed as a default value here.	Choice List	No	System uses the value Item by default. Change selection to the desired value.
Next Requisition Number	Optional	Use to specify the next requisition number when none is specified in the requisition header interface table.	Free Text	No	N/A
Initiate Approval after Requisition Import	Required	Set the value to Yes if you want imported draft requisitions submitted for approval immediately after the process completes.	Yes/No	No	No (default value)
Error Processing	Required	Select from the possible values All or Partial.All: The default value for this parameter. A requisition is created only if all the lines from the interface header pass validation.Partial: A requisition is created with only the lines that pass validation, even though some lines fail validation.	All/Partial	All	All (default value)

Troubleshooting Information

You can view the status of the process on the scheduled processes UI.
The validation error messages that prevented the successful import of requisitions is displayed in the error log.
When the program is submitted, you can Resubmit, Put on Hold, Cancel Process, Release Process as provided by the scheduled processes UI.