This set of columns provides the cost elements information of an item. You can type or paste in the relevant values straight into Excel. No validation is performed until you run the upload program. Alternatively you can use the Cost Elements form.
First position your cursor on the row you wish to contain the cost element data. Then double-click in one of the cells to contain the values, or alternatively click the ‘Forms’ icon and select ‘Cost Elements Form’ on the ribbon.
The ‘Item Cost Elements’ form will display:
The form functionality mimics that of the standard transaction forms in Oracle Applications.
Note - You can upload one item within an organization at a time, a selected range of items or your entire worksheet. The Oracle interface does not allow you to update or create just one element if a cost exists, however the Wizard supports this feature by automatically adding the other elements to the interface (if you choose ‘Create and Update’ mode from the ribbon).
Data Entry Fields:
Cost Element
This will give a list of cost elements for an organization. Default sub elements will be available relating to the option chosen in this field.
Sub Element
Default sub elements for an organization relating to the ‘Cost Element’ chosen, will be available in a list of values.
Activity
The default activity you associated with the Sub Element is the default.
Basis
The Basis is associated with the Sub Element.
Rate Or Amount
This is the Rate or Amount for the Sub Element and the Activity.
Activity Occurrences
This value is required when the ‘Basis’ is ‘Activity’ and must be a numeric value.
Number Of Items
This value is required when the ‘Basis’ is ‘Activity’ and must be a numeric value.
In the ‘Item Cost Elements’ form once you have entered your data, click the ‘Ok’ button to transfer the information back to Excel click the ‘Cancel’ button if you wish to revert to the old values or click the ‘<<Header’ button to take you back to the Header form.
