To create or update an item's multi-row attributes in a spreadsheet:When creating or updating items/item revisions using a spreadsheet, you can provide values for multi-row attributes. When updating an item/item revision's multi-row attributes, you only provide the values for the multi-row attributes; you cannot make changes to the primary or single-row attributes--doing so results in errors. Further, when selecting multi-row attributes from a display format for export to a spreadsheet, select which multi-row attribute to update from the search results page. Even though you can create a display format for more than one multi-row attribute, only the data for the single, selected multi-row attribute is exported to the spreadsheet.
When updating an item multi-row attribute in a spreadsheet, you must input values for the following primary attributes for each multi-row attribute row:
Transaction Type (Sync)
Item
Organization Code
When updating an item revision multi-row attribute in a spreadsheet, you must input the Revision Code for each multi-row attribute row.
To create or update an item's multi-row attributes in a spreadsheet:Perform steps 1-7 in the Importing Items Using a Spreadsheet procedure.
In the spreadsheet, copy the row for the item (or item revision) and paste it into the next row. Then, delete the values of the primary/single row attributes in the new row. You must delete the values of the primary/single row attributes; if you do not, errors will occur.
Note: By default, the spreadsheet is protected. To copy/paste rows, select the Tools menu, then select Protection, and then select Unprotect.
Ensure that the unique key remains the same. After you have a row containing the same unique key as the item (or item revision) whose multi-row attributes you wish to update, and the primary/single row attributes are removed, you can enter values for the multi-row attributes In the following spreadsheet the unique key (Org Code and Item) in the second and third rows remain the same; the single row attributes have been deleted, and the multi-row attribute (Product Name, Impact Classification) values are provided.
Additional Information: To delete an existing value in a record, enter the following data in the appropriate column of the spreadsheet:
| For field type: | Enter value: |
|---|---|
| Date | 31-DEC-9999 |
| Character | ! |
| Numeric | 9.99E125 |
If you want to retain an existing value in a record, have it blank in the appropriate column of the spreadsheet.
Exception: In the user defined attributes interface table, when you want to delete an existing value in any of the following fields, use the value !. If you want to retain an existing value in a record, no entry is necessary.
ATTR_DISP_VALUE
ATTR_VALUE_STR
ATTR_NUM_VALUE
ATTR_VALUE_DATE
Make a note of the Result Format Usage ID at the top of the spreadsheet. You will need this ID later when you upload the spreadsheet in the systemk.
After data entry is complete, select Upload from the Oracle menu in the toolbar.
In the Upload Parameters window, enter the Result Format Usage ID and check the Automatically Submit Concurrent Process box, and then click Proceed to Upload.
In the Oracle Web ADI window, click Upload. After the upload process completes, a message appears with the Concurrent Request number. Make a note of this number, as you will need it later when you access the view log for the concurrent request. Click Close when the process messages complete.
Return to the Applications tree menu and click the "View Concurrent Requests" link. It is recommended that you check the concurrent process view log to ensure that the upload process was successful.
On the View Concurrent Requests page, click the Details icon.
On the Request Details page, click View Log.
From the View Log, paste the URL string in a web browser to view any errors. If no errors appear, the upload was successful.