Import External Purchase Prices
Use the Import External Purchase Prices scheduled process to create or update external purchase prices from the data in the interface tables.
The records are imported from the interface table as external purchase prices when the header action is Create. The records are imported as change orders when the header action is Update or Cancel.
When to Use
Scheduled the process to run automatically according to the frequency of the interface data being populated. For example, if the data is pushed to the interface from external systems once daily, the Import External Purchase Prices process should be scheduled to run daily after the data is available in the interface.
Privileges Required
- Import External Purchase Prices (SCH_IMPORT_EXTERNAL_PURCHASE_PRICES_PRIV)
Specifications
Review these specifications before you set up the scheduled process.
| Specification | Description |
|---|---|
| Job Type | Scheduled. The process can also be submitted manually to process the records with errors after rectifying the errors. |
| Frequency | The process should be scheduled to run automatically according to the frequency with which the interface data is populated. For example, if the data is pushed to the interface from external systems once daily, the Import External Purchase Prices process should be scheduled to run daily. |
| Time of Day | After the data in the interface is populated. Preferably, after work hours or during the early hours of the day. |
| Duration | Typically, less than five minutes. |
| Compatibility | There should be only one instance of the job running at any one
time and there is no current functional need to run multiple
instances of this process at the same time. This process is
automatically placed on hold when any of these other External
Purchase Prices scheduled processes are running.
|
Parameters
| Parameter | Optional or Required | Description | Parameter Values | Special Combinations Required | Notes |
|---|---|---|---|---|---|
| Batch ID | Optional |
|
Value of the batch ID. | None | Schedule the process without specifying a batch ID to import the interface record for all batches. |
| Reprocess Error | Optional |
|
Yes or No | No | Schedule the process with Reprocess Error = No. |
Troubleshooting Information
- Records that are successfully imported are deleted from the interface tables. Records with errors are retained in the interface table and will be reprocessed by the next import process.
- The import errors exception card is displayed in the External Purchase Prices work area when errors have occurred during import. From here, you can drill down to the Errors During Import page which lists the error messages with details such as the attributes that caused the error.
- From the Errors During Import page, download the Microsoft Excel template for managing the external purchase prices interface data. This predefined template uses the Oracle Visual Builder Add-in for Excel to download the import errors and interface data from External Purchase Prices to a spreadsheet.
- You can use this template to view the interface headers and lines data. Additionally, you can delete the interface headers or lines and upload the changes back to the External Purchase Prices work area. You can’t update the data in the interface tables.
- Once the errors are resolved, the interface records are processed in the next run of the Import External Purchase Prices scheduled process.
- The recommended maximum number of records that can be processed by the import process is 100,000 lines across multiple headers. If you have more than 100,000 lines in the interface tables, split them into multiple batches and import one batch at a time not exceeding 100,000 lines.