Import Supplier Addresses

When to Use

For the initial load of suppliers from legacy applications to Oracle Fusion Cloud Applications to create many suppliers, or to update the profile for large number of suppliers, the FBDI uses the import suppliers job that will do the following:

Create suppliers and child objects.
Update suppliers and child objects.

Privileges Required

Import Supplier (POZ_IMPORT_SUPPLIER_PRIV)
Manage Scheduled Processes (FND_MANAGE_SCHEDULED_PROCESSES_PRIV)

Specifications

Review the following before setting up this scheduled process:

Specification	Description
Job Type	Ad hoc job.
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 in the Scheduled Processes work area or the Import Suppliers work area.
The validation errors and warning messages that prevented the importing of suppliers are displayed in the job’s output report.
Any interactive warning validations aren't performed.
When the program is submitted, you can Resubmit, Put on Hold, Cancel Process, Release Process as provided by the Scheduled Processes work area.
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.