Import Suppliers
File Based Data Import uses this scheduled processes to create or update suppliers.
Import Suppliers: To create or update suppliers profile.
When to Use
For the initial load of suppliers from legacy application to Oracle Cloud to create a large number of suppliers, or to update the profile for large number of suppliers, the File Based Data Import uses the import suppliers job that will do the following:
- Create suppliers and child objects, or
- Update suppliers and child objects.
Privileges Required
To import suppliers, you must have this privilege (POZ_IMPORT_SUPPLIER_PRIV) or this privilege (FND_MANAGE_SCHEDULED_PROCESSES_PRIV). If you don't have either of these privileges assigned already, check with your administrator.
Specifications
| Specification | Description |
|---|---|
| Job Type | Ad hoc. |
| Time of Day | Any time. |
| Compatibility | There can be multiple instances of the job running at any time when the import suppliers job is run for different batches. |
Parameters
|
Parameter |
Optional or Required |
Description |
Parameter Value |
Special Combination Required |
Notes |
|---|---|---|---|---|---|
|
Import Options |
Optional |
To import new or rejected supplier records in the interface table, select the import options as New or Rejected respectively. Select All to import both types of supplier records. |
N/A |
None |
N/A |
|
Report Exceptions Only |
Optional |
If you want the output report of the import suppliers job to publish only rejected records, select the value of report exceptions only parameter as Yes. |
N/A |
None |
N/A |
|
Batch ID |
Optional |
To import a specific group of suppliers from the interface table, enter the value of batch ID parameter as available for these supplier records in the interface table. |
N/A |
None |
N/A |
Troubleshooting Information
- You can view the status of the import suppliers forecast operation on the scheduled processes or the import suppliers UI.
- The validation errors and warning messages that prevented the importing of suppliers are displayed in the job’s output report.
- Any interactive warning validations are NOT performed.
- When the program is submitted, you can Resubmit, Put on Hold, Cancel Process, Release Process as provided by the scheduled processes UI.
- If the job errors due to validations on supplier records, identify the attribute values that caused errors, update the values in the FBDI template, load the file with updated supplier profile and re-run the job.
- If the job takes more than expected time to complete, run multiple jobs in batches of maximum of size 20000 records.
- Use an attribute’s value as #NULL if the need is to null out that attribute’s value in the supplier profile.