The worksheet is divided into sections. The section headings can be found in Row 8 of the worksheet.
Each section corresponds to information held about a Supplier in Oracle E-Business Suite. The first few columns of the worksheet are ‘Status’ columns, these are used to track the progress of the records as they upload into Oracle E-Business Suite and report any error messages. The error messages are written into the ‘Rejection Reason’ column.
Supplier Wizard contains the following sections:
•Status
•Supplier
•Supplier Dff
•Supplier Global Dff
•Organization Dff
•Supplier Attach
•Supplier Contact
•Business Classification
•Supplier Bank Acc
•Supplier Bank Acc Dff
•Supplier Acc Owner
•Intermediary Acc Supp
•Site
•Site Dff
•Address Dff
•Site Global Dff
•Site Attach
•Contact
•Site Bank Acc
•Site Bank Acc Dff
•Site Acc Owner
•Intermediary Acc Site
The column names are stored in row 9. These are fixed and cannot be changed. Do NOT insert or delete rows before row 10.
The case of the column names is not important, but spelling is. If you change the contents of row 9 in any column, you have in effect deleted the column as far as the program is concerned. You can move the columns anywhere you like or even delete them (we do not recommend hiding columns as the data will still be loaded).
Information for one Supplier may be over several rows within the worksheet. The supplier header information will be on the first row. Then each section will start on the first row and continue down for as many records as are required.
Example: Supplier with five Sites.
You can see that this Supplier and related information will take up five rows on the worksheet (assuming no site has more than one contact or bank details). A Supplier with only one site will take up one row on the worksheet again assuming the site does not have more than one contact or one bank account.
Default Values
Supplier Wizard provides you with the ability to enter default values in Row 10.
